vijayinformatica

 Profile Answers by vijayinformatica 

• Jun 9th, 2008

 

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

vijayinformatica

 Profile Answers by vijayinformatica 

• Jun 9th, 2008

 

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 

vijayinformatica

 Profile Answers by vijayinformatica 

• Jun 9th, 2008

 

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

ashuboy12345678

 Profile Answers by ashuboy12345678 

• Jul 27th, 2008

 

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.

gtomar

 Profile Answers by gtomar 

• 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.