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