INFS 346 CH 9

what is also known as "data interrogation"?

Ad-hoc direct analysis b/c the answer it finds from one query leads to another

data mart / DW front end apps are commonly referred to as

BI apps

OLAP tools are known as

BI tools

Online refers not to the internet but rather

type of a computer processing in which the computer responds to immediately to user requests

OLTP tools

updating modifying, inserting, deleting, querying, and presenting data

ad-hoc direct analysis

user access data in DW with an OLAP/BI too and performs actions

drill up

makes the granularity of the date COARSER

DW Deployment

refers to allowing the end user to access the newly created and populated DW and its front-end apps

OLAP/BI tools functionalities

slice and dice, picot, drill down/up

transformation process also includes.....

data quality control and data quality improvement

common use of accessing data in a data warehouse

designed for analysis of dimensionally modeled data

OLAP/BI tools can be used on analytical data stores created with

different modeling approaches

Pivot(rotate)

does not change values in the original query, it reorganizes them/ sorts them differently

OLAP tools

engage in querying and presenting data;

refresh load

every subsequent load after initial load

MOLAP

multidimensional online analytical processing

slice and dice

operation adds, replaces, or eliminates specified dimension or values of dimension attributes from already displayed result

production release

passes the alpha and beta releases; actual deployment of the warehousing system occurs

initial/first load

populates initially empty data warehouse tables; can involve large amounts of data dependent on time horizon

ETL Extraction, Transformation, Load

populating tables with data retrieved from operational dbs

data cleansing (scrubbing)

process of transformation has to enable detection and correction of low quality data

OLTP example

transaction reflecting a withdrawal from a checking account

creating a data warehouse

using functionalities of database management software to implement data warehouse as collection of physically created and mutually connected db tables

other OLAP/BI tools

visualize answers in graphical ways, create and examine calculated data; determine comparative or relative differences; conduct exception, trend, and regression analysis; etc

alpha release

DW testing phase; the DW and its front-end apps are deployed internally to members of the development team to a selected group of users to test the usability of the system

front end apps in a DW can retrieve data from _____ or _____ that contain a subset of the data from the DW

DW, dependent data marts

Point-and-click

OLAP/BI tools users can query fact and dimension tables using this tool; writes and executes code in language of the DBMS that hosts the data warehouse or data mart being queried

2 purposes that OLAP/BI tools can be used for

ad-hoc direct analysis of dimensionally modeled data; creation of front-end applications for indirect access of dimensionally modeled data

executive dashboard

intended for use by higher-level decision makers w/in an org; contains organized, easy to read display of a number of critically important queries describing the performance of the org

active data warehouses

loads occur in micro batches that happen continuously, ensuring the data in the data warehouse is updated close to real time (enabling analysis of latest data)

key difference between the 2 models of relational db model and multidimensional db model

locating the data

Drill down

make the granularity of the data in the query result FINER

OLTP (online transaction processing)

refers to updating, querying, and presenting data from the db for operational uses; encompasses all the everyday update transactions done on the operational db system

beta release

subsequent release after passing alpha release; deployed to select group of users to test the usability of the system before it is fully deployed

Which tools are used for reading data aka retrieving data for a quick read and analysis of the data?

OLAP tools

DW front-end apps can simply be a collection of ______ created by experts

OLAP/BI Tool queries

refresh cycle

refers to frequency with which the data warehouse is reloaded with new data

load

refers to process of loading extracted, transformed, and quality assured data into target data warehouse

OLAP (online analytical processing)

refers to querying and presenting data from data warehouses and/or data marts for analytical purposes; refers to use from data marts and data warehouses

Transformation

refers to the process of transforming structure of extracted data in order to fit the structure of the target data warehouse model

extraction

refers to the retrieval of analytically useful data from operational sources that will eventually be loaded into the data warehouse