The very design that makes an OLTP system efficient for transaction processing makes it inefficient for what?
A) end-user ad hoc reports, queries, and analysis
B) transaction processing systems that constantly update operational databases
C) the collection of reputable sources of intelligence
D) transactions such as ATM withdrawals, where we need to reduce a bank balance accordingly

Question

Quizplus · Accepted Answer

OLTP systems are designed for efficient transaction processing, which prioritizes consistency, accuracy, and reliability of data. This design does not prioritize the ease of ad hoc reporting or analysis, which relies on different data structures and processing. OLTP systems are optimized for data retrieval for individual transactions, whereas analysis systems may need to retrieve and analyze large data sets across multiple periods to generate meaningful insights.

The Very Design That Makes an OLTP System Efficient for Transaction