Final--MIS 342--Chapter 13

A ____ is optimized for decision support and is generally represented by a data warehouse or a data mart.

____ are in charge of presenting data to the end user in a variety of ways.

____ provide a unified, single point of entry for information distribution.

In business intelligence framework, data are captured from a production system and placed in ____ on a near real-time basis.

____ tools focus on the strategic and tactical use of information.

From a data analysts point of view, decision support data differ from operational data in three main areas: time span, granularity, and ____.

Operational data are commonly stored in many tables, and the stored data represent information about a given ____ only.

The ____ schema must support complex (non-normalized) data representation.

Data ____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.

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

Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) ____.

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

Computed or derived facts, at run time, are sometimes called ____ to differentiate them from stored facts.

In a star schema, attributes are often used to search, filter, or classify ____.

In a star schema representation, a fact table is related to each dimension table in a _____ relationship

The attribute hierarchy provides a top-down data organization that is used for two main purposes: ____ and drill-down/roll-up data analysis.

Fact and dimension tables are related by ____ keys.

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

A ____ schema is a type of star schema in which dimension tables can have their own dimension tables.

____ splits a table into subsets of rows or columns and places the subsets

The reliance on ____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.

Decision support data tend to be non-normalized, ____, and pre-aggregated.

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

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

Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a ____.

An multidimensional database management systems (MDBMS) uses proprietary techniques to store data in ____ n-dimensional arrays.

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