Please enable JavaScript.
Coggle requires JavaScript to display documents.
2.2.1 Differentiate Data Warehousing and OLAP - Coggle Diagram
2.2.1 Differentiate Data Warehousing and OLAP
OLAP
OLAP tool helps to organize data in the warehouse using multidimensional models.
Data aggregation and summarization is utilized to organize data using multidimensional models.
data is analyzed and evaluated in the data ware house.
processing that can be used to analyze and evaluate data in a warehouse.
OLAP in a data warehouse enables companies to organize information in multiple dimensions, which makes it easy for businesses to understand and use data.
It is application-oriented.
In Online transaction processing, there is no data redundancy.
It uses transaction processing
In Online transaction processing, the size of data base is around 10MB-100GB.
It holds current data.
It is designed for business transaction process.
It is technique that is used for detailed day to day transaction data which keep chaining on everyday.
Data Warehouse
The warehouse has data coming from varied sources.
Data from different data sources is stored in a relational database for end use analysis.
Supports the analysis of data but does not support data of online analysis.
serves as a repository to store historical data that can be used for analysis.
It is technique that gathers or collect data from different sources into central repository .
It is designed for decision making process.
It stores large amount of data or historical data.
In Data warehousing, the size of database is around 100GB-2TB .
It uses Query processing.
In Data warehousing, data redundancy is present.
It is subject-oriented.
https://www.itransition.com/blog/olap-data-warehouse#:~:text=Thus%2C%20OLAP%20in%20a%20data,method%20of%20storing%20that%20data
.
https://www.careerride.com/Data-warehousing-OLAP-and-data-warehouse.aspx#:~:text=real%20time%20environment.-,What%20is%20the%20difference%20between%20OLAP%20and%20data%20warehouse%3F,data%20coming%20from%20varied%20sources
.
https://www.geeksforgeeks.org/difference-between-data-warehousing-and-online-transaction-processing-oltp/