appع

Definition

OLTP (online transaction processing)

Contributor(s): Lee Gilbert and Jan Hewitt

OLTP (online transaction processing) is a class of software programs capable of supporting -oriented applications on the Internet. In computing, a transaction is a sequence of discrete information exchanges that are treated as a unit. Many everyday acts involve OLTP, including online banking, online shopping and even in-store shopping when the point of sale (POS) terminal is tied to inventory management software.

Two important characteristics of an OLTP system are concurrency and atomicity. Atomicity guarantees that if one step is incomplete or fails during the transaction, the entirety will not continue. Concurrency prevents multiple users from altering the same data at the same time. In order for a transaction to be completed successfully, all database changes must be permanent, a condition known in computing as .

To avoid single points of failure, OLTP systems are often decentralized. For example, is a distributed relational database service that runs on . It is designed to support global online transaction processing.

OLTP vs. OLAP

In the past, online transaction processing (OLTP) databases were designed to only handle operational data and separate online analytical processing () databases handled any analytical processes. While OLTP systems processed all kinds of queries (read, insert, update and delete), OLAP was generally optimized for read only queries. To bridge the two systems, extract, transform and load () processes periodically moved data from the OLTP database to the OLAP database.

OLTP vs. OLAP

Today, some are able to process tables of transaction data stored in system memory instead of having to pull them from disk storage. This approach is called .

This was last updated in July 2019

Next Steps

Learn how SQL Server 2014 leverages in-memory technology

Continue Reading About OLTP (online transaction processing)

Dig Deeper on IBM system z and mainframe systems

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

Thank you so much, this website provides complete information in a concise way.
You will never know the amount of relief I get, when I find a term I am looking for, in your website.
Cancel

  • Learn how this free PowerShell-based utility digs into your Office 365 security setup and offers guidance for administrators ...

  • Administrators of Office 365 or Azure platforms can benefit from using newer Microsoft software technologies to handle many jobs,...

  • Microsoft's hosting service for DNS domains is an option for organizations with a heavy Azure investment that want the benefits ...

  • Mini PCs are a low-cost hardware alternative to servers that enable organizations to maintain maximum data center features and ...

  • VDI has specific hardware needs that servers hosting other virtualized workloads may not meet. Learn how to gauge VDI hardware ...

  • This year's VMworld conference runs virtually from Sep. 29 to Oct. 1. Read the latest news and announcements about and from the ...

  • The public cloud providers closed the 2010s as one of the dominant forces in IT, but they'll face competition in the 2020s from ...

  • Put your IT team in the best position to succeed with AI. Develop these machine learning skills and see how they translate to the...

  • Get to know AWS cloud networking services for load balancing, traffic routing, content delivery and more with this overview.

Close