mamatha

• Aug 1st, 2006

 

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.

shafique

• Nov 22nd, 2006

 

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

Guest

• Jan 4th, 2007

 

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.

harishsj

 Profile Answers by harishsj Questions by harishsj

• Jul 24th, 2007

 

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.