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
No comments:
Post a Comment