Final–MIS 342–Chapter 13 – Flashcards
Unlock all answers in this set
Unlock answersquestion
A ____ is optimized for decision support and is generally represented by a data warehouse or a data mart.
answer
data store
question
____ are in charge of presenting data to the end user in a variety of ways.
answer
Data visualization tools
question
____ provide a unified, single point of entry for information distribution.
answer
Portals
question
In business intelligence framework, data are captured from a production system and placed in ____ on a near real-time basis.
answer
data warehouse
question
____ tools focus on the strategic and tactical use of information.
answer
Business intelligence
question
From a data analysts point of view, decision support data differ from operational data in three main areas: time span, granularity, and ____.
answer
dimensionality
question
Operational data are commonly stored in many tables, and the stored data represent information about a given ____ only.
answer
transaction
question
The ____ schema must support complex (non-normalized) data representation.
answer
decision support database
question
Data ____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.
answer
integration
question
____ can serve as a test vehicle for companies exploring the potential benefits of data warehouse.
answer
data marts
question
Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) ____.
answer
data warehouse
question
The basic star schema has four components: facts, _____, attributes, and attribute hierarchies.
answer
dimensions
question
Computed or derived facts, at run time, are sometimes called ____ to differentiate them from stored facts.
answer
metrics
question
In a star schema, attributes are often used to search, filter, or classify ____.
answer
facts
question
In a star schema representation, a fact table is related to each dimension table in a _____ relationship
answer
many-to-one (M:1)
question
The attribute hierarchy provides a top-down data organization that is used for two main purposes: ____ and drill-down/roll-up data analysis.
answer
aggregation
question
Fact and dimension tables are related by ____ keys.
answer
foreign
question
In a typical star schema, each dimension record is related to thousands of ____ records.
answer
fact
question
A ____ schema is a type of star schema in which dimension tables can have their own dimension tables.
answer
snowflake
question
____ splits a table into subsets of rows or columns and places the subsets
answer
Partitioning
question
The reliance on ____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.
answer
normalization
question
Decision support data tend to be non-normalized, ____, and pre-aggregated.
answer
duplicated
question
____ extends SQL so that it can differentiate between access requirements for data warehouse data and operational data.
answer
ROLAP
question
A ____ index is based on the 0 and 1 bits to represent a given condition.
answer
bitmapped
question
Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a ____.
answer
data cube
question
An multidimensional database management systems (MDBMS) uses proprietary techniques to store data in ____ n-dimensional arrays.
answer
matrix-like
question
A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.
answer
materialized view
