Microsoft Azure Data FundamentalsDescribe core data conceptsMedium
A financial institution processes millions of transactions daily, requiring immediate consistency and atomicity for each transaction to maintain data integrity. These transactions involve updates to account balances, which must be accurate at all times. Which type of data workload BEST describes this scenario?
- ABatch Processing
- BOnline Transaction Processing (OLTP)
- COnline Analytical Processing (OLAP)
- DStream Processing
Show answer & explanationAnswer & explanation
Correct answer: B. Online Transaction Processing (OLTP)
Online Transaction Processing (OLTP) is characterized by a high volume of small, atomic, and concurrent transactions requiring immediate consistency, which perfectly matches the financial institution's need for accurate, real-time account balance updates.
Why the other options are wrong
- A. Batch processing handles large volumes of data at scheduled intervals, not immediate, individual transactions.
- C. OLAP is for complex analytical queries on historical data, not real-time transactional updates.
- D. Stream processing handles continuous data streams, but the focus here is on individual, atomic transactions, not just data flow.
Online Transaction Processing (OLTP)
A class of software systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing.
- Characterized by a large number of small, atomic transactions.
- Requires high data integrity and immediate consistency (ACID properties).
- Optimized for fast inserts, updates, and deletes.
- Common in banking, e-commerce, and airline reservation systems.
Memory trick: OLTP is like a busy cashier, quick and precise with every transaction.