Basics - What is the main differnce between schema in RDBMS and schemas in DataWarehouse....?

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 42 of 111

What is the main differnce between schema in RDBMS and schemas in DataWarehouse....?

Total Answers and Comments: 5

Last Update: February 13, 2006

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

August 31, 2005 10:05:36

AS VENKATESH

RE: What is the main differnce between schema in RDBMS and schemas in DataWarehouse....?

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

Is this answer useful? Yes | No

December 15, 2005 08:27:34

Sithu

RE: What is the main differnce between schema in RDBMS...

Schema is nothing but the systematic arrangement of tables

In OLTP it will be normalized
In Data warehouse it will be denormalized

Is this answer useful? Yes | No

January 08, 2006 05:54:42

Surya

RE: What is the main differnce between schema in RDBMS...

The difference depends on the context.

Technically, if Oracle is used, a schema is a "user". In that context there is no difference between the schema's in OLTP or ROLAP.Although, denormalized/nortmalized tables are given as examples above, it is not the difference.

Is this answer useful? Yes | No

January 25, 2006 04:33:16

sithusithu

Member Since: December 2005 Contribution: 161

RE: What is the main differnce between schema in RDBMS...

RDBMS-normalized

Datawarehouse -Denormalized

Is this answer useful? Yes | No

February 13, 2006 02:52:56

senthil kumar B

RE: What is the main differnce between schema in RDBMS...

Diff b.w OLTP and OLAP :
------------------------

OLTP Schema :
* Normalized
* More no.of trans
* Less time for queries execution
* More no.of users
* Have Insert,delete and update trans.

OLAP (DWH) Schema :

* De Normalized
* Less no.of trans
* Less no.of users
* More time for query exec
* Will not have more insert,delete and updates.

Is this answer useful? Yes | No

Go To Top