Database and Data Warehouse

Database is the data required for transactions in a business and data warehouse is the data required for business analysis and decision making process.

Simply database is current data and data warehouse is the current data and historical data. i,e database + metadata.

Company database contains all the current data.
whereas the data warehouse of means data repository.
Database stores all the data on which business runs but database repository contains the data that is required for transactions. that all historical data. e.g.when the data is updated or deleted then one can find the earlier records in data repository.

All the changes done in data structure or data are being tracked by data repository.

Hi,
The main diff between database and data warehouse------>
DW
1)Its stores historical & Summarized data
2)Denormalized data(multiple joins)
3)Its improves query performance
4)Queried by business users(eg:CEO,MANAGERS...)
5)Enterprize data

DB
1)It stores current transactional data
2)Normalized data(relations)
3)Its improves transactions performance
4)Queried by end users(clerks,account holders
5)Department data