Chapter 6

Question 1

Differences between entities, tables, Rose, and attributes

Answer 1

An entity is something you collect data about, such as people or classes. We often think of entities as tables, where each row is a record and each column is an attribute. A record is a collection of related attributes about a single instance of an entity. Each record typically consists of many attributes, which are individual pieces of information. For example, a name in a social security number are attributes of a particular person

Question 2

SQL

Answer 2

The most common language used to interface with databases

Question 3

Operational systems

Answer 3

The systems that are used to interact with customers and run a business in real time

Question 4

Business intelligence

Answer 4

The use of information systems to gather and analyze information from both external and internal sources to make better decisions, and the data derived from these processes

Question 5

Informational systems

Answer 5

System designed to support decision-making based on the Stable point – in – time for historical data.

Question 6

Master data management

Answer 6

Consolidating master data so as to facilitate arriving at a single version of the truth

Question 7

Data warehouse

Answer 7

And integration of multiple, large databases and other information sources into a single repository or access point that is suitable for direct querying, analysis or processing

Question 8

Ad hoc query

Answer 8

Request for information created due to unplanned information needs that is typically not saved for later use

Question 9

Scheduled reports

Answer 9

Reports produced at predefined intervals – daily, weekly, or monthly – to support routine decisions

Question 10

Key – indicator reports

Answer 10

Reports that provide a summary of critical information on a recurring schedule

Question 11

Exception reports

Answer 11

Reports that Highlad situations that are out of the normal range

Question 12

Drill – down reports

Answer 12

Reports that provide greater detail, so as to help analyze my key indicator is not under at an appropriate level or why an exception occurred.

Question 13

Ad hoc queries

Answer 13

Queries answering unplanned information request to support a nonroutine decision; typically not seem to be run again

Question 14

Online analytical processing OLAP

Answer 14

The process of quickly conducting complex analysis of data stored in a database, typically using graphical software tools

Question 15

Measures

Answer 15

The values and numbers a user wants to analyze

Question 16

Dimensions

Answer 16

A way to summarize data, such as region, time, or product line.

Question 17

OLAP Cube

Answer 17

A data structure allowing for multiple dimensions to be added to a traditional two – dimensional table for detailed analysis.

Question 18

Slicing and dicing

Answer 18

Analyzing the data on subsets of the dimensions. Example: a slice Michau sales by product type and region only for the second quarter of 2012. Another slice may only show scale for desktops in the western region

Question 19

Information visualization

Answer 19

The display of complex data relationships using a variety of graphical methods

Question 20

Digital dashboards

Answer 20

A display delivering summary information to managers and executives to provide warnings, action notices, and summaries of business conditions.

Question 21

Push reporting

Answer 21

Quick overview of key performance indicators and other key operational statistics and trends

Question 22

Exception reporting

Answer 22

Alert user of any items that require immediate attention

Question 23

Pull reporting

Answer 23

To analyze the root causes of an exception or perform other analysis he can drill down or perform self-service ad hoc queries