Muutke küpsiste eelistusi

Data Model Resource Book: A Library of Logical Data and Data Warehouse Models [Pehme köide]

  • Formaat: Paperback / softback, 366 pages, kõrgus x laius: 190x235 mm, kaal: 624 g, Illustrations
  • Ilmumisaeg: 04-Apr-1997
  • Kirjastus: John Wiley & Sons Inc
  • ISBN-10: 0471153648
  • ISBN-13: 9780471153641
Teised raamatud teemal:
  • Formaat: Paperback / softback, 366 pages, kõrgus x laius: 190x235 mm, kaal: 624 g, Illustrations
  • Ilmumisaeg: 04-Apr-1997
  • Kirjastus: John Wiley & Sons Inc
  • ISBN-10: 0471153648
  • ISBN-13: 9780471153641
Teised raamatud teemal:
Development of corporate database systems is complex, time-consuming, and expensive, leaving developers on the lookout for ways to cut costs. The authors of this text have found a way to do this. It's based on a simple observation: most companies handle a core set of basic business functions in similar ways. Therefore the databases that support these functions can be boiled down to a relatively few basic models. But most companies continue to "reinvent the wheel" by creating their own data models, a complicated and lengthy task. The solution is to identify the core data models that most companies share, standardize them, and make them available to all. This resource book provides a common set of data models for the specific core functions shared by most businesses such as sales, marketing, order processing, budgeting and accounting; it also provides a library of data models for companies in specific industry groups. In many cases, readers can apply more than one industry model to the organization, for example, for companies that both manufacture, market and distribute products. It also shows how to turn these data models into a structure suitable for data warehousing. This practical volume provides proven data models that database developers can use to save the time it normally takes to develop databases for common business tasks, plus save considerable sums in consulting fees. The CD-ROM product is available. It provides all of the data models contained in the book in electronic form (ASCII). Companies can use the CD to load the data directly to most data modelling tools and customize the models to fit their specific requirements.
Foreword ix(2)
Acknowledgments xi
CHAPTER 1 INTRODUCTION
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)
The Companion CD-ROM
15(2)
CHAPTER 2 PEOPLE AND ORGANIZATIONS
17(24)
Introduction
17(1)
Organization Definition
18(2)
Person Definition
20(2)
Party Definition
22(2)
Party Relationship
24(5)
Address Definition
29(3)
Contact Mechanism Definition
32(4)
Contact Information
36(3)
Summary
39(2)
CHAPTER 3 PRODUCTS
41(26)
Introduction
41(1)
Product Definition
42(6)
Product Suppliers and Manufacturers
48(2)
Inventory Item Storage
50(3)
Product Pricing
53(5)
Product Costing
58(3)
Product Components
61(3)
Summary
64(3)
CHAPTER 4 ORDERING PRODUCTS
67(46)
Introduction
67(1)
Standard Order Model
68(3)
Order Definition
71(3)
Order Header
74(2)
Order Line Items
76(6)
Order Relationship to Party Location
82(4)
Person Roles for Orders
86(2)
Optional Order Models
88(1)
Requisition Definition
88(5)
Request Definition
93(3)
Quote Definition
96(4)
Person Roles for Requests and Quotes
100(1)
Agreement Definition
100(10)
Summary
110(3)
CHAPTER 5 ORDER DELIVERY AND INVOICING
113(26)
Introduction
113(1)
Shipment Definition
114(4)
Shipment Methods
118(3)
Shipping Lots
121(2)
Shipments and Order Association
123(3)
Invoice Definition
126(4)
Shipment Invoice Association
130(3)
Invoice Billing
133(3)
Summary
136(3)
CHAPTER 6 WORK EFFORT
139(38)
Introduction
139(1)
Work Orders and Work Efforts
140(1)
Work Order Definition
140(5)
Work Order Roles
145(2)
Work Effort Generation
147(4)
Work Task Definition
151(3)
Work Effort and Party Allocations
154(3)
Work Task Assignments
157(4)
Inventory Assignments
161(2)
Fixed Asset Assignments
163(3)
Party Asset Assignments
166(1)
Work Task Type Requirements
167(3)
Work Effort Invoicing
170(5)
Summary
175(2)
CHAPTER 7 ACCOUNTING AND BUDGETING
177(30)
Introduction
177(1)
Chart of Accounts for Internal Organizations
178(5)
Accounting Transaction Definition
183(8)
Asset Depreciation
191(1)
Budget Definition
192(6)
Use of Budgeted Money
198(5)
Budget Relationship to General Ledger
203(2)
Summary
205(2)
CHAPTER 8 HUMAN RESOURCES
207(28)
Introduction
207(1)
Position Definition
208(4)
Position Type Definition
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)
Payroll Information
229(4)
Summary
233(2)
CHAPTER 9 CREATING THE DATA WAREHOUSE DATA MODEL FROM THE CORPORATE DATA MODEL
235(22)
Introduction
235(1)
The Data Warehouse Architecture
236(2)
The Corporate Data Model
238(5)
Making the Transformation
243(12)
The Order of Applying the Transformation Criteria
255(1)
Summary
255(2)
CHAPTER 10 A SAMPLE DATA WAREHOUSE DATA MODEL
257(12)
Introduction
257(1)
Transformation to Customer Invoice
258(7)
The Sample Data Warehouse Data Model
265(2)
Summary
267(2)
CHAPTER 11 STAR SCHEMA DESIGNS FOR SALES ANALYSIS
269(8)
Introduction
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)
Summary
284(3)
CHAPTER 12 STAR SCHEMA DESIGNS FOR HUMAN RESOURCES ANALYSIS
287(12)
Introduction
287(1)
Employee Pay History
288(6)
Average Annual Pay
294(3)
Summary
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)
Summary
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