An extension of Two Phase Locking to support parallel updates of data warehouses

Even though Two Phase Locking (2PL) has shown a good performance in various applications for on-line transaction processing, it failed to provide analytical transactions with fresh data in data warehousing systems. One of the main reasons for such poor freshness is due to the lack of parallel updates of data warehouses. If several update transactions in 2PL are allowed to execute concurrently without an adequate concurrency control, data inconsistency between data warehouses and operational databases inevitably arises due to incorrect propagation of the updates on the operational databases into the data warehouses. To prevent such an incorrect propagation of update transactions, we extended 2PL so as to process update transactions in an order of their creation if they conflict with each other. In addition, to speed up analytical transactions, locking rules of 2PL are slightly modified in a way of minimizing conflicts among transactions. To investigate the applicable areas of our algorithm, its performance is evaluated by means of simulation approach. Our experimental results show that the extended 2PL enables OLAP transactions to read fresher data than the conventional 2PL.
Publisher
INT ASSOC COMPUTER INFO SYSTEM
Issue Date
2006
Language
ENG
Keywords

CONSISTENCY; MANAGEMENT; SYSTEM

Citation

JOURNAL OF COMPUTER INFORMATION SYSTEMS, v.47, no.1, pp.3 - 14

ISSN
0887-4417
URI
http://hdl.handle.net/10203/4154
Appears in Collection
KGSM-Journal Papers(저널논문)
  • Hit : 468
  • Download : 64
  • Cited 0 times in thomson ci
This item is cited by other documents in WoS
⊙ Detail Information in WoSⓡClick to seewebofscience_button
⊙ Cited 1 items in WoSClick to see citing articles inrecords_button

qr_code

  • mendeley

    citeulike


rss_1.0 rss_2.0 atom_1.0