| Acknowledgements |
|
i | |
| Foreword |
|
iii | |
| Introduction |
|
v | |
|
|
|
7 | (4) |
|
What is So Special About Data Models? |
|
|
11 | (8) |
|
|
|
11 | (2) |
|
|
|
13 | (1) |
|
|
|
14 | (2) |
|
|
|
16 | (3) |
|
|
|
19 | (8) |
|
|
|
20 | (1) |
|
|
|
21 | (6) |
|
|
|
27 | (6) |
|
|
|
28 | (1) |
|
|
|
29 | (4) |
|
|
|
33 | (10) |
|
|
|
35 | (2) |
|
|
|
37 | (3) |
|
Identifying and Non-Identifying Relationships |
|
|
40 | (1) |
|
|
|
41 | (2) |
|
What Makes a Definition Great? |
|
|
43 | (4) |
|
|
|
44 | (1) |
|
|
|
44 | (1) |
|
|
|
45 | (2) |
|
What is the Subject Area Model? |
|
|
47 | (8) |
|
Business Subject Area Model (BSAM) |
|
|
48 | (3) |
|
Application Subject Area Model (ASAM) |
|
|
51 | (2) |
|
Comparison Subject Area Model (CSAM) |
|
|
53 | (2) |
|
What is the Logical Data Model? |
|
|
55 | (26) |
|
|
|
55 | (2) |
|
|
|
57 | (3) |
|
|
|
60 | (8) |
|
|
|
68 | (3) |
|
|
|
71 | (3) |
|
|
|
74 | (7) |
|
What is the Physical Data Model? |
|
|
81 | (24) |
|
|
|
81 | (12) |
|
|
|
93 | (2) |
|
|
|
95 | (1) |
|
|
|
96 | (1) |
|
|
|
97 | (2) |
|
|
|
99 | (6) |
|
What is the Best Approach to Build the Models? |
|
|
105 | (6) |
|
Purpose + Audience = Deliverables |
|
|
105 | (2) |
|
Deliverables + Resources + Time = Approach |
|
|
107 | (4) |
|
How Do I Validate a Data Model? |
|
|
111 | (16) |
|
How Well Does the Model Capture the Requirements? |
|
|
113 | (3) |
|
How Complete is the Model? |
|
|
116 | (1) |
|
How Structurally Sound is the Model? |
|
|
117 | (2) |
|
How Well Does the Model Leverage Generic Structures? |
|
|
119 | (1) |
|
How Well Does the Model Follow Naming Standards? |
|
|
120 | (1) |
|
How Well Has the Model Been Arranged for Readability? |
|
|
121 | (1) |
|
How Good are the Definitions? |
|
|
122 | (1) |
|
How Well Has the Real World Context Been Incorporated? |
|
|
123 | (1) |
|
How Consistent is the Model with the Enterprise? |
|
|
124 | (1) |
|
How Well Does the Metadata Match the Data? |
|
|
125 | (2) |
|
Top 3 Most Frequently Asked Questions |
|
|
127 | (4) |
|
How Do I Keep My Modeling Skills Sharp? |
|
|
127 | (1) |
|
What is the Best Data Modeling Tool? |
|
|
128 | (1) |
|
What is the Future Role of the Data Modeler? |
|
|
128 | (3) |
| Suggested Reading |
|
131 | (1) |
| Books |
|
131 | (1) |
| Web Sites |
|
131 | |
