What is Transaction processing and analytical processing?
In short
Online transaction processing (OLTP) systems handle large numbers of short transactions in real time, such as order entry. Online analytical processing (OLAP) supports complex analysis of historical data, usually from a data warehouse.
Key takeaways
- Transaction systems use normalized databases optimized for fast updates.
- Analytical systems let users drill down and slice data across dimensions such as time, product and region.
- Running heavy analysis on transaction systems can slow operations.
Where it's tested
ISC: Data Management & Governance — study notes, a five-minute revision sheet and practice questions.
Practise: 3 questions
Question 1 of 3 · 0 answered
Who is normally accountable for approving which users may access a particular set of financial data?