Difference Between Database and Data Warehouse

Parameter	Database	Data Warehouse
Definition	Organized Collection of Data is called database.	Database of Databases is Called Data Warehouse.
Purpose	It is designed to allow the definition, creation, querying, update, administration of data (Transaction Processing).	It is a relational database that is designed for query and analysis rather than transaction processing.
Data Type	Data stored in Database is up to date.	Current and Historical Data is Stored in Data Warehouse.
Orientation	Transaction Oriented: e.g. Each Transaction of Bank Customer is written to database and is interpreted as Accounting Database.	Subject Oriented: The data in the data warehouse is organized so that all the data elements relating to the same real-world event or object are linked together.
Data Redundancy	Databases are designed to avoid redundancy.	Data Warehouse design is intended to introduce redundancy.
Storage of data	Flat Relational Approach is used for data storage.	Data Ware House uses dimensional and normalized approach for data storage.
Query Type	Simple Transaction Queries are Used.	Uses Complex Queries for the analysis of Database.
Data Summary	Detailed Data is stored in database.	It stores detailed, lightly and highly summarized data.
Read/Write Optimization	Write Optimized: database is designed to make sure every transaction gets recorded within time. Data can be updated, deleted or can be over written.	Read Optimized and contains mostly read only data. Data in the data warehouse are never over-written or deleted — once committed, the data are static, read-only, and retained for future reporting.
Modeling	ER Modeling Technique is used for database Design.	Data Modeling Techniques is Data Warehouse Design.
User Access	Used by a large number of Operational Users.	Used by a limited number of managerial Users.

Alternate Links:

Difference between Database and Data Warehouse

How Database is Different from Data Ware House

Database vs Data Ware House

Distinguish between Database and Data Ware House

Compare Database and Data Ware House