cid 7c857ccd4c5c65e84305f1d1ee97653743b3fd7aac56e331645dd176e08f9812 · original · via openalex
Title: MVCC Authors: Venkateswara Vadlamani Venue: Apress eBooks Year: 2024 Canonical: doi:10.1007/979-8-8688-0817-3_17 URL: https://doi.org/10.1007/979-8-8688-0817-3_17 Collector: openalex OA: false ABSTRACT The core competency of the database engine is gauged by its adherence to multi-version concurrency control (MVCC) transaction processing procedures and protocols. MVCC enables multiple user transactions to access the data concurrently for select, insert, update, and delete operations using ANSI-compliant isolation levels, which include READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, or SERIALIZABLE. Dirty reads are possible with READ UNCOMMITTED transactions, whereas READ COMMITTED reads committed data, avoiding dirty reads.