Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Introduction
Section I Data Modeling and the Need for Validation
Chapter 1 Data Modeling Primer
Entities
Attributes
Domains
Relationships
Keys
Candidate Key (Primary and Alternate)
Surrogate Key
Foreign Key
Secondary Key
Subtypes
Chapter 2 Importance of Data Model Quality
Precision
Leverage
Data Quality
Chapter 3 Data Model Scorecard Overview
Scorecard Characteristics
Scorecard Template
DMM Context
DMM and Data Modeling
DMBOK Context
Section II Data Model Scorecard Categories
Chapter 4 Category One: Correctness How well does the model capture the requirements?
Category Expectations
Chapter 5 Category Two: Completeness How complete is the model?
Category Expectations
Chapter 6 Category Three: Scheme How well does the model match its scheme?
Category Expectations
Conceptual Data Model Adherence
Relational Adherence
Dimensional Adherence
Logical Data Model Adherence
Relational Adherence
Dimensional Adherence
Physical Data Model Adherence
Relational Adherence
Dimensional Adherence
NoSQL Database Adherence
Chapter 7 Category Four: Structure How structurally sound is the model?
Category Expectations
Model is Consistent
Model has Integrity
Model Follows Core Principles
Chapter 8 Category Five: Abstraction How well does the model leverage generic structures?
Category Expectations
Model is Extensible
Model is Useable
Chapter 9 Category Six: Standards How well does the model follow naming standards?
Category Expectations
Model is Well-Structured
Model Uses the Correct Terms
Model has Consistent Style
Chapter 10 Category Seven: Readability How well has the model been arranged for readability?
Category Expectations
Model is Readable
Entity Layout Acceptable
Attribute Sequence Acceptable
Relationship Layout Acceptable
Chapter 11 Category Eight: Definitions How good are the definitions?
Category Expectations
Definitions are Clear
Definitions are Complete
Definitions are Correct
Chapter 12 Category Nine: Consistency How consistent is the model with the enterprise?
Category Expectations
Chapter 13 Category Ten: Data How well does the metadata match the data?
Category Expectations
Section III Validating Data Models With the Scorecard
Chapter 14 Preparing for the Model Review
Required Documentation
Extra Credit Documentation
Review Structure
Divide the Model up into Realistic Chunks for Review
Deciding who Participates in the Review
Seating Pattern
Chapter 15 During the Model Review
Choose a Mile Deep Over a Mile Wide
Set the Stage
Build a Support Group
Average the Scores
Start With a CDM
Know When to Throw in the Towel
Keep it Fun
Chapter 16 Data Model Scorecard Case Study: Consumer Interaction
1. Correctness
2. Completeness
3. Scheme
4. Structure
5. Abstraction
6. Standards
7. Readability
8. Definitions
9. Consistency
10. Data
Completed Scorecard
Index
← Prev
Back
Next →
← Prev
Back
Next →