koti57

 Profile Answers by koti57 

• Aug 30th, 2010

 

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.

prasadkawade

 Profile Answers by prasadkawade 

• Mar 20th, 2012

 

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.

Rajarao marisa

• Jun 6th, 2012

 

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