OLAP vs OLTP (5)

• Data model:

  • OLTP: relational data model
  • OLAP: multi-dimensional data cube
    • dimensions are hierarchical
    • typical operations:
      • roll-up and drill-down
      • slice_and_dice
      • pivot

Previous slide

Next slide

Back to first slide

View graphic version