OLTP vs OLAP - Khai's personal knowledge vault.

Edit History Tags Source

OLTP vs OLAP

OLTP (On Line Transaction Processing):

Current data
Short database transactions
Online update/insert/delete
Normalization is promoted
High volume transactions
Transaction recovery is necessary

OLAP (On Line Analytical Processing):

Current and historical data
Long database transactions
Batch update/insert/delete
Denormalization is promoted
Low volume transactions
Transaction recovery is not necessary

OLAP is more related to data warehousing, analyzing historical data.

page revision: 1, last edited: 13 Nov 2008 18:04

Edit Tags History Files Print Site tools + Options

Click here to edit contents of this page.

Click here to toggle editing of individual sections of the page (if possible). Watch headings for an "edit" link when available.

Append content without editing the whole page source.

Check out how this page has evolved in the past.

If you want to discuss contents of this page - this is the easiest way to do it.

View and manage file attachments for this page.

A few useful tools to manage this Site.

See pages that link to and include this page.

Change the name (also URL address, possibly the category) of the page.

View wiki source for this page without editing.

View/set parent page (used for creating breadcrumbs and structured layout).

Notify administrators if there is objectionable content in this page.

Something does not work as expected? Find out what you can do.

General Wikidot.com documentation and help section.

Wikidot.com Terms of Service - what you can, what you should not etc.

Wikidot.com Privacy Policy.

Khai's personal knowledge vault.

Materials on this site are not original. When possible, references to original articles are listed on each page.

OLTP (On Line Transaction Processing):

OLAP (On Line Analytical Processing):

Other interesting sites

Majjhima

Wikistória

Himetop

Performance & Philosophy