Data Modeling by Example · Volume Three by Williams, Barry -- Read -- Imperial Library of Trantor

Index

Welcome

Why is This Book Free?

Volume Three : Advanced Level 13. From the Cradle to the Grave

13.1 Introduction 13.2 I am a New Baby 13.3 Me and Mommy 13.4 Me, Mommy, and Meals 13.5 Children’s Playgroups 13.6 Church Sunday School 13.7 Student Accommodation 13.8 Student Assessments 13.9 Joining Facebook 13.10 Joining a Swimming Club 13.11 A Ticket from a Traffic Cop 13.12 I Get Married 13.13 I Become a Baseball Umpire 13.14 I Go to Hospital 13.15 I Visit a Funeral Home 13.16 Events in my Life 13.17 Events in my Work 13.18 Canonical Data Model 13.19 What Have We Learned?

14. Check the Quality of a Data Model

14.1 Introduction 14.2 Create a Top-Level Business Data Model 14.3 Draft the Business Rules 14.4 Draft a Glossary of Terms 14.5 Check that the Data Model is Correct 14.6 Review with Users 14.7 Check Normalized Design 14.8 Reference Data 14.9 Slowly Changing Data 14.10 Check Normalization 14.11 Look for Design Patterns 14.12 Review Data Warehouses Designs 14.13 Check Naming Standards 14.14 Check for Consistent Data Types 14.15 Check for Defaults 14.16 Determine the Assurance Level 14.17. Checklist for Quality Assurance 14.18 What Have We Learned?

15. Enterprise Data Models

15.1 Introduction 15.2 Business Intelligence (BI) 15.3 Insurance 15.4 Investment Banking 15.5 Local Government 15.6 Retail 15.7 What Have We Learned?

16. Master Data Management (MDM)

16.1 Introduction 16.2 MDM for CRM 16.3 MDM for Law Enforcement 16.4 MDM for Local Government 16.5 What Have We Learned?

17. Build an Enterprise Data Model

17.1 Introduction 17.2 Opening a Pool Hall 17.2.1 Top-Level Model 17.2.2 Subject Area Models 17.2.3 Bookings 17.2.4 Customers 17.2.5 Payments 17.2.6 Data Warehouse 17.3 Opening a Funeral Home 17.4 Making a Movie 17.5 What Have We Learned?

18. A Single View of the Truth

18.1 Introduction 18.2 The Data Architecture 18.3 A Data Loading Sequence 18.4 Detailed Data Architecture 18.5 The Canonical Data Model 18.6 ERD for the Canonical Data Model 18.7 Master Data Management 18.8 ERD for Generic Data Warehouse 18.9 Generic Retail Data Mart 18.10 Sample Data Marts 18.11 What Have We Learned?

19. A Case Study

19.1 Background 19.2 Our Conclusions 19.3 Functional Description 19.4 A Specific Model in Word 19.5 A Generic Model in Word 19.6 A Top-Level Generic Data Model 19.7 What Have We Learned?