| |
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. |
| January 01, 2006 03:49:03 |
#7 |
| Sithu |
Database Expert Member Since: December 2005 Total Comments: 161 |
RE: What is a Data Warehousing?
|
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 |
| |
Back To Question | |
