SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
On-line warehouse view maintenance
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Supporting multiple view maintenance policies
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Efficient view maintenance at data warehouses
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Multiversion concurrency control—theory and algorithms
ACM Transactions on Database Systems (TODS)
Incremental Maintenance of Materialized Views
DEXA '97 Proceedings of the 8th International Conference on Database and Expert Systems Applications
Concurrent Warehouse Maintenance Without Compromising Session Consistency
DEXA '98 Proceedings of the 9th International Conference on Database and Expert Systems Applications
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Incremental maintenance of multi-source views
ADC '01 Proceedings of the 12th Australasian database conference
MEDWRAP: Consistent View Maintenance over Distributed Multi-relation Sources
DEXA '02 Proceedings of the 13th International Conference on Database and Expert Systems Applications
Creation and management of versions in multiversion data warehouse
Proceedings of the 2004 ACM symposium on Applied computing
Accessing multidimensional data through natural text-based user interactivity
WISICT '04 Proceedings of the winter international synposium on Information and communication technologies
DSD: maintain data cubes more efficiently
Fundamenta Informaticae - Special issue on the 9th international conference on rough sets, fuzzy sets, data mining and granular computing (RSFDGrC 2003)
On querying versions of multiversion data warehouse
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
ENC '05 Proceedings of the Sixth Mexican International Conference on Computer Science
Exploiting versions for on-line data warehouse maintenance in MOLAP servers
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
New trends in information integration
Proceedings of the 2nd international conference on Ubiquitous information management and communication
Metadata management in a multiversion data warehouse
Journal on data semantics VIII
Metadata management in a multiversion data warehouse
OTM'05 Proceedings of the 2005 OTM Confederated international conference on On the Move to Meaningful Internet Systems: CoopIS, COA, and ODBASE - Volume Part II
DSD: Maintain Data Cubes More Efficiently
Fundamenta Informaticae - The 9th International Conference on Rough Sets, Fuzzy Sets, Data Mining and Granular Conputing (RSFDGrC 2003)
| Hi-index | 0.00 |
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.