Show:
OLAP
Systems
You Can Build It!
DW Architecture
100
This is the process of extracting rows
What is selection?
100
A collection of data that is primarily used in organizational decision-making.
What is a data warehouse?
100
This subset of the data warehouse is usually smaller and easier to implement.
What is a data mart?
100
This is responsible for loading data into the warehouse.
What is the load manager?
200
This is the process of extracting specific columns.
What is projection?
200
The primary concern is short, isolated transactions.
What is Online Transaction Processing (OLTP)?
200
This contains various measures and foreign keys while serving as a central node.
What is fact table?
200
A repository of current and integrated operational data.
What is an operational data store?
300
An example of this is consolidating multiple records into a single row.
What is rollup?
300
In Latin, it means "for this".
What is ad hoc?
300
An example of this is PRODUCT, CUSTOMER, or TIME.
What is a dimension table?
300
This is responsible for user queries.
What is query manager?
400
Pivot re-orients this type of view.
What is multidimensional?
400
This type of data is more important than individual records in a data warehouse.
What is aggregated or consolidated?
400
This term is derived from the combination of fact and dimension tables due to its shape.
What is a star schema?
400
One way this is used is to map data sources to common views of the data.
What is metadata?
500
When we implement drill-down, we are doing this to the level of aggregation.
What is decrease?
500
This is the key performance metric for an OLTP system.
What is transaction throughput?
500
This is also known as a multi-level star in which dimensions are also hierarchical.
What is a snowflake schema?
500
An Executive Information System/Decision Support System is an example of this.
What is an End-User Access Tool?