0
2.4kviews
Difference between database and data warehouse.
1 Answer
0
21views
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 datawarehouse, 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.
Ina database, the performance is low for analysis queries. In a datawarehouse, there is high performance for analytical queries.
It includes rows and columns. It includes a database in its structure.
Please log in to add an answer.