Project 5 Flashcards
Has detailed day to day transaction data which keeps changing. (Information)
OLTP (Online Transaction Processing System)
Stores data for analysis purposes. The input for this system is from OLTP systems. (Business Intelligence)
OLAP (Online Analytical Processing System)
The problem with operational systems
Because the way they are designed, the RESPONSE TIME of the system degrades in a quadratic manner with the growth of the stored data
the large majority of the historical data must be purged from the _______ _______
Operational system
Data warehouse system is referred to as
Online analytical processing system (OLAP)
Unlike the OLTP system the data warehouse does not store primarily transactional data, but instead stores ______ ____
Summarized data
_________ 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
Performance
A ____ ____ creates what is called a cross tabulated structure or crosstab
Pivot table
The crosstab displays ______ ___ ______ data based on which way you sort the columns and rows
Aggregated and summarized
_____ is a way to filter a large dataset to smaller data sets of interest
Slicing
______ the sliced data set creates an even more granularly defined data set
Dicing
Slicing & Dicing techniques
Sort, filter, rank, aggregations
Standard aggregations
SUM, MIN, MAX, AVG, COUNT
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
Exception aggregations
Powerful in-depth OLAP analysis tool that provides- capability to create predefined workbooks that included guided navigation
Analysis