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. |
Year | DOI | Venue |
---|---|---|
1999 | 10.1109/IDEAS.1999.787275 | IDEAS |
Keywords | Field | DocType |
materialized view,data warehouse,views dynamically,warehouse reader,latest updates,warehouse maintenance transaction,reader session,multiple versions,consistent data,maintenance transaction,concurrent maintenance,configuration management,data warehouses,transaction processing,databases,data mining,information science,read only memory,efficiency,data analysis,data integrity,materialized views | Transaction processing,Data warehouse,Data mining,World Wide Web,Concurrency,Computer science,Tuple,Data integrity,Database transaction,Online analytical processing,Materialized view,Database | Conference |
ISBN | Citations | PageRank |
0-7695-0265-2 | 12 | 1.43 |
References | Authors | |
10 | 2 |
Name | Order | Citations | PageRank |
---|---|---|---|
Sachin Kulkarni | 1 | 151 | 8.87 |
Mukesh Mohania | 2 | 496 | 42.79 |