Abstract
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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Barquin R., Edelstein H., Planning and Designing the Data Warehouse, Prentice Hall, Inc., 1997.
Beck K., Johnson R., Patterns Generate Architectures, European Conference on Object Oriented Programming (ECOOP’94), Springer-Verlag, Bologna, Italy, July 1994.
Berson A., Smith S. J., Data Warehousing, Data Mining and OLAP, McGraw-Hill Companies, Inc., 1997.
Callaghan, D., Virtual DB Breaks Down Data Barriers; Data Management and Analysis; Web Site: http://www.midrangesystems.com/archive/1997/oct10/dm101603.htm
Common Warehouse Metamodel (CWM) Specification, Object Management Group, http://www.omg.org/technology/cwm/index.htm
Conrad S., Eaglestone B., Hasselbring W., et al. Research Issues in Federated Database Systems, Report of EFDBS’97 Workshop, SIGMOD Record, Vol. 26, N. 4, December 1997.
Dresner H., Lett B., Evaluating Executive Information Systems. An Gartner Group Strategic Analysis Report. September 1995.
Inmon W. H., Building the Data Warehouse, John Wiley and Sons, Inc., 1996.
Kimball R., The Data Warehouse Toolkit, John Wiley and Sons, Inc., 1996.
Labio W. J., Zhuge Y., Wiener J. L., Gupta H., Molina H. G., Widow J., The WHIPS Prototype for Data Warehouse Creation and Maintenance; Proc. ACM SIGMOD Conf. AZ, USA, 1997.
Pacitti E., Silva S. D., Duarte C. H. C., Melo R. N., HEROS: An Object Oriented Heterogeneous Database System, VIII Brazilian Database Symposium, Campina Grande, PB, 1993 (in Portuguese).
Pitoura E., Bukhres O., Elmagannid A., Object Orientation in Multidatabase Systems, ACM Computing Surveys, Vol. 27, N. 2, June 1995.
Rani S., Guest Editor’s Introduction: Heterogeneous Distributed Database Systems, in: IEEE Computer, Vol.24, N. 12, December 1991.
Samos J., Saltor F., Sistac J., Bardés A., DataBase Architecture for Data Warehousing: An Evolutionary Approach; DEXA Conference and Workshop Programme, Vienna, Austria, 1998.
Sheth A. P., Larson J. A., Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases; ACM Computing Surveys, Vol. 22, N. 3, September 1990.
Silberschatz A., Zdonic, S., Database Systems - Breaking Out the Box, SIGMOD Record, Vol. 26, N. 3, September 1997.
Silva D., Siqueira S., Uchôa E., Braz M., Melo R. N., An Architecture for Data Warehouse Systems Using an Heterogeneous Database Management System, XV Brazilian Database Symposium, Joao Pessoa, PA, October 2000.
Silva D. S., An Architecture for Data Warehouse Systems using HEROS: an Heterogeneous Database Management System. Computer Science Department -Pontificia Universidade Católica do Rio de Janeiro (PUC-Rio). M.Sc. Thesis, 1999 (in Portuguese)
SynopSysandtrade; White Paper, Web Site: http://www.themis.co.uk/WhtPaper1.html, January 1998.
Templeton M., Metadata Challenges in Federating Databases; Web Site: http://computer.org/conferences/meta96/templeton/templeton.html
Uchôa E. M. A., Lifschitz, S., Melo R. N., HEROS: A Heterogeneous Object-Oriented Database System; DEXA Conference and Workshop Programme, Vienna, Austria, 1998.
Uchôa E. M. A., Melo R. N., HEROS: a Framework for Heterogeneous Database Systems Integration; DEXA Conference and Workshop Programme, Florence, Italy, 1999.
Uchôa E. M. A., A Framework for Heterogeneous Database Systems. Computer Science Department — Pontificia Universidade Católica do Rio de Janeiro (PUC-Rio). Ph.D. Thesis, 1999 (in Portuguese)
Unified Modeling Language (UML), Object Management Group http://www.omg.org/uml/
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer Science+Business Media Dordrecht
About this chapter
Cite this chapter
de S. e Silva, D., Siqueira, S.W.M., Uchôa, E.M.A., Braz, M.H.L.B., Melo, R.N. (2002). An Architecture for Data Warehouse Systems Using a Heterogeneous Database Management System — HEROS. In: Bestougeff, H., Dubois, JE., Thuraisingham, B. (eds) Heterogeneous Information Exchange and Organizational Hubs. Springer, Dordrecht. https://doi.org/10.1007/978-94-017-1769-4_6
Download citation
DOI: https://doi.org/10.1007/978-94-017-1769-4_6
Publisher Name: Springer, Dordrecht
Print ISBN: 978-90-481-6030-3
Online ISBN: 978-94-017-1769-4
eBook Packages: Springer Book Archive