Project 5

Question 1

Has detailed day to day transaction data which keeps changing. (Information)

Answer 1

OLTP (Online Transaction Processing System)

Question 2

Stores data for analysis purposes. The input for this system is from OLTP systems. (Business Intelligence)

Answer 2

OLAP (Online Analytical Processing System)

Question 3

The problem with operational systems

Answer 3

Because the way they are designed, the RESPONSE TIME of the system degrades in a quadratic manner with the growth of the stored data

Question 4

the large majority of the historical data must be purged from the _______ _______

Answer 4

Operational system

Question 5

Data warehouse system is referred to as

Answer 5

Online analytical processing system (OLAP)

Question 6

Unlike the OLTP system the data warehouse does not store primarily transactional data, but instead stores ______ ____

Answer 6

Summarized data

Question 7

_________ is not as important as in the OLTP system and because of the different structure of the system, even though the system is large the performance is acceptable

Answer 7

Performance

Question 8

A ____ ____ creates what is called a cross tabulated structure or crosstab

Answer 8

Pivot table

Question 9

The crosstab displays ______ ___ ______ data based on which way you sort the columns and rows

Answer 9

Aggregated and summarized

Question 10

_____ is a way to filter a large dataset to smaller data sets of interest

Answer 10

Slicing

Question 11

______ the sliced data set creates an even more granularly defined data set

Answer 11

Dicing

Question 12

Slicing & Dicing techniques

Answer 12

Sort, filter, rank, aggregations

Question 13

Standard aggregations

Answer 13

SUM, MIN, MAX, AVG, COUNT

Question 14

Occurs when it doesn’t make sense to aggregate. Instead we want results as a point in time such as the number of employees at the end of the year

Answer 14

Exception aggregations

Question 15

Powerful in-depth OLAP analysis tool that provides- capability to create predefined workbooks that included guided navigation

Answer 15

Analysis

Question 16

• Sophisticated set of tools that can be used to determine patterns in data that are not logically apparent
• can result in very interesting and profitable situations
• to many companies this presently is an advanced approach, but with the heavier use of data warehousing, it will become more widely used

Answer 16

Data mining

Question 17

With respect to data warehousing, one of the biggest areas of concern is that the data rolling into the data warehouse is ________ ___ _______

Answer 17

Consisten and accurate

Question 18

Are created from the sliced and diced data

Answer 18

Reports