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.

2 comments:

  1. Very Impressive SQL Tutorial. The content seems to be pretty exhaustive and excellent and will definitely help in learning SQL Tutorial. I'm also a learner taken up SQL Tutorial and I think your content has cleared some concepts of mine. While browsing for SQL Tutorial on YouTube i found this fantastic video on SQL Tutorial. Do check it out if you are interested to know more.:-https://www.youtube.com/watch?v=2OZQXAsCBvk

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis