Final–MIS 342–Chapter 13 – Flashcards

Unlock all answers in this set

Unlock answers
question
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
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New