Flight Schedule Modification Loading Method
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current methods for loading flight scheduling changes into computerized air transport reservation systems are inefficient, often leading to unnecessary changes in passenger reservations and lengthy processing times due to manual analysis of changes' repercussions on existing schedules, lacking a comprehensive view of all changes and their impacts.
Innovation Solution
A method that updates the flight schedule database and reservation inventory database by simulating scheduling changes without final activation, allowing for bulk processing and reassignment of passenger reservations, using a graphical user interface for verification and validation, and employing future schedule records to manage dependencies and automate updates.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If flight scheduling changes are applied one after another sequentially, then the existing schedule database can be updated, but the reservations are changed more often than necessary and processing time increases
Solution Approach 1:
The system creates a future schedule database that stores all planned scheduling changes before they are applied to the existing schedule. This preliminary storage allows the system to analyze all changes together and determine the optimal application sequence, preventing unnecessary reservation changes and reducing processing time by avoiding sequential trial-and-error updates
2Reliability
If manual analysis is performed for each reservation change, then data integrity can be maintained, but the processing time becomes excessively long for large-scale changes
Solution Approach 1:
The system replaces manual analysis with an automated computerized method that processes scheduling changes and reservation reassignments algorithmically. The future schedule database and automated processing system maintain data integrity through systematic validation while dramatically increasing processing speed for large-scale seasonal changes involving thousands of flight records
Solution Approach 2:
The system creates a copy of the existing schedule database as a future schedule database to test and validate scheduling changes before applying them to the production system. This copying approach allows comprehensive analysis of all changes together without risking the integrity of the live reservation system
3Ease of manufacture
If scheduling changes are applied immediately without simulation, then the update process is simpler, but risks of database disturbance increase before complete validation
Solution Approach 1:
The system performs simulation of scheduling changes by storing them in the future schedule database and processing them in a test environment before applying to production. This preliminary simulation validates the correctness of changes and their impact on reservations without risking the stability of the live database
Solution Approach 2:
The future schedule database acts as an intermediary layer between the planned scheduling changes and the existing production database. It allows changes to be prepared, validated, and tested before being transferred to the production system, maintaining both simplicity and reliability
Data Source
AI summary
A method for loading flight schedule modifications in an air travel computerized reservation system, wherein: the flight schedule database is updated; the reservations concerned by the flight schedule modifications are reassigned to update the reservation inventory database. The method for loading flight schedule modifications includes the following steps: receiving at least one lot of modifications containing flight schedule modification data, retrieving individual modifications contained in the lot and storing in a register in the form of records for future scheduling, simulating reassignment of the reservations concerned by the flight schedule modification, by accessing with the reservation distribution server both the records and the flight schedule database, final updating of the flight schedule databases and of the reservation inventory. The method is useful for updating databases during flight schedule modifications in computerized reservation systems.