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

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.