DB workloads

• Online transaction processing (OLTP): fast operations that only read or write a small amount of data each time
• Online analytical processing (OLAP): complex queries that read a lot of data to compute aggregates
• Hybrid: OLTP + OLAP mixed

Storage models

• N-ary storage model: store data in a tuple together
  • pros: …
  • cons: …
• Decomposition storage model: “official” name for column store
  • pros: …
  • cons: …