Stanford InfoLab Publication Server

Expiring Data from a Warehouse

Labio, W. and Garcia-Molina, H. (1997) Expiring Data from a Warehouse. Technical Report. Stanford.




Data warehouses are used to collect and analyze data from remote sources. The data collected often originate from transactional information and can become very large. This paper presents a framework for incrementally removing warehouse data (without a need to fully recompute offering two choices. One is to expunge data, in which case the result is as if the data had never existed. The second is to expire data, in which case views defined over the data are not necessarily affected. the framework, a user or administrator can specify what data to expire or expunge, what auxiliary data is to be kept for facilitating incremental view maintenance, what type of updates are expected from external sources, and how the system should compensate when data is expired or other parameters changed. We present algorithms for the various expiration and compensation actions, and we show how our framework can be implemented on top of a conventional RDBMS. Keywords: view maintenance, data warehous

Item Type:Techreport (Technical Report)
Uncontrolled Keywords:Data Warehouse, Storage Management, View Maintenance
Subjects:Computer Science > Data Warehousing
Related URLs:Project Homepage
ID Code:256
Deposited By:Import Account
Deposited On:25 Feb 2000 16:00
Last Modified:04 Jan 2009 11:24

Download statistics

Repository Staff Only: item control page