Transaction Isolation in Mixed-Level and Mixed-Scope Settings

Autor: Stephen J. Hegner
Rok vydání: 2019
Předmět:
Zdroj: Advances in Databases and Information Systems ISBN: 9783030287290
ADBIS
DOI: 10.1007/978-3-030-28730-6_24
Popis: Modern database-management systems permit the isolation level to be set on a per-transaction basis. In such a mixed-level setting, it is important to understand how transactions running at different levels interact. More fundamentally however, these levels are sometimes of different scopes. For example, READ COMMITTED and REPEATABLE READ are of local scope, since the defining properties depend upon only the transaction and its relationship to those running concurrently. On the other hand, SERIALIZABLE is of global scope; serializability is a property of a schedule of transactions, not of a single transaction. In this work, in addition to formalizing the interaction of transactions at different levels, the meaning of serializability within local scope is also addressed.
Databáze: OpenAIRE