Data Mining Pipeline Exam Review
What is a records warehouse
A separate garage place for incorporated, time version, problem orientated and non-risky
collection of statistics
It is break free operational facts
What can a facts warehouse be used for
supporting control's selection making manner
Give examples of the difficulty oriented nature of facts warehouse
Stores, produces, students and so on.
What is time-version inside the context of information warehouses?
Longer time span than instantaneous or current information. It is historic and timestamped.
What does non-volatile mean within the context of data warehouse information?
Become independent from operational statistics, now not updated in area and has operations:
load, append and read.
What does OLTP stand for and what's it?
Online Transactional Processing. It is the processing of transaction orientated duties like
financial institution transfers or purchase. Daily operations: insert, update, delete
What does OLAP stand for and what's it?
Online Analytical Processing. It is complicated queries on historical information and evaluation
on that facts for insight / selection making.
What do records and dimensions correspond to in schemas for data warehouses?
Statistics -> income
dimensions -> objects
, What is the big name schema?
One truth table with multiple dimension tables
what is the snowflake schema?
One reality table with multiple tiers of dimension tables
What is the truth constellation schema?
A couple of reality tables, shared dimension tables.
What are the primary facts dice operations?
Drill up. Dice. Drill down. Roll up. Slice. Pivot.
What is a roll up operation in a facts cube?
Aggregation. Eg. Daily => monthly
What is the Drill down operation in a facts cube?
Reverse of roll up. Eg. North America => USA, Canada, Mexico
What does pivot correspond to in a information dice?
Rotation/visualization
Describe full materialization
vs
no materialization
vs
partial materialization
for records cubes
Full materialization: the entirety is pre-computed; all cuboids and cells.
No materialization: No pre computation, it's miles all finished on demand.
Partial Materialization: a few cuboids and cells are precomputed primarily based on a hard and
fast of heuristics.
What is an Iceberg facts cube?
What is a records warehouse
A separate garage place for incorporated, time version, problem orientated and non-risky
collection of statistics
It is break free operational facts
What can a facts warehouse be used for
supporting control's selection making manner
Give examples of the difficulty oriented nature of facts warehouse
Stores, produces, students and so on.
What is time-version inside the context of information warehouses?
Longer time span than instantaneous or current information. It is historic and timestamped.
What does non-volatile mean within the context of data warehouse information?
Become independent from operational statistics, now not updated in area and has operations:
load, append and read.
What does OLTP stand for and what's it?
Online Transactional Processing. It is the processing of transaction orientated duties like
financial institution transfers or purchase. Daily operations: insert, update, delete
What does OLAP stand for and what's it?
Online Analytical Processing. It is complicated queries on historical information and evaluation
on that facts for insight / selection making.
What do records and dimensions correspond to in schemas for data warehouses?
Statistics -> income
dimensions -> objects
, What is the big name schema?
One truth table with multiple dimension tables
what is the snowflake schema?
One reality table with multiple tiers of dimension tables
What is the truth constellation schema?
A couple of reality tables, shared dimension tables.
What are the primary facts dice operations?
Drill up. Dice. Drill down. Roll up. Slice. Pivot.
What is a roll up operation in a facts cube?
Aggregation. Eg. Daily => monthly
What is the Drill down operation in a facts cube?
Reverse of roll up. Eg. North America => USA, Canada, Mexico
What does pivot correspond to in a information dice?
Rotation/visualization
Describe full materialization
vs
no materialization
vs
partial materialization
for records cubes
Full materialization: the entirety is pre-computed; all cuboids and cells.
No materialization: No pre computation, it's miles all finished on demand.
Partial Materialization: a few cuboids and cells are precomputed primarily based on a hard and
fast of heuristics.
What is an Iceberg facts cube?
