Rainardi Building a Data Warehouse

With Examples in SQL Server
1. ed
ISBN: 978-1-4302-0528-9
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 523 Seiten

Here is the ideal field guide for data warehousing implementation. This book first teaches you how to build a data warehouse, including defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Coverage then explains how to populate the data warehouse and explores how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. It also details testing and how to administer data warehouse operation.

A bio is not available for this author.

Autoren/Hrsg.

Rainardi, Vincent

Inhaltsverzeichnis

1;Contents at a Glance;5
2;Contents;6
3;About the Author;12
4;Preface;13
5;Introduction to Data Warehousing;15
5.1;What Is a Data Warehouse?;15
5.2;Data Warehousing Today;31
5.3;Future Trends in Data Warehousing;38
5.4;Summary;41
6;Data Warehouse Architecture;42
6.1;Data Flow Architecture;42
6.2;System Architecture;55
6.3;Case Study;57
6.4;Summary;60
7;Data Warehouse Development Methodology;61
7.1;Waterfall Methodology;61
7.2;Iterative Methodology;66
7.3;Summary;71
8;Functional and Nonfunctional Requirements;72
8.1;Identifying Business Areas;72
8.2;Understanding Business Operations;73
8.3;Defining Functional Requirements;74
8.4;Defining Nonfunctional Requirements;76
8.5;Conducting a Data Feasibility Study;78
8.6;Summary;81
9;Data Modeling;82
9.1;Designing the Dimensional Data Store;82
9.2;Dimension Tables;87
9.3;Date Dimension;88
9.4;Slowly Changing Dimension;91
9.5;Product, Customer, and Store Dimensions;94
9.6;Subscription Sales Data Mart;100
9.7;Supplier Performance Data Mart;105
9.8;CRM Data Marts;107
9.9;Data Hierarchy;112
9.10;Source System Mapping;113
9.11;Designing the Normalized Data Store;117
9.12;Summary;122
10;Physical Database Design;123
10.1;Hardware Platform;123
10.2;Storage Considerations;130
10.3;Configuring Databases;133
10.4;Creating DDS Database Structure;138
10.5;Creating the Normalized Data Store;149
10.6;Using Views;167
10.7;Summary Tables;171
10.8;Partitioning;172
10.9;Indexes;176
10.10;Summary;181
11;Data Extraction;182
11.1;Introduction to ETL;182
11.2;ETL Approaches and Architecture;183
11.3;General Considerations;186
11.4;Extracting Relational Databases;189
11.5;Extracting File Systems;196
11.6;Extracting Other Source Types;199
11.7;Extracting Data Using SSIS;200
11.8;Memorizing the Last Extraction Timest209
11.9;Extracting from Files;217
11.10;Summary;223
12;Populating the Data Warehouse;224
12.1;Stage Loading;225
12.2;Data Firewall;227
12.3;Populating NDS;228
12.4;Using SSIS to Populate NDS;237
12.5;Upsert Using SQL and Lookup;244
12.6;Normalization;251
12.7;Practical Tips on SSIS;258
12.8;Populating DDS Dimension Tables;259
12.9;Populating DDS Fact Tables;275
12.10;Batches, Mini- batches, and Near Real- Time ETL;278
12.11;Pushing the Data In;279
12.12;Summary;280
13;Assuring Data Quality;281
13.1;Data Quality Process;282
13.2;Data Cleansing and Matching;285
13.3;Cross- checking with External Sources;298
13.4;Data Quality Rules;299
13.5;Action: Reject, Allow, Fix;301
13.6;Logging and Auditing;304
13.7;Data Quality Reports and Notifications;306
13.8;Summary;308
14;Metadata;309
14.1;Metadata in Data Warehousing;309
14.2;Data Definition and Mapping Metadata;311
14.3;Data Structure Metadata;316
14.4;Source System Metadata;321
14.5;ETL Process Metadata;326
14.6;Data Quality Metadata;328
14.7;Audit Metadata;331
14.8;Usage Metadata;332
14.9;Maintaining Metadata;333
14.10;Summary;335
15;Building Reports;336
15.1;Data Warehouse Reports;336
15.2;When to Use Reports and When Not to Use Them;339
15.3;Report Wizard;341
15.4;Report Layout;347
15.5;Report Parameters;349
15.6;Grouping, Sorting, and Filtering;358
15.7;Simplicity;363
15.8;Spreadsheets;364
15.9;Multidimensional Database Reports;369
15.10;Deploying Reports;373
15.11;Managing Reports;377
15.12;Summary;382
16;Multidimensional Database;383
16.1;What a Multidimensional Database Is;383
16.2;Online Analytical Processing;386
16.3;Creating a Multidimensional Database;387
16.4;Processing a Multidimensional Database;394
16.5;Querying a Multidimensional Database;400
16.6;Administering a Multidimensional Database;402
16.7;Summary;415
17;Using Data Warehouse for Business Intelligence;416
17.1;Business Intelligence Reports;417
17.2;Business Intelligence Analytics;418
17.3;Business Intelligence Data Mining;421
17.4;Business Intelligence Dashboards;437
17.5;Business Intelligence Alerts;442
17.6;Business Intelligence Portal;443
17.7;Summary;444
18;Using Data Warehouse for Customer Relationship Management;446
18.1;Single Customer View;447
18.2;Campaign Segmentation;452
18.3;Permission Management;455
18.4;Delivery and Response Data;459
18.5;Customer Analysis;465
18.6;Customer Support;468
18.7;Personalization;469
18.8;Customer Loyalty Scheme;470
18.9;Summary;471
19;Other Data Warehouse Usage;472
19.1;Customer Data Integration;472
19.2;Unstructured Data;475
19.3;Search in Data Warehousing;479
19.4;Summary;481
20;Testing Your Data Warehouse;482
20.1;Data Warehouse ETL Testing;483
20.2;Functional Testing;485
20.3;Performance Testing;487
20.4;Security Testing;490
20.5;User Acceptance Testing;491
20.6;End- to- End Testing;492
20.7;Migrating to Production;492
20.8;Summary;494
21;Data Warehouse Administration;495
21.1;Monitoring Data Warehouse ETL;496
21.2;Monitoring Data Quality;499
21.3;Managing Security;502
21.4;Managing Databases;503
21.5;Making Schema Changes;505
21.6;Updating Applications;507
21.7;Summary;507
22;Normalization Rules;509
22.1;First Normal Form;509
22.2;Second Normal Form;509
22.3;Third Normal Form;510
22.4;Boyce- Codd Normal Form;510
22.5;Higher Normal Forms;511
23;Index;512