Online Transaction Processing (OLTP)

Online Transaction Processing is a type of data processing that consists of executing a number of transactions occurring concurrently.

Three kinds of table update:

  1. The SQL INSERT command, for inserting a single constant tuple or each tuple in the result of a query;
  2. The SQL DELETE command, for removing all tuples satisfying a condition; and
  3. The SQL UPDATE command, for updating in place all tuples satisfying a condition.

See SQL.