Exam 13: Business Intelligence and Data Warehouses

Periodicity, usually expressed as current year only, previous years, or all years, provides information about the time span of the data stored in a table.

Multidimensional data analysis techniques include advanced computational functions.

_____ means to decompose data into more atomic components or data at lower levels of aggregation.

Fact and dimension tables are related by _____ keys.

Relational data warehouses use the star schema design technique to handle multidimensional data.

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

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

_____ are numeric measurements (values) that represent a specific business aspect or activity.

In multidimensional terms, the ability to focus on slices of the cube to perform a more detailed analysis is known as _____.

ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework.

A data _____ is a centralized, consolidated database that integrates data derived from the entire organization and from multiple sources with diverse formats.

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

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

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

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

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

_____ is a measurement of the density of the data held in the data cube and is computed by dividing the total number of actual values in the cube by the total number of cells in the cube.

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

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

Data visualization has its roots in the _____ sciences, which focus on how the human brain receives, interprets, organizes, and processes information.