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:
SQL INSERTcommand, for inserting a single constant tuple or each tuple in the result of a query;
SQL DELETEcommand, for removing all tuples satisfying a condition; and
SQL UPDATEcommand, for updating in place all tuples satisfying a condition.