Logo
Unionpedia
Communication
Get it on Google Play
New! Download Unionpedia on your Android™ device!
Free
Faster access than browser!
 

Isolation (database systems)

Index Isolation (database systems)

In database systems, isolation determines how transaction integrity is visible to other users and systems. [1]

24 relations: ACID, American National Standards Institute, Application software, Atomicity (database systems), Concurrency (computer science), Concurrency control, Consistency (database systems), Database, Deadlock, Durability (database systems), Insert (SQL), International Organization for Standardization, Java Database Connectivity, Multiversion concurrency control, Optimistic concurrency control, Record locking, Relational database management system, Schedule (computer science), Select (SQL), Serializability, Snapshot isolation, Spring Framework, SQL, Two-phase locking.

ACID

In computer science, ACID (Atomicity, Consistency, Isolation, Durability) is a set of properties of database transactions intended to guarantee validity even in the event of errors, power failures, etc.

New!!: Isolation (database systems) and ACID · See more »

American National Standards Institute

The American National Standards Institute (ANSI) is a private non-profit organization that oversees the development of voluntary consensus standards for products, services, processes, systems, and personnel in the United States.

New!!: Isolation (database systems) and American National Standards Institute · See more »

Application software

An application software (app or application for short) is a computer software designed to perform a group of coordinated functions, tasks, or activities for the benefit of the user.

New!!: Isolation (database systems) and Application software · See more »

Atomicity (database systems)

In database systems, atomicity (or atomicness; from Greek atomos, undividable) is one of the ACID (Atomicity, Consistency, Isolation, Durability) transaction properties.

New!!: Isolation (database systems) and Atomicity (database systems) · See more »

Concurrency (computer science)

In computer science, concurrency refers to the ability of different parts or units of a program, algorithm, or problem to be executed out-of-order or in partial order, without affecting the final outcome.

New!!: Isolation (database systems) and Concurrency (computer science) · See more »

Concurrency control

In information technology and computer science, especially in the fields of computer programming, operating systems, multiprocessors, and databases, concurrency control ensures that correct results for concurrent operations are generated, while getting those results as quickly as possible.

New!!: Isolation (database systems) and Concurrency control · See more »

Consistency (database systems)

Consistency in database systems refers to the requirement that any given database transaction must change affected data only in allowed ways.

New!!: Isolation (database systems) and Consistency (database systems) · See more »

Database

A database is an organized collection of data, stored and accessed electronically.

New!!: Isolation (database systems) and Database · See more »

Deadlock

In concurrent computing, a deadlock is a state in which each member of a group is waiting for some other member to take action, such as sending a message or more commonly releasing a lock.

New!!: Isolation (database systems) and Deadlock · See more »

Durability (database systems)

In database systems, durability is the ACID property which guarantees that transactions that have committed will survive permanently.

New!!: Isolation (database systems) and Durability (database systems) · See more »

Insert (SQL)

An SQL INSERT statement adds one or more records to any single table in a relational database.

New!!: Isolation (database systems) and Insert (SQL) · See more »

International Organization for Standardization

The International Organization for Standardization (ISO) is an international standard-setting body composed of representatives from various national standards organizations.

New!!: Isolation (database systems) and International Organization for Standardization · See more »

Java Database Connectivity

Java Database Connectivity (JDBC) is an application programming interface (API) for the programming language Java, which defines how a client may access a database.

New!!: Isolation (database systems) and Java Database Connectivity · See more »

Multiversion concurrency control

Multiversion concurrency control (MCC or MVCC), is a concurrency control method commonly used by database management systems to provide concurrent access to the database and in programming languages to implement transactional memory.

New!!: Isolation (database systems) and Multiversion concurrency control · See more »

Optimistic concurrency control

Optimistic concurrency control (OCC) is a concurrency control method applied to transactional systems such as relational database management systems and software transactional memory.

New!!: Isolation (database systems) and Optimistic concurrency control · See more »

Record locking

Record locking is the technique of preventing simultaneous access to data in a database, to prevent inconsistent results.

New!!: Isolation (database systems) and Record locking · See more »

Relational database management system

A relational database management system (RDBMS) is a database management system (DBMS) based on the relational model invented by Edgar F. Codd at IBM's San Jose Research Laboratory.

New!!: Isolation (database systems) and Relational database management system · See more »

Schedule (computer science)

In the fields of databases and transaction processing (transaction management), a schedule (or history) of a system is an abstract model to describe execution of transactions running in the system.

New!!: Isolation (database systems) and Schedule (computer science) · See more »

Select (SQL)

The SQL SELECT statement returns a result set of records from one or more tables.

New!!: Isolation (database systems) and Select (SQL) · See more »

Serializability

In concurrency control of databases,Philip A. Bernstein, Vassos Hadzilacos, Nathan Goodman (1987): (free PDF download), Addison Wesley Publishing Company, Gerhard Weikum, Gottfried Vossen (2001):, Elsevier, transaction processing (transaction management), and various transactional applications (e.g., transactional memoryMaurice Herlihy and J. Eliot B. Moss. Transactional memory: architectural support for lock-free data structures. Proceedings of the 20th annual international symposium on Computer architecture (ISCA '93). Volume 21, Issue 2, May 1993. and software transactional memory), both centralized and distributed, a transaction schedule is serializable if its outcome (e.g., the resulting database state) is equal to the outcome of its transactions executed serially, i.e. without overlapping in time.

New!!: Isolation (database systems) and Serializability · See more »

Snapshot isolation

In databases, and transaction processing (transaction management), snapshot isolation is a guarantee that all reads made in a transaction will see a consistent snapshot of the database (in practice it reads the last committed values that existed at the time it started), and the transaction itself will successfully commit only if no updates it has made conflict with any concurrent updates made since that snapshot.

New!!: Isolation (database systems) and Snapshot isolation · See more »

Spring Framework

The Spring Framework is an application framework and inversion of control container for the Java platform.

New!!: Isolation (database systems) and Spring Framework · See more »

SQL

SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

New!!: Isolation (database systems) and SQL · See more »

Two-phase locking

In databases and transaction processing, two-phase locking (2PL) is a concurrency control method that guarantees serializability.

New!!: Isolation (database systems) and Two-phase locking · See more »

Redirects here:

Isolation (DBMS), Isolation (computer science), Isolation (data management), Isolation (database management), Isolation Level, Isolation level, Phantom read, Transaction isolation, Transaction isolation level.

References

[1] https://en.wikipedia.org/wiki/Isolation_(database_systems)

OutgoingIncoming
Hey! We are on Facebook now! »