System and method for capturing, storing and analyzing revenue management information for the travel and transportation industries

A method for managing inventory, pricing and demand forecasting for an airline travel provider, comprising the steps of:

• establishing a relational database within a computer data storage device for storing and organizing information for an airline travel provider, said information being organized within said database in accordance with a logical data model comprising a plurality of entities and relationships defining the manner in which said information is stored and organized within said database, said logical data model including:
• a first subject area comprising a plurality of entities and relationships defining the manner in which revenue information for said airline travel provider is stored and organized within said relational database;
• a second subject area comprising a plurality of entities and relationships defining the manner in which product and service information for said airline travel provider is stored and organized within said relational database, said product and service information including flight information and flight segment information;
• and
• a third subject area comprising a plurality of entities and relationships defining the manner in which customer information for said airline travel provider is stored and organized within said relational database, said customer information including Passenger Name Record (PNR) data;
• populating said relational database with revenue, product and service, and customer information for said airline travel provider;
• analyzing, by an application server computer executing a revenue management application, Passenger Name Record (PNR), booking, ticketing, inventory, schedule, authorization adjustment and flown/ticket lift data contained within said database;
• and
• identifying, by an application server computer executing a revenue management application, fraudulent and improper booking and ticketing activity.