Difference between OLAP and data warehouse

NEXT>>
Data warehousing - What is the difference between OLAP and data warehouse? - May 11, 2009 at 14:40 pm by Vidya Sagar

What is the difference between OLAP and data warehouse?

The following are the differences between OLAP and data warehousing:

Data Warehouse

Data from different data sources is stored in a relational database for end use analysis.
Data organization is in the form of summarized, aggregated, non volatile and subject oriented patterns.
Supports the analysis of data but does not support data of online analysis.

Online Analytical Processing

With the usage of analytical queries, data is analyzed and evaluated in the data ware house.
Data aggregation and summarization is utilized to organize data using multidimensional models.
Speed and flexibility for online data analysis is supported for data analyst in real time environment.

Data warehousing - What is the difference between OLAP and data warehouse? - May 19, 2009 at 11:40 am by Rajmeet Ghai

What is the difference between OLAP and data warehouse?

A data warehouse serves as a repository to store historical data that can be used for analysis. OLAP is Online Analytical processing that can be used to analyze and evaluate data in a warehouse. The warehouse has data coming from varied sources. OLAP tool helps to organize data in the warehouse using multidimensional models.

NEXT>>
More Related Links
What is an OLTP system and OLAP system?

Answer - OLTP: Online Transaction and Processing helps and manages applications based........

What is XMLA?

Answer - XMLA is XML for Analysis which can be considered as a standard for accessing data in OLAP.......

What is data modeling and data mining? What is this used for?

Designing a model for data or database is called data modelling........ 

 
Latest placement tests
Latest links
 
 
Home | Want a Job? Submit Key Skills | Employer login | My key skills | About us | Sitemap | Contact us