Abstract
We consider the view maintenance problem in a web-based environment, in which clients query information from databases, stored in the form of materialized data warehouses, without accessing the original data sources. In addition to base data, data warehouses also contain highly aggregated and summarized information suitable for decision support. As changes are made to the data sources, the warehouse views must be updated to reflect a consistent state of the data sources. Recomputation is often too expensive. We describe in this paper an incremental view maintenance method based on the net changes on base table, to maintain the views efficiently in the presence of aggregation and summary information. An architecture of a web-based data warehousing system is described to minimize the workload of the data warehouse. Finally, we develop a prototype application utilizing the new maintenance algorithm and conduct a performance study based on the prototype, comparing it with existing maintenance algorithm.
Original language | English |
---|---|
Title of host publication | Proceedings of the 3rd ACM International Workshop on Data Warehousing and OLAP, DOLAP 2000 |
Publisher | Association for Computing Machinery |
Pages | 57-64 |
Number of pages | 8 |
Volume | Part F129125 |
ISBN (Electronic) | 1581133235 |
DOIs | |
Publication status | Published - 1 Nov 2000 |
Event | 3rd ACM International Workshop on Data Warehousing and OLAP, DOLAP 2000 - McLean, United States Duration: 6 Nov 2000 → 11 Nov 2000 |
Conference
Conference | 3rd ACM International Workshop on Data Warehousing and OLAP, DOLAP 2000 |
---|---|
Country/Territory | United States |
City | McLean |
Period | 6/11/00 → 11/11/00 |
Keywords
- Aggregated information
- Data warehouse
- Distributed databases
- Incremental refresh and propagate
- Internet
ASJC Scopus subject areas
- General Computer Science