Data warehousing - difference between OLAP and data warehouse

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.

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.
Data warehousing - Describe the foreign key columns in fact table and dimension table.
Foreign key columns in fact table and dimension table - The primary keys of entity tables are the foreign keys.......
Data warehousing - What is cube grouping?
What is cube grouping? - A transformer built set of similar cubes is known as cube grouping.......
Data warehousing - Define the term slowly changing dimensions (SCD)
Define the term slowly changing dimensions (SCD) - Slowly changing dimension target operator is one of the SQL warehousing operators......
Post your comment