Database Management Extra 13

Question 1

The multidimensional data structure used to store and manipulate data in a multidimensional DBMS. The location of each data value in the ??? ??? is based on its x-, y-, and z-axes. ??? ??? are static, meaning they must be created before they are used, so they cannot be created by an ad hoc query.

Answer 1

Data Cube

Question 2

A small, single-subject data warehouse subset that provides decision support to a small group of people.

Answer 2

Data Mart

Question 3

Abstracting data to provide information in a visual format that enhances the user’s ability to effectively comprehend the meaning of the data.

Answer 3

Data Visualization

Question 4

An integrated, subject-oriented, time-variant, nonvolatile collection of data in a specialized database that stores historical and aggregated data in a format that provides support for decision making.

Answer 4

Data Warehouse

Question 5

An arrangement of computerized tools used to assist managerial decision making within a business.

Answer 5

Decision Support System (DSS)

Question 6

In a data warehouse, tables used to search, filter, or classify facts within a star schema.

Answer 6

Dimension Tables

Question 7

To decompose data into more atomic components—that is, data at lower levels of aggregation. This approach is used primarily in a decision support system to focus on specific geographic areas, business types, and so on.

Answer 7

Drill Down

Question 8

In a data warehousing environment, the integrated processes of getting data from original sources into the data warehouse. ??? includes retrieving data from original data sources (extraction), manipulating the data into an appropriate form (transformation), and storing the data in the data warehouse (loading).

Answer 8

Extraction, Transformation, Loading (ETL)

Question 9

In business intelligence, quantifiable numeric or scale-based measurements that assess a company’s effectiveness or success in reaching strategic and operational goals. Examples of ??? are product turnovers, sales by promotion, sales by employee, and earnings per share.

Answer 9

KPIs

Question 10

In business intelligence, a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.

Answer 10

Master Data Management (MDM)