January 2008
Beginner to intermediate
672 pages
31h 44m
English
book
The Data Warehouse Lifecycle Toolkit
by Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy, Bob Becker
Content preview from The Data Warehouse Lifecycle Toolkit
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Index
A
abused user as interviewee, 101–102
access monitoring tables, 344
accumulating snapshot fact tables
functions of, 274–276
table loader, 397–398
ad hoc access
access policy, 219
ad hoc queries, 160
BI applications, 475
meaning of, 475
performance testing, 552
security tables, 344
affinity grouping, 497–498
aggregates
aggregate builder, 403–404
aggregate table, 465–466
BI query and reporting tool for, 354
choosing aggregates, 354–355
definitions, 140
elements of, 136
maintenance of, 355–357
metadata, 140
navigation, 136–137, 146
OLAP engine for, 354
Oracle, use of, 353–354
and performance improvement, 353
physical database, 353–357
presentation server architecture, 134–137
problems, types of, 354–357
and query management, 146
sizing estimates, 341
usage based optimization, 136
usage statistics, 140
agile. See rapid application development
alerts
BI applications, 481–482, 491
allocation
fact tables, 277–278
analytical applications
BI applications, 142, 480, 488–490, 512,
527
developing, 527
pre-built applications, 489–490
read/write applications, 490
standard template for, 512
types of, 488–489
analytical cycle
BI applications, 479
analytical data
user requirements, 134
annual report
as research tool, 70
ANSI SQL 99 support
queries, 483
application interface
BI applications, 504
GUI, physical database, 358–359
application logic, 155
architecture
plan document, 187–189
See also enterprise data warehouse bus
architecture; parallel processi ...