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.

Showing Answers 1 - 44 of 44 Answers

Praveen

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

R. Mohanraj

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

sundeep pattanayak

  • 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

Shubhodip Chakravarty

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

Shubhodip Chakravarty

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

senthil kumar.B

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

sithusithu

  • Jan 12th, 2006
 

Data-Warehouse-Prozess (englisch data warehousing) ist der Prozess zur Bewirtschaftung und Auswertung eines Data-Warehouses, der die folgenden Schritte umfasst: #Datenbeschaffung: das hei?t 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

  Was this answer useful?  Yes

sunil

  • Aug 8th, 2006
 

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

rma

  • Nov 29th, 2006
 

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

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.

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.

spatnam

  • Dec 9th, 2008
 

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.

  Was this answer useful?  Yes

Melisa

  • Aug 24th, 2011
 

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.

  Was this answer useful?  Yes

sourajit

  • Jan 13th, 2014
 

Data warehousing is the repository of an organizations electronically stored data. It’s basically designed to facilitate reporting and analysis but in a broader way data warehousing means to retrieve and analyze data, to extract , transform and load the data and to manage the data directory.

The definition of data warehouse includes business intelligence tool, extract, transform and load tools and tools for managing g and retrieving metadata.

  Was this answer useful?  Yes

mukku

  • Feb 25th, 2014
 

A data warehouse is a powerful database model that enhances the users ability to quickly analyze large and multinational data sets..

data warehouse changes and organizes data to allow users to make business decisions..

Data in the warehouse must have strong analytic characteristics i.e

1. Subject Oriented
2. Integrated
3. Time Referenced
7. Non- Volatile..

  Was this answer useful?  Yes

Avik Saha

  • Jul 2nd, 2014
 

Data Warehouse is an electronic storage of an organization of historical data for the purpose of analysis,reporting,data mining or knowledge discovery.

Data warehouse is a collection of set of information as well as supporting system.

  Was this answer useful?  Yes

Sushi

  • Apr 6th, 2016
 

DWH is a copy transactional data which is used for queries and analysis and also it is a subject-oriented, integrated, time varient and non volatile and then we use for reporting also....

  Was this answer useful?  Yes

TimeBeing

  • Jan 25th, 2017
 

Datawarehousing is a process of Designing a database Schema, ETL process and Reporting.

  Was this answer useful?  Yes

chandrasekhar

  • Mar 10th, 2017
 

The complete process of ETL activities (Extract, Transform and Load) and BI (Business Intelligence for generating reports) are called Data Warehousing.

  Was this answer useful?  Yes

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