| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: What is a Data Warehousing?
Answer: 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. |
| August 08, 2007 09:05:21 |
#10 |
| amarnath.a |
Member Since: August 2007 Total Comments: 1 |
RE: What is a Data Warehousing?
|
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. |
| |
Back To Question | |
