Transaction processing system software software#

OLTP systems are typically decentralized so the failure of a single server will not cause a failure in concurrency. Online transaction processing systems were developed to optimize concurrency (multiple users making multiple transactions in real time). The complexity of the process means most organizations today use database management systems to support OLTP operations. In essence, OLTP involves data input, processing the data and then updating existing data to reflect the gathered and processed data. OLTP databases need to operate in as close to real time as possible. Database queries with online transaction processing systems are simple, typically with sub-second response times and in most cases return relatively few records. Almost any business that has a large number of users who conduct short online transactions needs an OLTP system. OLTP database systems are commonly used for order entry, financial transactions, customer relationship management and retail sales via the Internet.

Transaction processing system software software#

Online transaction processing is database software designed to support transaction-related applications on the Internet.