Difference between database and data warehouse.

2views

written 6.4 years ago by

Database	Data warehouse
IT is used for Online Transactional Processing (OLTP).	It is used for Online Analytical Processing (OLAP).
This can be used for other purposes such as Data Warehousing.	This reads the historical data for the Users for business decisions.
In a database the tables and joins are complex since they are normalized for RDMS. This reduces redundant data and saves storage space.	In data warehouse, the tables and joins are simple since they are de-normalized. This is done to reduce the response time for analytical queries.
Relational modeling techniques are used for RDMS database design.	Modeling techniques are used for the Data Warehouse design.
It is optimized for write operation.	It is optimized for read operations.
In a database, the performance is low for analysis queries.	In a data warehouse, there is high performance for analytical queries.
It includes rows and columns.	It includes a database in its structure.	.

ADD COMMENT EDIT