Skip to main content
SpringerLink
Log in

A User-Centric View of Data Warehouse Maintenance Issues

  • Conference paper
  • First Online:
Advances in Databases (BNCOD 2000)

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

Included in the following conference series:

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.

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. ACT-NET: The Active Database Management System Manifesto: A Rulebase of ADBMS Features. SIGMOD Record 25(3) (1996)

    Google Scholar 

  2. D. Agrawal, A.E. Abbadi, A.K. Singh, T. Yurek: Efficient View Maintenance at Data Warehouses. SIGMOD Conference (1997)

    Google Scholar 

  3. C. Chaudhuri, U. Dayal: An Overview of Data Warehousing and OLAP Technology. SIGMOD Record 26(1) (1997)

    Google Scholar 

  4. L.S. Colby, T. Griffin, L. Libkin, I.S. Mumick, H. Trickey: Algorithms for Deferred View Maintenance. SIGMOD Conference (1996)

    Google Scholar 

  5. U. Dayal, P.A. Bernstein: On the Updatability of Relational Views. VLDB (1978)

    Google Scholar 

  6. A. Gupta, I.S. Mumick: Maintenance of Materialized Views: Problems, Techniques, and Applications. IEEE Data Engineering Bulletin 18(2) (1995)

    Google Scholar 

  7. H. Gupta, I.S. Mumick: Selection of Views to Materialize Under a Maintenance Cost Constraint. International Conference on Database Theory (1999)

    Google Scholar 

  8. J. Hammer, H. Garcia-Molina, J. Widom, W. Labio, Y. Zhuge: The Stanford Data Warehousing Project. IEEE Data Engineering Bulletin 18(2) (1995)

    Google Scholar 

  9. E.N. Hanson: A Performance Analysis of View Materialization Strategies. SIGMOD Conference (1987)

    Google Scholar 

  10. V. Harinarayan, A. Rajaraman, J.D. U1lman: Implementing Data Cubes Efficiently. SIGMOD Conference (1996)

    Google Scholar 

  11. R. Hull, G. Zhou: A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches. SIGMOD Conference (1996)

    Google Scholar 

  12. R. Hull, G. Zhou: Towards the Study of Performance Trade-offs Between Materialized and Virtual Integrated Views. VIEWS’96 (1996)

    Google Scholar 

  13. H.V. Jagadish, I.S. Mumick, A. Silberschatz: View Maintenance Issues for the Chronicle Data Model. PODS (1995)

    Google Scholar 

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

    Google Scholar 

  15. M. Lee, J. Hammer: Speeding Up Warehouse Physical Design Using A Randomized Algorithm. Design and Management of Data Warehouses, workshop at CAiSE (1999)

    Google Scholar 

  16. D. Lomet (editor), J. Widom (editor): Special Issue on Materialized Views and Data Warehousing. IEEE Data Engineering Bulletin 18(2) (1995)

    Google Scholar 

  17. D. Quass, J. Widom: On-Line Warehouse View Maintenance. SIGMOD Conference (1997)

    Google Scholar 

  18. N. Roussopoulos, H. Kang: Principles and Techniques in the Design of ADMS±. IEEE Computer 19(12) (1986)

    Google Scholar 

  19. R. Roussopoulos, C.M. Chen, S. Kelley, A. Delis, Y. Papakonstantinou: The ADMS Project: Views “R” Us. IEEE Data Engineering Bulletin 18(2) (1995)

    Google Scholar 

  20. S. Schwiderski: Monitoring the Behaviour of Distributed Systems. PhD thesis, University of Cambridge (1996)

    Google Scholar 

  21. A. Segev, W. Fang: Currency-Based Updates to Distributed Materialized Views. ICDE (1990)

    Google Scholar 

  22. A. Segev, W. Fang: Optimal Update Policies for Distributed Materialized Views. Management Science 37(7) (1991)

    Google Scholar 

  23. J. Srivastava, D. Rotem: Analytical Modeling of Materialized View Maintenance. PODS (1988)

    Google Scholar 

  24. J. Widom: Research Problems in Data Warehousing. CIKM (1995)

    Google Scholar 

  25. M.C. Wu, A.P. Buchmann: Research Issues in Data Warehousing. Datenbanksysteme in Büro, Technik und Wissenschaft, Ulm (1997)

    Google Scholar 

  26. J. Yang, J. Widom: Maintaining Temporal Views Over Non-Temporal Information Sources For Data Warehousing. EDBT (1998)

    Google Scholar 

  27. S. Yang, S. Chakravarthy: Formal Semantics of Composite Events for Distributed Environments. ICDE (1999)

    Google Scholar 

  28. G. Zhou, R. Hull, R. King, J.C. Franchitti: Data Integration and Warehousing Using H2O. IEEE Data Engineering Bulletin 18(2) (1995)

    Google Scholar 

  29. Y. Zhuge, H. Garcia-Molina, J.L. Wiener: The Strobe Algorithms for Multi-Source Warehouse Consistency. PDIS (1996)

    Google Scholar 

  30. Y. Zhuge: Incremental Maintenance of Consistent Data Warehouses. PhD Thesis, Stanford University (1999)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computer Science, University of Skövde, Sweden

    Henrik Engström

  2. Computer Science and Engineering Department, University of Texas at Arlington, US

    Sharma Chakravarthy

  3. School of Engineering and Computer Science, University of Exeter, UK

    Brian Lings

Authors
  1. Henrik Engström
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Sharma Chakravarthy
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Brian Lings
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science, University of Exeter, Prince of Wales Road, Exeter, EX4 4PT, UK

    Brian Lings

  2. Department for Computation and Information, CLRC Rutherford Appleton Laboratory, Chilton-Didcot, Oxon, OX11 0QX, UK

    Keith Jeffery

Rights and permissions

Reprints 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

Publish with us

Policies and ethics

Search

Navigation