The Community for Technology Leaders
Parallel and Distributed Information Systems, International Conference (1996)
Dec. 18, 1996 to Dec. 20, 1996
ISBN: 0-8186-7475-X
pp: 0158
D. Quass , Dept. of Comput. Sci., Stanford Univ., CA, USA
A. Gupta , Dept. of Comput. Sci., Stanford Univ., CA, USA
I.S. Mumick , Dept. of Comput. Sci., Stanford Univ., CA, USA
J. Widom , Dept. of Comput. Sci., Stanford Univ., CA, USA
ABSTRACT
Abstract: A data warehouse stores materialized views over data from one or more sources in order to provide fast access to the integrated data, regardless of the availability of the data sources. Warehouse views need to be maintained in response to changes to the base data in the sources. Except for very simple views, maintaining a warehouse view requires access to data that is not available in the view itself. Hence, to maintain the view, one either has to query the data sources or store auxiliary data in the warehouse. The authors show that by using key and referential integrity constraints, one often can maintain a select-project-join view without going to the data sources or replicating the base relations in their entirety in the warehouse. They derive a set of auxiliary views such that the warehouse view and the auxiliary views together are self-maintainable-they can be maintained without going to the data sources or replicating all base data. In addition, their technique can be applied to simplify traditional materialized view maintenance by exploiting key and referential integrity constraints.
INDEX TERMS
data integrity; data warehousing; materialized views; fast integrated data access; self-maintainable views; data source querying; auxiliary data storage; referential integrity constraints; key integrity constraints; select-project-join view; warehouse view; auxiliary views; materialized view maintenance
CITATION

I. Mumick, J. Widom, D. Quass and A. Gupta, "Making Views Self-Maintainable for Data Warehousing," Parallel and Distributed Information Systems, International Conference(PDIS), vol. 00, no. , pp. 0158, 1996.
doi:10.1109/PDIS.1996.568677
83 ms
(Ver 3.3 (11022016))