OLTP
Current data
Short database transactions
Online update/insert/delete
Normalization is promoted
High volume transactions
Transaction recovery is necessary
OLAP
Current and historical data
Long database transactions
Batch update/insert/delete
Denormalization is promoted
Low volume transactions
Transaction recovery is not necessary
Showing posts with label OLTP. Show all posts
Showing posts with label OLTP. Show all posts
Tuesday, June 15, 2010
Subscribe to:
Posts (Atom)