Advertisement

View adaptation in data warehousing systems

  • Zohra Bellahsene
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1460)

Abstract

An important aspect of a data warehouse system should be its ability to evolve according the user and organization needs. The reason being that the schema of a data warehouse can evolve for integrating new requirements resulting from analysis or data mining processing, schema changes on information sources etc. More precisely, schema changes arising on information sources should be propagated to the related views in order to maintain consistency between the sources and the derived views. In this paper, we present a view model extending the relational view model. And we show how this extended view definition language allows to support view schema changes enforcing consistency and without causing disruptions or modifications to existing views and application programs.

Keywords

data warehouse relational views data warehouse evolution 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Abiteboul, S., Bonner, A.: Objects and Views, in Proc. ACM SIGMOD, Conference on Management of Data, pp 238–247, Denver, Colorado, May 1991.Google Scholar
  2. 2.
    Bellahsene, Z.: Views for Schema Evolution in Object-oriented Database Systems. British National Conference on Database BNCOD-14. Lectures Notes in Computer Science of Springer Verlag, Edinburgh, July, 1996.Google Scholar
  3. 3.
    Bertino, E.: A View Mechanism for Object-oriented Database. 3rd International Conference on Extending Database Technology, March 23–24, Vienna (Austria), 1992.Google Scholar
  4. 4.
    Chaudhuri, S., Dayal U.: An Overview of Data Warehousing and OLAP Technology. SIGMOD Record, Vol.26, N01, March 1997.Google Scholar
  5. 5.
    Ferrandina, F., Meyer, T., Zicari, R., Ferran, G., Madec, J.: Schema and Database Evolution in the 02 Object Database System. Proc. of VLDB Conference Zurich, Switzerland, pp. 65–74, September, 1995.Google Scholar
  6. 6.
    Golfarelli, M., Maio, D., Rizzi, S.: Conceptual design of data Warehouses from E/R Schemes. Proc. of Hawaii International Conference on System Sciences, IEEE society press, Kona, Hawaii, January 6–9, 1998.Google Scholar
  7. 7.
    Hammer, J., Garcia-Molina, H., Widom, J., Labio, W., and. Zhuge, Y. The Stanford Data Warehouse Project. IEEE Data Engineering Bulletin, in Proc. Special Issue-48, June 1995.Google Scholar
  8. 8.
    Hull, R., Zhou, G.: A Framework for supporting Data Integration using the Materialized and Virtual Approaches. Proc. of SIGMOD'96 Conference, Montreal, Canada, 1996.Google Scholar
  9. 9.
    Marche, J.: Measuring the Stability of Data Models. European Journal of Information Systems, Vol. 2, NO 1, pp. 37–47, 1993.CrossRefGoogle Scholar
  10. 10.
    Ra, Y.G., Rundensteiner E. A: A transparent object-oriented Schema Changes Approach Using View Evolution. IEEE Int. Conf. on Data Engineering, Taipei, Taiwan, 1995.Google Scholar
  11. 11.
    Sjoberg D.: Quantifying Schema Evolution. Information and Software Technology Journal, Vol. 35, NO 1, pp. 34–44, January 1993.Google Scholar
  12. 12.
    Tresch, M., Scholl, M.H, “Schema Transformation without Database Reorganization. in SIGMOD Record, 22(1), March, 1993.Google Scholar
  13. 13.
    Widom, J., “Research Problems in Data Warehouse. Proc. of 4th international Conference on Information and Knowledge Management (CIKM), November, 1995.Google Scholar
  14. 14.
    Wiener, J.L et al: A System Prototype for Warehouse View Maintenance. Proceedings of the Workshop on Materialised Views: Techniques and Applications, Montreal, June 7, 1996.Google Scholar
  15. 15.
    Zhuge, Y., Garcia-Molina, H., Wiener, J.: Consistency Algorithms for Multi-Source Warehouse View Maintenance. Journal of Distributed and Parallel Information Systems, Kluwer Academic Publishers, pp 1–36, December 1996.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1998

Authors and Affiliations

  • Zohra Bellahsene
    • 1
  1. 1.LIRMM UMR 55060 CNRS - Montpellier IIMontpellier Cedex 5France

Personalised recommendations