OLAP vs OLTP (1)
Objective
- OLTP: automate clerical data processing tasks
- order entry, banking transaction, brokerage trading etc.
- bread-and-butter day-to-day operations of an enterprise
- OLAP: support organizational decision making
- analyze data to look for patterns, trends and exception conditions
- provide real-time support to analysts, managers, and executives in effective strategic decision making