Database Reference
In-Depth Information
Chapter 4
Designing Data Marts from XML
and Relational Data Sources
Yasser Hachaichi
Mir@cl Laboratory, Faculté des Sciences Economiques et de Gestion, Tunisia
Jamel Feki
Mir@cl Laboratory, Faculté des Sciences Economiques et de Gestion, Tunisia
Hanene Ben-Abdallah
Mir@cl Laboratory, Faculté des Sciences Economiques et de Gestion, Tunisia
ABSTRACT
Due to the international economic competition, enterprises are ever looking for efficient methods to
build data marts/warehouses to analyze the large data volume in their decision making process. On the
other hand, even though the relational data model is the most commonly used model, any data mart/
warehouse construction method must now deal with other data types and in particular XML documents
which represent the dominant type of data exchanged between partners and retrieved from the Web.
This chapter presents a data mart design method that starts from both a relational database source and
XML documents compliant to a given DTD. Besides considering these two types of data structures, the
originality of our method lies in its being decision maker centered, its automatic extraction of loadable
data mart schemas and its genericity.
INTRODUCTION
analytical queries and scheduled reporting. Indeed,
a data warehouse (DW) is organized in such a way
that relevant data is clustered together for an easy
access. In addition, a DW can be used as a source
for building data marts (DM) that are oriented to
specific subjects of analyses.
Traditionally, the data loaded into a DW/DM
is mainly issued from the enterprise's own opera-
tional information system. Thus, most currently
proposed DW/DM construction approaches sup-
Faced with the ever increasing economic com-
petition, today's enterprises are hard-pressed to
rely on decision support systems (DSS) to assist
them in the analysis of very large data volumes.
As a response to this constraint, data warehousing
technologies have been proposed as a means to
extract pertinent data from information systems and
present it as historical snapshots used for ad hoc
Search WWH ::




Custom Search