You are previewing The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries.
O'Reilly logo
The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries

Book Description

A quick and reliable way to build proven databases for core business functions

Industry experts raved about The Data Model Resource Book when it was first published in March 1997 because it provided a simple, cost-effective way to design databases for core business functions. Len Silverston has now revised and updated the hugely successful First Edition, while adding a companion volume to take care of more specific requirements of different businesses. Each volume is accompanied by a CD-ROM, which is sold separately. Each CD-ROM provides powerful design templates discussed in the books in a ready-to-use electronic format, allowing companies and individuals to develop the databases they need at a fraction of the cost and a third of the time it would take to build them from scratch.

With each business function boasting its own directory, this CD-ROM provides a variety of data models for specific implementations in such areas as financial services, insurance, retail, healthcare, universities, and telecom.

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright
  4. Advance Praise for The Data Model Resource Book, Revised Edition, Volume 2
  5. Contents
  6. Foreword
  7. Acknowledgments
  8. About the Author
    1. About the Contributors
  9. CHAPTER 1: Introduction
    1. Why Is There a Need for This Book?
    2. To Integrate or Disintegrate? That Is the Question
    3. Approach of This Book
    4. Who Is the Intended Audience for This Book?
    5. General Industry Models versus More Specific Industry Models
    6. Industry Data Models versus Data Model Applications
    7. The Volume 2 Models: Customized and New Models for Each Industry
    8. Conventions and Standards Used in This Book
    9. The Data Model Resource Book, Volume 2, Industry Download Products
  10. CHAPTER 2: Manufacturing
    1. People and Organizations in Manufacturing
    2. Product Models in Manufacturing
    3. Orders
    4. Delivery
    5. Work Effort
    6. Invoicing, Accounting, Budgeting, and Human Resources Models
    7. Star Schema for Manufacturing
    8. Manufacturing Summary
  11. CHAPTER 3: Telecommunications
    1. People and Organizations in Telecommunications
    2. Telecommunications Products
    3. Orders
    4. Delivery
    5. Invoicing
    6. Work Effort, Accounting, and Human Resources Models
    7. Telecommunications Summary
  12. CHAPTER 4: Health Care
    1. People and Organizations in Health Care
    2. Health Care Products
    3. Health Care “Orders”
    4. Health Care Shipments and Delivery
    5. Health Care Claims
    6. Payment Settlement
    7. Health Care Referrals
    8. Star Schema for Health Care
    9. Health Care Summary
  13. CHAPTER 5: Insurance
    1. People and Organizations in Insurance
    2. Insurance Product
    3. Insurance Product Coverage
    4. Insurance Policies (Orders for Insurance)
    5. Premium Schedule
    6. Policy Claims
    7. Delivery, Work Efforts, Accounting, and Human Resources for Insurance Enterprises
    8. Star Schemas for Insurance
    9. Insurance Summary
  14. CHAPTER 6: Financial Services
    1. People and Organizations in Financial Services
    2. Financial Services Products
    3. Financial Product Regulations and Rules
    4. Agreements
    5. Delivery
    6. Work Efforts
    7. Invoicing, Accounting, and Human Resources
    8. Star Schemas for Financial Services
    9. Financial Services Summary
  15. CHAPTER 7: Professional Services
    1. People and Organizations in Professional Services
    2. Professional Services Products
    3. Orders
    4. Delivery
    5. Work Efforts
    6. Invoicing
    7. Accounting and Human Resources Management
    8. Star Schema for Professional Services
    9. Dimensions
    10. Professional Services Summary
  16. CHAPTER 8: Travel
    1. People and Organizations in Travel
    2. Travel Products
    3. Travel Orders (Reservations)
    4. Delivery (Travel Experience)
    5. Invoicing
    6. Work Efforts
    7. Travel Programs and Travel Accounts
    8. Star Schemas for Travel
    9. Travel Summary
  17. CHAPTER 9: E-Commerce Models
    1. People and Organizations in E-Commerce
    2. Web Site Content and User Login Information
    3. E-Commerce Products and Objects
    4. Orders in E-Commerce
    5. Delivery, Work Efforts, Invoicing, Accounting, and Human Resources
    6. Web Server Hits Star Schema
    7. E-Commerce Summary
  18. CHAPTER 10: Using the Industry Models in the Real World
    1. Using the Models to Build Transaction-Oriented Systems and Data Warehouses
    2. Enterprises in Other Industries
    3. Relevance of Models to Very Specific Industries
    4. Diverse Enterprises Needing Models from Several Chapters
    5. Setting Up Modularized Data Models for Use Across Industries
    6. For More Information
  19. APPENDIX A: Entities and Attributes for Manufacturing Models
    1. Entities and Attributes Listing for Manufacturing
  20. APPENDIX B: Entities and Attributes for Telecommunications Models
    1. Entities and Attributes Listing for Telecommunications Models
  21. APPENDIX C: Entities and Attributes for Health Care Models
    1. Entities and Attributes Listing for Health Care Models
  22. APPENDIX D: Entities and Attributes for Insurance Models
    1. Entities and Attributes Listing for Insurance Models
  23. APPENDIX E: Entities and Attributes for Financial Services Models
    1. Entities and Attributes Listing for Financial Services Models
  24. APPENDIX F: Entities and Attributes for Professional Services Models
    1. Entities and Attributes Listing for Professional Services Models
  25. APPENDIX G: Entities and Attributes for Travel Models
    1. Entities and Attributes Listing for Travel Models
  26. APPENDIX H: Entities and Attributes for E-Commerce Models
    1. Entities and Attributes Listing for E-Commerce Models
  27. APPENDIX I: List of Entities and Their Associated Figures
  28. Other Reusable Data Model and Data Warehouse Design Resources
  29. How to Use the Volume 2 Industry Electronic Products
    1. Contents of the Industry Electronic Products
    2. Using the Scripts
    3. How to Use the Industry Electronic Products in Conjunction with the Data Model Resource CD-ROM, Volume 1
  30. Index
  31. 30_customer_note.html