Incremental update to aggregated information for data warehouses over internet

Miranda Chan, Hong Va Leong, Antonio Si

Research output: Chapter in book / Conference proceedingConference article published in proceeding or bookAcademic researchpeer-review

6 Citations (Scopus)

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 languageEnglish
Title of host publicationProceedings of the 3rd ACM International Workshop on Data Warehousing and OLAP, DOLAP 2000
PublisherAssociation for Computing Machinery
Pages57-64
Number of pages8
VolumePart F129125
ISBN (Electronic)1581133235
DOIs
Publication statusPublished - 1 Nov 2000
Event3rd ACM International Workshop on Data Warehousing and OLAP, DOLAP 2000 - McLean, United States
Duration: 6 Nov 200011 Nov 2000

Conference

Conference3rd ACM International Workshop on Data Warehousing and OLAP, DOLAP 2000
CountryUnited States
CityMcLean
Period6/11/0011/11/00

Keywords

  • Aggregated information
  • Data warehouse
  • Distributed databases
  • Incremental refresh and propagate
  • Internet

ASJC Scopus subject areas

  • Computer Science(all)

Cite this