Concurrency control and recovery in database systems
Concurrency control and recovery in database systems
The R*-tree: an efficient and robust access method for points and rectangles
SIGMOD '90 Proceedings of the 1990 ACM SIGMOD international conference on Management of data
Shoring up persistent applications
SIGMOD '94 Proceedings of the 1994 ACM SIGMOD international conference on Management of data
An overview of data warehousing and OLAP technology
ACM SIGMOD Record
Range queries in OLAP data cubes
SIGMOD '97 Proceedings of the 1997 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
Distributed and parallel computing issues in data warehousing (abstract)
Proceedings of the tenth annual ACM symposium on Parallel algorithms and architectures
SAC '98 Proceedings of the 1998 ACM symposium on Applied Computing
Array-Based Evaluation of Multi-Dimensional Queries in Object-Relational Databases Systems
ICDE '98 Proceedings of the Fourteenth International Conference on Data Engineering
Efficient Organization of Large Multidimensional Arrays
Proceedings of the Tenth International Conference on Data Engineering
The R+-Tree: A Dynamic Index for Multi-Dimensional Objects
VLDB '87 Proceedings of the 13th International Conference on Very Large Data Bases
The X-tree: An Index Structure for High-Dimensional Data
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Concurrent Warehouse Maintenance Without Compromising Session Consistency
DEXA '98 Proceedings of the 9th International Conference on Database and Expert Systems Applications
The DC-Tree: A Fully Dynamic Index Structure for Data Warehouses
ICDE '00 Proceedings of the 16th International Conference on Data Engineering
Concurrent Maintenance of Views Using Multiple Versions
IDEAS '99 Proceedings of the 1999 International Symposium on Database Engineering & Applications
Creation and management of versions in multiversion data warehouse
Proceedings of the 2004 ACM symposium on Applied computing
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
Design and development of a multiversion OLAP application
Proceedings of the 2006 ACM symposium on Applied computing
An extendible multidimensional array system for MOLAP
Proceedings of the 2006 ACM symposium on Applied computing
Integrating XML data in the TARGIT OLAP system
International Journal of Web Engineering and Technology
Data & Knowledge Engineering
Metadata management in a multiversion data warehouse
Journal on data semantics VIII
EaCRS: an extendible array based compression scheme for high dimensional data
Proceedings of the Second Symposium on Information and Communication Technology
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
Repairing inconsistent dimensions in data warehouses
Data & Knowledge Engineering
On-demand multidimensional data integration: toward a semantic foundation for cloud intelligence
The Journal of Supercomputing
Extended dimensions for cleaning and querying inconsistent data warehouses
Proceedings of the sixteenth international workshop on Data warehousing and OLAP
Hi-index | 0.00 |
A data warehouse is an integrated database whose data is collected from several data sources, and supports on-line analytical processing (OLAP). Typically, a query to the data warehouse tends to be complex and involves a large volume of data. To keep the data at the warehouse consistent with the source data, changes to the data sources should be propagated to the data warehouse periodically. Because the propagation of the changes (maintenance) is batch processing, it takes long time. Since both query transactions and maintenance transactions are long and involve large volumes of data, traditional concurrency control mechanisms such as two-phase locking are not adequate for a data warehouse environment. We propose a multi-version concurrency control mechanism suited for data warehouses which use multi-dimensional OLAP (MOLAP) servers. We call the mechanism multiversion concurrency control for data warehouses (MVCCDW). To our knowledge, our work is the first attempt to exploit versions for online data warehouse maintenance in a MOLAP environment. MVCC-DW guarantees the serializability of concurrent transactions. Transactions running under the mechanism do not block each other and do not need to place locks.