17 years helping Australian businesses
choose better software
Online Transaction Processing
Online transaction processing (OLTP) is a database system paradigm for handling transactional data. In computing, a transaction is defined as a sequence of discrete actions that are treated as a single unit. For example, withdrawing money from a bank account is a transaction that involves multiple steps (debiting the first account and crediting the second). OLTP systems need to be atomic: if one step fails, the entire transaction should fail. They also need to be highly available, fast, and capable of handling potentially large amounts of concurrent transactions. The OLTP paradigm is contrasted with online analytical processing (OLAP), which is a database architecture for performing business queries and analytics.
What Small and Midsize Businesses Need to Know About Online Transaction Processing
Small and midsize businesses likely need both OLTP and OLAP databases in their IT ecosystem. OLTP systems support day-to-day business operations, while OLAP systems are intended for complex business intelligence and analytics.
Related terms
- Tokenization
- ROIT (Return on Information Technology)
- SAC (Subscriber Acquisition Cost)
- Energy Trading and Risk Management (ETRM)
- Chief Revenue Officer (CRO)
- Core Banking System
- Record to Report (R2R)
- Fintech
- Financial Management System (FMS)
- Business Capability Modeling
- Capital Allocation
- Compound Annual Growth Rate (CAGR)
- Net Present Value
- Hedge Fund
- Gateway
- Selling General and Administrative (SG&A) Expenses
- ROE (Return on Equity)
- Financial Planning and Analysis (FP&A)
- Dollar-Cost Averaging (DCA)
- Procure-to-pay Solution
