Abstract
A data warehouse is a software infrastructure which supports OLAP applications by providing a collection of tools for data extraction and cleaning, data integration and aggregation, and data organization into multidimensional structures. At the design level, a data warehouse is defined as a hierarchy of view expressions whose ultimate nodes are queries on data sources. In this paper, we propose a logical model for a data warehouse representation which consists of a hierarchy of views, namely the base views, the intermediate views and the users views. This schema can be used for different design purposes, as the evolution of a data warehouse which is also the focus of this paper.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
E. Baralis, S. Paraboschi, E. Teniente. Materialized View Selection in a Multidimensional Environment. In Proceedings of the 23rd International Conference on Very Large Data Bases (VLDB’97), Athens, Greece, August 1997.
D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi, R. Rosati. Source Integration integration: conceptual modeling and reasoning support. In Proceedings of the 3rd IFCIS International Conference on Cooperative Information Systems (CoopIS’98), New York City, USA, August 1998.
S. Chawathe, H. Garcia-Molina, J. Hammer, K. Ireland, Y. Papakonstantinou, J. Ullman, J. Widom. The TSIMMIS project: Integration of Hererogeneous Information Sources. In Proceedings of the 10th Meeting of the Information Processing Society of Japan (IPSJ’94), Tokyo, Japan, October 1994.
S. Chaudhuri, A. Dayal. An Overview of Data Warehousing and OLAP Technology. Tutorial, In Proceedings of the 22th International Conference on Very Large Data Bases (VLDB’96), Mumbai, India, September1996.
H. Garcia-Molina, Y. Papakonstantinou, D. Quass, A. Rajamaran, Y. Sagiv, J. Ullman, V. Vassalos, J. Widom. The TSIMMIS approach to mediation: Data model and Languages. In 2nd International Workshop on Next Generation Information Technologies and Systems (NGITS’ 95), Naharia, Israel, June 1995.
J. Hammer, H. Garcia-Molina, J. Widom, W. Labio, Y. Zhuge. The Stanford Data Warehousing Project. IEEE Data Engineering Bulletin, Special Issue on Materialized Views and Data Warehousing, 18(2), June 1995
R. Hull, G. Zhou. A Framework for Supporting Data Integration Using the Materialized and Virtual Approches. In Proceedings of the ACM SIGMOD International Conference on Management of Data, Montreal, Canada, June 1996.
M. Jarke, Y. Vassiliou. Foundation of Data Warehouse Quality: an Overview of the DWQ project. In Proceedings of the 2nd International Conference on Information Quality, Cambridge, Mass, 1997.
M. Jarke, M. Lenzerini, Y. Vassiliou, P. Vassiliadis. (edits). Fundamentals of Data Warehouses. Springer, 1999.
Z. Kedad. Techniques d’intégration dans les systèmes d’information multi-source. PhD Thesis, Laboratoire PriSM, University of Versailles, France, January 1999.
Z. Kedad, M. Bouzeghoub. Conception de systèmes d’information multi-source. In Proceedings of INFORSID’99, Toulon, France, June 1999.
A.Y. Levy, A. Rajaraman, J.J. Ordille. Query-Answering Algorithms for Information Agents. In Proceedings of the 13th National Conference on Artificial Intelligence and 8th Innovative Applications of Artificial Intelligence Conference (AAAI 96, IAAI 96), Portland, Oregon, August 1996.
A.Y. Levy, A. Rajaraman, J.J. Ordille. Querying Heterogeneous Information Sources Using Source Description. In Proceedings of the 22th International Conference on Very Large Data Bases (VLDB’96), Mumbai, India, September 1996.
S. Ligoudistianos, T. Sellis, D. Theodoratos, Y. Vassiliou. Heuristic Algorithms For Designing The Data Warehouse with SPJ Views. In Proceedings of the International Conference on Data Warehousing and Knowledge Discovery (DAWAK’99), 1999.
C. Quix. Repository support for Data Warehouse Evolution. In Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW’99), Heidelberg, Germany, June 1999.
D. Theodoratos, T. Sellis. The Data Warehouse Configuration. In Proceedings of the 23rd International Conference on Very Large Data Bases (VLDB’97), Athens, Greece, August 1997.
D. Theodoratos, T. Sellis. Data Warehouse Schema and Instance Design. In Proceedings of the 17th International Conference on Conceptual Modeling (ER’98), Singapore, November 1998.
D. Theodoratos, S. Ligoudistianos, T. Sellis. Designing the Global Data Warehouse with SPJ Views. In Proceedings of the 11th Conference on Advanced Information Systems Engineering (CAISE’99), Heidelberg, Germany, June 1999.
D. Theodoratos. Detecting Redundancy in Data Warehouse Evolution. In Proceedings of the 18th International Conference on Conceptual Modeling (ER’99), Paris, France, november 1999.
J. Widom. Research Problems in Data Warehousing. In Proceedings of the 4th International Conference on Information and Knowledge Management (CIKM’95), Baltimore, Maryland, November 1995.
J.L. Wiener, H. Gupta, W.J. Labio, Y. Zhuge, H. Garcia-Molina, J. Widom. A System Prototype for Warehouse View Maintenance. In VIEWS 96
J. Yang, K. Karlapalem, S. Li. Algorithms for materialized view design in data warehousing Environment. In Proceedings of the 23rd International Conference on Very Large Data Bases (VLDB’97), Athens, Greece, August 1997.
G. Zhou, R. Hull, R. King, J.C. Franchitti. Data Integration and Warehousing using H2O. IEEE Data Engineering Bulletin, Special Issue on Materialized Views and Data Warehousing, 18(2), June 1995
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2000 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Bouzeghoub, M., Kedad, Z. (2000). A Logical Model for Data Warehouse Design and Evolution. In: Kambayashi, Y., Mohania, M., Tjoa, A.M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2000. Lecture Notes in Computer Science, vol 1874. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44466-1_18
Download citation
DOI: https://doi.org/10.1007/3-540-44466-1_18
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-67980-6
Online ISBN: 978-3-540-44466-4
eBook Packages: Springer Book Archive