Difference between Database and Datawarehouse

What are the difference between a database and data warehouse?

Questions by maheshnayakg

Showing Answers 1 - 5 of 5 Answers

Normally database means deatailed data, and Volatile data and which contains summaraised data ,Non Volatile and subject oriented and time varient systems called as datawaer house

  Was this answer useful?  Yes

As per my knowledge : actually clusters will be using to not to have down time in the source system. mpp means massivly parlell processing (i.e parlelly processing from the source to target massively by placing multiple processors) but coming to cluster point,
first of all when ever we are fetching data from one 'A'system to 'B' system,'A' system should be down then only we can fetch data from 'A' to 'B'.
so now here by using cluster we do not want to down the 'A' system 

  Was this answer useful?  Yes

Data mart is subset of dataware house
In Brief: Assume that there is an company called vijayJDK,
 and it is havaing 4 dept
now if you develop dataware house for any of them above 4 dept's we call them as datamarts,and then if you consolidate 4 dept's then ,that will be called as dataware house

  Was this answer useful?  Yes

Database is a collection of mostly recent data. Where as Datawarehouse consist of historical data the size can vary upto 100 GB or more.
Datawarehouse is a combination of datamart used mainly knowledge processing.

  Was this answer useful?  Yes


  • Jul 28th, 2008

Database :- database is a collection of related information stored in a structured form in terms of table so that It makes easier insertion, deletion and mainupulation of data. database consist of tables that contain attributes.

DatawareHouse :- a data warehouse is a database system optimised for reporting.data warehousing involves architectures, methodologies and technologies that enable an organisation to better utilise its data in a way which minimises the load on source database systems. A data warehouse sources its data from the main operational systems but performs its own processing and stores the data efficiently to allow the data to be presented in the most usable format.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions