Policy for reducing update duration of materialized views by distinguishing Insertion/Deletion operations


The KIPS Transactions:PartD, Vol. 10, No. 6, pp. 917-926, Oct. 2003
10.3745/KIPSTD.2003.10.6.917,   PDF Download:

Abstract

More views in data warehouse, can respond to the users more rapidly because the user's requests may be processed by utilizing only the materialized views with higher probabilities rather than accessing base relations. But, more views cause longer update duration of all the materialized views. During the update time, queries of users can not be processed because accesses to the datawarehouse are blocked. Thus, the update durations of the materialized views are necessary to be reduced. In this paper, we propose algorithm for reducing the update duration of the materialized views owing to managing by distinguishing insertion/deletion operations. Though there might be overheads for distinguishing insertion/deletion, we conclude that proposed algorithm could be excellent than others.


Statistics
Show / Hide Statistics

Statistics (Cumulative Counts from September 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.


Cite this article
[IEEE Style]
K. G. Hyeong and L. D. Cheol, "Policy for reducing update duration of materialized views by distinguishing Insertion/Deletion operations," The KIPS Transactions:PartD, vol. 10, no. 6, pp. 917-926, 2003. DOI: 10.3745/KIPSTD.2003.10.6.917.

[ACM Style]
Kim Geun Hyeong and Lee Dong Cheol. 2003. Policy for reducing update duration of materialized views by distinguishing Insertion/Deletion operations. The KIPS Transactions:PartD, 10, 6, (2003), 917-926. DOI: 10.3745/KIPSTD.2003.10.6.917.