and 3 others joined a min ago.
0
2.7kviews
Difference between database and data warehouse.
1 Answer
0
21views
written 9.9 years ago by
teamques10
★ 70k
|
| 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. |
ADD COMMENT
EDIT
Please log in to add an answer.