Differentiation between data warehouse and OLAP

Question

Briefly describe the differentiation between data warehouse and OLAP?

Answer 1

The differences between data warehousing and OLAP are illustrated below:

i) Data Warehouse:

• Data from various data sources is kept in a relational database for end utilize analysis.
• Data organization is in the type of comprehensive, summarized, unstable and subject leaning patterns.
• Supports the analysis of data however doesn’t support data of online analysis.

ii) Online Analytical Processing:

• With the practice of analytical queries, data is determined and measured in the data ware house.
• Data summarization and aggregation is employed to systematize data using multidimensional models.
• Flexibility and Speed for online data analysis is supported for data analyst in actual time situation.