| 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 Department of Computing |
| Pages: | vi, 73 leaves : ill. ; 30 cm |
| Language: | English |
| 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. |
| Rights: | All rights reserved |
| Access: | restricted access |
Files in This Item:
| File | Description | Size | Format | |
|---|---|---|---|---|
| b14421707.pdf | For All Users (off-campus access for PolyU Staff & Students only) | 2.76 MB | Adobe PDF | View/Open |
Copyright Undertaking
As a bona fide Library user, I declare that:
- I will abide by the rules and legal ordinances governing copyright regarding the use of the Database.
- 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.
- 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.
Please use this identifier to cite or link to this item:
https://theses.lib.polyu.edu.hk/handle/200/3249