Exam 13: Business Intelligence and Data Warehouses

Conceptually,MDBMS end users visualize the stored data as a three-dimensional cube known as a ____.

BusinessObjects is a(n)____ tool.

The basic star schema has four components: facts,____,attributes,and attribute hierarchies.

Data mining is part of the "____" section of the business intelligence framework.

ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework.

What is a characteristic of ROLAP?

SAP is a portal vendor.

____________________ is a term used to describe a comprehensive,cohesive,and integrated set of tools and processes used to capture,collect,integrate,store,and analyze data with the purpose of generating and presenting information used to support business decision making.

Decision support data tend to be non-normalized,____,and pre-aggregated.

In a typical ____________________ schema,each dimension record is related to thousands of fact records.

There are 12 rules that define a(n)____.

Computed or derived facts are sometimes called ____ to differentiate them from stored facts.

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

In most implementations,the data warehouse and OLAP are stand-alone,independent environments.

In the prognosis phase,the data-mining findings are used to predict future behavior and forecast business outcomes.

OLAP systems are designed to use both operational and data ____________________ data.

Data warehouse data are organized and summarized by table,such as CUSTOMER and ADDRESS.

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

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

The most distinct characteristic of modern OLAP tools is their capacity for ____________________ analysis.