An Architecture for Data Warehouse Systems Using a Heterogeneous Database Management System

One of the most challenging prospects facing the Data Warehouse (DW) project is the integration of heterogeneous data from different sources. The database community has spent years researching the integration of heterogeneous and distributed data. Heterogeneous Database Management Systems (HDBMS) have been presented as one of the solutions to this problem. In this paper, we propose an architecture for DW systems using a HDBMS as the middleware for data integration. This architecture uses a subset of Common Warehouse Metamodel (CWM) specification in order to provide more semantic to data integration according to a standard proposal. A case study presenting the use of the proposed architecture is also shown.

[1]  William E. Lorensen,et al.  Object-Oriented Modeling and Design , 1991, TOOLS.

[2]  Ralph Kimball,et al.  The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses , 1996 .

[3]  Wilhelm Hasselbring,et al.  Research issues in federated database systems: report of EFDBS '97 workshop , 1997, SGMD.

[4]  José Samos,et al.  Database Architecture for Data Warehousing: An Evolutionary Approach , 1998, DEXA.

[5]  Antonio Vallecillo,et al.  Object Interoperability , 1999, ECOOP Workshops.

[6]  Abraham Silberschatz,et al.  Database systems—breaking out of the box , 1997, SGMD.

[7]  Rubens N. Melo,et al.  HEROS: A Heterogeneous Object-Oriented Database System , 1998, DEXA.

[8]  Ralph E. Johnson,et al.  Patterns Generate Architectures , 1994, ECOOP.

[9]  Jennifer Widom,et al.  The WHIPS prototype for data warehouse creation and maintenance , 1997, SIGMOD '97.

[10]  Ahmed K. Elmagarmid,et al.  Object orientation in multidatabase systems , 1995, CSUR.

[11]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[12]  Philip Cannata,et al.  SQL Access: an implementation of the ISO Remote Database Access Standard , 1991, Computer.

[13]  J. Liu,et al.  An architecture for data warehouse systems , 1998, Proceedings of IEEE TENCON '98. IEEE Region 10 International Conference on Global Connectivity in Energy, Computer, Communication and Control (Cat. No.98CH36229).

[14]  Alex Berson,et al.  Data Warehousing, Data Mining, and OLAP , 1997 .

[15]  Ramon C. Barquin,et al.  Planning and Designing the Data Warehouse , 1996 .

[16]  Joyce Bischoff,et al.  Data Warehouse: Practical Advice from the Experts , 1997 .

[17]  Elvira Maria Antunes Uchôa,et al.  HEROSfe: A Framework for Heterogeneous Database Systems Integration , 1999, DEXA.