OIM 350 Exam 3

duck charts

"self promoting graphs"

time series

- Graphs where the X axis is time - Measures change(s) over that time

bivariate graphs

- two variables - typically scatterplots - useful for examining one-to-one relationships (correlations)

spatial graphs (maps)

Applying an overlay of data visualization where the location in space is important

faceting

Several distinct graphs arranged in a manner for comparison

transaction time

a column representing the time of the transaction

transaction identifier

a column representing the transaction ID

row indicator

a column that provides a quick indicator of whether the record is currently valid

dimensional modeling

a data design methodology used for designing subject-oriented analytical databases, i.e., data warehouses or data marts

normalized data warehouse

a data warehouse modeled by using the traditional database modeling techniques of ER modeling, relational modeling, and/or normalization, resulting in a normalized set of tables

slowly changing dimensions

a dimension that contains attributes whose values can change

detailed fact tables

a fact table in which each record refers to a single fact

line-item detailed fact table

a fact table in which each record represents a line item of a particular transaction

transaction-level detailed fact table

a fact table in which each row represents a particular transaction

surrogate key

a noncomposite system-generated key assigned to each dimension of a star schema

snowflake models

a star schema tat contains the dimensions that are normalized

type 2 approach

an approach to handling slowly changing dimensions that is used in cases when history should be preserved; it creates a new additional dimension record using a new value for the surrogate key every time a value in a dimension record changes

type 3 approach

an approach to handling slowly changing dimensions that is used in cases when there is a fixed number of changes possible per column of a dimension, or in cases when only a limited history is recorded; it creates a "previous" and "current" column in the dimension table, for each column where the changes are anticipated

degenerate dimension

an event identifier included within the fact table (rather than having its own separate dimension)

timestamps

columns in tables that indicate the time interval for which the values in the records are applicable

detailed data

data composed of single instances of data

aggregated data

data representing summarization of multiple instances of data

dimensionally modeled data warehouse

data warehouse modeled using dimensional modeling

granularity

describes what is depicted by one row in the fact table

aggregated fact tables

fact tables in which each record summarizes multiple facts

data-ink

ink that is used to convey data

star schema

schema containing fact tables and dimensions

conformed dimensions

standardized dimensions created before development of star schemas; typically used with multiple fact tables

constellation (galaxy) of stars

star schema containing multiple fact tables

Moiré Effects (Visual Vibrations)

static images appear to move (vibrate) when lines are too close to each other or overlap

dimension tables (dimensions)

tables in a dimensional model that contain descriptions of the business, organization, or enterprise to which the subject of analysis belongs and contain a primary key and attributes that are used for analysis of the measures in the fact tables

fact tables

tables in a dimensional model that contain measures related to the subject of analysis and foreign keys that connect the fact table to the dimension tables

type 1 approach

the approach to handling slowly changing dimensions based on overwriting values in records of dimension; it is used mostly when a change in a dimension is the result of an error