Flight time unified coding and full life cycle tracking management method

Abstract

The invention discloses a flight time unified coding and full life cycle tracking management method. The method comprises the following steps: establishing a time unified coding format; judging whether a margin can be allocated at the moment applied by the aviation carrier or not; establishing a time tracking data storage library; judging an application type selected by the aviation carrier before submitting the moment application information; processing the time adding application submitted by the aviation carrier; processing a moment adjustment application submitted by the aviation carrier; processing the moment replacement application submitted by the aviation carrier; processing the moment cancel application submitted by the aviation carrier; and constructing a time full life cycle tracking data model. According to the invention, through constructing a double unified coding system of time library coding and time pool coding, establishing a time integrated data storage system, and designing a time full life cycle tracking management process, accurate identification and full-process tracing of flight time are realized, the refinement level of flight time management is effectively improved, and the time management efficiency is improved. And reasonable utilization and ordered circulation of time resources are ensured.

Description

TECHNICAL FIELD

[0001] The application belongs to the technical field of aviation operation management, and particularly relates to a flight time unified coding and full life cycle tracking management method. BACKGROUND

[0002] As a key resource of civil aviation transportation, the reasonable allocation and effective management of flight time is of great importance to the improvement of aviation transportation efficiency and the healthy development of civil aviation industry. Under the background of the rapid development of the current civil aviation industry, the flight time resource is increasingly tight, and the complexity of time management is increasing.

[0003] In the existing flight time management system, there is a lack of unified coding identification system, which makes the resource association of time library and time pool unclear. Different systems and departments have different identification methods for flight time, which not only brings great difficulty to the statistics and analysis of time resources, but also hinders the information communication in the process of time allocation, reducing the collaborative efficiency of time management.

[0004] At the level of air carriers (referred to as airlines), time adding, adjusting, replacing, canceling and other business frequently occur. In these business flow scenarios, due to the lack of effective tracking means, the flow direction of time resources cannot be recorded and traced throughout the process. Air carriers often consider maximizing their own interests in the process of time acquisition, which may lead to repeated occupation or abuse of time resources. Once there is a time transfer record fault, it is difficult to determine the status of the time at each link and the responsible person, which affects the efficiency and accuracy of time management and disrupts the overall order of civil aviation transportation.

[0005] In order to cope with the above challenges, to solve the problems of inaccurate identification, difficult control of resource allocation, and incomplete full-process tracking in the existing flight time management, it is necessary to build a standardized coding rule and supporting tracking method to realize the accurate identification and full-process tracking of flight time, improve the fine level of flight time management, and ensure the reasonable use and orderly flow of time resources. SUMMARY

[0006] In view of the above shortcomings of the prior art, the purpose of the present application is to provide a flight time unified coding and full life cycle tracking management method to realize the standardized identification of time resources and the traceable management of the full life cycle of time, and to improve the standardization and efficiency of flight time management; to solve the problems of inaccurate identification, difficult control of resource allocation, and incomplete full-process tracking in the existing flight time management.

[0007] To achieve the above purpose, the technical scheme adopted by the present application is as follows:

[0008] The flight time unified coding and full life cycle tracking management method of the present application comprises the following steps:

[0009] 1) Establish a unified encoding format for time, including time library encoding and time pool encoding;

[0010] 2) In combination with the core constraint of limited pit number in the time pool, the total amount of resources is explicitly limited through the flight time coordination parameter table, and the used state of time resources is tracked through the time pool time allocation table, so as to determine whether the time applied by the air carrier has a surplus that can be allocated, forming a closed-loop management of total amount control-dynamic tracking-allocation judgment;

[0011] 3) Establish a data storage library for time tracking, including: time usage record table, time pool time allocation table and historical time usage record table, which are associated through time library encoding, forming a complete data link of real-time dynamic record + historical permanent archive;

[0012] 4) Determine the application type selected by the air carrier before submitting the time application information, if the application type is new, execute step 5); if the application type is adjustment, execute step 6); if the application type is replacement, execute step 7); if the application type is cancellation, execute step 8);

[0013] 5) Process the time application submitted by the air carrier, check the time pool surplus, if there is no surplus, terminate and prompt; otherwise, according to the airport, flight time, take-off and landing attributes and the class attributes of the application, match the time pool time allocation table, determine the time pool encoding SKCBM; then generate the time library encoding, store the application information and the time library encoding in the time usage record table, and store the time pool encoding and the time library encoding in the time pool time allocation table;

[0014] 6) Process the time adjustment application submitted by the air carrier, check the time pool surplus of the new time after adjustment, if there is no surplus, terminate and prompt; otherwise, match the airport, flight time, take-off and landing attributes and the class attributes of the new time, calculate and allocate the new time pool encoding SKCBM; according to the rules, store the data before adjustment to the historical time usage record table; update the time usage record table to the data after adjustment with the time library encoding as the key information, and synchronize the time pool encoding in the time pool time allocation table;

[0015] 7) Process the time replacement application submitted by the air carrier, store the original data of the two records to be replaced in the historical time usage record table respectively; interchange the core data of the two records in the time usage record table with the time library encoding as the key information, change the application type to replacement, and keep the original application filing time; synchronize the time pool encoding of the two records in the time pool time allocation table;

[0016] 8) processing the time cancellation application submitted by the air carrier, transferring the to-be-cancelled record from the time use record table to the historical time use record table; then taking the time bank code as the key information, changing the application type of the corresponding record in the time use record table to cancellation, and setting the time bank code in the matching record in the time pool time allocation table to null;

[0017] 9) constructing a time full life cycle tracking data model to realize the tracking management of the full life cycle of the flight time.

[0018] Further, the time bank code in step 1) adopts the structure of mark + time bank serial number, which realizes the accurate identification of the time record in the time bank; the time pool code adopts the structure of pit mark + time pool serial number, which is used to adapt to the management constraint of the limited number of pit positions in the time pool and realize the accurate identification of the unallocated time record in the time pool;

[0019] 11) the time bank code consists of 22 characters, which is coded in the structure of mark + time bank serial number; in the structure of mark + time bank serial number, the mark is used as the unique identity anchor point, and 19-bit feature code is used to record the core attributes of the initial allocation of the time; the time bank serial number adopts 3 Arabic numerals, which is used to distinguish the time with the same attributes; the combination of the mark + time bank serial number realizes the accurate identification of the time record in the time bank;

[0020] 12) the time pool code consists of 13 characters, which is coded in the structure of pit mark + time pool serial number; in the structure of pit mark + time pool serial number, the pit mark is used as the unique identity anchor point, and 10-bit feature code is used to accurately lock and record the specific core attributes of the specific flight time in the time pool based on the core setting condition that the number of pit positions in the time pool is limited, so as to ensure that each time corresponds to one of the limited physical pit positions in the time pool; the time pool serial number adopts 3 Arabic numerals, which is used to distinguish the multiple pit position records corresponding to the same time; the combination of the pit mark + time pool serial number realizes the management constraint adaptation of the limited number of pit positions in the time pool and the accurate identification of the unallocated time record in the time pool.

[0021] Further, the step 2) specifically includes:

[0022] 21) establishing a flight time coordination parameter table, and the specific data item information of the table includes: season, airport, flight period, coordination parameter time range, total amount of flight times that can be provided within 60 minutes, total amount of take-off flight times that can be provided within 60 minutes, total amount of landing flight times that can be provided within 60 minutes, total amount of flight times that can be provided within 15 minutes, total amount of take-off flight times that can be provided within 15 minutes, and total amount of landing flight times that can be provided within 15 minutes;

[0023] 22) Establish the time pool time allocation table, its specific data item information includes: time pool code and time library code; With time pool code core identification, real-time record each time pool code allocation state; Through the time library code is empty, to represent the resource has been used / unused situation;

[0024] 23) According to the logic of first total amount, then used, finally judge, judge whether the time of the air carrier application has the amount of distribution.

[0025] Further, the step 23) specifically includes:

[0026] 231) According to the application information, locate the total amount of resources in the flight coordination parameter table; Clear the application season, application airport, application class, application time and take-off and landing attribute when the air carrier submits the time application, according to the clear information in the flight time coordination parameter table to match the corresponding resource amount, including: 60 minutes can provide the total amount of flight time , 60 minutes can provide the total amount of flight time of take-off flight , 60 minutes can provide the total amount of flight time of landing flight , 15 minutes can provide the total amount of flight time , 15 minutes can provide the total amount of flight time of take-off flight And 15 minutes can provide the total amount of flight time of landing flight ;

[0027] 232) Based on the time pool time allocation table, the number of used resources is counted; According to the application season, application airport, application class, application time and take-off and landing attribute submitted by the carrier in step 231), all time pool codes with corresponding conditions are screened out in the time pool time allocation table, and the number of allocated is counted, including: the number of time allocated in 1 hour of application time , the number of take-off flight time allocated in 1 hour of application time , the number of landing flight time allocated in 1 hour of application time , the number of time allocated in 15 minutes of application time , the number of take-off flight time allocated in 15 minutes of application time And the number of landing flight time allocated in 15 minutes of application time ;

[0028] 233) Calculate the remaining amount of distribution and judge the feasibility of the application time; Through the calculation method of resource total amount minus used resource amount, establish the calculation model to judge whether the time submitted by the air carrier can be distributed, including: take-off time calculation model and landing time calculation model, as follows:

[0029] The calculation model at takeoff is:

[0030] ;

[0031] The calculation model at landing is:

[0032] ;

[0033] When the above calculation model is established, the time submitted by the air carrier can be allocated; otherwise, there is no surplus in the time pool that can be allocated to the air carrier.

[0034] Further, the step 3) specifically comprises:

[0035] 31) establishing a time use record table for recording the current time use behavior in real time, and the specific data item information includes: time bank code, season, air carrier, flight number, airport, schedule attribute, flight time, takeoff and landing attribute, passenger and cargo attribute, application filing time, and application type;

[0036] 32) establishing a historical time use record table for storing the time use records that have ended or been canceled, forming a historical database of time use, and the specific data item information includes: time bank code, season, air carrier, flight number, airport, schedule attribute, flight time, takeoff and landing attribute, passenger and cargo attribute, application filing time, application type, archiving time, and time pool code;

[0037] 33) when the data in the time use record changes, the change tracing and historical archiving rule of the time use record is realized: the data in the time use record before the change is stored into the historical time use record table, the archive information before the change is completely retained, and the association tracing of the change record and the original time allocation information is realized through the three key data items of time bank code, archiving time, and time pool code in the historical time use record table; most of the data items in the historical time use record table are directly derived from the time use record table, and specifically include: time bank code, season, air carrier, flight number, airport, schedule attribute, flight time, takeoff and landing attribute, passenger and cargo attribute, application filing time, and application type; the values of the remaining two data items in the historical time use record table are: one is the archiving time, which refers to the operation time when the current record is synchronized from the time use record table to the historical time use record table and the change is completed; the other is the time pool code, which is derived from the associated time pool time allocation table, and specifically associated with the time use record table and the time pool time allocation table through the time bank code.

[0038] Further, the step 5) specifically comprises:

[0039] 51) According to the season, airline, flight number, airport, schedule attribute, flight time, take-off and landing attribute and passenger and cargo attribute information entered by the airline, it is judged whether there is a margin in the time pool to meet the time demand submitted by the airline according to the calculation model defined in step 23). If there is a margin that can be allocated, step 52) is executed; otherwise, it is prompted that the new time applied by the airline has no margin available in the time pool, and the process ends.

[0040] 52) According to the airport, flight time, take-off and landing attribute and schedule attribute data in the airline time application information, the time pool code of the current application record is calculated by matching the time pool code in the time pool time allocation table, and the value of the time pool code is allocated to the time pool code SKCBM. The specific steps are as follows:

[0041] 521) Extract the core data items in the airline time new application record, including: airport, flight time, take-off and landing attribute and schedule attribute, and match the corresponding time allocation record of the time pool in the time pool time allocation table according to the four data items. If no record is matched, generate the time pool code of the airline time new application record according to the time pool code definition rule in step 12), the time pool code is generated, the time pool sequence number contained in the time pool code is 001, and the time pool code is allocated to the time pool code SKCBM. If there is a record matched, go to step 522);

[0042] 522) Select the record with empty time pool code from the matching result; if there is a record, sort the selected records in ascending order according to the time pool sequence number of the time pool code, select the record with the smallest time pool sequence number, and allocate the time pool code of the record to the time pool code SKCBM. The time pool code is not newly generated; if there is no record, select the record with the largest time pool sequence number from the matching result, add 1 to the time pool sequence number contained in the time pool code of the record, and allocate it to the time pool code SKCBM. The time pool code is newly generated;

[0043] 53) According to the new time application information submitted by the airline, generate the time pool code according to the time pool code definition rule in step 11); save the time pool code, season, airline, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute and application type information to the corresponding data items in the time use record table, and store the remaining application filing time data item in the time use record table into the current system time SYSDATE;

[0044] 54) Determine the source of the time pool code in step 52), save the time pool code SKCBM obtained in step 52) and the time pool code obtained in step 53) to the time pool time allocation table, and the specific operation is as follows:

[0045] If the source of the time pool code is newly generated, a data record is added in the time pool time allocation table, the value of the time pool code data item in the data record is the time pool code SKCBM obtained in step 52, and the value of the time library code data item is the time library code obtained in step 53; if the source of the time pool code is not newly generated, the data record corresponding to the time pool code in the time pool time allocation table is modified, and the value of the time library code data item in the data record is updated to the time library code obtained in step 53.

[0046] Further, the step 6) specifically comprises:

[0047] 61) According to the adjusted seasonal, airline, flight number, airport, flight period attribute, flight time, take-off and landing attribute and passenger and cargo attribute information submitted by the airline, it is judged whether there is a margin in the time pool to meet the new time demand submitted by the airline after adjustment according to the calculation model defined in step 23, if there is a margin that can be allocated, then step 62) is entered; otherwise, it is prompted that there is no margin that can be provided for the airline, and the process is ended.

[0048] 62) According to the airport, flight time, take-off and landing attribute and flight period attribute data in the data record adjusted by the airline time adjustment application, the time pool code of the time pool time allocation table is matched, the time pool code of the adjusted new time is calculated, and the value of the time pool code SKCBM is allocated to the time pool code.

[0049] 63) According to the rules defined in step 33), the record before adjustment in the adjustment time application information is associated with the corresponding record in the time library code and time use record table; after the association is completed, the data of the associated record in the time use record table is stored in the historical time use record table;

[0050] 64) Taking the time library code as the key matching information, the data values of the adjusted seasonal, airline, flight number, airport, flight period attribute, flight time, take-off and landing attribute and passenger and cargo attribute in the application information are updated to the same data items of the corresponding matching record in the time use record table; the original value of the application filing time data item in the time use record table is retained, and the value of the time use record table application type data item is updated to adjustment.

[0051] 65) Taking the time library code as the key matching information, the time pool code SKCBM is updated to the time pool code data item of the matching record in the time pool time allocation table.

[0052] Further, the step 7) specifically comprises:

[0053] 71) The data of two records to be replaced submitted by the air carrier in the time use record table is transferred into the historical time use record table according to the rules in step 33);

[0054] 72) The data of season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute and passenger and cargo attribute before the replacement of the second time base code is updated to the corresponding data items of the matching record in the time use record table with the first time base code as the key matching information; the value of the remaining application filing time data item of the matching record in the time use record table is unchanged, and the value of the application type data item is updated to replacement; the data of season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute and passenger and cargo attribute before the replacement of the first time base code is updated to the corresponding data items of the matching record in the time use record table with the second time base code as the key matching information; the value of the remaining application filing time data item of the matching record in the time use record table is unchanged, and the value of the application type data item is updated to replacement;

[0055] 73) The values of the time pool code data items corresponding to the two time replacement records in the time pool time allocation table are exchanged and saved with the time base code as the key matching information.

[0056] Further, the step 8) specifically comprises:

[0057] 81) The data of the record to be cancelled submitted by the air carrier in the time use record table is transferred into the historical time use record table according to the rules in step 33);

[0058] 82) The value of the application type data item of the matching record in the time use record table is updated to cancellation, and the other data items are unchanged with the time base code as the key matching information;

[0059] 83) The value of the time pool code data item of the matching record in the time pool time allocation table is updated to empty with the time base code as the key matching information.

[0060] Further, the step 9) specifically comprises:

[0061] 91) Determine the unique index;

[0062] Set the time base code SKBM as the unique index of the time full life cycle tracking, which is used to associate various data entities and ensure the uniqueness of the data link;

[0063] 92) Explicitly associate the data table;

[0064] Determine the core data table participating in the association, including: the historical time use record table, the time use record table and the time pool time allocation table, which together form a complete data link from historical archive data to current real-time use and resource allocation matching;

[0065] 93) Build historical moment usage record sub-model;

[0066] Take the moment pool code SKBM as the index and sort it in ascending order of filing time. Integrate all original information corresponding to the moment into the historical moment usage record sub-model [SKBM], and the complete model is: Historical moment usage record sub-model [SKBM] = historical moment usage record sub-model {[SKBM] season, air carrier, flight number, airport, schedule attribute, flight moment, take-off and landing attribute, passenger and cargo attribute, application filing time, application type, filing time, moment pool code}; Wherein, [SKBM] is the index item of the historical moment usage record sub-model, and the fields of season, air carrier, flight number, airport, schedule attribute, flight moment, take-off and landing attribute, passenger and cargo attribute, application filing time, application type, filing time and moment pool code correspond to the original record information in the historical moment usage record table respectively;

[0067] 94) Build the moment record sub-model in use;

[0068] Take the moment pool code SKBM as the unique primary key, and integrate the real-time usage information set by associating the moment usage record table and the moment pool moment allocation table, that is, the moment record sub-model in use [SKBM], and the specific association method is:

[0069] Extract the season, air carrier, flight number, airport, schedule attribute, flight moment, take-off and landing attribute, passenger and cargo attribute, application filing time, and application type field information corresponding to [SKBM] from the moment usage record table;

[0070] Extract the moment pool code field information corresponding to [SKBM] from the moment pool moment allocation table;

[0071] The value of the filing time field is empty;

[0072] The complete model of the moment record sub-model in use is:

[0073] The moment record sub-model in use [SKBM] = the moment record sub-model in use {[SKBM] season, air carrier, flight number, airport, schedule attribute, flight moment, take-off and landing attribute, passenger and cargo attribute, application filing time, application type, filing time, moment pool code} = {moment usage record table [(SKBM) season, air carrier, flight number, airport, schedule attribute, flight moment, take-off and landing attribute, passenger and cargo attribute, application filing time, application type], empty, moment pool moment allocation table [(SKBM) moment pool code]};

[0074] 95) Integrate the full life cycle tracking data model;

[0075] The history time using record sub-model [SKBM] generated in step 93) is aggregated with the time record sub-model [SKBM] being used generated in step 94) to form a complete full life cycle tracking data model, and the expression is: full life cycle tracking data model {[SKBM] season, air carrier, flight number, airport, class attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time, application type, filing time, time pool code} = history time using record sub-model [SKBM] + time record sub-model [SKBM] being used; wherein [SKBM] is an index item of the full life cycle tracking data model, and through the index, a complete data link from historical archived data to current real-time use and resource allocation matching can be connected in series.

[0076] Advantages of the present application:

[0077] 1. The present application realizes the coding tracking of each flight time by establishing a unified time coding, forms a traceable and digitized management mode of flight time resource use, and enables the air carrier and the management party to quickly obtain complete information required for time management without manually splicing data across systems and tables, thereby providing data support for time allocation optimization, resource scheduling adjustment and other decisions.

[0078] 2. The present application accurately identifies a single time record through time library coding (birthmark + time library serial number), and time pool coding (birthmark + time pool serial number) adapts to time pool pit constraint and identifies unallocated resources, so that the double coding system avoids identification confusion caused by repeated flight numbers and similar times, and ensures that each time record can be traced back through a unique code from generation to filing, thereby improving data association accuracy.

[0079] 3. The present application combines the flight time coordination parameter table to determine the upper limit of the total amount of resources, and the time pool time allocation table dynamically tracks the used state, and the linkage of the two can accurately judge the allocation feasibility of the air carrier's application time, which not only avoids idle or excessive allocation of time pool resources, but also meets the management constraints of limited pit quantity, forms a closed loop of total amount control-dynamic tracking-allocation judgment, and improves resource utilization efficiency.

[0080] 4. The present application uses time library coding as a unique index to connect the whole process data of time addition, adjustment, replacement and cancellation. Among them, the original information before the historical table filing change, the real-time table records the current state, and the resource table matches the allocation situation; combined with the full life cycle tracking formula, each stage and each change of the time from application to filing can be checked and verified. BRIEF DESCRIPTION OF DRAWINGS

[0081] Figure 1 The present application is a schematic diagram of the method. DETAILED DESCRIPTION

[0082] For the convenience of those skilled in the art to understand, the present application is further illustrated below in conjunction with the embodiments and the accompanying drawings, and the content mentioned in the embodiments is not a limitation on the present application.

[0083] Flight time (hereinafter referred to as time) refers to the right of an aircraft to use relevant infrastructure and services for arriving at or leaving a certain airport on a specified date and time; the time of the flight time is based on the wheel block time and the wheel block removal time. According to the regulations of the Civil Aviation Bureau, the flight time applied by the air carrier must be 5 minutes apart, for example: the flight time applied within 9 to 10 o'clock can only be 12 time points, which are 9:00, 9:05, 9:10, 9:15, 9:20, 9:25, 9:30, 9:35, 9:40, 9:45, 9:50, 9:55.

[0084] Flight time pool (hereinafter referred to as time pool) refers to the set of all available flight times, including new flight times, unconfigured flight times, and returned, recalled, and canceled flight times.

[0085] Flight time library (hereinafter referred to as time library) refers to the set of flight times already configured to the air carrier.

[0086] Flight time coordination parameters (hereinafter referred to as coordination parameters) refer to the number of flight times that can be provided within a specific 1 hour or 15 minutes at the airport. For example, when the time granularity is 1 hour, the start time and end time of the number of flight times that can be provided within a specific 1 hour in 1 day are 0000 and 0055, 0100 and 0155, 0200 and 0255, 0300 and 0355, …, 2300 and 2355; when the time granularity is 15 minutes, the start time and end time of the number of flight times that can be provided within a specific 15 minutes in 1 hour are 0000 and 0010, 0015 and 0025, 0030 and 0040, 0045 and 0055.

[0087] Referring to Figure 1 The flight time unified coding and full life cycle tracking management method of the present application has the following steps:

[0088] 1) Establish a unified time coding format, including time library coding and time pool coding;

[0089] Among them, the time library coding adopts the structure mode of mark + time library serial number, which realizes the accurate identification of time records in the time library; the time pool coding adopts the structure mode of mark + time pool serial number, which is used to adapt to the management constraints of the limited number of pit positions in the time pool, and realizes the accurate identification of unallocated time records in the time pool;

[0090] 11) The time library code consists of 22 characters, encoded in the form of a tattoo + time library serial number. In the tattoo + time library serial number structure, the tattoo serves as a unique identity anchor, and the 19-bit feature code records the core attributes of the initial allocation of the time. The time library serial number uses 3 Arabic numerals (001-999) to distinguish time with the same attributes. The combination of the tattoo + time library serial number realizes the accurate identification of the time record in the time library.

[0091] 111) The 19-bit feature code that makes up the tattoo is specifically: 4-bit airport identifier + 4-bit initial time (format HHMM) + 3-bit initial season (e.g. 23S represents the 2023 summer and autumn season, 23W represents the 2023 winter and spring season) + 3-bit applicant air carrier + 8-bit application time (format YYYYMMDD) + 1-bit takeoff and landing attribute ("D" represents takeoff, "A" represents landing) + 1-bit passenger and cargo attribute ("P" represents passenger, "C" represents cargo) + 1-bit schedule attribute (e.g. "1" represents every Monday, "2" represents every Tuesday,..., "7" represents every Sunday), each data item corresponds to a key dimension of time management; the specific meaning and examples are shown in Table 1 below:

[0092] Table 1

[0093]

[0094] 112) The time library serial number, as a supplementary field of the tattoo, is used to mark records in the same tattoo (i.e. the 19-bit feature code is exactly the same). The initial allocation starts with 001, and the newly added records under the same tattoo are sequentially numbered by +1 rule, thereby distinguishing multiple time records and ensuring the uniqueness of the code.

[0095] For example: An air carrier (CCA) applies for a takeoff (D) at 8:30 (0830) on every Sunday (7) for passenger (P) at Guangzhou Baiyun Airport (ZGGG) in the summer and autumn season of 2024 (24S) on March 15, 2024 (20240315), and the initial allocation of the time library serial number is "001". If the air carrier applies for a takeoff (D) at 8:30 (0830) on every Sunday (7) for passenger (P) at Guangzhou Baiyun Airport (ZGGG) in the summer and autumn season of 2024 (24S) on the same day, the time library serial number of the second record is "002".

[0096] 12) The time pool code consists of 13 characters, encoded in the structure of pit mark + time pool sequence number; in the pit mark + time pool sequence number structure, the pit mark serves as a unique identity anchor, based on the core setting condition of limited pit quantity in the time pool, the 10-bit feature code accurately locks and completely records the specific core attributes corresponding to the specific flight time in the time pool, ensuring that each time corresponds to a limited physical pit in the time pool; the time pool sequence number uses 3 Arabic numerals (001-999) to distinguish multiple pit records corresponding to the same time; the combination of pit mark + time pool sequence number realizes the management constraint adaptation of limited pit quantity in the time pool, and realizes the accurate identification of unallocated time records in the time pool, avoiding the repeated allocation or idle waste of limited pit resources due to identification confusion;

[0097] 121) The 10-bit feature code that constitutes the pit mark is specifically: 4-bit airport identification + 4-bit time (format HHMM) + 1-bit take-off attribute ("D" represents take-off, "A" represents landing) + 1-bit class attribute (e.g. "1" represents Monday, …, "7" represents Sunday);

[0098] 122) The time pool sequence number is a supplementary field of the pit mark, which is used to mark the record under the same pit mark (i.e. the 10-bit feature code is completely the same): the initial allocation starts with 001, and the new record under the same pit mark is numbered in sequence according to the +1 rule, so as to distinguish multiple time records in the time pool and ensure that the code is unique; at the same time, combined with the core setting of limited pit quantity in the time pool, the maximum number of time pool codes used in the time pool can be compared with the preset capacity of the pit to determine whether there are available flight times for the corresponding pit in the time pool, accurately matching the resource management needs of limited pits.

[0099] 2) Combined with the core constraint of limited pit quantity in the time pool, the total amount of resources is limited through the flight time coordination parameter table, and the used state of time resources is tracked through the time pool time allocation table, so as to determine whether the time applied by the air carrier has a surplus that can be allocated, forming a closed-loop management of total amount control-dynamic tracking-allocation judgment;

[0100] 21) Establish a flight time coordination parameter table, which includes the following data items: season, airport, class, coordination parameter time range, total amount of flight times that can be provided within 60 minutes, total amount of take-off flight times that can be provided within 60 minutes, total amount of landing flight times that can be provided within 60 minutes, total amount of flight times that can be provided within 15 minutes, total amount of take-off flight times that can be provided within 15 minutes, and total amount of landing flight times that can be provided within 15 minutes. The specific example is shown in Table 2 below;

[0101] Table 2

[0102]

[0103] 22) Establish the time pool time allocation table, its specific data item information includes: time pool code and time library code; With time pool code core identification, real-time record each time pool code allocation state; Through time library code is empty or not, to represent the resource used / unused situation;

[0104] 23) According to the logic of first fixed total amount, then calculate the used, finally judge whether the time of the airline applicant has the amount to be allocated; The specific steps are as follows:

[0105] 231) According to the application information to locate the total amount of resources in the flight coordination parameter table; Clear the application season, application airport, application class, application time and take-off and landing attribute when the airline submits the time application, according to the clear information in the flight time coordination parameter table to match the corresponding resource amount, including: 60 minutes can provide the total amount of flight time , 60 minutes can provide the total amount of flight time of take-off flight , 60 minutes can provide the total amount of flight time of landing flight , 15 minutes can provide the total amount of flight time , 15 minutes can provide the total amount of flight time of take-off flight And 15 minutes can provide the total amount of flight time of landing flight ;

[0106] For example: the airline applicant "24S season, ZGGG airport, every Monday 07:10 take-off time", the system matches the parameter in the coordination parameter table "24S, ZGGG, 1234567, 0700-0759" period; 、 、 、 .

[0107] 232) Based on the time pool time allocation table to count the number of used resources; According to the application season, application airport, application class, application time and take-off and landing attribute submitted by the carrier in step 231), all time pool codes with corresponding conditions are screened out in the time pool time allocation table, and the number of allocated is counted, including: the number of time allocated in 1 hour of the application time , the number of take-off flight time allocated in 1 hour of the application time , the number of landing flight time allocated in 1 hour of the application time , the number of time allocated in 15 minutes of the application time , the number of take-off flight time allocated in 15 minutes of the application time And the number of landing flight time allocated in 15 minutes of the application time ;

[0108] 233)Calculate the remaining amount of distribution and determine the feasibility of the application time; through the calculation method of subtracting the used resource amount from the total resource amount, establish a calculation model to judge whether the time submitted by the air carrier is assignable, including: take-off time calculation model and landing time calculation model, as follows:

[0109] The take-off time calculation model is:

[0110] ;

[0111] The landing time calculation model is:

[0112] ;

[0113] When the above calculation model is established, the time submitted by the air carrier can be assigned; otherwise, there is no remaining amount in the time pool that can be assigned to the air carrier.

[0114] 3) Establish a data storage library for time tracking, including: time use record table, time pool time allocation table and historical time use record table, which are associated through time library coding to form a complete data link of real-time dynamic record + historical permanent archive;

[0115] 31) Establish a time use record table to record the current time use behavior in real time, and its specific data item information includes: time library coding, season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time and application type (new, adjustment, replacement, cancellation);

[0116] 32) Establish a historical time use record table to store the records of time use that have ended or been cancelled, forming a historical database of time use, and its specific data item information includes: time library coding, season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time, application type (new, adjustment, replacement, cancellation), archiving time and time pool coding;

[0117] 33) When the data in the time use record is changed, the change tracing and history archiving rule of the time use record is implemented: the data in the time use record before the change is transferred into the history time use record table, the archive information before the change is completely retained, and the association tracing of the change record and the original time allocation information is realized through the three key data items of the time bank code, the archiving time and the time pool code in the history time use record table; most of the data items in the history time use record table are directly derived from the time use record table, including: the time bank code, the season, the air carrier, the flight number, the airport, the schedule attribute, the flight time, the take-off and landing attribute, the passenger and cargo attribute, the application archiving time and the application type; the values of the remaining two data items in the history time use record table are: one is the archiving time, which refers to the operation time when the current record is synchronized from the time use record table to the history time use record table and the change is completed; the other is the time pool code, which is derived from the associated time pool time allocation table, and is specifically associated with the time use record table and the time pool time allocation table through the time bank code.

[0118] 4) The application type selected by the air carrier before submitting the time application information is judged, if the application type is addition, step 5) is executed; if the application type is adjustment, step 6) is executed; if the application type is replacement, step 7) is executed; if the application type is cancellation, step 8) is executed.

[0119] 5) According to the addition time application information submitted by the air carrier, it is judged whether there is a surplus in the time pool to meet the time demand, if there is no surplus, it is prompted that there is no surplus, and the process is ended; otherwise, there is a surplus, and the process continues, which is specifically: according to the airport, time, take-off and landing attribute and schedule attribute in the application, the pit record of the time pool time allocation table is matched to determine the time pool code SKCBM; then the time bank code is generated according to the application information, and the time bank code is stored in the time use record table together with the application information; the obtained time pool code and time bank code are stored in the time pool time allocation table together; which specifically includes:

[0120] 51) According to the season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute and passenger and cargo attribute information entered by the air carrier, it is judged whether there is a surplus in the time pool to meet the time demand submitted by the air carrier according to the calculation model defined in step 23), if there is a surplus that can be allocated, step 52) is executed; otherwise, it is prompted that the new time applied by the air carrier has no surplus available in the time pool, and the process is ended;

[0121] 52) According to the airport, flight time, take-off and landing attribute and schedule attribute data in the air carrier time application information, the pit record of the time pool time allocation table is matched to calculate the time pool code of the current application record, and the value of the time pool code is allocated to the time pool code SKCBM; which is specifically as follows:

[0122] 521) Extract the core data items in the new airline schedule application record, including: airport, flight schedule, take-off and landing attributes, and class attributes. According to the four data items, match the corresponding schedule pool schedule allocation record in the schedule pool schedule allocation table. If no record is matched, generate the schedule pool code of the new airline schedule application record according to the schedule pool code definition rule in step 12). The schedule pool code is newly generated, and the schedule pool number contained in the schedule pool code is 001. Assign the schedule pool code to the schedule pool code SKCBM. If a record is matched, go to step 522).

[0123] 522) Select the record with an empty schedule pool code from the matching results. If there is a record, sort the selected records in ascending order according to the schedule pool number of the schedule pool code, and select the record with the smallest schedule pool number. Assign the schedule pool code of the record to the schedule pool code SKCBM. The schedule pool code is not newly generated. If there is no record, select the record with the largest schedule pool number from the matching results. Add 1 to the schedule pool number contained in the schedule pool code of the record, and assign it to the schedule pool code SKCBM. The schedule pool code is newly generated.

[0124] 53) Generate the schedule pool code according to the new schedule application information submitted by the airline according to the schedule pool code definition rule in step 11). Save the schedule pool code, season, airline, flight number, airport, class attribute, flight schedule, take-off and landing attribute, passenger and cargo attribute, and application type information to the corresponding data items in the schedule usage record table. The remaining application filing time data item in the schedule usage record table is stored in the current system time SYSDATE.

[0125] 54) Determine the source of the schedule pool code in step 52). Save the schedule pool code SKCBM obtained in step 52) and the schedule pool code obtained in step 53) to the schedule pool schedule allocation table. The specific operation is as follows:

[0126] If the source of the schedule pool code is newly generated, add a new data record to the schedule pool schedule allocation table. The value of the schedule pool code data item in the data record is the schedule pool code SKCBM obtained in step 52), and the value of the schedule pool code data item is the schedule pool code obtained in step 53). If the source of the schedule pool code is not newly generated, modify the data record corresponding to the schedule pool code in the schedule pool schedule allocation table, and update the value of the schedule pool code data item in the data record to the schedule pool code obtained in step 53).

[0127] The new schedule application information includes: season, airline, flight number, airport, class attribute, flight schedule, take-off and landing attribute, passenger and cargo attribute, and application type. The value of the application type data item is new.

[0128] 6) According to the adjusted season, airline, flight number, airport, schedule attribute, flight time, take-off and landing attribute and passenger and cargo attribute information in the adjustment time application information submitted by the air carrier, it is judged whether there is a surplus in the time pool to meet the new time demand. If there is no surplus, the air carrier is prompted that there is no surplus, and the process ends. Otherwise, there is a surplus, and the process continues, as follows: through the pit record of the airport, flight time, take-off and landing attribute and schedule attribute in the adjusted record matched with the time pool time allocation table, the time pool code of the new time after adjustment is calculated and allocated to the time pool code SKCBM; according to the rules defined in step 33), the time usage record table data before adjustment in the adjustment time application information is transferred to the historical time usage record table; then, taking the time library code as the key information, the data items in the time usage record table are updated to the adjusted season, airline, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute data values, the original value of the application filing time data item is retained, and the value of the application type data item is changed to adjustment; taking the time library code as the key information, the time pool code of the matching record in the time pool time allocation table is updated to the time pool code SKCBM; which specifically includes:

[0129] 61) According to the adjusted season, airline, flight number, airport, schedule attribute, flight time, take-off and landing attribute and passenger and cargo attribute information in the adjustment time application information submitted by the air carrier, it is judged whether there is a surplus in the time pool to meet the new time demand, according to the calculation model defined in step 23). If there is a surplus that can be allocated, then go to step 62); otherwise, prompt the air carrier that there is no surplus available, and the process ends.

[0130] 62) According to the airport, flight time, take-off and landing attribute and schedule attribute data in the data record after adjustment according to the air carrier's time adjustment application, the pit record of the time pool code in the time pool time allocation table is matched, and the time pool code of the new time after adjustment is calculated. The value of the time pool code is allocated to the time pool code SKCBM.

[0131] 63) According to the rules defined in step 33), the record before adjustment in the adjustment time application information is associated with the corresponding record in the time usage record table through the time library code; after the association is completed, the data of the associated record in the time usage record table is transferred to the historical time usage record table.

[0132] 64) Take the time library code as the key matching information, and update the data values of the adjusted season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, and passenger and cargo attribute in the application information to the same data items of the corresponding matching records in the time use record table; keep the original value of the application filing time data item in the time use record table, and update the value of the application type data item in the time use record table to adjustment;

[0133] 65) Take the time library code as the key matching information, and update the time pool code data item of the matching records in the time pool time allocation table with the time pool code SKCBM.

[0134] The adjustment time application information includes: time library code, season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, and application type; wherein the data items of season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, and passenger and cargo attribute all contain pre-adjustment records and post-adjustment records; the specific acquisition and generation method is as follows: receiving the air carrier to enter the time library code, querying the corresponding record in the time use record table according to the time library code, and taking the current value of the above data items in the record as the pre-adjustment record; modifying the values of the above data items according to actual needs, and taking the modified values as the post-adjustment record; the pre-adjustment record and the post-adjustment record are associated through the time library code.

[0135] In addition, the value of the application type data item in the adjustment time application information is fixed as adjustment.

[0136] 7) According to the two time library codes submitted by the air carrier, the corresponding data in the time use record table is obtained as two records to be replaced; then the respective corresponding data of the two records to be replaced in the time use record table is respectively stored into the historical time use record table; take the two time library codes as the key matching information, and interchange and save the values of the season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, and passenger and cargo attribute data items in the corresponding two records in the time use record table, keep the original application filing time data item value, and update the application type data item to replacement; take the two time library codes as the key matching information, and interchange and save the values of the time pool code data items in the corresponding two records in the time pool time allocation table; specifically including:

[0137] 71) The data of the two records to be replaced submitted by the air carrier in the time use record table is stored into the historical time use record table according to the rules in step 33);

[0138] 72) Take the first time library code as the key matching information, the second time library code before the replacement of the season, the airline carrier, the flight number, the airport, the class attribute, the flight time, the landing attribute and the passenger and cargo attribute data update time using the corresponding data items of the matching record in the time using record table; the remaining application filing time data item value of the matching record in the time using record table is unchanged, and the application type data item value is updated to replacement; take the second time library code as the key matching information, the season, the airline carrier, the flight number, the airport, the class attribute, the flight time, the landing attribute and the passenger and cargo attribute data update time using the corresponding data items of the matching record in the time using record table before the replacement of the first time library code; the remaining application filing time data item value of the matching record in the time using record table is unchanged, and the application type data item value is updated to replacement;

[0139] 73) Take the time library code as the key matching information, and exchange and save the values of the time pool code data items in the time pool time allocation table corresponding to the two time replacement records.

[0140] Among them, the replacement time application information includes time library code, season, airline carrier, flight number, airport, class attribute, flight time, landing attribute, passenger and cargo attribute and application type; wherein the data items of time library code, season, airline carrier, flight number, airport, class attribute, flight time, landing attribute and passenger and cargo attribute all contain two records to be replaced, and the specific acquisition and generation method is as follows: receiving the airline carrier to input two time library codes respectively, and after corresponding records are found in the time using record table according to the time library code, the current values of the above data items of the two records are taken as the records to be replaced.

[0141] In addition, the value of the application type data item in the replacement time application information is fixed as replacement.

[0142] 8) According to the airline carrier submitted to be cancelled time record, the data recorded in the time using record table is stored into the historical time using record table; then take the time library code as the key matching information, update the application type data item value of the corresponding record in the time using record table to cancellation, and update the time pool code data item value to empty in the time pool time allocation table; specific including:

[0143] 81) The airline carrier submitted to be cancelled record in the time using record table is stored into the historical time using record table according to the rule in step 33);

[0144] 82) Take the time library code as the key matching information, update the application type data item value of the matching record in the time using record table to cancellation, and other data items remain unchanged;

[0145] 83) Take the time library code as the key matching information, update the time pool time allocation table matching record time pool code data item value to empty.

[0146] The cancellation time application information includes: time library code, season, air carrier, flight number, airport, class attribute, flight time, take-off and landing attribute, passenger and cargo attribute, and application type. The data items of time library code, season, air carrier, flight number, airport, class attribute, flight time, take-off and landing attribute, and passenger and cargo attribute are obtained and generated as follows: receiving the air carrier to enter the time library code, querying the corresponding record in the time use record table according to the time library code, and taking the current value of the above data items of the record as the record to be cancelled.

[0147] In addition, the value of the application type data item in the cancellation time application information is fixed as cancellation.

[0148] 9) Construct a time full life cycle tracking data model to realize the tracking management of the full life cycle of flight time; the specific implementation is as follows:

[0149] 91) Determine the unique index;

[0150] Set the time library code SKBM as the unique index of the time full life cycle tracking, which is used to associate various data entities and ensure the uniqueness of the data link;

[0151] 92) Clearly associate the data table;

[0152] Determine the core data table participating in association, including: historical time use record table, time use record table and time pool time allocation table, which together form a complete data link from historical archive data to current real-time use and resource allocation matching;

[0153] 93) Construct a historical time use record sub-model;

[0154] Take the time library code SKBM as the index, sort in ascending order of archiving time, and integrate all original information corresponding to the time into the historical time use record sub-model [SKBM]. The complete model is: historical time use record sub-model [SKBM] = historical time use record sub-model {[SKBM] season, air carrier, flight number, airport, class attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application archiving time, application type, archiving time, time pool code}. Wherein, [SKBM] is the index item of the historical time use record sub-model, and the season, air carrier, flight number, airport, class attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application archiving time, application type, archiving time and time pool code each field respectively corresponds to the original record information in the historical time use record table;

[0155] 94) Constructing the time record sub-model in use;

[0156] Take the time bank code SKBM as the unique primary key, integrate the real-time use information set, that is, the time record sub-model in use [SKBM], by associating the time use record table and the time pool time allocation table, and the specific association method is:

[0157] Extract the season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time, and application type field information corresponding to [SKBM] from the time use record table;

[0158] Extract the time pool code field information corresponding to [SKBM] from the time pool time allocation table;

[0159] Since the real-time record has no filing time, the value of the filing time field is empty;

[0160] The complete model of the time record sub-model in use is:

[0161] The time record sub-model in use [SKBM] = the time record sub-model in use {[SKBM] season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time, application type, filing time, time pool code} = {time use record table [(SKBM) season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time, application type], empty, time pool time allocation table [(SKBM) time pool code]};

[0162] 95) Integrate the full life cycle tracking data model;

[0163] Aggregate the historical time use record sub-model [SKBM] generated in step 93) and the time record sub-model in use [SKBM] generated in step 94) to form a complete full life cycle tracking data model, and the expression is: full life cycle tracking data model {[SKBM] season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time, application type, filing time, time pool code} = historical time use record sub-model [SKBM] + time record sub-model in use [SKBM]; wherein [SKBM] is the index item of the full life cycle tracking data model, and through the index, a complete data link from historical archived data to current real-time use and resource allocation matching can be connected.

[0164] The application has many specific application approaches, and the above description is only the preferred embodiment of the application, and it should be pointed out that, for ordinary skilled in the art, several improvements can be made without departing from the principles of the application, and these improvements should also be considered as the protection scope of the application.

Claims

1. A flight schedule uniform coding and full life cycle tracking management method, characterized in that, The steps are as follows: 1) Establish a unified coding format for time, including time library coding and time pool coding; 2) Combine the core constraint of limited pit quantity in the time pool, and through the flight time coordination parameter table, the upper limit of the total amount of resources is specified, and the used state of the time resources is tracked through the time pool time allocation table, so as to judge whether the time applied by the air carrier has a surplus that can be allocated, forming a closed-loop management of total amount control-dynamic tracking-allocation judgment; 3) Establish a data storage library for time tracking, including: time use record table, time pool time allocation table and historical time use record table, which are associated through time library coding, forming a complete data link of real-time dynamic record + historical permanent archive; 4) Determine the application type selected by the air carrier before submitting the time application information, if the application type is new, step 5) is executed; if the application type is adjustment, step 6) is executed; if the application type is replacement, step 7) is executed; if the application type is cancellation, step 8) is executed; 5) Process the time application submitted by the air carrier, verify the time pool surplus, if there is no surplus, terminate and prompt; otherwise, according to the airport, flight time, take-off and landing attributes and the class attributes of the application, match the time pool time allocation table, determine the time pool coding SKCBM; then generate the time library coding, store the application information and the time library coding in the time use record table, and store the time pool coding and the time library coding in the time pool time allocation table; 6) Process the time adjustment application submitted by the air carrier, verify the time pool surplus of the new time after adjustment, if there is no surplus, terminate and prompt; otherwise, match the airport, flight time, take-off and landing attributes and the class attributes of the new time, calculate and allocate the new time pool coding SKCBM; according to the rules, store the data before adjustment to the historical time use record table; update the time use record table to the data after adjustment with the time library coding as the key information, and synchronize the time pool coding in the time pool time allocation table; 7) Process the time replacement application submitted by the air carrier, store the original data of the two records to be replaced in the historical time use record table respectively; interchange the core data of the two records in the time use record table with the time library coding as the key information, change the application type to replacement, and keep the original application filing time; synchronize the time pool coding of the two records in the time pool time allocation table; 8) Process the time cancellation application submitted by the air carrier, store the record to be cancelled from the time use record table to the historical time use record table; then change the application type of the corresponding record in the time use record table to cancellation with the time library coding as the key information, and empty the time pool coding of the matching record in the time pool time allocation table; 9) Build a time full life cycle tracking data model to realize the tracking management of the full life cycle of flight time.

2. The flight schedule uniform coding and full life cycle tracking management method according to claim 1, characterized in that, The time library coding in step 1) adopts the structure of mark + time library serial number, which realizes the accurate identification of time records in the time library; the time pool coding adopts the structure of pit mark + time pool serial number, which is used to adapt to the management constraint of limited pit quantity in the time pool, and realizes the accurate identification of unallocated time records in the time pool; 11) The time library code consists of 22 characters, encoded in the form of a mark + time library serial number. In the mark + time library serial number structure, the mark serves as the unique identity anchor, and the 19-bit feature code records the core attributes of the initial allocation of the time. The time library serial number uses 3 Arabic numerals to distinguish the same attributes of the time. The combination of the mark + time library serial number realizes the accurate identification of the time record in the time library. 12) The time pool code consists of 13 characters, encoded in the form of a mark + time pool serial number. In the mark + time pool serial number structure, the mark serves as the unique identity anchor, and based on the core setting condition that the number of pit positions in the time pool is limited, the 10-bit feature code accurately locks and records the specific core attributes of the specific flight time in the time pool, ensuring that each time corresponds to a limited physical pit position in the time pool. The time pool serial number uses 3 Arabic numerals to distinguish multiple pit position records corresponding to the same time. The combination of the mark + time pool serial number realizes the management constraint adaptation of the limited number of pit positions in the time pool, and realizes the accurate identification of the unallocated time record in the time pool.

3. The flight schedule uniform coding and life cycle tracking management method according to claim 1, characterized in that, The step 2) specifically includes: 21) Establish a flight time coordination parameter table, which specifically includes the following data items: season, airport, flight period, coordination parameter time range, total number of flight times available in 60 minutes, total number of take-off flight times available in 60 minutes, total number of landing flight times available in 60 minutes, total number of flight times available in 15 minutes, total number of take-off flight times available in 15 minutes, and total number of landing flight times available in 15 minutes; 22) Establish a time pool time allocation table, which specifically includes the following data items: time pool code and time library code; with the time pool code as the core identifier, the allocation status of each time pool code is recorded in real time; whether the time library code is empty indicates whether the resource is used or not used; 23) According to the logic of first determining the total amount, then calculating the used amount, and finally judging, it is judged whether the time applied by the air carrier has a surplus that can be allocated.

4. The flight schedule uniform coding and full life cycle tracking management method according to claim 3, characterized in that, The step 23) specifically includes: 231) According to the application information, the total amount of resources in the flight coordination parameter table is located; the application season, application airport, application class, application time and take-off and landing attribute when the air carrier submits the time application are clarified, and the corresponding resource amount in the flight time coordination parameter table is matched according to the clarified information, including: the total amount of flight time that can be provided within 60 minutes , the total amount of flight time that can provide take-off flight within 60 minutes , the total amount of flight time that can provide landing flight within 60 minutes , the total amount of flight time that can be provided within 15 minutes , the total amount of flight time that can provide take-off flight within 15 minutes , and the total amount of flight time that can provide landing flight within 15 minutes ; 232) Count the number of used resources based on the time slot pool time allocation table; according to the application season, application airport, application class, application time and take-off and landing attributes submitted by the carrier in step 231), all time slot pool codes with corresponding conditions are screened out in the time slot pool time allocation table, and the number of allocated resources is counted, including: the number of time slots allocated within 1 hour of the application time , the number of take-off flight time slots allocated within 1 hour of the application time , the number of landing flight time slots allocated within 1 hour of the application time , the number of time slots allocated within 15 minutes of the application time , the number of take-off flight time slots allocated within 15 minutes of the application time , and the number of landing flight time slots allocated within 15 minutes of the application time ; 233) Calculate the remaining allocatable amount and judge the feasibility of the application time; by calculating the total amount of resources minus the amount of used resources, a calculation model is established to judge whether the time submitted by the air carrier can be allocated, including: take-off time calculation model and landing time calculation model, as follows: The take-off time calculation model is: ； The landing time calculation model is: ； When the above calculation model is established, the time submitted by the air carrier can be allocated; otherwise, there is no surplus in the time pool that can be allocated to the air carrier.

5. The flight schedule uniform coding and full life cycle tracking management method according to claim 4, characterized in that, The step 3) specifically includes: 31) Establish a time use record table to record the current time use behavior in real time, which specifically includes the following data items: time library code, season, air carrier, flight number, airport, flight period attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time, and application type; 32) Establishing a historical time slot usage record table for storing the time slot usage records that have been ended or cancelled, forming a historical database of time slot usage, and the specific data item information includes: time slot bank code, season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time, application type, filing time and time slot pool code; 33) When the data in the time slot usage record changes, the change traceability and historical filing rules of the time slot usage record are implemented: the data in the time slot usage record before the change is transferred into the historical time slot usage record table, the archive information before the change is completely retained, and the association traceability of the change record and the original time slot allocation information is realized through the three key data items of time slot bank code, filing time and time slot pool code in the historical time slot usage record table; most of the data items in the historical time slot usage record table are directly derived from the time slot usage record table, including: time slot bank code, season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time and application type; the values of the remaining two data items in the historical time slot usage record table are: one is the filing time, which refers to the operation time when the current record is synchronized from the time slot usage record table to the historical time slot usage record table and the change is completed; the other is the time slot pool code, which is derived from the associated time slot pool time slot allocation table, and is specifically associated with the time slot usage record table and the time slot pool time slot allocation table through the time slot bank code.

6. The flight schedule uniform coding and full life cycle tracking management method according to claim 5, characterized in that, The step 5) specifically includes: 51) According to the season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute and passenger and cargo attribute information entered by the air carrier, it is judged whether there is a surplus in the time slot pool to meet the time slot demand submitted by the air carrier according to the calculation model defined in step 23), if there is a surplus that can be allocated, then step 52) is executed; otherwise, it is prompted that the new time slot applied by the air carrier has no surplus available in the time slot pool, and the process is ended; 52) According to the airport, flight time, take-off and landing attribute and schedule attribute data in the air carrier time slot application information, the time slot pool code of the current application record is calculated by matching the pit record of the time slot pool code in the time slot pool time slot allocation table, and the value of the time slot pool code is allocated to the time slot pool code SKCBM; specifically as follows: 521) Extract the core data items in the new time slot application record of the air carrier, including: airport, flight time, take-off and landing attribute and schedule attribute, and match the time slot allocation record of the corresponding time slot pool in the time slot pool time slot allocation table according to the four data items; if no record is matched, then generate the time slot pool code of the new time slot application record of the air carrier according to the time slot pool code definition rule in step 12), the time slot pool code is newly generated, the time slot pool serial number contained is 001, and the time slot pool code is allocated to the time slot pool code SKCBM; if a record is matched, then step 522) is entered; 522) From the matching results, filter out the records with empty time bank codes; if there are records, sort the filtered records in ascending order according to the time bank sequence numbers of the time bank codes, select the record with the smallest time bank sequence number, and assign the time bank code of the record to the time bank code SKCBM, which is derived from non-new generation; if there are no records, select the record with the largest time bank sequence number from the matching results, add 1 to the time bank sequence number contained in the time bank code of the record, and assign it to the time bank code SKCBM, which is derived from new generation; 53) According to the newly added time application information submitted by the airline carrier, generate the time bank code according to the time bank code definition rule in step 11); save the time bank code, season, airline carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, and application type information to the corresponding data items in the time use record table; save the remaining application filing time data item in the time use record table to the current system time SYSDATE; 54) Determine the source of the time bank code in step 52), save the time bank code SKCBM obtained in step 52) and the time bank code obtained in step 53) to the time bank time allocation table, and the specific operation is as follows: If the source of the time bank code is new generation, add a new data record to the time bank time allocation table, the value of the time bank code data item in the data record is the time bank code SKCBM obtained in step 52, and the value of the time bank code data item is the time bank code obtained in step 53); if the source of the time bank code is non-new generation, modify the data record corresponding to the time bank code in the time bank time allocation table, and update the value of the time bank code data item in the data record to the time bank code obtained in step 53).

7. The flight schedule uniform coding and life cycle tracking management method according to claim 6, characterized in that, The step 6) specifically includes: 61) According to the adjusted season, airline carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, and passenger and cargo attribute information in the adjusted time application information submitted by the airline carrier, determine whether there is a surplus in the time bank to meet the new time demand of the airline carrier after adjustment according to the calculation model defined in step 23); if there is a surplus that can be allocated, then go to step 62); otherwise, prompt the airline carrier that there is no surplus available, and end; 62) According to the airport, flight time, take-off and landing attribute, and schedule attribute data in the data record after adjustment in the airline carrier time adjustment application, match the time bank code in the time bank time allocation table, calculate the time bank code of the new time after adjustment, and assign the value of the time bank code to the time bank code SKCBM; 63) According to the rules defined in step 33), associate the record before adjustment in the adjustment time application information with the corresponding record in the time use record table through the time bank code; after the association is completed, copy the data of the associated record in the time use record table to the historical time use record table. 64) Take the time library code as the key matching information, and update the data values of the adjusted season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, and passenger and cargo attribute in the application information to the same data items of the matching records in the time use record table; keep the original values of the application filing time data items in the time use record table, and update the value of the application type data item in the time use record table to adjustment; 65) Take the time library code as the key matching information, and update the time pool code data item of the matching records in the time pool time allocation table with the time pool code SKCBM.

8. The flight schedule uniform coding and full life cycle tracking management method according to claim 7, characterized in that, The step 7) specifically includes: 71) According to the rules in step 33), the data of the two records to be replaced submitted by the air carrier in the time use record table are stored in the historical time use record table; 72) Take the first time library code as the key matching information, and update the season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, and passenger and cargo attribute data before the replacement of the second time library code to the corresponding data items of the matching records in the time use record table; the remaining application filing time data item values of the matching records in the time use record table remain unchanged, and the application type data item value is updated to replacement; take the second time library code as the key matching information, and update the season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, and passenger and cargo attribute data before the replacement of the first time library code to the corresponding data items of the matching records in the time use record table; the remaining application filing time data item values of the matching records in the time use record table remain unchanged, and the application type data item value is updated to replacement; 73) Take the time library code as the key matching information, and exchange and save the values of the time pool code data items of the two time replacement records in the time pool time allocation table.

9. The flight schedule uniform coding and life cycle tracking management method of claim 8, wherein, The step 8) specifically includes: 81) According to the rules in step 33), the data of the record to be cancelled submitted by the air carrier in the time use record table are stored in the historical time use record table; 82) Take the time library code as the key matching information, and update the application type data item value of the matching records in the time use record table to cancellation, and other data items remain unchanged; 83) Take the time library code as the key matching information, and update the time pool code data item value of the matching records in the time pool time allocation table to empty.

10. The flight schedule uniform coding and full life cycle tracking management method according to claim 9, characterized in that, The step 9) specifically includes: 91) Determine the unique index; Set the time library code SKBM as the unique index of the whole life cycle tracking of the time, which is used to associate various data entities and ensure the uniqueness of the data link; 92) Clearly associate the data table; Determine the core data table participating in the association, including: the historical time use record table, the time use record table, and the time pool time allocation table, which together form a complete data link from historical archive data to current real-time use and resource allocation matching; 93) Build a historical time use record sub-model; The original information corresponding to the time is integrated into a historical time use record sub-model [SKBM] in ascending order of the filing time, with the time library code SKBM as the index, and the complete model is: historical time use record sub-model [SKBM] = historical time use record sub-model {[SKBM] season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time, application type, filing time, time pool code}; wherein [SKBM] is an index item of the historical time use record sub-model, and the fields of season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time, application type, filing time and time pool code correspond to the original record information in the historical time use record table respectively; 94) constructing a time record sub-model in use; The real-time use information set, i.e., the time record sub-model in use [SKBM], is integrated by associating the time use record table and the time pool time allocation table, with the time library code SKBM as the unique primary key, and the specific association manner is: The fields of season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time and application type corresponding to [SKBM] are extracted from the time use record table; The field information of the time pool code corresponding to [SKBM] is extracted from the time pool time allocation table; The value of the filing time field is empty; The complete model of the time record sub-model in use is: The time record sub-model in use [SKBM] = the time record sub-model in use {[SKBM] season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time, application type, filing time, time pool code} = {time use record table [(SKBM) season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time, application type], empty, time pool time allocation table [(SKBM) time pool code]}; 95) integrating a full life cycle tracking data model; The historical time use record sub-model [SKBM] generated in step 93) and the time record sub-model in use [SKBM] generated in step 94) are aggregated to form a complete full life cycle tracking data model, and the expression is: full life cycle tracking data model {[SKBM] season, air carrier, flight number, airport, schedule attribute, flight time, take-off and landing attribute, passenger and cargo attribute, application filing time, application type, filing time, time pool code} = historical time use record sub-model [SKBM] + time record sub-model in use [SKBM]; wherein [SKBM] is an index item of the full life cycle tracking data model, and through the index, a complete data link from historical archived data to current real-time use and resource allocation matching can be connected in series.

Images