OLTP, OLAP, and Data Marts
OLTP (On-Line Transaction Processing)
- supports a business’ day-to-day activities
- high update rate, simple queries
- MB or GB
OLAP (On-Line Analytical Processing) system or Data Warehouse
- analyzes operational data
- low update rate, complex queries
- GB or TB
- a strategic business decision: high rewards, but low chance of success
A Data Mart is a subject-specific OLAP system
- 10-100 GB
- tactical entry into OLAP
- emphasis on integration and ease-of-use