Abstract
Data in warehouses need to be updated in a timely manner from underlying operational data sources. This is referred to as warehouse maintenance. Not all of the data in the warehouse has the same requirement in terms of staleness (how old can it be with respect to the actual data), or its inverse freshness, and consistency (combining data from autonomous sources may give rise to some inconsistency). Given the requirements and schema information of a data warehouse, identifying policies for change detection and warehouse maintenance is a complex task. In this paper we identify a problem with current specification of user requirements, and suggest a specification scheme that is more general and user-oriented than extant suggestions. We also survey various policies that have been proposed for data propagation and analyse how change detection capabilities of sources influence user, as well as system requirements.
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
ACT-NET: The Active Database Management System Manifesto: A Rulebase of ADBMS Features. SIGMOD Record 25(3) (1996)
D. Agrawal, A.E. Abbadi, A.K. Singh, T. Yurek: Efficient View Maintenance at Data Warehouses. SIGMOD Conference (1997)
C. Chaudhuri, U. Dayal: An Overview of Data Warehousing and OLAP Technology. SIGMOD Record 26(1) (1997)
L.S. Colby, T. Griffin, L. Libkin, I.S. Mumick, H. Trickey: Algorithms for Deferred View Maintenance. SIGMOD Conference (1996)
U. Dayal, P.A. Bernstein: On the Updatability of Relational Views. VLDB (1978)
A. Gupta, I.S. Mumick: Maintenance of Materialized Views: Problems, Techniques, and Applications. IEEE Data Engineering Bulletin 18(2) (1995)
H. Gupta, I.S. Mumick: Selection of Views to Materialize Under a Maintenance Cost Constraint. International Conference on Database Theory (1999)
J. Hammer, H. Garcia-Molina, J. Widom, W. Labio, Y. Zhuge: The Stanford Data Warehousing Project. IEEE Data Engineering Bulletin 18(2) (1995)
E.N. Hanson: A Performance Analysis of View Materialization Strategies. SIGMOD Conference (1987)
V. Harinarayan, A. Rajaraman, J.D. U1lman: Implementing Data Cubes Efficiently. SIGMOD Conference (1996)
R. Hull, G. Zhou: A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches. SIGMOD Conference (1996)
R. Hull, G. Zhou: Towards the Study of Performance Trade-offs Between Materialized and Virtual Integrated Views. VIEWS’96 (1996)
H.V. Jagadish, I.S. Mumick, A. Silberschatz: View Maintenance Issues for the Chronicle Data Model. PODS (1995)
A. Koschel, P.C. Lockemann: Distributed events in active database systems: Letting the genie out of the bottle. Journal of Data and Knowledge Engineering 25(1–2) (1998)
M. Lee, J. Hammer: Speeding Up Warehouse Physical Design Using A Randomized Algorithm. Design and Management of Data Warehouses, workshop at CAiSE (1999)
D. Lomet (editor), J. Widom (editor): Special Issue on Materialized Views and Data Warehousing. IEEE Data Engineering Bulletin 18(2) (1995)
D. Quass, J. Widom: On-Line Warehouse View Maintenance. SIGMOD Conference (1997)
N. Roussopoulos, H. Kang: Principles and Techniques in the Design of ADMS±. IEEE Computer 19(12) (1986)
R. Roussopoulos, C.M. Chen, S. Kelley, A. Delis, Y. Papakonstantinou: The ADMS Project: Views “R” Us. IEEE Data Engineering Bulletin 18(2) (1995)
S. Schwiderski: Monitoring the Behaviour of Distributed Systems. PhD thesis, University of Cambridge (1996)
A. Segev, W. Fang: Currency-Based Updates to Distributed Materialized Views. ICDE (1990)
A. Segev, W. Fang: Optimal Update Policies for Distributed Materialized Views. Management Science 37(7) (1991)
J. Srivastava, D. Rotem: Analytical Modeling of Materialized View Maintenance. PODS (1988)
J. Widom: Research Problems in Data Warehousing. CIKM (1995)
M.C. Wu, A.P. Buchmann: Research Issues in Data Warehousing. Datenbanksysteme in Büro, Technik und Wissenschaft, Ulm (1997)
J. Yang, J. Widom: Maintaining Temporal Views Over Non-Temporal Information Sources For Data Warehousing. EDBT (1998)
S. Yang, S. Chakravarthy: Formal Semantics of Composite Events for Distributed Environments. ICDE (1999)
G. Zhou, R. Hull, R. King, J.C. Franchitti: Data Integration and Warehousing Using H2O. IEEE Data Engineering Bulletin 18(2) (1995)
Y. Zhuge, H. Garcia-Molina, J.L. Wiener: The Strobe Algorithms for Multi-Source Warehouse Consistency. PDIS (1996)
Y. Zhuge: Incremental Maintenance of Consistent Data Warehouses. PhD Thesis, Stanford University (1999)
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
Engström, H., Chakravarthy, S., Lings, B. (2000). A User-Centric View of Data Warehouse Maintenance Issues. In: Lings, B., Jeffery, K. (eds) Advances in Databases. BNCOD 2000. Lecture Notes in Computer Science, vol 1832. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45033-5_6
Download citation
DOI: https://doi.org/10.1007/3-540-45033-5_6
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-67743-7
Online ISBN: 978-3-540-45033-7
eBook Packages: Springer Book Archive