chapter 3 Flashcards
1
Q
data warehouse charecteristics
A
subject oriented integrated time-variant nonvolatile summarized not normalized metadata web based
2
Q
data mart
A
a departmental small-scale DW
3
Q
ODS
A
operational data store
4
Q
oper mart
A
operational data mart
5
Q
EDW
A
enterprise data warehouse
6
Q
metadata
A
data about data
7
Q
ERP
A
enterprise resource planning
8
Q
POS
A
point of sale
9
Q
ETL
A
extract transform load
10
Q
ETL process
A
select extract transform integrate load
11
Q
common to my consulting approach
A
extract data from event source sore in DW that provides -single version of truth -quality -transactional system independence
12
Q
EAI
A
enterprise application integration
13
Q
EII
A
enterprise information integration
14
Q
dimensional modeling
A
a retrieval based system that supports high=volume query access
15
Q
star schema
A
the most commonly used and the simplest style of dimensional modeling
contains a fact table surrounded by and connected to several dimensional tables
