Skip to main content
SpringerLink
Log in

A Logical Model for Data Warehouse Design and Evolution

  • Conference paper
  • First Online:
Data Warehousing and Knowledge Discovery (DaWaK 2000)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1874))

Included in the following conference series:

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 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.

    Google Scholar 

  2. 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.

    Google Scholar 

  3. 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.

    Google Scholar 

  4. 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.

    Google Scholar 

  5. 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.

    Google Scholar 

  6. 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

    Google Scholar 

  7. 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.

    Google Scholar 

  8. 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.

    Google Scholar 

  9. M. Jarke, M. Lenzerini, Y. Vassiliou, P. Vassiliadis. (edits). Fundamentals of Data Warehouses. Springer, 1999.

    Google Scholar 

  10. Z. Kedad. Techniques d’intégration dans les systèmes d’information multi-source. PhD Thesis, Laboratoire PriSM, University of Versailles, France, January 1999.

    Google Scholar 

  11. Z. Kedad, M. Bouzeghoub. Conception de systèmes d’information multi-source. In Proceedings of INFORSID’99, Toulon, France, June 1999.

    Google Scholar 

  12. 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.

    Google Scholar 

  13. 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.

    Google Scholar 

  14. 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.

    Google Scholar 

  15. 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.

    Google Scholar 

  16. 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.

    Google Scholar 

  17. 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.

    Google Scholar 

  18. 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.

    Google Scholar 

  19. D. Theodoratos. Detecting Redundancy in Data Warehouse Evolution. In Proceedings of the 18th International Conference on Conceptual Modeling (ER’99), Paris, France, november 1999.

    Google Scholar 

  20. 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.

    Google Scholar 

  21. 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

    Google Scholar 

  22. 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.

    Google Scholar 

  23. 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

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Laboratoire PRiSM, Université de Versailles, 45, avenue des Etats-Unis, 78035, Versailles Cedex, France

    Mokrane Bouzeghoub & Zoubida Kedad

Authors
  1. Mokrane Bouzeghoub
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Zoubida Kedad
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Graduate School of Informatics, Kyoto University, Yoshida-Honmachi, Sakyo-ku, Kyoto, 606-8501, Japan

    Yahiko Kambayashi

  2. Computer Science Department, Western Michigan University, Kalamazoo, MI, 49008, USA

    Mukesh Mohania

  3. Vienna University of Technology, IFS, Favoritenstr. 9-11/188, 1040, Vienna, Austria

    A. Min Tjoa

Rights and permissions

Reprints 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

Publish with us

Policies and ethics

Search

Navigation