DocumentCode :
3088613
Title :
Concurrent maintenance of views using multiple versions
Author :
Kulkarni, Sachin ; Mohania, Mukesh
Author_Institution :
DataBase Div., Prophecy Int. Ltd., Kent Town, SA, Australia
fYear :
1999
fDate :
36373
Firstpage :
254
Lastpage :
258
Abstract :
Materialized views in data warehouses are maintained incrementally, for reasons of efficiency, to present the latest updates to the users. These views are used by many warehouse readers (users) to execute OLAP queries by running several reader sessions and these views are maintained periodically by maintenance transactions. Therefore, there is an inherent problem of maintaining these views while the reader sessions continue to receive consistent data from these views. In this paper, we discuss a method that allows warehouse maintenance transactions to run concurrently with the reader sessions. Concurrency allows the readers to read the data from the views while the maintenance transaction updates these views. In our proposed method we create additional versions of views dynamically that contain only the modified tuples of the views and provide a mechanism to collapse these versions into the views periodically when there are no reader sessions accessing the views. These versions allow the reader sessions to access the old and the new information. The collapsing of the views is done by a low-priority process executing periodically
Keywords :
configuration management; data integrity; data mining; data warehouses; transaction processing; OLAP queries; concurrent view maintenance; consistent data; data warehouse maintenance transactions; efficiency; latest updates; maintenance transactions; materialized views; modified tuples; multiple versions; periodically executing low-priority process; reader sessions; view collapsing; Australia; Cities and towns; Data analysis; Data warehouses; Databases; Information science; Lakes; Marketing and sales; Read only memory;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Database Engineering and Applications, 1999. IDEAS '99. International Symposium Proceedings
Conference_Location :
Montreal, Que.
Print_ISBN :
0-7695-0265-2
Type :
conf
DOI :
10.1109/IDEAS.1999.787275
Filename :
787275
Link To Document :
بازگشت