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