The Data Model Resource Book
Subtitle: Vol. 2: A Library of Universal Data Models by Industry Types
Edition: 2nd ed.,Revised
Publisher: Wiley [Imprint]; John Wiley & Sons, Incorporated.
Published: 2001
Place of publication: Hoboken
Language: eng
Format: [electronic resource] :
ISBN-13: 9780471353485
Other titles: Safari books online.
Description: Annotation
Notes: Scholarly & Professional John Wiley & Sons, Incorporated
Table of contents: title: Foreword
pagenum: xiii; title: Acknowledgments
pagenum: xv; title: About the Author
pagenum: xvii; label: Chapter 1
title: Introduction
pagenum: 1; title: Why Is There a Need for This Book?
pagenum: 1; title: To Integrate or Disintegrate? That Is the Question
pagenum: 2; title: Approach of This Book
pagenum: 4; title: Who Is the Intended Audience for This Book?
pagenum: 5; title: General Industry Models versus More Specific Industry Models
pagenum: 5; title: Industry Data Models versus Data Model Applications
pagenum: 7; title: The Volume 2 Models: Customized and New Models for Each Industry
pagenum: 8; title: Conventions and Standards Used in This Book
pagenum: 8; title: Entities
pagenum: 8; title: Subtypes and Supertypes
pagenum: 15; title: Non-Mutually Exclusive Sets of Subtypes
pagenum: 16; title: Attributes
pagenum: 17; title: Relationships
pagenum: 18; title: Relationship Optionality
pagenum: 18; title: Relationship Cardinality
pagenum: 19; title: Foreign Key Relationships
pagenum: 20; title: Foreign Key Inheritance
pagenum: 20; title: Intersection or Association Entities to Handle Many-to-Many Relationships
pagenum: 21; title: Exclusive Arcs
pagenum: 22; title: Recursive Relationships
pagenum: 22; title: Physical Models
pagenum: 23; title: Conventions Used for Illustration Tables
pagenum: 24; title: Conventions Used to Reference Figures
pagenum: 25; title: The Data Model Resource Book, Volume 2, Industry Download Products
pagenum: 25; label: Chapter 2
title: Manufacturing
pagenum: 27; title: People and Organizations in Manufacturing
pagenum: 31; title: Product Models in Manufacturing
pagenum: 33; title: Products and Parts
pagenum: 33; title: Design Engineering
pagenum: 36; title: Part Specifications and Documentation
pagenum: 36; title: Part Specification Roles and Status
pagenum: 40; title: Engineering Change
pagenum: 41; title: Product Bill of Material, Substitutes, and Inventory Configurations
pagenum: 43; title: Product Bill of Materials
pagenum: 44; title: Part Substitutions
pagenum: 46; title: Inventory Item Configurations
pagenum: 50; title: Other Product Models
pagenum: 53; title: Orders
pagenum: 54; title: Usage of the Order Models for Manufacturers
pagenum: 54; title: Materials Requirements Planning
pagenum: 56; title: Delivery
pagenum: 57; title: Deployment and Use of Products
pagenum: 58; title: Deployments
pagenum: 58; title: Deployment Usage
pagenum: 60; title: Inventory Ownership
pagenum: 62; title: Work Effort
pagenum: 63; title: Process Plan
pagenum: 63; title: Production Runs
pagenum: 65; title: Invoicing, Accounting, Budgeting, and Human Resources Models
pagenum: 67; title: Star Schema for Manufacturing
pagenum: 69; title: Production Run Fact
pagenum: 70; title: Dimensions
pagenum: 71; title: Variation of Product Run Data Mart
pagenum: 72; title: Manufacturing Summary
pagenum: 73; label: Chapter 3
title: Telecommunications
pagenum: 75; title: People and Organizations in Telecommunications
pagenum: 80; title: Generic Person and Organization Roles from Volume 1
pagenum: 80; title: Party Roles and Relationships for Telecommunications
pagenum: 80; title: Example of Party Roles and Relationships for Telecommunications
pagenum: 83; title: Telecommunications Products
pagenum: 84; title: Telecommunications Modifications to the Generic Product Data Models
pagenum: 84; title: Telecommunications Services
pagenum: 86; title: Telecommunications Goods
pagenum: 88; title: Telecommunications Features
pagenum: 88; title: Product Feature Interaction
pagenum: 89; title: Telecommunications Product and Product Feature Example
pagenum: 89; title: Product Deployment
pagenum: 91; title: Telecommunications Product Associations
pagenum: 93; title: Network Data Models
pagenum: 98; title: Network Components
pagenum: 99; title: Network Assemblies
pagenum: 101; title: Circuits
pagenum: 104; title: Product, Circuit, and Network Assembly Capabilities
pagenum: 106; title: Communication IDs and Contact Mechanisms
pagenum: 109; title: Orders
pagenum: 111; title: Service Orders
pagenum: 111; title: Product Availability
pagenum: 113; title: Delivery
pagenum: 114; title: Deployment Usage
pagenum: 114; title: Invoicing
pagenum: 118; title: Work Effort, Accounting, and Human Resources Models
pagenum: 120; title: Star Schema for Telecommunications
pagenum: 121; title: Product Deployment Usage Fact
pagenum: 122; title: Customers
pagenum: 123; title: Deployment Usage Types and Unit of Measures Dimensions
pagenum: 123; title: Products
pagenum: 123; title: Facilities
pagenum: 124; title: Time by Hour
pagenum: 124; title: Telecommunications Summary
pagenum: 124; label: Chapter 4
title: Health Care
pagenum: 127; title: People and Organizations in Health Care
pagenum: 129; title: Person Roles
pagenum: 129; title: Organization Roles
pagenum: 132; title: Insured Party Roles
pagenum: 133; title: Party Relationships
pagenum: 134; title: Party Roles Example
pagenum: 134; title: Health Care Facilities and Contact Mechanisms
pagenum: 138; title: Patient, Practitioner, and Provider Information
pagenum: 138; title: Health Care Products
pagenum: 141; title: Health Care Offering Definition
pagenum: 141; title: Health Care "Orders"
pagenum: 144; title: Agreement Definition
pagenum: 145; title: Health Care Shipments and Delivery
pagenum: 148; title: Health Care Episodes, Incidents and Visits
pagenum: 148; title: Health Care Delivery
pagenum: 151; title: Health Care Claims
pagenum: 154; title: Invoice Data Models versus Claims Data Models
pagenum: 154; title: Health Care Claims Submission
pagenum: 156; title: Claim Header Information
pagenum: 157; title: Claim Codes
pagenum: 159; title: Insurance Policy Information
pagenum: 160; title: Payment Settlement
pagenum: 162; title: Health Care Referrals
pagenum: 164; title: Star Schema for Health Care
pagenum: 165; title: Health Care Summary
pagenum: 167; label: Chapter 5
title: Insurance
pagenum: 171; title: People and Organizations in Insurance
pagenum: 173; title: Person Roles
pagenum: 176; title: Organization Roles
pagenum: 178; title: Person or Organization Roles
pagenum: 179; title: Insurance Party Relationships
pagenum: 181; title: Insurance Product
pagenum: 184; title: Insurance Products and Categories
pagenum: 185; title: Insurance Product Coverage
pagenum: 188; title: Details behind Coverage Types and Coverage Levels
pagenum: 190; title: Insurance Product Features
pagenum: 194; title: Insurance Product Rules
pagenum: 196; title: Insurance Pricing
pagenum: 200; title: Community-Based Rating
pagenum: 200; title: Insurance Rate Tables
pagenum: 203; title: Experienced-Based Insurance Rating
pagenum: 206; title: Insurance Policies (Orders for Insurance)
pagenum: 206; title: Insurance Application
pagenum: 206; title: Insurance Quote
pagenum: 208; title: The Insurance Agreement or Insurance Policy
pagenum: 213; title: Insurance Policy Roles
pagenum: 214; title: Insurance Policy Items
pagenum: 216; title: Health Care Insurance Agreement
pagenum: 219; title: Casualty Insurance Agreement
pagenum: 224; title: Property Insurance Agreement
pagenum: 225; title: Life Insurance Agreement
pagenum: 226; title: Premium Schedule
pagenum: 227; title: Premium Invoicing and Payments
pagenum: 231; title: Policy Claims
pagenum: 231; title: Insurance Claim Incidents
pagenum: 232; title: Insurance Claims Submission
pagenum: 234; title: Claims Settlement
pagenum: 237; title: Delivery, Work Efforts, Accounting, and Human Resources for Insurance Enterprises
pagenum: 240; title: Star Schemas for Insurance
pagenum: 241; title: Analysis Information
pagenum: 241; title: Claim Star Schema
pagenum: 241; title: Fact Table
pagenum: 242; title: Dimensions
pagenum: 242; title: Insurance Summary
pagenum: 245; label: Chapter 6
title: Financial Services
pagenum: 247; title: People and Organizations in Financial Services
pagenum: 249; title: Generic Party Role Subtypes
pagenum: 252; title: Financial Service Party Roles
pagenum: 252; title: Financial Service Relationships
pagenum: 254; title: Financial Objectives, Needs, and Plans
pagenum: 257; title: Financial Services Products
pagenum: 261; title: Financial Services Product Definition
pagenum: 262; title: Product Categories
pagenum: 264; title: Product Feature and Functional Setting
pagenum: 264; title: Financial Product and Functional Setting
pagenum: 265; title: Features and Functional Settings for Product Categories
pagenum: 266; title: Features and Functional Settings for Products
pagenum: 267; title: Example of Predefined Financial Products with Product Features and Functional Settings
pagenum: 267; title: Financial Products That Are Customized for the Specific Needs of a Customer
pagenum: 268; title: Product Category Roll-ups
pagenum: 272; title: Financial Product Regulations and Rules
pagenum: 273; title: Agreements
pagenum: 276; title: Financial Agreements
pagenum: 276; title: Agreement Subtypes and Roles
pagenum: 276; title: Asset Roles and Agreement Asset Usage
pagenum: 278; title: Agreement Status
pagenum: 279; title: Delivery
pagenum: 279; title: Financial Account
pagenum: 279; title: Account Product
pagenum: 280; title: Account Roles
pagenum: 282; title: Account Relationships
pagenum: 282; title: Media
pagenum: 283; title: Account Status
pagenum: 283; title: Account Transaction
pagenum: 284; title: Account Transaction Type
pagenum: 284; title: Account Transaction Status
pagenum: 286; title: Account Transaction Relationships
pagenum: 286; title: Account Transaction Tasks
pagenum: 288; title: Work Efforts
pagenum: 290; title: Account Notification
pagenum: 290; title: Notification Task Types
pagenum: 291; title: Invoicing and Statement Tasks
pagenum: 291; title: Marketing Tasks
pagenum: 293; title: Alert Tasks
pagenum: 294; title: Other Notification Tasks
pagenum: 294; title: Example of Account Notification Tasks
pagenum: 295; title: Analysis Task
pagenum: 295; title: Analysis Task Data Model
pagenum: 297; title: Example of Risk Analysis Task
pagenum: 299; title: Invoicing, Accounting, and Human Resources
pagenum: 299; title: Star Schemas for Financial Services
pagenum: 300; title: Analysis Information
pagenum: 300; title: Account Star Schema
pagenum: 300; title: Fact Table
pagenum: 302; title: Dimensions
pagenum: 302; title: Account Transaction Star Schema
pagenum: 304; title: Fact Table
pagenum: 304; title: Dimensions
pagenum: 304; title: Financial Services Summary
pagenum: 306; label: Chapter 7
title: Professional Services
pagenum: 309; title: People and Organizations in Professional Services
pagenum: 311; title: Person Roles
pagenum: 313; title: Organization Roles
pagenum: 314; title: Professional Services Roles and Relationships Examples
pagenum: 314; title: Professional Services Products
pagenum: 316; title: Professional Services Products Model
pagenum: 317; title: Applicability of Other Product Models
pagenum: 319; title: Professional Service Product Associations
pagenum: 321; title: Orders
pagenum: 321; title: Professional Services Requirements
pagenum: 322; title: Professional Services Requests and Quotes
pagenum: 325; title: Professional Services Requests
pagenum: 328; title: Professional Service Quotes (Proposals and Statements of Work)
pagenum: 330; title: Engagements
pagenum: 333; title: Types of Engagement Items
pagenum: 333; title: Engagement Rates
pagenum: 335; title: Placement versus Deliverables-Based Consulting
pagenum: 336; title: Engagement Example
pagenum: 336; title: Professional Services Agreements
pagenum: 338; title: Delivery
pagenum: 341; title: Professional Services Entries
pagenum: 341; title: Work Efforts
pagenum: 343; title: Invoicing
pagenum: 346; title: Accounting and Human Resources Management
pagenum: 347; title: Star Schema for Professional Services
pagenum: 348; title: Time Entry Fact
pagenum: 349; title: Dimensions
pagenum: 350; title: Professional Services Summary
pagenum: 350; label: Chapter 8
title: Travel
pagenum: 353; title: People and Organizations in Travel
pagenum: 355; title: Person Roles
pagenum: 357; title: Organization Roles
pagenum: 357; title: Party Relationships
pagenum: 359; title: Travel Preferences
pagenum: 362; title: Travel Products
pagenum: 364; title: Product Definition
pagenum: 364; title: Travel Orders (Reservations)
pagenum: 369; title: Order Models
pagenum: 370; title: Ticketing
pagenum: 373; title: Agreements
pagenum: 376; title: Travel Agreements
pagenum: 376; title: Pricing of Agreements and Products
pagenum: 376; title: Delivery (Travel Experience)
pagenum: 379; title: Invoicing
pagenum: 383; title: Work Efforts
pagenum: 383; title: Travel Programs and Travel Accounts
pagenum: 383; title: Travel Programs, Rules, and Factors
pagenum: 385; title: Travel Account Example
pagenum: 385; title: Star Schemas for Travel
pagenum: 386; title: Passenger Transportation Offering Star Schema
pagenum: 386; title: Fact Table
pagenum: 386; title: Dimensions
pagenum: 387; title: Non-Transportation Travel Product Star Schema
pagenum: 388; title: Fact Table
pagenum: 388; title: Dimensions
pagenum: 388; title: Travel Summary
pagenum: 389; label: Chapter 9
title: E-Commerce Models
pagenum: 393; title: People and Organizations in E-Commerce
pagenum: 395; title: E-Commerce Parties, Roles, and Relationships
pagenum: 397; title: Automated Agent Party Subtype
pagenum: 398; title: Generic Party Roles from Volume 1
pagenum: 399; title: E-Commerce Party Roles and Relationships
pagenum: 399; title: Is There Always a PARTY for a PARTY ROLE?
pagenum: 400; title: Example Data for E-Commerce Party Roles and Relationships
pagenum: 400; title: Party Contact Mechanisms in E-Commerce
pagenum: 402; title: Web Site Content and User Login Information
pagenum: 405; title: Web Site Content
pagenum: 405; title: Login Account
pagenum: 407; title: E-Commerce Products and Objects
pagenum: 408; title: Orders in E-Commerce
pagenum: 410; title: Party and Product Needs
pagenum: 412; title: Subscriptions
pagenum: 414; title: Web Visits
pagenum: 418; title: Web Hits and Web Logs
pagenum: 419; title: Web Visits Model
pagenum: 420; title: VISIT Information
pagenum: 422; title: SERVER HIT Information
pagenum: 422; title: Defining a Visit
pagenum: 423; title: Delivery, Work Efforts, Invoicing, Accounting, and Human Resources
pagenum: 426; title: Web Server Hits Star Schema
pagenum: 426; title: Server Hit Star Schema
pagenum: 427; title: Server Hit Fact
pagenum: 428; title: Visitors Dimension
pagenum: 428; title: ISPS Dimension
pagenum: 429; title: Referrers Dimension
pagenum: 429; title: Web Contents Dimension
pagenum: 429; title: User Agent Types Dimension
pagenum: 430; title: Products Dimension
pagenum: 430; title: Time by Hour Dimension
pagenum: 430; title: Web Visit Star Schema
pagenum: 431; title: E-Commerce Summary
pagenum: 433; label: Chapter 10
title: Using the Industry Models in the Real World
pagenum: 435; title: Using the Models to Build Transaction-Oriented Systems and Data Warehouses
pagenum: 436; title: Enterprises in Other Industries
pagenum: 437; title: Relevance of Models to Very Specific Industries
pagenum: 438; title: Diverse Enterprises Needing Models from Several Chapters
pagenum: 438; title: Setting Up Modularized Data Models for Use Across Industries
pagenum: 439; title: For More Information
pagenum: 439; label: Appendix A
title: Entities and Attributes for Manufacturing Models
pagenum: 443; title: Entities and Attributes Listing for Manufacturing
pagenum: 445; label: Appendix B
title: Entities and Attributes for Telecommunications Models
pagenum: 453; title: Entities and Attributes Listing for Telecommunications Models
pagenum: 454; label: Appendix C
title: Entities and Attributes for Health Care Models
pagenum: 463; title: Entities and Attributes Listing for Health Care Models
pagenum: 464; label: Appendix D
title: Entities and Attributes for Insurance Models
pagenum: 475; title: Entities and Attributes Listing for Insurance Models
pagenum: 476; label: Appendix E
title: Entities and Attributes for Financial Services Models
pagenum: 487; title: Entities and Attributes Listing for Financial Services Models
pagenum: 488; label: Appendix F
title: Entities and Attributes for Professional Services Models
pagenum: 497; title: Entities and Attributes Listing for Professional Services Models
pagenum: 498; label: Appendix G
title: Entities and Attributes for Travel Models
pagenum: 507; title: Entities and Attributes Listing for Travel Models
pagenum: 508; label: Appendix H
title: Entities and Attributes for E-Commerce Models
pagenum: 519; title: Entities and Attributes Listing for E-Commerce Models
pagenum: 520; label: Appendix I
title: List of Entities and Their Associated Figures
pagenum: 525; title: Other Reusable Data Model and Data Warehouse Design Resources
pagenum: 541; title: Reusable Data Model Resources
pagenum: 541; title: Reusable Data Warehouse Design Resources
pagenum: 542; title: How to Use the Volume 2 Industry Electronic Products
pagenum: 543; title: Contents of the Industry Electronic Products
pagenum: 544; title: Using the Scripts
pagenum: 545; title: How to Use the Industry Electronic Products in Conjunction with the Data Model Resource CD-ROM, Volume 1
pagenum: 545; title: Platform-Specific and Other Information on the Electronic Products
pagenum: 545; title: Index
pagenum: 547