0
2.4kviews
Difference between database and data warehouse.
1 Answer
written 8.0 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 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. |