chapter 3 Flashcards
data warehouse charecteristics
subject oriented integrated time-variant nonvolatile summarized not normalized metadata web based
data mart
a departmental small-scale DW
ODS
operational data store
oper mart
operational data mart
EDW
enterprise data warehouse
metadata
data about data
ERP
enterprise resource planning
POS
point of sale
ETL
extract transform load
ETL process
select extract transform integrate load
common to my consulting approach
extract data from event source sore in DW that provides -single version of truth -quality -transactional system independence
EAI
enterprise application integration
EII
enterprise information integration
dimensional modeling
a retrieval based system that supports high=volume query access
star schema
the most commonly used and the simplest style of dimensional modeling
contains a fact table surrounded by and connected to several dimensional tables
multidimensionality
the ability to organize, present, and analyze data by several dimension, such as sales by region, by product, by salesperson, and by time
slice
a subset of a multidimentional array
dice
a slice on more than two dimensions
drill down
navigating among levels of data ranging from the most summarizing up to the most detailed
DWA
data warehouse administrator
BRM
business performance management
closed loop process to optimize business performance
strategize
plan
monitor
adjust
six sigma
a performance management methodology aimed at reducing the number of defects in a business process to as close to zero defects per million opportunities
