Database Management Extra 14

Question 1

A database management system that uses proprietary techniques to store data in matrixlike arrays of n dimensions known as cubes.

Answer 1

MDBMSs

Question 2

An extension of online analytical processing to multidimensional database management systems.

Answer 2

MOLAP

Question 3

In terms of business intelligence, a unified, single point of entry for information distribution.

Answer 3

Portals

Question 4

Analytical processing functions that use relational databases and familiar relational query tools to store and analyze multidimensional data.

Answer 4

Relational Online Analytical Processing (ROLAP)

Question 5

(1) To aggregate data into summarized components, that is, higher levels of aggregation. (2) In SQL, an OLAP extension used with the GROUP BY clause to aggregate data by different dimensions. ??? ??? the data is the exact opposite of drilling down the data.

Answer 5

Roll Up

Question 6

The ability to focus on slices of a data cube (drill down or roll up) to perform a more detailed analysis.

Answer 6

Slice And Dice

Question 7

In multidimensional data analysis, a measurement of the data density held in the data cube.

Answer 7

Sparsity

Question 8

A data condition in which data representation and manipulation are dependent on the physical data storage characteristics.

Answer 8

Data Dependence

Question 9

A condition in which data access is unaffected by changes in the physical data storage characteristics.

Answer 9

Data Independence

Question 10

In a relational database, a condition in which the data in the database complies with all entity and referential integrity constraints.

Answer 10

Data Integrity