MetaCartSign in to MyCiteSeer

Include Citations | Advanced Search | Help

Include Citations | Advanced Search | Help

  Multiple View Consistency for Data Warehousing (1997) [31 citations — 3 self]

Download:
Download as a PDF | Download as a PS
by Yue Zhuge, Janet L. Wiener, Hector Garcia-molina
in Proceedings of IEEE International Conference on Data Engineering
http://www-db.stanford.edu/pub/papers/mvc-full.ps
Add To MetaCart

Abstract:

A data warehouse stores integrated information from multiple distributed data sources. In effect, the warehouse stores materialized views over the source data. The problem of ensuring data consistency at the warehouse can be divided into two components: ensuring that each view reflects a consistent state of the base data, and ensuring that multiple views are mutually consistent. In this paper we study the latter problem, that of guaranteeing multiple view consistency (MVC). We identify and define formally three layers of consistency for materialized views in a distributed environment. We present a scalable architecture for consistently handling multiple views in a data warehouse, which we have implemented in the WHIPS(WareHousing Information Project at Stanford) prototype. Finally, we develop simple, scalable, algorithms for achieving MVC at a warehouse. 1

Citations

1319 Concurrency Control and Recovery in Database Systems – Bernstein, Hadzilacos, et al. - 1987
797 Mediators in the Architecture of Future Information Systems – Wiederhold - 1992
230 View maintenance in a warehousing environment – Zhuge, Garcia-Molina, et al. - 1995
220 Maintenance of materialized views: Problems, techniques, and applications – GUPTA, MUMICK - 1995
189 Interoperability of Multiple Autonomous Databases – Litwin, Mark, et al. - 1990
170 Wm.; Efficiently Updating Materialized Views – Blakeley, Larson, et al. - 1986
140 Incremental Maintenance of Views with Duplicates – Griffin, Libkin - 1995
135 Updating Derived Relations: Detecting Irrelevant and Autonomously Computable Updates – Blakeley, Coburn, et al. - 1989
112 Making views self-maintainable for data warehousing – Quass, Gupta, et al. - 1996
97 A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches – Hull, Zhou - 1996
86 Overview of multidatabase transaction management – Breitbart, Garcia-Molina, et al. - 1992
86 The Strobe Algorithms for Multi-Source Warehouse Consistency – Zhuge, Garc'ia-Molina, et al. - 1996
83 Data Integration using Self-Maintainable Views – Gupta, Jagadish, et al. - 1994
79 Materialized view maintenance and integrity constraint checking: Trading space for time – Ross, Srivastava, et al. - 1996
28 Jarke. Incremental Maintenance of Externally Materialized Views – Staudt, Matthias - 1996
25 A System Prototype for Warehouse View Maintenance – Wiener, Gupta, et al. - 1996
10 Physical database design for data warehousing – Labio, Quass, et al. - 1997
8 Conservative timestamp revised for materialized view maintenance in a data warehouse – Baralis, Ceri, et al. - 1996