____ is a measurement of the density of the data held in the data cube.
Compactness
Concentration
Mass
Sparsity
____ are numeric measurements or values that represent a specific business aspect or activity.
Tables
Schemas
Facts
Attributes
When you ____ the data, you are aggregating the data to a higher level.
drill down
drill up
wrap up
roll up
The end user GUI might be a custom-made program or a plug-in module that is integrated with Lotus 123, Microsoft Excel, or other third party data ____ and query tools.
analysis
base
processing
integration
Decision ____ is a methodology designed to extract information from data and to use such information as a basis for decision making.
management
support
mining
analysis
Running the OLAP GUI on client workstations and the OLAP engine on a shared computer results in a more practical ____ than running both on the same computer.
interface
processing system
architecture
support system
____ is defined as "surroundings or atmosphere."
Architecture
Arrangement
Relational data
Environment
____ makes a copy of a table and places it in a different location, to improve access time.
Periodicity
Aggregation
Partitioning
Replication
Data cubes can grow to n-number of dimensions, thus becoming ____.
memory cubes
dimensional cubes
hypercubes
star data cubes
Client/server ____ provide(s) a framework within which new systems can be designed, developed, and implemented.
interfaces
architecture
processing
support
During the ____ phase of implementing a data warehouse, the designer must, among other tasks, identify and interview key users, define the main subjects, and identify the operational data model.
initial data gathering
design and mapping
loading and testing
rollout and feedback
During the data ____ phase of data mining, the main data sets to be used by the data mining operation are identified and cleansed of any data impurities.
analysis
preparation
classification
acquisition
Multidimensional data analysis is also affected by how the database system handles ____.
Many of the OLAP interface features are "borrowed" from previous generations of data ____ tools.
module
processing
filtering
analysis
____ are qualifying characteristics that provide additional perspectives to a given fact.
Views
Attributes
Dimensions
Tact tables
Using multidimensional jargon, the ability to focus on slices of the cube to perform a more detailed analysis is known as ____.
star cuts
slice and dice
microscoping
TPL processing
Given the importance and universality of this dimension from a data analysis perspective, many vendors have added automatic ____ dimension management features to their data warehousing products.
space
time
location
product
A ____ view is a dynamic table that contains not only the SQL query command to generate the rows, but also stores the actual rows.
structural
materialized
CUBE
rollup
MOLAP's premise is that ____ databases are best suited to manage, store, and analyze multidimensional data.