Title: Selective 2-versioning for concurrency control in data warehousing systems: S2V

Authors: Jinbae Kim, Dongcheon Shin, Songchun Moon

Addresses: Department of Computer Science, Anyang Technical College, San 39-1, Anyang 3, Manan, Anyang, Gyeonggi 430-749, Republic of Korea. Department of Information System, Chung-Ang University, 72-1 Naeri, Daeduck, Ansung, Gyeonggi 456-756, Republic of Korea. Graduated School of Management, Korea Advanced Institute of Science and Technology, 207-43 Cheongryang, Dongdaemun, Seoul 130-012, Republic of Korea

Abstract: To speed up on-line analytical processing, data warehousing systems materialise views derived from several operational databases. When the operational databases happen to change, the materialised views get stale. To enhance the freshness of the materialised views, we proposed a new concurrency control scheme, which enables a number of update transactions to execute concurrently with analytical transactions. When an update transaction attempts to modify the data that is using by any analytical transactions, this scheme immediately allows the update transaction to create a new transient version for the data. Due to this selective versioning, analytical transactions could continuously access fresh data.

Keywords: concurrency control; data warehouse; materialised view; selective 2-versioning; serialisability.

DOI: 10.1504/IJCAT.2003.002123

International Journal of Computer Applications in Technology, 2003 Vol.17 No.4, pp.263-271

Published online: 07 Oct 2003 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article