Exam 13: Business Intelligence and Data Warehouses

Operational data are commonly stored in many tables,and the stored data represent information about a given only.

From a data analyst's point of view,decision support data differ from operational data in three main areas: time span,granularity,and .

The schema must support complex (non-normalized)data representations.

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

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

What is data visualization? Name different techniques of data visualization.

The data warehouse development life cycle differs from classical systems development.

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.

Normalizing fact tables improves data access performance and saves data storage space.

In business intelligence framework,data are captured from a production system and placed in the____ on a near real- time basis.

A multidimensional database management systems (MDBMS)uses proprietary techniques to store data in n-dimensional arrays.

_____ are quantifiable measurements (numeric or scale based)that assess a company's effectiveness or success in reaching its strategic and operational goals.

Computed or derived facts,at run time,are sometimes called to differentiate them from stored facts.

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

_____ online analytical processing provides OLAP functionality by using relational databases and familiar relational query tools to store and analyze multidimensional data.

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

To support a(n)_____ adequately,the DBMS might be required to support advanced storage technologies,and even more importantly,to support multiple-processor technologies,such as a symmetric multiprocessor (SMP)or a massively parallel processor (MPP).

Multidimensional data analysis techniques include advanced computational functions.

What is the difference between decision support data and operational data from the point of view of data analyst?

A(n)_____ is a read-only database optimized for data analysis and query processing.