OLAP vs OLTP (3)
Workload
- OLTP: large number of simple transactions
- read or update a few (tens of) records accessed typically on their primary keys
- OLAP: complex, ad-hoc queries
- access large amounts of data (5 years of sales data)
- analyze relationships between many types of business elements (sales, products, regions, channels)
- compute and compare aggregated data over hierarchical time periods (monthly, quarterly, yearly)
- present data in different perspectives (sales by regions vs sales by channels within each region)