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
-
n Oracle/PLSQL, the decode function has the functionality of an IF-THEN-ELSE statement. The syntax for the decode function is: ...
-
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