Exam 9: Data Warehousing and Data Integration

What are some of the approaches to data integration?

________ is/are a new technology which trade(s) off storage space savings for computing time.

Data that are never physically altered once they are added to the store are called ________ data.

When a dimension participates in a hierarchy, the database designer can normalize the dimension into a nested set of tables with 1:M relationships between them.

A data mart is a data warehouse that contains data that can be used across the entire organization.

Data scrubbing is a technique 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.

The process of transforming data from a detailed to a summary level is called selection.

What is data transformation?

Data federation consolidates all data into one database.

The status of data is the representation of the data after an event has occurred.

The major advantage of the data propagation approach to data integration is the near real-time cascading of data changes throughout the organization.

Explain what the star schema is.

Every key used to join the fact table with a dimension table should be a ________ key.

User interaction integration is achieved by creating fewer ________ that feed different systems.

________ is an ill-defined term applied to databases where size strains the ability of commonly used relational DBMSs to manage the data.

Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data.

A conformed dimension is one or more dimension tables associated with only one fact table.

Why are data mining applications growing rapidly?

Explain a situation where multiple fact tables may be necessary.

What is a logical data mart and what makes this architecture unique?