GeekInterview.com
Series: Subject: Topic:
Question: 129 of 129

What is a Data Warehousing?

Data Warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated....This makes it much easier and more efficient to run queries over data that originally came from different sources.

Typical relational databases are designed for on-line transactional processing (OLTP) and do not meet the requirements for effective on-line analytical processing (OLAP). As a result, data warehouses are designed differently than traditional relational databases.

Asked by: Interview Candidate | Asked on: Aug 25th, 2005
Showing Answers 1 - 14 of 14 Answers
Praveen

Answered On : Aug 16th, 2005

Datawarehosing is a process of creating,queriring and populating datawarehouse. it includes a number of discrete technologies like  
Identifying sources 
Process of ECCD, ETL which includes data cleansing , data transforming and data loading to targets. 

Yes  1 User has rated as useful.
  
Login to rate this answer.
R. Mohanraj

Answered On : Aug 25th, 2005

A Data warehouse is a subject oriented, integrated, time-variant, nonvolatile collection of data to enable decision making across disparate group of users.

Yes  3 Users have rated as useful.
  
Login to rate this answer.
sundeep pattanayak

Answered On : Sep 14th, 2005

A data warehouse is a repository containing subject-oriented, integrated,time-variant and non-volatile collection of data, used for  companys decision support systems requirement

Yes  1 User has rated as useful.
  
Login to rate this answer.
Shubhodip Chakravarty

Answered On : Sep 28th, 2005

Datawarehousing is a subject oriented, authoritative,integrated historical database reflective of changes over meaningful time periods in order to facilitate query and analysis for useful management decision making.

Yes  2 Users have rated as useful.
  
Login to rate this answer.
Shubhodip Chakravarty

Answered On : Sep 28th, 2005

Datawarehousing is a subject oriented, authoritative,integrated historical database reflective of changes over meaningful time periods in order to facilitate query and analysis for useful management decision making.

Yes  1 User has rated as useful.
  
Login to rate this answer.
senthil kumar.B

Answered On : Oct 3rd, 2005

Datawarehouse contains a collection of historic(history of data) ,integrated ,non-volatile  data ,which is used for analysing and developing forecasting reports.

Yes  1 User has rated as useful.
  
Login to rate this answer.
sithusithu

Answered On : Jan 12th, 2006

View all answers by sithusithu

Data-Warehouse-Prozess (englisch data warehousing) ist der Prozess zur Bewirtschaftung und Auswertung eines Data-Warehouses, der die folgenden Schritte umfasst: #Datenbeschaffung: das heit die Extraktion der relevanten Daten aus den Quellsystemen, Transformation und gegebenenfalls Bereinigung der Daten (Data Cleansing) in einem Arbeitsbereich (englisch staging area) sowie Laden in das Data-Warehouse. Dieser Schritt wird auch Extract-Transform-Load-Prozess (ETL-Prozess) genannt.

Cheers,

Sithu

  
Login to rate this answer.
sunil

Answered On : Aug 8th, 2006

a subject oriented,time varient,non volatile and integrated decision supporting system.

Yes  1 User has rated as useful.
  
Login to rate this answer.
rma

Answered On : Nov 29th, 2006

Data Warehousing is a collection of Subject Oriented, Integrated, non-Volatile and time Varient to Support Management decision-making Process

Yes  1 User has rated as useful.
  
Login to rate this answer.

A single complete and consistent store of data obtained from a variety of diff sources made available to end users in what they can understand and use in a business context.
As per bill Inman - a collection of subject oriented, integrated, nonvolatile and time varying data which is used in the process of decision making.
As per Ralph Kimball - a copy of transactional data specially structured to query and analysis.
In layman words - a data warehousing is a read only database which copies and stores the data from transactional data.

Yes  1 User has rated as useful.
  
Login to rate this answer.
tanilkumar_rao

Answered On : Aug 29th, 2007

View all answers by tanilkumar_rao

Data Warehousing is Relational Database which is specially designed for analysis processing rather then for querying and transactional processing.

Yes  1 User has rated as useful.
  
Login to rate this answer.

As explained by users , i think DWH is repository containing subject-oriented , integrated , nonovalatile and time varient data which helps the management to analysis the business trends and take the appropriate decision to improve the business.It is important that data quality is good inorder to analyse the data and take appropriate decision. It also helps to anaysis how a particular product is doing in market and take appropriate decision to improve more.

Yes  1 User has rated as useful.
  
Login to rate this answer.
spatnam

Answered On : Dec 9th, 2008

View all answers by spatnam

Data warehouse is Subject oriented,Integrated Non volatile, Time variant collection of data. unlike transactional systems. Its a Denormalized huge database.Used for Querying and Reporting Analytics.

  
Login to rate this answer.
Melisa

Answered On : Aug 24th, 2011

View all answers by Melisa

Hi..!!
As explained following above different people have different definitions for a data warehouse. The most popular definition came from Bill Inmon, who provided following:
A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in context of management's decision making process.

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.