Concurrency control and recovery in database systems
Concurrency control and recovery in database systems
View maintenance in a warehousing environment
SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
An overview of data warehousing and OLAP technology
ACM SIGMOD Record
On-line warehouse view maintenance
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
Synchronizing a database to improve freshness
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
The notions of consistency and predicate locks in a database system
Communications of the ACM
The Strobe algorithms for multi-source warehouse consistency
DIS '96 Proceedings of the fourth international conference on on Parallel and distributed information systems
Performance Issues in Incremental Warehouse Maintenance
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Efficient Snapshot Differential Algorithms for Data Warehousing
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
| Hi-index | 0.00 |
To speed up on-line analytical processing, data warehousing systems materialise views derived from several operational databases. When the operational databases happen to change, the materialised views get stale. To enhance the freshness of the materialised views, we proposed a new concurrency control scheme, which enables a number of update transactions to execute concurrently with analytical transactions. When an update transaction attempts to modify the data that is using by any analytical transactions, this scheme immediately allows the update transaction to create a new transient version for the data. Due to this selective versioning, analytical transactions could continuously access fresh data.