US 12,361,438 B2
Adjusting seat booking availability
Jonathan Tracy, Tempe, AZ (US); James Fox, Tempe, AZ (US); Julianne Bowles, Tempe, AZ (US); Michael Costello, Tempe, AZ (US); Daniel Muzich, Phoenix, AZ (US); and Thomas Trenga, Mesa, AZ (US)
Assigned to AMERICAN AIRLINES, INC., Fort Worth, TX (US)
Filed by American Airlines, Inc., Fort Worth, TX (US)
Filed on Mar. 12, 2024, as Appl. No. 18/602,233.
Application 18/602,233 is a continuation of application No. 17/708,445, filed on Mar. 30, 2022, granted, now 11,954,699.
Application 17/708,445 is a continuation of application No. 13/791,711, filed on Mar. 8, 2013, granted, now 11,321,721, issued on May 3, 2022.
Prior Publication US 2024/0265414 A1, Aug. 8, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06Q 10/00 (2023.01); G06Q 30/0202 (2023.01)
CPC G06Q 30/0202 (2013.01) 19 Claims
OG exemplary drawing
 
1. A method, comprising:
remapping, by one or more processors, a fare class to form a remapped bookings table;
storing, by the one or more processors, the remapped bookings table in a database;
tuning, by the one or more processors, the database having the remapped bookings table to optimize performance of the database,
wherein the tuning includes placing frequently used files containing the remapped bookings table on separate file systems to reduce in and out bottlenecks;
designating, by the one or more processors, a key field in a plurality of related data tables to speed searching in the remapped bookings table;
merging, by the one or more processors, the plurality of related data tables based on a type of the remapped bookings table in the key field;
sorting, by the one or more processors, the remapped bookings table according to a known order to simplify a lookup process;
obtaining, by the one or more processors, the remapped bookings table from the database;
combining, by the one or more processors, the remapped bookings table with expected demand information to provide input to a forecasting system;
restricting, by the one or more processors and based on the remapped bookings table, a number of upper-class seats from being booked; and
opening, by the one or more processors and based on the remapped bookings table, additional lower-class seats for being booked.