Incremental update to aggregated information for data warehouses over internet

M. Chan, Hong Va Leong, A. Si

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

5 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 publicationInternational Conference on Information and Knowledge Management, Proceedings
Pages57-64
Number of pages8
Publication statusPublished - 1 Dec 2000
Event9th International Conference on Information and Knowledge Management (CIKM 2000) - McLean, VA, United States
Duration: 10 Nov 2000 → …

Conference

Conference9th International Conference on Information and Knowledge Management (CIKM 2000)
CountryUnited States
CityMcLean, VA
Period10/11/00 → …

Keywords

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

ASJC Scopus subject areas

  • Decision Sciences(all)
  • Business, Management and Accounting(all)

Cite this