Current Slide

Small screen detected. You are viewing the mobile version of SlideWiki. If you wish to edit slides you will need to use a larger device.

OLTP vs. OLAP

 OLTPOLAP
usersclerk, IT professional
knowledge worker

function

DB design

day to day operations

application-oriented

decision support

subject-oriented

datasurrent, up-to-date detailed, flat relational isolated
historical, summarized, multidimensional integrated, sonsolidated

usage

access

repetetive

read/write index/hash on prim key

ad-hoc

lots of scans

unit of work

#records accessed

short, simple transaction

tens

complex query

millions

#users

DB size

metric

thousands

100MB-GB

transaction throughput

hundreds

100GB-TB

query throughput, response



Speaker notes:

Content Tools

Sources

There are currently no sources for this slide.