Download:
|
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
|