Distinguish, differentiate, compare and explain what is the difference between Database and Data Warehouse. Comparison and Differences.
Comparison and Difference between Database and Data Warehouse
1. The tables and joins in the Database DB are complex since they are normalized. Tables and joins in Data Warehouse are simple since they are de-normalized.
2. ER Modeling techniques are used for database design whereas, in Data Warehouse, dimension modeling techniques are used for database design.
3. A database is optimized for write operation whereas Data Warehouse is optimized for reading operations.
4. In the database, performance is slow for analytical queries while data warehouse gives high performance for analytical queries