Concepts - what is the difference between OLAP and datawarehosue

GeekInterview.com > Interview Questions > Data Warehousing > Concepts

Go To First | Previous Question | Next Question

Concepts | Question 16 of 31

what is the difference between OLAP and datawarehosue

Total Answers and Comments: 4

Last Update: July 24, 2007 Asked by: stalin.thangaraj

Sponsored Links

Best Rated Answer

—

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

August 01, 2006 13:59:01

mamatha

RE: what is the difference between OLAP and datawareho...

datawarehouse is the place where the data is stored for analyzing

where as OLAP is the process of analyzing the data,managing aggregations,

partitioning information into cubes for indepth visualization.

Is this answer useful? Yes | No

November 22, 2006 05:38:27

shafique

RE: what is the difference between OLAP and datawareho...

hi in OLAP ER schema is used whereas in data warehousing Star schema is used.OLAP is for process a unit of organization where as data warehousing interprise view of data

Is this answer useful? Yes | No

January 04, 2007 07:48:17

RE: what is the difference between OLAP and datawareho...

Don't get confused ,OLAP and Datawarehouse are the terms that can be used interchangeably in some places.Online Analytical Processing is a concept whereas Datawarehouse is the collection of data in denormalized form so that it can help in fast and frequent analysis.

Is this answer useful? Yes | No

July 24, 2007 02:23:35

harishsj

Member Since: July 2007 Contribution: 6

RE: what is the difference between OLAP and datawareho...

Datawarehouse V/S OLAP

Both the terms are interchangble.

DW:

Data from different source systems is stored in a relational database for end use analysis.
Data is organized in summarized, aggregated,subject-oriented,non-vilatile pattern.
Data in a DW is consolidated,flexible collection of data, which supports analysis of data, but not online analysis of data.

OLAP:

A tool to evaluate & analyze data in a DW using analytical queries.
A tool which helps organize data in a DW using multidimensional models.
Supports analysis in real time & online anlysis with speed and flexibility.

Is this answer useful? Yes | No

Go To Top