Teradata Travel and Hospitality Industry Data Model

Where to?

Industry logical data models serve as maps to an organization's information.  Whether you're traveling or designing a data warehouse, maps and models can help you navigate the environment and home in on the details that could influence or affect your journey.

Learn More

Teradata Travel and Hospitality Industry Data Model (THDM) leverages our vast experience with leaders in the travel industry to help you answer critical business questions from every area of your business — customers, channels, products, operations, finance and employees — providing a solid basis for an enterprise-wide view of the business data throughout the complex shopping, purchase, service and travel cycle.

Combined with the Teradata Travel and Hospitality Data Integration Roadmap, we’ll tailor this powerful data model to address your specific requirements. Because of the Travel data model's flexible, modular design, developing new strategic applications and reacting to fresh business opportunities is far easier and less costly.

Features & Benefits

Teradata Travel and Hospitality Data Model can help you determine answers in these vital areas and more:

  • What demographics, channels and characteristics differentiate profitable from unprofitable customers 
  • Understand how customers respond to various promotional offers 
  • Determine the amount of revenue on outstanding accounts receivable invoices 
  • Assess the profitability of your business by geography, business unit and product line 
  • Reduce delays and cancellations due to maintenance 
  • Track maintenance measurements, measurement events, actual tests and readings taken along with the actual values and test conditions.
  • Compare your actual results to budget 
  • Comprehensive analysis of purchase activity, channel preference, travel patterns and scope of influence 
  • Improve program performance through early warning indicators and the ability to analyze what-if scenarios 
  • Increase asset readiness and effectiveness by providing visibility to maintenance and supply issues and pinpointing root causes 
  • Increase awareness of key events and alerts that are critical to decision making process
  • Determine actions front-line representatives should take based on customer’s history, preferences, and operational developments 
  • Find the ratio of outstanding accounts receivable invoices to outstanding customer orders 

Primary Components

  • Provides the new Physical Data Model (PDM) diagrams for each Subject Area utilizing Teradata standards for physical data model display and structure. 
    • Upgraded to include the new Teradata Physical Data Model Standards
    • Model Subject Areas contain both Logical and Physical Data Model Diagrams
    • Best Practice Physical Primary Indexes included
    • New Tool Driven Option Sets in Erwin specifically for Teradata
    • New Physical Data Model (PDM) Reference Guide comes with the model
    • Examples of physical modeling patterns diagrams and techniques already in ERwin
  • Supports many industry areas, including: 
    • Financial Management – Integration that reduces the effort to deliver real-time, detailed financial performance information
    • Maintenance, Repair, Overhaul (MRO) – Helps support purchasing and contracting, inventory levels and allocations, component maintenance scheduling/prioritization, reliability management, line and engine maintenance, and aircraft overhaul.
    • Air Cargo – Supports airway bill tracking, maximum lift capacity and cargo revenues, better Universal Load Device (ULD) utilization and customs processing.
    • Hotel and Gaming – Expanded support covers retail sales, gaming and asset tracking for casinos, as well as player activity monitoring; calendar event management; special hospitality activity reservations and tracking for golf, dining and special events; group event activity tracking; and hotel support for property layout, room rates, reservations, and asset and revenue tracking.
    • Human Resources – Expanded to track the job posting and application process, individual applicant resumes, interviews and applicant status, labor grievance process and inolved parties, grievance status and resolution.
  • Graphically diagrams the relationship of data extracted from disparate data sources to provide an enterprise-wide view of your business
  • Data stored in third normal form only once in the warehouse

How can we help?

Contact us for insight and answers to your questions.

Contact Teradata

Related Resources