Data warehousing

Data Warehousing

Data warehousing (pronunciation: /ˈdeɪtə ˈwɛərˌhaʊsɪŋ/) is a system used for reporting and data analysis, and is considered a core component of business intelligence.

Etymology

The term "data warehousing" was coined by Bill Inmon in 1990, who is known as the father of data warehousing. The term is a metaphor derived from the concept of a physical warehouse.

Definition

A data warehouse is a large store of data collected from a wide range of sources within a company and used to guide management decisions. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.

Components

Data warehousing involves several key components, including:

• Data Integration: This is the process of combining data from different sources into a single, unified view. Integration begins with the ingestion process, and includes steps such as cleansing, ETL mapping, and transformation.

• Data Cleaning: This involves detecting and correcting (or removing) corrupt or inaccurate records from a record set, table, or database.

• Data Transformation: This is the process of converting data from one format or structure into another format or structure.

• Data Loading: This involves loading the data into the data warehouse. Data loading primarily involves transforming data into a single format that is appropriate for reporting and analysis.

Related Terms

• Data Mining: This is the process of discovering patterns in large data sets involving methods at the intersection of machine learning, statistics, and database systems.

• Business Intelligence: This involves strategies and technologies used by enterprises for the data analysis of business information.

• ETL: Extract, Transform, Load (ETL) is a process in data warehousing responsible for pulling data out of the source systems and placing it into a data warehouse.

This WikiMD.org article is a stub. You can help make it a full article.