Method to generate predicted variances of an operation based on data from one or more connected databases

A system comprising:

• a network interface communicating with a memory;
• the memory communicating with a processor for enabling revenue maximization;
• the processor, when executing a computer program, executes operations comprising:
• determining, by an optimizer module in communication with the processor, a capacity (CAP) from a central data repository of the one or more connected aircraft databases;
• determining, by the optimizer module in communication with the processor and using a flight cost prediction model in a prediction module and in real-time iteratively throughout a period of time, an optimal authorized passenger location level that minimizes an overbooking cost;
• predicting, by the processor using a cost engine, a spoiled value for each passenger location in a plurality of passenger locations associated with an operation comprising a flight;
• predicting, by the processor using the cost engine, a denied value for the operation based on a probability of a volunteer not taking the flight;
• determining, by the processor and based on data from the one or more connected aircraft databases, a passenger no-show prediction for each passenger for the operation, wherein the passenger no-show prediction is based upon whether the respective passenger flew on a previous leg of a passenger flight itinerary;
• storing, by the processor and in one or more connected databases, the spoiled value, the denied value, and the passenger no-show prediction;
• using, by the processor, a key field in pre-selected at least one of databases or data sectors to speed searches;
• conducting, by the processor, sequential searches through all tables and files to speed the searches;
• sorting, by the processor, records in a file according to a known order to simplify lookup;
• completing, by the processor, a database merge function by using the key field;
• tuning, by the processor, the one or more connected databases to optimize database performance, wherein the tuning comprises placing frequently used files on separate file systems to reduce in and out bottlenecks;
• and
• obtaining, by the computer-based system, the spoiled value, the denied value, and the passenger no-show prediction from the one or more connected databases;
• aggregating, by the processor, the passenger no-show prediction and an attendance prediction to create an overall flight prediction;
• determining, by the processor, an authorized passenger location for the operation that minimizes an overfilled value, wherein the overfilled value is based upon the optimal authorized passenger location level and an accumulation of each spoiled value, the denied value and the overall flight prediction;
• modeling, the processor using the cost engine, the denied value as an aggregate, for each passenger denied boarding, of a breakage adjusted voucher cost, an involuntary rate draft cost, a rolling denied boarding marginal cost and a secondary accommodations cost;
• and
• updating, by the processor and on a database and in real-time iteratively throughout the period of time, an authorization parameter to create an updated authorization parameter for the flight based upon the authorized passenger location to maximize revenue for the flight and minimize costs of overbooking.

A non-transitory computer-readable medium storing instructions that, when executed by processor, cause the processor to perform operations comprising:

• predicting, by the processor, a spoiled value comprising a spoiled seat (SS) cost for each passenger location in a plurality of passenger locations associated with an operation comprising a flight;
• predicting, by the processor, a denied value comprising a denied boarding (DB) cost for the operation based on a probability of a volunteer not taking the flight;
• determining, by the processor in real-time iteratively, a passenger no-show prediction for each passenger booked for the operation, wherein the passenger no-show prediction is based upon whether the respective passenger flew on a previous leg of a passenger flight itinerary;
• storing, by the processor and in one or more connected databases, the spoiled value, the denied value, and the passenger no-show prediction;
• using, by the processor, a key field in pre-selected at least one of databases or data sectors to speed searches;
• conducting, by the processor, sequential searches through all tables and files to speed the searches;
• sorting, by the processor, records in a file according to a known order to simplify lookup;
• completing, by the processor, a database merge function by using the key field;
• tuning, by the processor, the one or more connected databases to optimize database performance, wherein the tuning comprises placing frequently used files on separate file systems to reduce in and out bottlenecks;
• and
• obtaining, by the computer-based system, the spoiled value, the denied value, and the passenger no-show prediction from the one or more connected databases;
• aggregating, by the processor in real-time iteratively, the passenger no-show prediction and an unbooked passenger attendance prediction to create an overall flight prediction;
• and
• determining, by the processor, an authorized passenger location for the operation that minimizes an overfilled value, wherein the overfilled value is based upon an accumulation of each spoiled value, the denied value and the overall flight prediction.