Transaction Control Language

A Transaction Control Language (TCL) is a computer language and a subset of SQL, used to control transactional processing in a database. A transaction is logical unit of work that comprises one or more SQL statements, usually a group of Data Manipulation Language (DML) statements.

Examples of TCL commands include:

COMMIT to apply the transaction by saving the database changes.
ROLLBACK to undo all changes of a transaction.
SAVEPOINT to divide the transaction into smaller sections. It defines breakpoints for a transaction to allow partial rollbacks.

Database management systems

Types	Object-oriented comparison Relational comparison Document-oriented Graph NoSQL NewSQL

Concepts	Database ACID CAP theorem CRUD Null Candidate key Foreign key Primary key Superkey Surrogate key Armstrong's axioms

Objects	Relation table column row View Transaction Log Trigger Index Stored procedure Cursor Partition

Components	Concurrency control Data dictionary JDBC XQJ ODBC Query language Query optimizer Query plan

Functions	Administration and automation Query optimization Replication

Related topics	Database models Database normalization Database storage Distributed DBMS Federated database system Referential integrity Relational algebra Relational calculus Relational database Relational DBMS Relational model Object-relational database Transaction processing

This article is issued from Wikipedia - version of the Tuesday, February 23, 2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.

Transaction Control Language

See also