Isolation (database systems)

<p>In <a href="/facts/Database/VYcpkevb">database</a> systems, isolation is one of the <a href="/facts/ACID/XdHkYzHN">ACID</a> (<i><a href="/facts/Atomicity_(database_systems)/A356GsoW">Atomicity</a>, <a href="/facts/Consistency_(database_systems)/GmTWXGKA">Consistency</a>, Isolation, <a href="/facts/Durability_(database_systems)/KHYwqzG0">Durability</a></i>) <a href="/facts/Database_transaction/q1Etrsl8">transaction</a> properties. It determines how <a href="/facts/Database_transaction/q1Etrsl8">transaction</a> integrity is visible to other users and systems. A lower isolation level increases the ability of many users to access the same data at the same time, but also increases the number of <a href="/facts/Concurrency_(computer_science)/Ctnrrq4A">concurrency</a> effects (such as <a href="/facts/Write%E2%80%93read_conflict/bnm0I5Qw"> dirty reads</a> or <a href="/facts/Lost_update/m8nBTdWF">lost updates</a>) users might encounter. Conversely, a higher isolation level reduces the types of concurrency effects that users may encounter, but requires more system resources and increases the chances that one transaction will block another.
</p>

Isolation (database systems) open-in-new

Isolation (database systems)