The Data Model Resource Book, Volume 2 ^{2nd Ed.}

If you’ve relied on The Data Model Resource Book, Revised Edition, Volume 1 (0-471-38023-7) to jump-start your system development efforts, then you know that using a library of proven data models and data warehouse designs can produce huge savings in development costs. But what about the unique needs of your industry?

The Data Model Resource Book, Revised Edition, Volume 2, provides data models specifically tailored to your industry. It includes both brand-new models for each industry and generic models that the author customizes. The result is a comprehensive library of the industry’s core data models and applications, including models for:

• Financial services
• Professional services
• E-commerce
• Manufacturing
• Health care
• Insurance
• Travel
• Telecommunications

You not only get the data models themselves, you also learn to:

• Apply reusable data designs across a broad variety of industries
• Integrate databases and data warehouses across your organization
• Combine models from different applications for your specific needs
• Use the data structures to provide quality assurance for your own models
• Employ the book’s star schema designs to develop data analysis solutions

You can save even more time and money with the Data Model Resource Book, Revised Edition, Volume 2, CD-ROM, which:

• Provides the SQL code you’ll need to implement the models described in the book or to reverse-engineer them into your CASE tool
• Allows you to view for free the demonstration of data models from both Volume 1 and Volume 2
• Allows you to purchase online the downloadable models by industry type–directions inside

• Chapter 1: Introduction
• Why Is There a Need for This Book?
• To Integrate or Disintegrate? That Is the Question
• Approach of This Book
• Who Is the Intended Audience for This Book?
• General Industry Models versus More Specific Industry Models
• Industry Data Models versus Data Model Applications
• The Volume 2 Models: Customized and New Models for Each Industry
• Conventions and Standards Used in This Book
• Entities
• Subtypes and Supertypes
• Non-Mutually Exclusive Sets of Subtypes
• Attributes
• Relationships
• Relationship Optionality
• Relationship Cardinality
• Foreign Key Relationships
• Foreign Key Inheritance
• Intersection or Association Entities to Handle Many-to-Many Relationships
• Exclusive Arcs
• Recursive Relationships
• Physical Models
• Conventions Used for Illustration Tables
• Conventions Used to Reference Figures
• The Data Model Resource Book, Volime 2, Industry Download Products
• Chapter 2: Manufacturing
• People and Organizations in Manufacturing
• Product Models in Manufacturing
• Products and Parts
• Design Engineering
• Part Specification and Documentation
• Part Specification Roles and Status
• Engineering Change
• Product Bill of Material, Substitutes, and Inventory
• Configurations
• Product Bill of Materials
• Part Substitutions
• Inventory Item Configurations
• Other Product Models
• Orders
• Usage of the Order Models for Manufacturers
• Materials Requirements Planning
• Delivery
• Deployment and Use of Products
• Deployments
• Deployment Usage
• Inventory Ownership
• Work Effort
• Process Plan
• Production Runs
• Invoicing, Accounting, Budgeting, and Human Resources Models
• Star Schema for Manufacturing
• Production Run Fact
• Dimensions
• Variation of Product Run Data Mart
• Manufacturing Summary
• Chapter 3: Telecommunications
• People and Organizations in Telecommunications
• Generic Person and Organization Roles from Volume 1
• Party Roles and Relationships for Telecommunications
• Example of Party Roles and Relationships for Telecommunications
• Telecommunications Products
• Telecommunications Modifications to the Generic Product Data Models
• Telecommunications Services
• Telecommunications Goods
• Telecommunications Features
• Product Feature Interaction
• Telecommunications Product and Product Feature Example
• Product Deployment
• Telecommunications Product Associations
• Network Data Models
• Network Components
• Network Assemblies
• Circuits
• Product, Circuit, and Network Assembly Capabilities
• Communication IDs and Contact Mechanisms
• Orders
• Service Orders
• Product Availability
• Delivery
• Deplaoyment Usage
• Invoicing
• Work Effort, Accounting, and Human Resources Modules
• Star Schema for Telecommunications
• Product Deployment Usage Fact
• Customers
• Deployment Usage Types and Unit of Measures Dimensions
• Products
• Facilities
• Time by Hour
• Telecommunications Summary
• Chapter 4: Health Care
• People and Organizations in Health Care
• Person Roles
• Organization Roles
• Insured Party Roles
• Party Relationships
• Party Roles Example
• Health Care Facilities and Contact Mechanisms
• Patient, Practitioner, and Provider Information
• Health Care Products
• Health Care Offering Definition
• Health Care "Orders"
• Agreement Definition
• Health Care Shipments and Delivery
• Health Care Episodes, Incidents and Visits
• Health Care Delivery
• Health Care Claims
• Invoice Data Models versus Claims Data Models
• Health Care Claims Submission
• Claim Header Information
• Claim Codes
• Insurance Policy Information
• Payment Settlement
• Health Care Referrals
• Star Schemas for Health Care
• Health Care Summary
• Chapter 5: Insurance
• People and Organizations in Insurance
• Person Roles
• Organization Roles
• Person or Organization Roles
• Insurance Party Relationships
• Insurance Product
• Insurance Products and Categories
• Insurance Product Coverage
• Details behind Coverage Types and Coverage Levels
• Insurance Product Features
• Insurance Product Roles
• Insurance Pricing
• Community-Based Rating
• Insurance Rate Tables
• Experience-Based Insurance Rating
• Insurance Policies (Orders for Insurance)
• Insurance Application
• Insurance Quote
• The Insurance Agreement or Insurance Policy
• Insurance Policy Roles
• Insurance Policy Items
• Health Care Insurance Agreement
• Casualty Insurance Agreement
• Property Insurance Agreement
• Life Insurance Agreement
• Premium Schedule
• Premium Invoicing and Payments
• Policy Claims
• Insurance Claim Incidents
• Insurance Claims Submission
• Claims Settlement
• Delivery, Work Efforts, Accounting, and Human Resources for Insurance Enterprises
• Star Schemas for Insurance
• Analysis Information
• Claim Star Schema
• Fact Table
• Dimensions
• Insurance Summary
• Chapter 6: Financial Services
• People and Organizations in Financial Services
• Generic Party Role Subtypes
• Financial Services Party Roles
• Financial Services Relationships
• Financial Objectives, Needs, and Plans
• Financial Services Products
• Financial Services Product Definition
• Product Categories
• Product Feature and Functional Setting
• Financial Product and Functional Setting
• Features and Functional Settings for Product Categories
• Features and Functional Settings for Products
• Example of Predefined Financial Products with Product Features anbd Functional Settings
• Financial Products That Are Customized for the Specific Needs of a Customer
• Product Category Roll-ups
• Financial Product Regulations and Rules
• Agreements
• Financial Agreements
• Agreements Subtypes and Roles
• Asset Roles and Agreement Asset Usage
• Agreement Status
• Delivery
• Financial Account
• Account Product
• Account Roles
• Account Relationships
• Media
• Account Status
• Account Transaction
• Account Transaction Type
• Account Transaction Status
• Account Transaction Relationships
• Account Transaction Tasks
• Work Efforts
• Account Notification
• Notification Task Types
• Invoicing and Statement Tasks
• Marketing Tasks
• Alert Tasks
• Other Notification Tasks
• Analysis Task
• Analysis Task Data Model
• Example of Risk Analysis Task
• Invoicing, Accounting, and Human Resources
• Star Schemas for Financial Services
• Analysis Information
• Account Star Schema
• Fact Table
• Dimensions
• Account Transaction Star Schema
• Fact Table
• Dimensions
• Financial Services Summary
• Chapter 7: Professional Services
• People and Organizations in Professional Services
• Person Roles
• Organization Roles
• Professional Services Roles and Relationships Examples
• Professional Services Products
• Professional Services Products Model
• Applicability of Other Product Models
• Professional Services Product Associations
• Orders
• Professional Services Requirements
• Professional Services Requests and Quotes
• Professional Services Requests
• Professional Services Quotes (Proposal and Statements of Work)
• Engagements
• Types of Engagement Items
• Engagements Rates
• Placement versus Deliverable-Based Consulting
• Engagement Example
• Professional Services Agreements
• Delivery
• Professional Services Entries
• Work Efforts
• Invoicing
• Accounting, and Human Resources Management
• Star Schema for Professional Services
• Time Entry Fact
• Professional Services Summary
• Chapter 8: Travel
• People and Organizations in Travel
• Person Roles
• Organization Roles
• Party Relationships
• Travel Preferences
• Travel Products
• Product Definition
• Travel Orders (Reservations)
• Order Models
• Ticketing
• Agreements
• Travel Agreements
• Pricing of Agreements and Products
• Delivery (Travel Experience)
• Invoicing
• Work Efforts
• Travel Programs and Travel Accounts
• Travel Programs, Rules, and Factors
• Travel Account Example
• Star Schemas for Travel
• Passenger Transportation Offering Star Schema
• Fact Table
• Dimensions
• Non-Transportation Travel Product Star Schema
• Fact Table
• Dimensions
• Travel Summary
• Chapter 9: E-Commerce Models
• People and Organizations in E-Commerce
• E-Commerce Parties, Roles, and Relationships
• Automated Agent Party Subtype
• Generic Party Roles from Volume 1
• E-Commerce Party Roles and Relationships
• Is There Always a PARTY for a PARTY ROLE?
• Example Data for E-Commerce Party Roles and Relationships
• Party Contact Mechanisms in E-Commerce
• Web Site Content and User Login Information
• Web Site Content
• Login Account
• E-Commerce Products and Objects
• Orders in E-Commerce
• Party and Product Needs
• Subscriptions
• Web Visits
• Web Hits and Web Logs
• Web Visits Model
• VISIT Information
• SERVER HIT Information
• Defining a Visit
• Delivery, Work Efforts, Invoicing, Accounting, and Human Resources
• Web Server Hits Star Schema
• Server Hit Star Schema
• Server Hit Fact
• Visitors Dimension
• ISPS Dimension
• Referrers Dimension
• Web Contents Dimension
• User Agent Types Dimension
• Products Dimension
• Time by Hour Dimension
• Web Visit Star Schema
• E-Commerce Summary
• Chapter 10: Using the Industry Models in the Real World
• Using the Models to Build Transaction-Oriented Systems and Data Warehouses
• Enterprises in Other Industries
• Relevance of Models to Very Specific Industries
• Diverse Enterprises Needing Models from Several Chapters
• Setting Up Modularized Data Models for Use Across Industries
• For More Information
• Appendix A: Entities and Attributes for Manufacturing Models
• Entities and Attributes Listing for Manufacturing Models
• Appendix B: Entities and Attributes for Telecommunications Models
• Entities and Attributes Listing for Telecommunications Models
• Appendix C: Entities and Attributes for Health Care Models
• Entities and Attributes Listing for Health Care Models
• Appendix D: Entities and Attributes for Insurance Models
• Entities and Attributes Listing for Insurance Models
• Appendix E: Entities and Attributes for Financial Services Models
• Entities and Attributes Listing for Financial Services Models
• Appendix F: Entities and Attributes for Professional Services Models
• Entities and Attributes Listing for Professional Services Models
• Appendix G: Entities and Attributes for Travel Models
• Entities and Attributes Listing for Travel Models
• Appendix H: Entities and Attributes for E-Commerce Models
• Entities and Attributes Listing for E-Commerce Models
• Appendix I: List of Entities and Their Associated Figures
• Other Reusable Data Model and Data Warehouse Design Resources
• Reusable Data Model Resources
• Reusable Data Warehouse Design Resources
• How to Use the Volume 2 Industry Electronic Products
• Contents of the Industry Electronic Products
• Using the Scripts
• How to Use the Industry Electronic Products in Conjunction with the Data Model Resource CD-ROM, Volume 1
• Platform-Specific and Other Information on the Electronic Products

Well, this is the industrial complement to the first book, wherein we find stuff unique to TeleCom, Manufacturing etc.

Quite a nice introduction, not only on an IT-technical level, but also to the nomenclature used in the different industries.

If you haven't read the first volume, you are better of skipping this, but otherwise, it is a nice book.