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

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Print |

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

February 02, 2006 02:52:56	#5
senthil kumar B	Member Since: Visitor Total Comments: N/A
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.