Microsoft® SQL Server 2012 Unleashed

Application Terms

OLTP is a class of applications that facilitate and manage transaction-oriented processing, typically for data entry, complex business processes (such as order entry), and retrieval transactions. The term transaction in the context of computer or database transactions is a finite set of changes that are grouped together and can be undone together if any one of the pieces does not complete (or fails). But often we speak of transactions as a business “unit of work” that can span multiple database transactions as one logical business transaction. OLTP has also been used to refer to processing in which the system responds immediately to user requests. An automatic teller machine (ATM) application for a bank is the classic example ...