Conflict order-based view refreshment scheme for transaction management in data warehouse environment

Online analytical processing transactions (OLAP for short) are executed in integrated a data warehouse (DWH for short). DWH should be refreshed by recent value of data in source databases in order to prevent OLAP transactions from reading excessively stale data. This refreshing process is referred to as view maintenance. There have been many researches on ways to guarantee data consistency during the process of view maintenance. The most commonly used approach among them is to execute updated transactions in the nighttime while OLAP transactions are executed only in daytime. It is, however, meaningless to argue about absolute nighttime for a specific corporation. which is globalized. We proposed so called COB algorithm for view maintenance in DWH environment. COB can improve data freshness by supporting concurrent execution of one or more update transactions. COB can, moreover, reduce the cost of space management by maintaining only one additional version during the process of view maintenance.
Publisher
INT ASSOC COMPUTER INFO SYSTEM
Issue Date
2003
Language
ENG
Citation

JOURNAL OF COMPUTER INFORMATION SYSTEMS, v.44, no.2, pp.105 - 111

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

qr_code

  • mendeley

    citeulike


rss_1.0 rss_2.0 atom_1.0