C192 / OLAP / Data Warehousing

Which of the following is a characteristic of an OLAP?

Many of the OLAP interface features are "borrowed" from previous generations of data ____ tools.

____ is defined as an advanced data analysis environment that supports decision making, business modeling, and an operation’s researching activities.

The data warehouse and OLAP are two interrelated and complementary ____.

To provide better performance, some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at end user ____.

MOLAP extends OLAP functionality to multidimensional ____ management systems.

The location of each data value in the data cube is a function of the x, y, and z axes in a ____ space.

Data cubes are created by extracting data from the operational database or from the data ____.

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 ____.

____ schemas yield an easily implemented model for multidimensional data analysis, while still preserving the relational structures on which the operational database is built.

____ are qualifying characteristics that provide additional perspectives to a given fact.

The ____ hierarchy provides a top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis.

____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.

____ makes a copy of a table and places it in a different location, to improve access time.

____ provides information about the timespan of the data stored in the table.

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.

During the data ____ phase of data mining, common characteristics or patterns are identified.

During the ____ phase of data mining, the data mining findings are used to predict future behavior and forecast business outcomes.

The ____ schema creates the near equivalent of a multidimensional database schema from the existing relational database.

Which of the following is NOT a basic component of a star schema?

Using multidimensional jargon, the ability to focus on slices of the cube to perform a more detailed analysis is known as ____.

In contrast to the traditional DSS tools, data mining is ____.