Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
35 Cards in this Set
- Front
- Back
|
INDEX |
A data structure that is added to a database to increase the look up speed of a single value within a large table
|
|
|
OUTRIGGER
|
A "permissible" snowflake; Used when a dimension table has many attributes that get loaded at different times that are related together;
|
|
|
SNAPSHOT
|
Type of fact table data that is semi-additive meaning that it cannot be summed over time because it represents a value at a point in time
|
|
|
STAR
|
The name of a data warehouse schema or model
|
|
|
ROW
|
Something that can be added to a slowly changing dimension to preserve all history
|
|
|
CONFORMED
|
In order for a dimension get used in multiple star schemas it must adhere to a strict naming policy, so it is called this..
|
|
|
DATA
|
The typical source system for businesses
|
|
|
B+
|
A type of index that is very fast when an attribute has high cardinality
|
|
|
DEGENERATE
|
A word for a dimension attribute that was put into the fact table because it was alone by itself
|
|
|
ROLEPLAYING
|
A dimension that has its primary key included multiple times as a foreign key in the fact table; A dimension that can mean different things in a schema, ie a supplier and a customer
|
|
|
MEASURES
|
Additive or semi-additive attributes found in the fact table
|
|
|
UNIQUENESS
|
A measure for data quality that determines the frequency of the value
|
|
|
MINI
|
A type of dimension that is linked to both the fact table and a dimension table; it contains attributes that are prone to change, with a single row representing a unique combination of values;
|
|
|
ETL
|
Acronym used to describe the process of moving data out of the OLTP system, cleaning it, and loading it into the data warehouse
|
|
|
CURRENCY
|
A measure for data quality that describes the time sensitivity of the data
|
|
|
DIMENSION
|
An input in a report that may have some impact on the output or thing being measured
|
|
|
SNOWFLAKE
|
A name for a data warehouse schema that means it has too many relationships in it
|
|
|
AGGREGATE
|
When some of the rows in a fact table are summarized in a table to speed processing of certain reports
|
|
|
OVERWRITE
|
A strategy of updating a data warehouse with new information that is easy, but looses all history
|
|
|
COMPLETENESS
|
A measure for data quality that describes the range of the data
|
|
|
FACTLESS
|
If a fact table has nothing by primary keys
|
|
|
BITMAP
|
A type of index that consumes very little disk space
|
|
|
FACT
|
The name of the center table in a star schema
|
|
|
GRAIN
|
Represented by one row of a table.
|
|
|
NULL
|
A missing value in a data record
|
|
|
OLAP PURPOSE
|
Decision Support
|
|
|
OLAP DATA MODEL
|
Dimensional
|
|
|
OLAP TIME SPAN
|
Historical and Current Data
|
|
|
OLAP QUERY PROCESSING
|
Scan a substantial subset of data
|
|
|
OLAP OPERATION
|
Read-only
|
|
|
OLTP PURPOSE
|
Transaction Processing
|
|
|
OLTP DATA MODEL
|
Normalized Relational
|
|
|
OLTP TIME SPAN
|
Current Data
|
|
|
OLTP QUERY PROCESSING
|
Scan a small set of data
|
|
|
OLTP OPERATION
|
Read & Update |
