Chapter 10 Database

Static Extract

A method of capturing a snapshot of the required source data at a point in time. (10)

Incremental Extract

A method of capturing only the changes that have occurred in the source data since the last capture. (10)

Aggregation

A part-of relationship between a component object and an aggregate object. (w13) The process of transforming data from a detailed level to a summary level. (10)

Data Steward

A person assigned the responsibility of ensuring that organizational applications properly support the organization's enterprise goals for data quality. (10)

Data Scrubbing

A process of using pattern recognition and other artificial intelligence techniques to upgrade the quality of raw data before transforming and moving the data to the data warehouse. Also called data cleansing. (10)

Data Federation

A technique for data integration that provides a virtual view of integrated data without actually creating one centralized database. (10)

Update Mode

An approach to filling a data warehouse in which only changes in the source data are written to the data warehouse. (10)

Refresh Mode

An approach to filling a data warehouse that involves bulk rewriting of the target data at periodic intervals. (10)

Changed Data Capture

Comparing the current operational database with an image of the data taken at the last transfer of data to the warehouse

Master Data Management

Disciplines, technologies, and methods used to ensure the currency, meaning, and quality of reference data within and across various subject areas. (10)

Data Governance

High-level organizational groups and processes that oversee data stewardship across the organization. It usually guides data quality initiatives, data architecture, data integration and master data management, data warehousing and business intelligence, and other data-related matters. (10)

Data Transformation

The component of data reconciliation that converts data from the format of the source operational systems to the format of the enterprise data warehouse. (10)

Joining

The process of combining data from various sources into a single table or view. (10)

Selection

The process of partitioning data according to predefined criteria. (10)