Parallel and Distributed Information Systems, International Conference (1996)
Dec. 18, 1996 to Dec. 20, 1996
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: 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.
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
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.