Transaction Isolation in Mixed-Level and Mixed-Scope Settings
Autor: | Stephen J. Hegner |
---|---|
Rok vydání: | 2019 |
Předmět: |
050101 languages & linguistics
Schedule (computer science) Scope (project management) Computer science Property (programming) Serialization 05 social sciences 02 engineering and technology Computer security computer.software_genre Serializability 0202 electrical engineering electronic engineering information engineering 020201 artificial intelligence & image processing 0501 psychology and cognitive sciences Isolation (database systems) Set (psychology) computer Database transaction |
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 |
Externí odkaz: |