1.

What Is The Main Differnce Between Schema In Rdbms And Schemas In Datawarehouse?

Answer»

RDBMS Schema
* USED for OLTP SYSTEMS
* Traditional and old schema
* NORMALIZED
* Difficult to understand and navigate
* Cannot solve extract and complex problems
* Poorly modelled
DWH Schema
* Used for OLAP systems
* New generation schema
* DE Normalized
* EASY to understand and navigate
* Extract and complex problems can be easily solved
* Very good model.

RDBMS Schema
* Used for OLTP systems
* Traditional and old schema
* Normalized
* Difficult to understand and navigate
* Cannot solve extract and complex problems
* Poorly modelled
DWH Schema
* Used for OLAP systems
* New generation schema
* De Normalized
* Easy to understand and navigate
* Extract and complex problems can be easily solved
* Very good model.


Discussion

No Comment Found

Related InterviewSolutions