Self-maintainable Data Warehouse Views Using Differential Files

  • Authors:
  • Wookey Lee;Yonghun Hwang;Suk-Ho Kang;Sanggeun Kim;Changmin Kim;Yunsun Lee

  • Affiliations:
  • -;-;-;-;-;-

  • Venue:
  • DEXA '02 Proceedings of the 13th International Conference on Database and Expert Systems Applications
  • Year:
  • 2002

Quantified Score

Hi-index 0.00

Visualization

Abstract

Data warehouses materialize views in order to provide fast access to information, but the correctness also should be maintained. The notion of self-maintenance can be a goal that defined as maintaining views by materializing supplementary data. Incremental update mechanisms can now be prospective way to the goal. A discussion with extensive literature is generated on several issues with maintaining data warehouse views. There are issues related to the data warehouse view maintenance: algebraic approaches, the concurrency control problem, database rule related problems. Motivating example derived from TPC-D database is suggested in terms of incremental base relation method, auxiliary view method, and differential method respectively. After quantitative dealings and qualitative measures are reviewed, it is concluded that the differential method is superior to the others in that it is a true self-maintenance method and it does not burden the current base relations.