Chapter 13

Which extensions is added by relational online analytical processing (ROLAP) to traditional relational database management system (RDBMS) technology?

. Support for very large databases

Which of the following functions of multidimensional data analysis techniques are provided automatically, so an end user does not need to redefine the components each time they are accessed?

Advanced computational functions

________ within relational databases are primarily used when the number of possible values for an attribute is fairly small.

Bitmapped indexes

________ is a term used to describe a comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information used to support business decision making.

Business intelligence

________ ranges from simple data gathering and transformation to very complex data analysis and presentation.

Business intelligence (BI) functionality

The ________ extension enables you to get a subtotal for each column listed in the expression, in addition to a grand total for the last column listed.

CUBE

Which of the following is the first step in business intelligence (BI)?

Collecting and storing operational data

________ is used at all levels within the business intelligence (BI) framework, including queries and reporting, monitoring and alerting, and data visualization.

Data analytics

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

Data marts

________ provide advanced statistical analysis to uncover problems and opportunities hidden within business data.

Data-mining tools

Which of the following techniques is often used to optimize data warehouse design?

Denormalizing fact tables

________ are qualifying characteristics that provide additional perspectives to a given fact.

Dimensions

The ________ clause indicates that whenever a change is made in the base tables, the materialized view updates only the affected rows.

FAST

________ are numeric measurements or values that represent a specific business aspect or activity.

Facts

The ROLLUP extension is used with the ________ clause to generate aggregates by different dimensions

GROUP BY

The ________ clause indicates when the materialized view rows are actually populated.

IMMEDIATE

________ 's premise is multidimensional databases that are best suited to manage, store, and analyze multidimensional data.

MOLAP (multidimensional database management systems)

________ are augmented by advanced data presentation functions; advanced data aggregation, consolidation, and classification functions; advanced computational functions; and advanced data-modelling functions.

Multidimensional data analysis techniques

________ is a Web-based technology that uses a web browser to integrate data from multiple sources into a single web page.

Portal

________ uses sophisticated statistical tools to help an end user create advanced models that explain questions about future data occurrences.

Predictive analytics

________ schema is usually the result of normalizing dimension tables

Snowflake

________ is a measurement of the density of the data held in the data cube.

Sparsity

________ schemas yield an easily implemented model for multidimensional data analysis, while still preserving the relational structures on which the operational database is built.

Star

Which of the following is a characteristic of an OLAP?

Uses multidimensional data analysis techniques

Many of the OLAP interface features are "borrowed" from previous generations of data ________ tools.

analysis

During the ________ phase of data mining, common characteristics or patterns of the data are identified.

analysis and classification

Running the OLAP GUI on client workstations and the OLAP server on a shared server computer results in a more practical ________ than running both on the same computer

architecture

The ________ hierarchy provides a top-down data organization that is used for aggregation and drill-down/roll-up data analysis.

attribute

To speed data access, data cubes are normally held in memory in the cube ________.

cache

Data cubes must be ________ before they can be used.

created

The ________ creation process is critical and requires in-depth front-end design work as ad hoc queries cannot be used in the process.

data cube

A(n) ________ is optimized for decision support and is generally represented by a data warehouse or a data mart.

data store

A ________ must conform to uniform structures and formats to avoid data conflicts

data warehouse

what are the three requirements for a decision support database?

database schema, date extraction and filtering, and database size

According to Bill Inmon, a data warehouse is an integrated, subject-oriented, time-variant, nonvolatile collection of data that provides support for ________.

decision making

A(n) ________ system typically has a much narrower focus and reach than a BI solution

decision support

By default, the fact table's primary key is always formed by combining the ________ pointing to the dimension tables to which they are related.

foreign keys

Data cubes with n number of dimensions are known as ________.

hypercubes

During the ________ phase of data mining, the data-mining tool selects the appropriate modeling algorithms.

knowledge acquisition

In the data warehouse database, the fact table is related to each dimensional table in a(n) ________ relationship.

many-to-one (M:1)

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

materialized

During the ________ phase of data mining, the main data sets to be used by the data-mining operation are identified and cleansed of any data impurities.

preparation

During the ________ phase of data mining, findings are used to predict future behavior and forecast business outcomes.

prognosis

Since the data cube is predefined with a set number of dimensions, the addition of a new dimension requires that the entire data cube be ________.

re-created

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

roll up

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

slice and dice

Multidimensional data analysis is also affected by how the database system handles ________.

sparsity

The ________ schema creates the near equivalent of a multidimensional database schema from the existing relational database.

star

Relational online analytical processing (ROLAP) uses a special design technique, ________ that enables relational database management system (RDBMS) technology to support multidimensional data representations.

star schema

Data cubes are created by extracting data from the operational databases or from the data ________.

warehouse