C192- OLAP/Datawarehousing
What is DSS?
Decision Support System - Models information to support managers and business professionals during the decision-making process
What does OLAP do?
It is an approach to answer multi-dimensional analytical (MDA) queries swiftly in computing. OLAP is part of the broader category of business intelligence, which also encompasses relational databases, report writing and data mining.
What does ROLAP do?
It performs dynamic multidimensional analysis of data stored in a relational database rather than in a multidimensional database (which is usually considered the OLAP standard).
In which DSS architectural sytle does the data store contain lightly aggregated data in an RDBMS?
MIS with 3GL
____ is defined as an advanced data analysis environment that support decision making, business modeling, and an operation's researching activities?
OLAP
Multidimensional data analysis requires some type of multidimensional data representations, which is normally provided by the ____ engine.
OLAP.
What is ROLAP?
Relational online analytical processing
During the ___ phase of data mining, common characteristics or patterns are identified.
analysis
During the data ____ phase of data mining, common characteristics or patterns are identified.
analysis
Many of the OLAP interface features are "borrowed" from previous generations of data ____ tools.
analysis
The end user GUI might be customer-made program or a plug-in module that is integrated with Lotus 123, Microsoft Excel, or other third party data____ and query tools.
analysis
The DSS tools that use multidimensional data analysis techniques are known as online ___________ processing.
analytical
A complete data warehouse ____ includes support for a DSS data store, a data extraction and integration filter, and a specialized presentation interface.
architecture
Client/server ____ provides a framework within which new systems can be designed, developed, and implemented.
architecture
When the OLAP GUI runs on the client workstations, and the OLAP engine runs on a shared computer, the _____ is more practical than running both on the same computer.
architecture
The ___ hierarchy provides a top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis
attribute
The ability to capture the data _____ in memory provides faster response times but it also makes the MDBMS more resource-intensive than a its relational counterpart.
cube
Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a ____.
data cube
Which of the following is a rule that defines the data warehouse?
data is subject-oriented
The DSS database is called the ___.
data store
What are the high-level components that compose a DSS?
data store, data extraction and data filtering, end user query tool and end user presentation tool
____ data must conform to uniform structures and formats to avoid data conflicts.
data warehouse
MOLAP extends OLAP functionality to multidimensional ____ managements systems.
database
MOLAP extends OLAP functionality to multidimesional ____ management systems.
databse
____ are qualifying characteristics that provide additional perspectives to a given fact.
dimensions
Which of the following is NOT a basic component of a star schema?
domain
The datawarehouse and OLAP are two interrelated and complementary _____.
environments
The data warehouse and OLAP are two interrelated and complementary _____.
envrioments
____ are numeric measurements or values that represent a specific business aspect or activity.
facts
Data cubes can grow to n-number of dimensions, thus becoming _____.
hypercubes
During the ___ phase of data warehouse implementation the designer must identify and interview key users, define main subjects, and identify operational data models among other tasks.
initial data gathering
The components of a data warehouse are __________.
integrated
What does MOLAP do?
is a classical OLAP that facilitates data analysis by using a multidimensional data cube. Data is pre-computed, re-summarized, and stored
During the ____ phase of data mining, the data-mining tools selects the appropriate modeling algorithms.
knowledge acquisition
MOLAP's premise is that ____ database are best suited to manage, store, and analyze multidimensional data.
multidimensional
Multidimensional data analysis refers to the processing of data such that data are viewed as part of the _____ structure.
multidimensional
What is MDA?
multidimesional analytical
Which of the following is NOT a technique used to optimize data warehouse design?
normalization of fact tables
What is OLAP?
online analytical processing
___ splits a table into subsets of rows or columns and places the subset close to the client computer to improve data access time.
partitioning
____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.
partitioning
___ provides information about the timespan of the data stored in the table.
periodicity
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
preparation
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.
preparation
In contract to the traditional DSS tools, data mining is _____.
proactive.
During the ____ phase of data mining, the data-mining findings are used to predict future behavior and forecast business outcomes.
prognosis
During the ____ phase of data mining, the data-mining findings are used to predict future behavior and forecasts 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
____ makes a copy of a table and places it in a different location to improve access time.
replication
____ makes a copy of a table and places it in a different location, to improve access time.
replication
During the ____ phase of data warehouse implementation, tasks include system maintenance and system expansion.
rollout and feedback
Using multidimensional jargon, the ability to focus on slices of the cube to perform a more detailed analysis is known as a ____.
slice and dice
Multidimensional data analysis is also affected by how the database system handles _____.
sparsity
_____ is a measurement of the density of the data held in the data cube.
sparsity
The ___ schema creates the near equivalent of a multidimensional database schema from existing relational database.
star
The ____ schema creates the near equivalent of a multidimensional database schema from the existing relational database.
star
____ schema yields an easily implemented model for multidimensional data analysis, while still preserving the relational structures on which of the operational database is built.
star
Decision ____ is a methodology designed to extract information from data and to use such information as a basis for decision making.
support
Which of the following is a characteristic of an OLAP?
supports client/server architecture
The location of each data value in the data cube is a function of the x, y, and z axes in a ____ space.
three-dimensional
The location of each data value in the data cube is a function of the x, y, and z axes in a _____ space
three-dimensional
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.
time
Data cubes are created by extracting data from the operational database or from the data _____.
warehouse
Data cubes are created by extracting data from the opertional database or from the data _____.
warehouse
To provide better performance, some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at the end user's _____.
workstations
To provide better performance, some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at the end users _____.
workstations