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
Subscribe To
Posts
Comments
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Introduction to Semantic Layers The semantic layer is a metadata layer that abstracts the complexities of the data source. The end user see...
-
Designer lets you save universes in either enterprise or workgroup mode. Enterprise mode means that you are working in an environment with a...
-
Define what a Loop is Detect and recognize loops in Universe Using Aliases and Contexts to resolve the loops Identify when in the design ...
0 comments:
Post a Comment