GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  Data Warehousing
Go To First  |  Previous Question  |  Next Question 
 Data Warehousing  |  Question 40 of 45    Print  
Difference between Database and Datawarehouse
What are the difference between a database and data warehouse?


  
Total Answers and Comments: 3 Last Update: June 09, 2008     Asked by: maheshnayakg 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 09, 2008 07:24:13   #1  
vijayinformatica Member Since: June 2008   Contribution: 3    

RE: Difference between Database and Datawarehouse

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


 
Is this answer useful? Yes | No
June 09, 2008 07:46:51   #2  
vijayinformatica Member Since: June 2008   Contribution: 3    

RE: Difference between Database and Datawarehouse
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 

 
Is this answer useful? Yes | No
June 09, 2008 07:57:11   #3  
vijayinformatica Member Since: June 2008   Contribution: 3    

RE: Difference between Database and Datawarehouse

Data mart is subset of dataware house
In Brief: Assume that there is an company called vijayJDK,
 and it is havaing 4 dept
1:petrolium
2:deisel
3:kirosine
4:crudoil
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


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape