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