BUSI 3400 Lecture Notes - Lecture 11: Apache Hadoop, Fact Table, Data Cube

74 views2 pages

Document Summary

Index a secondary file structure that provides an alternative path to the data. Data sparsity number of different values a column could have. B+ tree provides improved performance on sequential and range searches. All keys are redundantly stored in the leaf nodes. Bitmap strings of bits, one for each row. Measure of the likelihood that an index will be used in query processing. Short-term decisions: fulfill orders, resolve complaints, provide staffing. Medium and long-term decisions: capacity planning, store locations, product promotion, new lines of business. Decision support data time span, granularity (drill down, roll up), Data warehouse definition characteristics data from operational databases and external data sources. Dimension keys (link fact table to the dimensions), Facts (measure details), grain is the level of detail that the facts are stored. Primary purpose is to facilitate analysis by allowing managers to slice/dice. Represent the characteristics of what is being measured (ie. what is in the fact table)

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers