Concurrency control and recovery in database systems
Concurrency control and recovery in database systems
Efficiently updating materialized views
SIGMOD '86 Proceedings of the 1986 ACM SIGMOD international conference on Management of data
SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
ACM Transactions on Database Systems (TODS)
Maintaining views incrementally
SIGMOD '93 Proceedings of the 1993 ACM SIGMOD international conference on Management of data
View maintenance in a warehousing environment
SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
Algorithms for deferred view maintenance
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Algebraic change propagation for semijoin and outerjoin queries
ACM SIGMOD Record
Locking Primitives in a Database System
Journal of the ACM (JACM)
Making views self-maintainable for data warehousing
DIS '96 Proceedings of the fourth international conference on on Parallel and distributed information systems
Mysql Reference Manual
SIGMOD '84 Proceedings of the 1984 ACM SIGMOD international conference on Management of data
Incremental Recomputation of Active Relational Expressions
IEEE Transactions on Knowledge and Data Engineering
Concurrency Control Theory for Deferred Materialized Views
ICDT '97 Proceedings of the 6th International Conference on Database Theory
On-line Schema Update for a Telecom Database
ICDE '00 Proceedings of the 16th International Conference on Data Engineering
Data recovery in IBM database 2
IBM Systems Journal
Efficient Execution of Small (Single-Tuple) Transactions in Main-Memory Databases
ADBIS '08 Proceedings of the 12th East European conference on Advances in Databases and Information Systems
Online reorganization of databases
ACM Computing Surveys (CSUR)
Non-blocking materialized view creation and transformation of schemas
ADBIS'06 Proceedings of the 10th East European conference on Advances in Databases and Information Systems
Online, asynchronous schema change in F1
Proceedings of the VLDB Endowment
| Hi-index | 0.00 |
A database schema should be able to evolve to reflect changes to the universe it represents. In existing systems, user transactions get blocked during complex schema transformations. Blocking user transactions is not an option in systems with very high availability requirements, like operational telecom databases. A non-blocking transformation framework is therefore needed. A method for performing non-blocking full outer join and split transformations, suitable for highly available databases, is presented in this paper. Only the log is used for change propagation, and this makes the method easy to integrate into existing DBMSs. Because the involved tables are not locked, the transformation may run as a low priority background process. As a result, the transformation has little impact on concurrent user transactions.