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

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:

Subscribe to: Post Comments (Atom)