Foreword |
|
ix | (2) |
Acknowledgments |
|
xi | |
|
|
1 | (16) |
|
Why Is There a Need for This Book? |
|
|
1 | (1) |
|
Who Can Benefit from Reading This Book? |
|
|
2 | (1) |
|
The Need for Universal Data Models |
|
|
2 | (1) |
|
A Holistic Approach to Systems Development |
|
|
3 | (2) |
|
What Is the Intent of This Book and These Models? |
|
|
5 | (1) |
|
Conventions and Standards Used in This Book |
|
|
6 | (9) |
|
|
15 | (2) |
|
CHAPTER 2 PEOPLE AND ORGANIZATIONS |
|
|
17 | (24) |
|
|
17 | (1) |
|
|
18 | (2) |
|
|
20 | (2) |
|
|
22 | (2) |
|
|
24 | (5) |
|
|
29 | (3) |
|
Contact Mechanism Definition |
|
|
32 | (4) |
|
|
36 | (3) |
|
|
39 | (2) |
|
|
41 | (26) |
|
|
41 | (1) |
|
|
42 | (6) |
|
Product Suppliers and Manufacturers |
|
|
48 | (2) |
|
|
50 | (3) |
|
|
53 | (5) |
|
|
58 | (3) |
|
|
61 | (3) |
|
|
64 | (3) |
|
CHAPTER 4 ORDERING PRODUCTS |
|
|
67 | (46) |
|
|
67 | (1) |
|
|
68 | (3) |
|
|
71 | (3) |
|
|
74 | (2) |
|
|
76 | (6) |
|
Order Relationship to Party Location |
|
|
82 | (4) |
|
|
86 | (2) |
|
|
88 | (1) |
|
|
88 | (5) |
|
|
93 | (3) |
|
|
96 | (4) |
|
Person Roles for Requests and Quotes |
|
|
100 | (1) |
|
|
100 | (10) |
|
|
110 | (3) |
|
CHAPTER 5 ORDER DELIVERY AND INVOICING |
|
|
113 | (26) |
|
|
113 | (1) |
|
|
114 | (4) |
|
|
118 | (3) |
|
|
121 | (2) |
|
Shipments and Order Association |
|
|
123 | (3) |
|
|
126 | (4) |
|
Shipment Invoice Association |
|
|
130 | (3) |
|
|
133 | (3) |
|
|
136 | (3) |
|
|
139 | (38) |
|
|
139 | (1) |
|
Work Orders and Work Efforts |
|
|
140 | (1) |
|
|
140 | (5) |
|
|
145 | (2) |
|
|
147 | (4) |
|
|
151 | (3) |
|
Work Effort and Party Allocations |
|
|
154 | (3) |
|
|
157 | (4) |
|
|
161 | (2) |
|
|
163 | (3) |
|
|
166 | (1) |
|
Work Task Type Requirements |
|
|
167 | (3) |
|
|
170 | (5) |
|
|
175 | (2) |
|
CHAPTER 7 ACCOUNTING AND BUDGETING |
|
|
177 | (30) |
|
|
177 | (1) |
|
Chart of Accounts for Internal Organizations |
|
|
178 | (5) |
|
Accounting Transaction Definition |
|
|
183 | (8) |
|
|
191 | (1) |
|
|
192 | (6) |
|
|
198 | (5) |
|
Budget Relationship to General Ledger |
|
|
203 | (2) |
|
|
205 | (2) |
|
CHAPTER 8 HUMAN RESOURCES |
|
|
207 | (28) |
|
|
207 | (1) |
|
|
208 | (4) |
|
|
212 | (2) |
|
Position Reporting Relationships |
|
|
214 | (3) |
|
Position Fulfillment and Tracking |
|
|
217 | (3) |
|
Salary Determination and Pay History |
|
|
220 | (5) |
|
Benefits Definition and Tracking |
|
|
225 | (4) |
|
|
229 | (4) |
|
|
233 | (2) |
|
CHAPTER 9 CREATING THE DATA WAREHOUSE DATA MODEL FROM THE CORPORATE DATA MODEL |
|
|
235 | (22) |
|
|
235 | (1) |
|
The Data Warehouse Architecture |
|
|
236 | (2) |
|
|
238 | (5) |
|
Making the Transformation |
|
|
243 | (12) |
|
The Order of Applying the Transformation Criteria |
|
|
255 | (1) |
|
|
255 | (2) |
|
CHAPTER 10 A SAMPLE DATA WAREHOUSE DATA MODEL |
|
|
257 | (12) |
|
|
257 | (1) |
|
Transformation to Customer Invoice |
|
|
258 | (7) |
|
The Sample Data Warehouse Data Model |
|
|
265 | (2) |
|
|
267 | (2) |
|
CHAPTER 11 STAR SCHEMA DESIGNS FOR SALES ANALYSIS |
|
|
269 | (8) |
|
|
269 | (1) |
|
Detailed Customer Sales Information |
|
|
270 | (7) |
|
Sales by Product, Sales Rep, Customer, and Location |
|
|
277 | (2) |
|
Sales by sales Rep, Customer, and Location |
|
|
279 | (3) |
|
Sales by Product and Geographic Area |
|
|
282 | (2) |
|
|
284 | (3) |
|
CHAPTER 12 STAR SCHEMA DESIGNS FOR HUMAN RESOURCES ANALYSIS |
|
|
287 | (12) |
|
|
287 | (1) |
|
|
288 | (6) |
|
|
294 | (3) |
|
|
297 | (2) |
|
CHAPTER 13 USING THESE MODELS IN THE REAL WORLD |
|
|
299 | (8) |
|
Using the Logical Data Models |
|
|
299 | (3) |
|
Using the Data Warehouse Models |
|
|
302 | (3) |
|
|
305 | (2) |
APPENDIX A DETAILED ATTRIBUTE LISTINGS FOR THE LOGICAL DATA MODELS |
|
307 | (18) |
APPENDIX B TABLE STRUCTURES FOR THE DATA WAREHOUSE DATA MODEL |
|
325 | (4) |
APPENDIX C TABLE STRUCTURES FOR THE SALES ANALYSIS STAR SCHEMA |
|
329 | (4) |
APPENDIX D TABLE STRUCTURE FOR THE HUMAN RESOURCES STAR SCHEMA |
|
333 | (4) |
APPENDIX E HOW TO USE THE CD-ROM PRODUCT |
|
337 | (4) |
INDEX |
|
341 | |