Database Reference
In-Depth Information
Figure 10. GUI for DM schema adaptation
REFERENCES
examples. In this paper, we illustrated the method
through an e-Ticket DTD used by an online broker
and a relational database modeling a hotel room
booking system.
Our design method assists decision makers in
defining their analytical needs by proposing all
analytical subjects that could be automatically
extracted from their data sources. In addition, it
guarantees that the extracted subjects are loadable
from the enterprise information system and/or the
XML source documents. Furthermore, it keeps
track of the origin of each component of the gener-
ated DM schema; this traceability information is
vital for the definition of ETL procedures.
We are currently extending our design method
to deal with other types of data sources and, in
particular, XML documents with XML schemas
and object databases. Furthermore, we are ex-
amining how to integrate adjusted/validated DM
schemas to design a DW schema loadable from
all the considered sources.
Ben Abdallah, M., Feki, J., & Ben-Abdallah, H.
(2006). MPI-EDITOR : Un outil de spécification
de besoins OLAP par réutilisation logique de
patrons multidimensionnels. In
Proceedings of
the Atelier des Systèmes Décisionnels (ASD'06)
,
Agadir, Morocco.
Böhnlein, M., & Ulbrich-vom Ende, A. (1999).
Deriving initial data warehouse structures from
the conceptual data models of the underlying
operational information systems. In
Proceedings
of the 2
nd
ACM international workshop on Data
warehousing and OLAP,
Kansas City, Missouri
(pp. 15-21).
Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A.,
& Paraboschi, S. (2001). Designing data marts for
data warehouse.
ACM Transactions on Software
Engineering and Methodology
,
10
, 452-483.
doi:10.1145/384189.384190
Boufares, F., & Hamdoun, S. (2005). Integration
techniques to build a data warehouse using het-
erogeneous data sources.
Journal of Computer
Science
, 48-55.
Search WWH ::
Custom Search