Differentiation between data warehouse and OLAP

Briefly describe the differentiation between data warehouse and OLAP?

View Complete Question

Comments & Conversion

Expert

Verified

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.

Related Questions in Database Management System

Q : SQL Server Analysis Services cubes

Describe briefly the term SQL Server Analysis Services cubes?

Q : Types of Strategies Specify the several

Specify the several types of Strategies?

Q : Er diagram Consider a MOVIE database in

Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: ¦ Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genre

Q : Snapshot of data warehouse Write down

Write down the snapshot with reference to data warehouse?

Q : Reduction in Cost due to cloud computing

Reduction in Cost: Huge reduction in costs can be achieved due to cloud computing both in terms of capital expenditure and operational expenditure. Since the organization now need not build its own