Isolation Levels
Of the four ACID properties in a DBMS (Database Management System), the isolation property is the one most often relaxed. When attempting to maintain the highest level of isolation, a DBMS usually acquires locks on data or implements multiversion concurrency control, which may result in a loss of concurrency. This requires adding logic for the application to function correctly.
Most DBMS's offer a number of transaction isolation levels, which control the degree of locking that occurs when selecting data. For many database applications, the majority of database transactions can be constructed to avoid requiring high isolation levels (e.g. SERIALIZABLE level), thus reducing the locking overhead for the system. The programmer must carefully analyze database access code to ensure that any relaxation of isolation does not cause software bugs that are difficult to find. Conversely, if higher isolation levels are used, the possibility of deadlock is increased, which also requires careful analysis and programming techniques to avoid.
The isolation levels defined by the ANSI/ISO SQL standard are listed as follows.
Read more about this topic: Isolation (database Systems)
Famous quotes containing the words isolation and/or levels:
“The one happiness is to shut one’s door upon a little room, with a table before one, and to create; to create life in that isolation from life.”
—Eleonora Duse (1859–1924)
“The word which gives the key to the national vice is waste. And people who are wasteful are not wise, neither can they remain young and vigorous. In order to transmute energy to higher and more subtle levels one must first conserve it.”
—Henry Miller (1891–1980)