Data Mining Pipeline Exam Review – lecture summary.pdf Data Mining Pipeline Exam Review – lecture summary.pdf Data Mining Pipeline Exam Review – lecture summary.pdf
Data Mining Pipeline Exam
Review – lecture summary
Data MiningGuidehttps://www.stuvia.com/dashboard!@_)#*)(@$)($@*($@)($@*_
Pipeline Exam Review – lecture summary.pdf Data Mining Pipeline Exam Review – lecture summary.pdf Data Mining Pipeline Exam Review – lecture summary.pdf
, Data Mining Pipeline Exam Review.pdf Data Mining Pipeline Exam Review.pdf Data Mining Pipeline Exam Review.pdf
What is a data warehouse A separate storage place for integrated, time variant, subject oriented and non-
volatile collection of data
It is separate from operational data
What can a data warehouse be used for supporting management's decision making process
Give examples of the subject oriented nature of data Stores, produces, students etc.
warehouse
What is time-variant in the context of data warehouses? longer time span than immediate or current data. It is historical and timestamped.
What does non-volatile mean in the context of data separate from operational data, not updated in place and has operations: load,
warehouse data? append and read.
What does OLTP stand for and what is it? Online Transactional Processing. It is the processing of transaction oriented tasks like
bank transfers or purchase. Daily operations: insert, update, delete
What does OLAP stand for and what is it? Online Analytical Processing. It is complex queries on historical data and analysis on
that data for insight / decision making.
Data Mining Pipeline Exam Review.pdf Data Mining Pipeline Exam Review.pdf Data Mining Pipeline Exam Review.pdf
Data Mining Pipeline Exam
Review – lecture summary
Data MiningGuidehttps://www.stuvia.com/dashboard!@_)#*)(@$)($@*($@)($@*_
Pipeline Exam Review – lecture summary.pdf Data Mining Pipeline Exam Review – lecture summary.pdf Data Mining Pipeline Exam Review – lecture summary.pdf
, Data Mining Pipeline Exam Review.pdf Data Mining Pipeline Exam Review.pdf Data Mining Pipeline Exam Review.pdf
What is a data warehouse A separate storage place for integrated, time variant, subject oriented and non-
volatile collection of data
It is separate from operational data
What can a data warehouse be used for supporting management's decision making process
Give examples of the subject oriented nature of data Stores, produces, students etc.
warehouse
What is time-variant in the context of data warehouses? longer time span than immediate or current data. It is historical and timestamped.
What does non-volatile mean in the context of data separate from operational data, not updated in place and has operations: load,
warehouse data? append and read.
What does OLTP stand for and what is it? Online Transactional Processing. It is the processing of transaction oriented tasks like
bank transfers or purchase. Daily operations: insert, update, delete
What does OLAP stand for and what is it? Online Analytical Processing. It is complex queries on historical data and analysis on
that data for insight / decision making.
Data Mining Pipeline Exam Review.pdf Data Mining Pipeline Exam Review.pdf Data Mining Pipeline Exam Review.pdf
