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
OLTP | OLAP | |
users | clerk, IT professional | knowledge worker |
function DB design | day to day operations application-oriented | decision support subject-oriented |
data | surrent, 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
Tools
Sources (0)
Tags (0)
Comments (0)
History
Usage
Questions (0)
Playlists (0)
Quality
Sources
There are currently no sources for this slide.