Abstract
Data warehouse refresh incorporates issues on how to capture and propagate updates occurring in operational systems into the warehouse in order to keep the data warehouse up-to-date. In this paper, we propose an object-oriented approach for the incremental refresh of data warehouses which considers the special nature of warehouse data, e.g., its temporal and heterogeneous dimension. Our approach can be used for the integration of data from a wide variety of heterogeneous operational sources and independently of a particular database system used for storing the warehouse data.
This is a preview of subscription content, log in via an institution to check access.
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
D. Agrawal, A. El Abbadi, A. Singh, T. Yurek. Efficient View Maintenance at Data Warehouses. Proc. of ACM SIGMOD Intl. Conf. of Management of Data, Tucson, Arizona, May 1997.
E. Bertino. Integration of Heterogeneous Data Repositories by Using Object-Oriented Views. Proc. of the 1st Intl. Workshop on Interoperability in Multi-database Systems, Kyoto, Japan, April 1991.
R. G.G. Cattell, D. Barry (ed). The Object Database Standard: ODMG 2.0. Morgan Kaufmann Publishers, San Francisco, California, 1997.
S. Chaudhuri, U. Dayal. An Overview of Data Warehousing and OI.AP Technology. ACM SIGMOD Record, 26:1, March 1997.
S. Gatziu, A. Vavouras, K.R. Dittrich. SIRIUS: An Approach for Data Warehouse Refreshment. Technical Report 98. 07, Insitut fr Informatik, Universitt Zrich,, July 1998.
A. Gupta, I.S. Mumick. Maintenance of materialized views: Problems, techniques, and applications. IEEE Data Engineering Bulletin, 18(2), June 1995.
J. Hammer, H. Garcia-Molina, J. Widom, W. Labio, Y. Zhuge. The Stanford Data Warehousing Project. In [18].
N. Huyn. Multiple-View Self-Maintenance in Data Warehousing Environments. Proc. of the 23rd Intl. Conf. on Very Large Data Bases, Athens, Greece, 1997.
W.H. Immon. Building the Data Warehouse. John Wiley, 1996.
M. Jarke, Y. Vassiliou. Data Warehouse Quality: A Review of the DWQ Project. Invited paper, Proc. 2nd Conf. on Information Quality, Massachusetts Institute of Technology, Cambridge, May, 1997.
M. Kaul, K. Dorsten, E.J. Neuhold. ViewSystem: Integrating Heterogeneous Information Bases by Object-Oriented Views. Proc. of the 6th Intl. Conference on Data Engineering, Los Angeles, California, February 1990.
J. Mylopoulos, A. Gal, K. Kontogiannis, M. Stanley. A Generic Integration Architecture for Cooperative Information Systems. Proc. of the 1st IFCIS Intl. Conference on Cooperative Information Systems, Brussels, Belgium, June 1996.
D. Quass, A. Gupta, I.S. Mumick, J. Widom. Making Views Self-Maintainable for Data Warehousing. Proc. of the 4th Intl. Conf. on Parallel and Distributed Information Systems, December 1996.
M.T. Roth, P. Schwarz. Don’t Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources. Proc. of the 23rd Intl. Conf. on Very Large Data Bases, Athens, Greece, 1997.
N. Roussopoulos. Materialized Views and Data Warehouses. SIGMOD Record, 27(1), p21–26, March 1998.
D. Srivastava, S. Dar, H.V. Jagadish, A.Y. Levy. Answering Queries with Aggregation Using Views. Proc. of the 22th Intl. Conf. on Very Large Data Bases, Bombay, India, September 1996.
M. Staudt, M. Jarke. Incremental Maintenance of Externally Materialized Views. Proc. of the 22th Intl. Conf. on Very Large Data Bases, Bombay, India, September 1996.
J. Widom (ed.). Special Issue on Materialized Views and Data Warehousing, IEEE Data Engineering Bulletin, 18:2, June 1995.
J. Widom. Research Problems in Data Warehousing. Proc. of the 4th Intl. Conf. on Information and Knowledge, Baltimore, 1995.
J. Widom, S. Ceri (ed). Active Database Systems: Triggers and Rules for Advanced Database Processing. Morgan-Kaufmann, 1996.
G. Wiederhold. Intelligent Integration of Information.Proc. of ACM SIGMOD Intl. Conf. of Management of Data, Washington, May 1993.
G. Wiederhold. Value-added Mediation in Large-Scale Information Systems. Database applications semantic: Proceedings of the IFIP WG 2.6 Working Conference on Database Applications Semantics (DS-6), Atlanta, Georgia, Chapmann & Hall, 1997.
J. Wiener, H. Gupta, W. Labio, Y. Zhuge, H. Garcia-Molina, J. Widom. A System Prototype for Warehouse View Maintenace. Proc. of the ACM Workshop on Materialized Views: Techniques and Applications, Montreal, June 1996.
M-C. Wu, A.P. Buchmann. Research Issues in Data Warehousing. Datenbanksysteme in Büro, Technik und Wissenschaft: GI-Fachtagung, Springer-Verlag, Ulm, 1997.
J. Yang, K. Karlapalem, Q. Li. Algorithms for Materialized View Design in Data Warehousing Environment. Proc. of the 23rd Intl. Conf. on Very Large Data Bases, Athens, Greece, August 1997.
J. Yang and J. Widom. Maintaining Temporal Views Over Non-Historical Information Sources For Data Warehousing. Proc. of the 14th Intl. Conf. on Data Engineering, Orlando, Florida, Februar 1998.
Y. Zhuge, H. Garcia-Molina, and J.L. Wiener The Strobe Algorithms for Multi-Source Warehouse Consistency. Proc. of the 4th Intl. Conf. on Parallel and Distributed Information Systems, December 1996.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Vavouras, A., Gatziu, S., Dittrich, K.R. (1999). The SIRIUS Approach for Refreshing Data Warehouses Incrementally. In: Buchmann, A.P. (eds) Datenbanksysteme in Büro, Technik und Wissenschaft. Informatik aktuell. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-60119-4_6
Download citation
DOI: https://doi.org/10.1007/978-3-642-60119-4_6
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-65606-7
Online ISBN: 978-3-642-60119-4
eBook Packages: Springer Book Archive