Materialized view self-maintenance on a personal loan application system

Pao Yue-kong Library Electronic Theses Database

Materialized view self-maintenance on a personal loan application system


Author: Yip, Po-yuk Mabel
Title: Materialized view self-maintenance on a personal loan application system
Degree: M.Sc.
Year: 1998
Subject: Data warehousing
Department: Multi-disciplinary Studies
Dept. of Computing
Pages: vi, 73 leaves : ill. ; 30 cm
Language: English
InnoPac Record:
Abstract: A data warehouse is a repository of integrated information from distributed, autonomous and possibly heterogeneous sources. This provides a one-stop shop for end-users who require data from these heterogeneous sources for decision support. Materialized views represent the relations stored at the data warehouse that facilitate the decision support analysis. These materialized views are synchronized periodically with the source data to provide up-to-date and consistent information to end users for further analysis. This process of synchronization is known as View Maintenance. In traditional data warehouse applications, the view maintenance process is executed daily when the source as well as warehouse databases are put offline. However, this introduces several problems: - For multinational corporation with offices worldwide, the time difference between countries make database offline impossible. - As more and more data are required for decision support, the batch window may not be long enough for a complete view maintenance process. - The communication line may not be capable to handle such a large volume of data transfer. Self-maintainable methodologies in view maintenance form one of the hottest research topics in data warehouse research. By self-maintainable means that it is capable to maintain materialized views without going to the data source or replicating the entire base relations in the source databases to the warehouse. This opens up a new paradigm in data warehouse application design. The objective of this dissertation is to advocate such methodologies to tackle the problems associated with the data warehouse view maintenance process. A Personal Loan Application System is used as an example implementation of the view maintenance methodologies. With the implementation of such methodologies, the source databases are capable to operate without being put offline during view maintenance, and the time for the process is expected to be much reduced.

Files in this item

Files Size Format
b14421707.pdf 2.825Mb PDF
Copyright Undertaking
As a bona fide Library user, I declare that:
  1. I will abide by the rules and legal ordinances governing copyright regarding the use of the Database.
  2. I will use the Database for the purpose of my research or private study only and not for circulation or further reproduction or any other purpose.
  3. I agree to indemnify and hold the University harmless from and against any loss, damage, cost, liability or expenses arising from copyright infringement or unauthorized usage.
By downloading any item(s) listed above, you acknowledge that you have read and understood the copyright undertaking as stated above, and agree to be bound by all of its terms.


Quick Search


More Information