Wiley
Wiley.com

Complete Listing of Models Available

List of the available data model diagrams for Volumes 1 and 2 of the Data Model Resource Book

List of Models for the Data Model Resource Book: A Library of Universal Data Models for All Enterprises, Revised Edition, Volume 1

Parties

Figure 2.1 Organization

Figure 2.2 Person

Figure 2.2b Person alternate model

Figure 2.3 Party

Figure 2.4 Party roles

Figure 2.5 Specific party relationships

Figure 2.6 Common party relationships

Figure 2.7 Party relationship information

Figure 2.8 Postal address information

Figure 2.9 Party contact number

Figure 2.10 Party contact mechanism

Figure 2.11 Facility versus contact mechanism

Figure 2.12 Party communication event

Figure 2.13 Communication event follow up

Figure 2.14 Overall party model

Products

Figure 3.1 Product definition

Figure 3.2 Product category

Figure 3.3 Product identification

Figure 3.4 Products feature

Figure 3.5 Suppliers and manufacturers of products

Figure 3.6 Inventory item storage

Figure 3.7 Standard product pricing

Figure 3.8 Estimated product cost

Figure 3.9 Product to product associations

Figure 3.9a Product to product associations- alternate model

Figure 3.10 Product and parts

Figure 3.10a Product and parts alternate model

Figure 3.11 Overall product model

Orders

Figure 4.1 Standard Order Items

Figure 4.2 Orders and order items

Figure 4.3 Sales order parties and contact mechanisms

Figure 4.4 Purchase order parties and contact mechanisms

Figure 4.5 Generic order roles and contact mechanisms

Figure 4.6 Order adjustments and sales tax

Figure 4.7 Order status and items

Figure 4.8 Order item associations

Figure 4.9 Requirement

Figure 4.10 Request

Figure 4.11 Quotes

Figure 4.12 Agreements

Figure 4.13 Agreement item

Figure 4.14 Agreement terms

Figure 4.15 Agreement pricing

Figure 4.16 Agreement to orders

Figure 4.17 Overall order models

Shipments

Figure 5.1 Shipment definition

Figure 5.2 Shipping detail

Figure 5.3 Shipment to order

Figure 5.4 Shipment receipt for incoming shipment

Figure 5.5 Item issuance for outgoing shipments

Figure 5.6 Shipping documents

Figure 5.7 Shipment route segments

Figure 5.8 Overall shipment model

Work Efforts

Figure 6.1 Work requirement

Figure 6.2 Work requirement roles

Figure 6.3a Work effort generation

Figure 6.3b Work effort generation alternative model

Figure 6.4 Work effort associations

Figure 6.5 Work effort party assignment

Figure 6.6 Work effort time tracking

Figure 6.7 Work effort rates

Figure 6.8 Inventory assignment

Figure 6.9 Fixed asset assignment

Figure 6.10 Party fixed asset assignment

Figure 6.11 Work effort type metrics

Figure 6.12 Work effort results

Figure 6.13 Overall work effort model

Invoicing

Figure 7.1a Invoice and invoice items

Figure 7.1b Invoice and invoice items – alternate model

Figure 7.2 Invoice roles

Figure 7.3a Invoice billing account

Figure 7.3b Invoice specific roles

Figure 7.4 Invoice status and terms

Figure 7.5 Billing for shipment items

Figure 7.6 Billing of time entries and work efforts

Figure 7.7 Billing for order items

Figure 7.8a Invoice payment

Figure 7.8b Invoice payment – alternate model

Figure 7.9 Financial accounts

Figure 7.10 Overall invoice models

Accounting and Budgeting

Figure 8.1 Chart of accounts for internal organizations

Figure 8.2 Accounting transactions

Figure 8.3a Accounting transaction details

Figure 8.3b Accounting transaction details with account balances

Figure 8.4 General ledger account associations and subsidiary ledger accounts

Figure 8.5 Asset depreciation

Figure 8.6 Budget definition

Figure 8.7 Budget revision

Figure 8.8 Budget review

Figure 8.9 Budget scenario

Figure 8.10 Budget allocations

Figure 8.11 Budget relationship to general ledger

Figure 8.12 Overall accounting and budgeting model

Human Resources

Figure 9.1 Standard emp-dept model

Figure 9.2 Employment

Figure 9.3 Position definition

Figure 9.4 Position type definition

Figure 9.5 Position fulfillment

Figure 9.6 Position reporting

Figure 9.7 Salary determination and history

Figure 9.8 Benefits determination and tracking

Figure 9.9 Payroll information

Figure 9.10 Employee application

Figure 9.11 Employee skills and qualifications

Figure 9.12 Employee performance

Figure 9.13 Employment termination

Figure 9.14 Overall human resources model

Chapter 10 Creating the data warehouse from the data model

Figure 10.1 Data warehouse architecture

Figure 10.2 the components of a data model

Figure 10.3 Subject data areas

Figure 10.4 Subject data areas as mid level models

Figure 10.5 Data Warehousing one subject data at a time

Figure 10.6 Removing operational data

Figure 10.7 Adding an element of time for the warehouse

Figure 10.8 Adding derived data to the data warehouse

Figure 10.9 Relationship artifacts in the warehouse

Figure 10.10 Artifacts of the operational data relationship

Figure 10.11 Discrete historical data

Figure 10.12 Accommodating different levels of stability

Figure 10.13 Merging data

Figure 10.14 Creating arrays of data

Figure 10.15 Arranging data according to stability

Chapter 11 Data warehouse designs

Figure 11.1 A Sample sales analysis data warehouse

Figure 11.2 A Sample data warehouse design

Chapter 12 Sales analysis data mart designs

Figure 12.1 Sales analysis star schema

Figure 12.2 Transaction sales star schema

Figure 12.3 Sales representative performatives star schema

Figure 12.4 Product analysis star schema

Chapter 13 Human resources analysis data mart designs

Figure 13.1 Human resources analysis star schema

Figure 13.2 Human resources analysis star schema – alternate model

Chapter 14 Additional data mart designs

Figure 14.1 Inventory management star schema

Figure 14.2 Purchase order star schema

Figure 14.3 Shipments/logistics star schema

Figure 14.4 Work effort management star schema

Figure 14.5 Financial analysis star schema

Chapter 15 Implementing Universal Data Models in the Real World – the following models include physical implementation models

Figure 15.1 Party contact mechanism

Figure 15.2 Customized arty contact mechanism

Figure 15.3 Additions to the party contact mechanism model

Figure 15.4 Detailed model for the sales force

Figure 15.5 Specific party relationships

Figure 15.6 Party roles separate tables for sub-types 1

Figure 15.7 Party roles separate tables for sub-types 2

Figure 15.8 Party role physical design option 3 generic design

List of Models for the Data Model Resource Book: A Library of Universal Data Models for Industry Types, Revised Edition, Volume 2

Chapter 2 Manufacturing

Figure 2.1 Manufacturing party roles and relationships

Figure 2.2 Parts and products

Figure 2.3 Part specifications and documentation

Figure 2.4 Part specifications roles and status

Figure 2.5 Engineering changes

Figure 2.6 Bill of materials

Figure 2.7 Part Substitutions

Figure 2.8 Inventory item configurations

Figure 2.9 Manufacturing orders

Figure 2.10 Product deployment and usage

Figure 2.11 Process plan

Figure 2.12 Production runs

Figure 2.13 Product run star schema

Figure 2.14 Overall manufacturing model

Chapter 3 Telecommunications

Figure 3.1 Telecommunications party roles and responsibilities

Figure 3.2 Telecommunications products and features

Figure 3.3 Product deployment

Figure 3.4 Telecommunications product associations

Figure 3.5 Network components

Figure 3.6 Network assembly

Figure 3.7 Products, circuits, and network assemblies

Figure 3.8 Products, circuits, and network assemblies capabilities

Figure 3.9 Communication IDs and contact mechanisms

Figure 3.10 Service orders

Figure 3.11 Product deployment usage

Figure 3.12 Telecommunications billing

Figure 3.13 Deployment usage data mart design

Figure 3.14 Overall telecommunications design

Chapter 4 Health Care

Figure 4.1 Health care roles and relationships

Figure 4.2 Health care facilities and contact mechanisms

Figure 4.3 Patient and provider information

Figure 4.4 Health care offerings

Figure 4.5 Health care agreements

Figure 4.6 Health care incident, episode, and visit

Figure 4.7 Health care delivery

Figure 4.8a Invoices versus claims

Figure 4.8b Health care claims

Figure 4.9 Claims submission

Figure 4.10 Payment settlement

Figure 4.11 Health care referrals

Figure 4.12 Star schema for health care

Figure 4.13 Overall health care model

Chapter 5 Insurance

Figure 5.1 Insurance party roles and relationships

Figure 5.2 Insurance products and categories

Figure 5.3 Insurance coverage

Figure 5.4 Insurance product features

Figure 5.5 Insurance product rules

Figure 5.6 Insurance underwriting

Figure 5.7 Insurance rate tables

Figure 5.8 Insurance application

Figure 5.9 Insurance quotes

Figure 5.10 Insurance policy roles

Figure 5.11 Insurance policies

Figure 5.12 Health care policy

Figure 5.13 Premium schedule

Figure 5.14 Insurance claim incidents

Figure 5.15 Insurance claim submissions

Figure 5.16 Insurance payment settlement

Figure 5.17 Claims Star Schema

Figure 5.18 Overall insurance models

Chapter 6 Financial Services (banking and investing)

Figure 6.1 Financial services party roles and relationships

Figure 6.2 Financial objectives, needs and plans

Figure 6.3 Financial services product definition

Figure 6.4 Financial product regulations and rules

Figure 6.5 Financial agreement

Figure 6.6 Financial account

Figure 6.7 Financial account transaction

Figure 6.8 Account notification

Figure 6.9 Analysis task

Figure 6.10 Financial account star schema

Figure 6.11 Account transaction star schema

Figure 6.12 Overall financial services model

Chapter 7 Professional Services

Figure 7.1 Professional services roles and relationships

Figure 7.2 Professional service products

Figure 7.3 Product components

Figure 7.4 Professional service requirements

Figure 7.5 Professional service RFP, RFQ and RFI

Figure 7.6 Professional service quotes

Figure 7.7 Professional service engagements

Figure 7.8 Professional service agreements to engagements

Figure 7.9 Professional service entries

Figure 7.10 Engagements and work efforts

Figure 7.11 Professional service invoicing

Figure 7.12 Professional service time entry star schema

Figure 7.13 Overall professional services model

Chapter 8 Travel

Figure 8.1 Travel party roles and relationships

Figure 8.2 Travel preferences

Figure 8.3 Travel product

Figure 8.4 Travel reservations

Figure 8.5 Ticketing

Figure 8.6 Travel agreements

Figure 8.7 Pricing of agreements and products

Figure 8.8 Travel experience

Figure 8.9 Travel programs and travel accounts

Figure 8.10 Passenger transportation offering star schema

Figure 8.11 Non-transportation travel product star schema

Figure 8.12 Overall travel model

Chapter 9 Retail e-Commerce (World Wide Web models)

Figure 9.1 Party roles and relationships in e- commerce

Figure 9.2 Party contact mechanisms for e-commerce

Figure 9.3 Web site content and user login

Figure 9.4 E-commerce products and objects

Figure 9.5 Party and product needs

Figure 9.6 Web subscriptions

Figure 9.7 Web visits

Figure 9.8 Web Hits Star Schema

Figure 9.9 Web Visits Star Schema

Return to the Companion Site home page