Exam 15: Databases for Decision Support

In a star schema, dimensions are normally stored in ____.

A data store is used by the data analyst to create the queries that access the database.

To support a(n) ____________________ adequately, the DBMS might be required to use advanced hardware, such as multiple disk arrays, and even more importantly, to support multiple-processor technologies, such as a symmetric multiprocessor (SMP) or a massively parallel processor (MPP).

OLAP systems are designed to use both operational and data ____________________ data.

A(n) ____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.

Normalizing fact tables improves data access performance and saves data storage space.

Facts can be computed or derived at run time.

ROLAP extends ____ so that it can differentiate between access requirements for data warehouse data and operational data.

____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.

The basic star schema has four components: facts, ____, attributes, and attribute hierarchies.

When you ____________________ data, you are aggregating the data to a higher level.

____ systems provided no data extraction/integration process.

The data warehouse designer must define common business dimensions that will be used by the data analyst to narrow a search, group information, or describe attributes.

To deliver efficient decision support, OLAP tools must have advanced data ____________________ features.

There are 12 rules that define a(n) ____.

Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.

Once data enter the data warehouse, they are never removed.

Operational data and decision support data serve the same purpose.

Fact and dimension tables are related by ____ keys.

OLAP systems share three main characteristics. What are they?