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.
Preview
Unable to display preview. Download preview PDF.
References
Abiteboul, S., Bonner, A.: Objects and Views, in Proc. ACM SIGMOD, Conference on Management of Data, pp 238–247, Denver, Colorado, May 1991.
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.
Bertino, E.: A View Mechanism for Object-oriented Database. 3rd International Conference on Extending Database Technology, March 23–24, Vienna (Austria), 1992.
Chaudhuri, S., Dayal U.: An Overview of Data Warehousing and OLAP Technology. SIGMOD Record, Vol.26, N01, March 1997.
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.
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.
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.
Hull, R., Zhou, G.: A Framework for supporting Data Integration using the Materialized and Virtual Approaches. Proc. of SIGMOD'96 Conference, Montreal, Canada, 1996.
Marche, J.: Measuring the Stability of Data Models. European Journal of Information Systems, Vol. 2, NO 1, pp. 37–47, 1993.
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.
Sjoberg D.: Quantifying Schema Evolution. Information and Software Technology Journal, Vol. 35, NO 1, pp. 34–44, January 1993.
Tresch, M., Scholl, M.H, “Schema Transformation without Database Reorganization. in SIGMOD Record, 22(1), March, 1993.
Widom, J., “Research Problems in Data Warehouse. Proc. of 4th international Conference on Information and Knowledge Management (CIKM), November, 1995.
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.
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.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1998 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Bellahsene, Z. (1998). View adaptation in data warehousing systems. In: Quirchmayr, G., Schweighofer, E., Bench-Capon, T.J. (eds) Database and Expert Systems Applications. DEXA 1998. Lecture Notes in Computer Science, vol 1460. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0054491
Download citation
DOI: https://doi.org/10.1007/BFb0054491
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-64950-2
Online ISBN: 978-3-540-68060-4
eBook Packages: Springer Book Archive