Friday 31 August 2012

Differences between Datawarehouse schema and RDBMS schema?


RDBMS Schema
DWH Schema
Used in OLTP system like banking
Used for OLAP systems
Its Normalized using either of the normal forms
Its De normalized
Its difficult to understand the tables and understand in User perspective
Easy to understand and mainly used for data analysis and extracting the data.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

ShareThis