Sunday, July 27, 2014

What are the differnces between a RDBMS schema and a data warehouse schema?

RDBMS Schema
  •   Used for OLTP systems
  •   Highly Normalized
  •   Difficult to understand and navigate
  •   Difficult to extract and solve complex problems
DWH Schema
  •   Used for OLAP systems
  •   De-normalized
  •   Easy to understand and navigate
  •   Relatively easier in extracting the data and solving complex problems

No comments: