Wednesday, July 23, 2008

Differences between OLTP and OLAP databases.

Posted by sapbotopics
Differences between OLTP and OLAP databases.

Relational Database (OLTP)
Data is atomized
Data is current
Processes many records at a time
Process oriented
Designed for highly structured repetitive processing

Dimensional Database (OLAP)

Data is summarized
Data is historical
Processes one record at a time
Subject oriented
Designed for highly unstructured analytical processing
Labels:

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)