OLAP vs OLTP (2)

• Data

  • OLTP: detailed, up-to-date data
    • hundreds of megabytes to gigabytes
  • OLAP: historical, summarized and consolidated data
    • from several operational databases
    • over potentially long periods of time
    • projected hundreds of gigabytes to terabytes

Previous slide

Next slide

Back to first slide

View graphic version