Stanford InfoLab Publication Server

Expiring Data in a Warehouse

Garcia-Molina, H. and Labio, W. and Yang, J. (1998) Expiring Data in a Warehouse. In: 24rd International Conference on Very Large Data Bases (VLDB 1998), August 24-27, 1998 , New York, NY.




Data warehouses collect data into materialized views for analysis. After some time, some of the data may no longer be needed or may not be of interest. In this paper, we handle this by expiring or removing unneeded materialized view tuples. A framework supporting such expiration is presented. Within it, a user or administrator can declaratively request expirations and can specify what type of modifications are expected from external sources. The latter can significantly increase the amount of data that can be expired. We present efficient algorithms for determining what data can be expired (data not needed for maintenance of other views), taking into account the types of updates that may occur

Item Type:Conference or Workshop Item (Paper)
Uncontrolled Keywords:data warehousing, materialized views
Subjects:Computer Science > Data Warehousing
Related URLs:Project Homepage
ID Code:316
Deposited By:Import Account
Deposited On:25 Feb 2000 16:00
Last Modified:29 Dec 2008 09:36

Download statistics

Repository Staff Only: item control page