building of 124–126
challenge of 121–124
characteristics of 126
current valued data 126–127
dismantling of 131 , 131 f
frozen business requirements 130 , 130 f
high availability 128–129
minimal historical data 127–128
overlap between 129–130
Siloed systems 121 , 124–125
Six Sigma, Data Vault 2.0 168–169
SLA See Service-level agreement (SLA)
SLDC See Software development life cycle (SLDC)
Smart key 152–153
Software development life cycle (SLDC) 163–164, 167–168
Source system sequence-driven business keys 153–155
Spreadsheets 107–108, 332–334, 332–334f
Stacked bar chart 389 t, 391–392, 391 f
Staging area 221–222
Standard data warehouse 52
Standard structured DBMS 11 f, 12
Standard work unit (swu) 185 , 188
hourglass analogy 185–187
racetrack analogy 187 , 187 f
response time, elements of 185 , 186 f
SLA 188–189
Star join
data marts 325
data model 343–345, 344–345f
Stemming 373
word 283
Stop words 373
nonrepetitive data 282–283
Strategic business value 364–365
Structured approach, data architecture 204 , 205 f
Structured data 1 , 2 f, 10 , 23 , 24 f
analysis of 217–218
decisions based 89–90, 90 f
Index