OLAP

From TedYunWiki
Revision as of 04:32, 13 November 2013 by Tedyun (talk | contribs) (Created page with "=== Two Types of Database Activity === # OLTP (Online Transaction Processing) #* short transactions #* simple queries #* touch small portions of data #* frequent update # OLAP...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Two Types of Database Activity

  1. OLTP (Online Transaction Processing)
    • short transactions
    • simple queries
    • touch small portions of data
    • frequent update
  2. OLAP (Online Analytical Processing)
    • long transactions
    • complex queries
    • touch large portions of the data
    • infrequent updates
Retrieved from "https://wiki.tedyun.com/index.php?title=OLAP&oldid=111"