Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access