Patent ID: 11954699
Assignee: AMERICAN AIRLINES, INC.
Field: IT methods for management (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A method, comprising:
remapping, by a processor using a prime class remapping module, a fare class to form a remapped bookings table;
storing, by the processor, the remapped bookings table in a database;
tuning, by the processor, the database having the remapped bookings table to optimize the database performance,
wherein the tuning includes placing frequently used files on separate file systems to reduce in and out bottlenecks;
designating, by the processor, a key field in a plurality of related data tables to speed searching in the remapped bookings table;
merging, by the processor, the plurality of related data tables based on the type of the remapped bookings table in the key field; and
sorting, by the processor, the remapped bookings table according to a known order to simplify a lookup process;
obtaining, by the processor, the remapped bookings table from the database;
combining, by the processor, the remapped bookings table with the expected demand information to provide input to a forecasting system, wherein the forecasting system uses an unobscuring module and an unconstraining module;
restricting, by the processor and based on the remapped bookings table, a number of upper-class seats from being booked; and
opening, by the processor and based on the remapped bookings table, additional lower-class seats for being booked.