Exam 15: Databases for Decision Support

In a typical star schema, each dimension record is related to thousands of ____ records.

____________________ makes a copy of a table and places it in a different location to improve access time.

The ____ schema is designed to optimize data query operations rather than data update operations.

BI is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom.

The ____ dimension of a data cube provides a framework from which sales patterns can be analyzed and possibly predicted.

MOLAP is a logical choice for companies that already use relational databases for their operational data.

A data mart is part of the "____" section of the business intelligence framework.

____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses.

Queries against operational data typically are broad in scope and high in complexity.

To provide better performance, some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at end-user workstations.

In a typical ____________________ schema, each dimension record is related to thousands of fact records.

The ____ contains business data extracted from the operational database and from external data sources.

A characteristic of decision support data is ____.

Data warehouses usually have one fact table.

In a MOLAP system, the MOLAP ____ allows end users to interact with the MOLAP server and request data for analysis.

Decision support data are a snapshot of the operational data at a given point in time.

___________________________________ are quantifiable measurements (numeric or scale based) that assess the company's effectiveness or success in reaching its strategic and operational goals.

The mainframe environment enables an OLAP system to be divided into several components that define its architecture.

A ____ index is based on 0 and 1 bits to represent a given condition.

Data ____________________ tools are tools that provide advanced statistical analysis to uncover problems and opportunities hidden within business data.