Re-usable Patterns and UDM For Travel Course Outline

3 Day Course (Course can be customized to meet your organization’s needs.)

Session 1 - Jump Starting the Data Modeling Effort (Days 1 and 2)

DAY 1

  1. Introduction to Universal Data Models (UDM) (2 hours) for general audience
    • What are UDM?
    • What UDM are not
    • What are the benefits?
    • Examples of UDMs
    • Examples of how other organizations have used UDM
    • How to apply Universal Data Models
  2. The following sections include modeling techniques, pitfalls, “war stories” of incorrect modeling, and “best practice” techniques. Each section also includes a workshop in which you customize models for your organization.

  3. Patterns within Universal Data Models (2 hours)
    • Roles
    • Statuses
    • Categorizations
    • Hierarchies/recursions
    • Type versus instance
    • Rules
  4. Travel Related People and Organization Data Models (2 hours)
    • Parties in the travel industry
    • Organizations
    • People
    • Parties
    • Roles
    • Relationships between parties
    • Addresses and other contact management information
    • Travel preferences
    • Data modeling exercise – applying the models to your organization
  5. Product Data Models (start for ½ hour – see next section)

DAY 2

  1. Product Data Models (2 hours)
    • Travel products
    • Scheduled transportation offering
    • Fixed assets and accommodation map
    • Facilities
    • Inventory item storage
    • Product pricing
    • Data modeling exercise – applying the models to your organization
  2. Reservations (2 hours)
    • Reservation and reservation item
    • Reservation roles
    • Reservation status
    • Accommodation spots (type of accommodation)
    • Reservation dependencies
    • Data modeling exercise – applying the models to your organization
  3. Ticketing, invoicing, payments, travel experience (2 hours)
    • Tickets and coupons
    • Sales
    • Invoice
    • Payments
    • Travel experience
    • Data modeling exercise – applying the models to your organization
  4. Orders and Agreements (1 hour)
    • Order and order items
    • Agreements and/or contractual terms
    • Agreement pricing

Session 2 – Using Universal Data Models for Data Warehousing

DAY 3
  1. Progressing from the UDM to the Data Warehouse (3 hours)
    • Data warehouse architecture considerations
    • Transformation steps to converting the UDM to a data warehouse design
    • Workshop Exercise Enhancing an Existing Data Warehouse Design
  2. Using Universal Data Models for Developing Data Marts (2.5 hours)
    • Data mart method—a practical approach to designing data marts
    • Examples data mart designs using universal data models
    • Workshop exercise - Creating a data mart design using a universal data model
  3. Course conclusion (1 hour)
    • Possible objections to UDMs and responses
    • Universal principles in effectively integrated data