A method, apparatus and device for tariff data pruning

Abstract

The application provides a kind of freight data pruning method, device and equipment, method includes: obtaining freight original data, delete the data of the flight owner pruning range outside of the freight original data;Delete the data in the freight original data that is outside the owner pruning range of freight;Remaining non-airline data is stored in release area;Remaining explicit airline data is stored in non-release area;Remaining implicit airline data is stored in non-release area;Iterate non-release data, migrate non-release data to release area or waiting area;Data in the release area is stored in file as pruned data file, and released to the data preprocessing module in the freight calculation system.The size of the freight data is reduced by deleting and arranging the freight original data, so that the pruned data does not lose and is not redundant.

Description

Technical Field

[0001] This invention relates to the field of data processing technology, and specifically to a method, apparatus, and equipment for cropping freight rate data. Background Technology

[0002] International air fare data currently widely follows the ATPCO standard, and this data is released daily at set times. When processing international passenger ticket fare data, the international air fare calculation system first receives raw fare data from external sources and saves it to a data preprocessing server. Then, it preprocesses the raw data into a database usable by the international air fare calculation system. This database is several orders of magnitude larger than the raw data, such as… Figure 1 .

[0003] International civil aviation fare calculation systems not only calculate ticket prices for flights that haven't yet taken off, but also support fare calculations for refunds and changes for already issued tickets. Therefore, they require not only currently valid fare data, but also historical data (such as the past two years). This results in a very large database, high operating costs, and high requirements for the hardware specifications of computer servers, including memory, hard drives, and networks. Summary of the Invention

[0004] In view of this, embodiments of the present invention provide a method, apparatus, and device for cropping freight rate data to reduce the size of freight rate data.

[0005] To achieve the above objectives, the embodiments of the present invention provide the following technical solutions:

[0006] A freight rate data trimming method, applied in a freight rate calculation system, includes the following steps:

[0007] Obtain the raw fare data, which includes: a flight owner data frame and a fare owner data frame;

[0008] Delete the data in the flight owner data frame that is outside the flight owner clipping range;

[0009] Delete the data in the fare owner data frame that is outside the fare owner clipping range;

[0010] Store the remaining non-airline data in the publishing area;

[0011] Store the remaining explicit airline data in the unpublished area;

[0012] The remaining implicit airline data will be stored in the unpublished area;

[0013] Iterate through the unpublished data and migrate it to the publishing area or the waiting area;

[0014] The data in the publishing area is stored in a file and published as a cropped data file to the data preprocessing module of the fare calculation system.

[0015] Optionally, in the above-mentioned freight rate data trimming method, the step of traversing unpublished data and migrating it to the publishing area or waiting area includes:

[0016] Traverse the queue of explicit airline data in the unpublished area to obtain one explicit airline data entry;

[0017] Obtain the type and primary key number of the associated implicit airline data corresponding to the explicit airline data;

[0018] Insert the type and primary key number of the implicit airline data into the waiting area;

[0019] Move the explicit airline data from the unpublished area to the published area.

[0020] Optionally, in the above fare data trimming method, after the explicit airline data in the unpublished area has been traversed, the method further includes:

[0021] Iterate through the data in the waiting area;

[0022] Based on the waiting area data obtained through traversal, the target data is searched in the implicit airline data queue in the unpublished area.

[0023] If the target data is found, delete the data in the waiting area that has been traversed;

[0024] Obtain the type and primary key number of the associated implicit airline data corresponding to the target data and insert it into the waiting area;

[0025] Move the target data from the unpublished area to the published area.

[0026] Optionally, in the above-mentioned freight rate data trimming method, after traversing the waiting area data, the method further includes:

[0027] Check if the data in the waiting area has already been published. If it has, delete the data in the waiting area.

[0028] Optionally, in the above-mentioned fare data trimming method, storing the data within the publishing area in a file includes:

[0029] The data in the published area is stored in a file in ATPCO text format.

[0030] A freight rate data clipping device, applied in a freight rate calculation system, includes the following method:

[0031] The data acquisition unit is used to acquire raw fare data, which includes: a flight owner data frame and a fare owner data frame.

[0032] The data deletion unit is used to delete data in the flight owner data frame that is outside the flight owner clipping range; and to delete data in the fare owner data frame that is outside the fare owner clipping range.

[0033] The data processing unit is used to store the remaining non-airline data in the publishing area; store the remaining explicit airline data in the unpublished explicit airline data queue; store the remaining implicit airline data in the unpublished implicit airline data index directory; traverse the unpublished data and migrate the unpublished data to the publishing area or waiting area; and store the data in the publishing area in a file, which is then published as a trimmed data file to the data preprocessing module of the fare calculation system.

[0034] Optionally, in the above-mentioned fare data trimming device, when the data processing unit traverses unpublished data and migrates it to the publishing area or waiting area, it is specifically used for:

[0035] Traverse the queue of explicit airline data in the unpublished area to obtain one explicit airline data entry;

[0036] Obtain the type and primary key number of the associated implicit airline data corresponding to the explicit airline data;

[0037] Insert the type and primary key number of the implicit airline data into the waiting area;

[0038] Move the explicit airline data from the unpublished area to the published area.

[0039] Optionally, in the above-mentioned fare data trimming device, after the data processing unit has completed traversing the explicit airline data in the unpublished area, it is further used for:

[0040] Iterate through the data in the waiting area;

[0041] Based on the waiting area data obtained through traversal, the target data is searched in the implicit airline data queue in the unpublished area.

[0042] If the target data is found, delete the data in the waiting area that has been traversed;

[0043] Obtain the type and primary key number of the associated implicit airline data corresponding to the target data and insert it into the waiting area;

[0044] Move the target data from the unpublished area to the published area.

[0045] Optionally, in the above-mentioned fare data trimming device, after traversing the waiting area data, the data processing unit is further used to:

[0046] Check if the data in the waiting area has already been published. If it has, delete the data in the waiting area.

[0047] A fare cutting device, used in a fare calculation system, includes:

[0048] Memory and processor;

[0049] The memory is used to store programs;

[0050] The processor is configured to execute the program to achieve:

[0051] Obtain the raw fare data, which includes: a flight owner data frame and a fare owner data frame;

[0052] Obtain the raw fare data, which includes: a flight owner data frame and a fare owner data frame;

[0053] Delete the data in the flight owner data frame that is outside the flight owner clipping range;

[0054] Delete the data in the fare owner data frame that is outside the fare owner clipping range;

[0055] Store the remaining non-airline data in the publishing area;

[0056] Store the remaining explicit airline data in the unpublished area;

[0057] The remaining implicit airline data will be stored in the unpublished area;

[0058] Iterate through the unpublished data and migrate it to the publishing area or the waiting area;

[0059] The data in the publishing area is stored in a file and published as a cropped data file to the data preprocessing module of the fare calculation system.

[0060] Based on the above technical solutions, the solutions provided in the embodiments of the present invention reduce and organize the original freight rate data so that the data is not lost or redundant, thereby reducing the size of the freight rate data. Attached Figure Description

[0061] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on the provided drawings without creative effort.

[0062] Figure 1 This is a schematic diagram of the existing freight rate calculation system;

[0063] Figure 2 This is a schematic diagram of the fare calculation system disclosed in this application;

[0064] Figure 3 This is a diagram illustrating the relationship between fares and flights;

[0065] Figure 4 This is a flowchart illustrating the freight rate data trimming method disclosed in the embodiments of this application;

[0066] Figure 5 This is a flowchart illustrating a freight rate data cropping method disclosed in another embodiment of this application;

[0067] Figure 6 This is a flowchart illustrating a freight rate data cropping method disclosed in another embodiment of this application;

[0068] Figure 7 This is a schematic diagram of the fare data clipping device disclosed in an embodiment of this application;

[0069] Figure 8 This is a schematic diagram of the fare data trimming device disclosed in the embodiments of this application. Detailed Implementation

[0070] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0071] Airlines are currently striving to increase the proportion of sales through their own channels, while also promoting the deployment of independent sales systems overseas to improve the global customer ticketing experience. To support the needs of airlines' direct sales websites and reduce independent deployment costs, the international civil aviation fare system needs to trim fare data, remove irrelevant data, reduce database size, and lower hardware specifications without compromising user experience, thereby saving costs.

[0072] This invention adds a data trimming module to the existing international civil aviation fare system (see...). Figure 2 This allows for a significant reduction in database size without requiring extensive modifications to the original system.

[0073] International civil aviation fare data is characterized by complex operations, and determining whether data should be deleted or retained is crucial. Therefore, this invention categorizes fare data as shown in Table 1:

[0074] Table 1

[0075]

[0076] Based on whether it is proprietary data belonging exclusively to a particular airline, fare data can be divided into airline data and non-airline data. Non-airline data includes exchange rates, national taxes, etc. These data are characterized by not being specific to any particular airline, being very small in scale, and requiring no trimming. Airline data is further divided into fare owner data and flight owner data based on the rules and restrictions applied, see [link to relevant documentation]. Figure 3 Flight ownership data is determined by the airline to which the flight belongs. For example, in the case of multiple airlines operating through the same route, the flight owner may only open up certain special cabin classes for connection with other airlines.

[0077] Multiple flights are divided into several calculation units according to business rules. Each calculation unit selects one airline from its subordinate flights as the fare owner for the entire calculation unit. Therefore, the fare rule data set by the fare owner controls all flights under one calculation unit.

[0078] Airline data is categorized into explicit and implicit airline data based on airline attributes. Explicit airline data contains airline attributes in several of its attributes, explicitly indicating that the data belongs to a specific airline. Implicit airline data does not contain airline attributes; its primary key is an eight-digit number, and it can be further subdivided into direct and indirect associations. Directly associated implicit airline data can be linked to explicit airline data based on its primary key to obtain the airline attribute. Indirectly associated implicit airline data is linked to other implicit airline data through its primary key, eventually connecting to the explicit airline data after multiple associations.

[0079] The characteristics of implicit airline data include:

[0080] It can be cited by multiple airlines simultaneously;

[0081] Once published, it will not be modified.

[0082] Multiple data entries under the same eight-digit number are always released in one complete batch, not in separate batches.

[0083] There is a possibility that the space for eight-digit numbering will run out, so numbers that are no longer used for a period of time (such as two years) will be reused.

[0084] The scope of airline fare adjustments is divided into two categories: flight ownership and fare ownership. The former refers to the range of airlines that can be linked to on the airline's direct sales website, generally including multiple airlines or all airlines worldwide. The latter refers to the fare rule set by the airline selling tickets, generally the direct sales airline or all airlines under its group.

[0085] In this solution, the data trimming device is located before the data preprocessing module (see...). Figure 2The system takes the original ATPCO data as input and outputs cropped data in the same format as the original data, but with a smaller data volume. The archived data area includes three auxiliary storage devices: an unpublished area, a waiting area, and a published area. These devices work in conjunction with three sub-processes: data archiving, data association, and data generation, to perform data cropping.

[0086] Unpublished Area: Contains recently received raw data, as well as unprocessed portions of previous batches of raw data. There are two queues: an explicit airline data queue and an implicit airline data index directory. The former is a one-dimensional array, and the latter is a multi-level directory structure (e.g., data type / first, second, and third digits of the ID / fourth, fifth, and sixth digits of the ID / seventh and eighth digits of the ID / data text file).

[0087] The waiting area is a one-dimensional array where each element represents the type and primary key number of the implicitly referenced airline data. This indicates that the data is explicitly referenced and awaiting publication. The possible states of the specific data corresponding to these numbers are: unpublished original ATPCO data, unpublished data within the archived data area, or published data within the archived data area.

[0088] Release area: Contains data to be released, as well as an implicit index directory of airline data to be released or already released (e.g., data type / first, second, and third digits of the number / fourth, fifth, and sixth digits of the number / seventh and eighth digits of the number, without storing the data itself).

[0089] For details, see Figure 4 The execution process of the fare data trimming method loaded in the data trimming device may specifically include:

[0090] Step S101: Obtain the original fare data, which includes: flight owner data frame and fare owner data frame;

[0091] The original fare data is ATPCO fare data, which includes a flight owner data frame and a fare owner data frame. The ATPCO fare data consists of multiple text files. The first line of each file contains information such as the number of data entries in the file and the update time. Each subsequent line represents a complete data entry. Each field is defined by a fixed position range within the line, and the first field of the line defines the fare data type.

[0092] After obtaining the raw freight rate data, this solution does not require parsing all fields:

[0093] For non-airline fare data types in the raw fare data, the parsing process is skipped, and the data is directly archived.

[0094] For the explicit airline data type in the original fare data, parse the airline field and the fields associated with the implicit airline data;

[0095] For the implicit airline data type in the original fare data, parse the primary key number and the fields that are associated with other implicit airline data.

[0096] Step S102: Delete the data in the flight owner data frame that is outside the flight owner clipping range;

[0097] Based on the preset flight owner clipping range, delete the data in the flight owner data frame that is outside the flight owner clipping range;

[0098] Step S103: Delete the data in the fare owner data frame that is outside the fare owner clipping range;

[0099] Based on the preset fare subject clipping range, delete the data in the fare subject data frame that is outside the fare subject clipping range;

[0100] Step S104: Store the remaining non-airline data in the publishing area;

[0101] In this solution, based on all the original data that has not been deleted, the data is processed according to its data type: the non-airline data in the original data can be directly stored in the publishing area.

[0102] Step S105: Store the remaining explicit airline data in the unpublished area explicit airline data queue;

[0103] Simply store the explicit airline data from the data that has not been deleted in the explicit airline data queue in the unpublished area;

[0104] Step S106: Store the remaining implicit airline data in the implicit airline data index directory in the unpublished area;

[0105] The unpublished implicit airline data index directory in the undeleted data is traversed. If an index conflict is found, the conflicting implicit airline data is replaced with new implicit airline data. At the same time, the published implicit airline data index directory in the published area is traversed to find and delete conflicting implicit airline data.

[0106] Step S107: Traverse the unpublished data and migrate the unpublished data to the publishing area or the waiting area;

[0107] This step mainly involves performing data association operations on the remaining data, with the aim of migrating unpublished data to the publishing area or waiting area.

[0108] See Figure 5 This step may specifically include:

[0109] Step S201: Traverse the unpublished area explicit airline data queue to obtain one explicit airline data entry;

[0110] Step S202: Obtain the type and primary key number of the associated implicit airline data corresponding to the explicit airline data;

[0111] Step S203: Insert the type and primary key number of the implicit airline data into the waiting area;

[0112] Step S204: Move the explicit airline data from the unpublished area to the published area.

[0113] In this step, the explicit airline data in the unpublished area of ​​the remaining data is first traversed to obtain one explicit airline data. After data deletion in step S105, the remaining data are all within the limited airline range, so they can be directly transferred to the publishing area. In addition, these explicit airline data are clues related to implicit airline data. This clue is extracted into a data structure as the type and primary key number of the implicit airline data related to other implicit airline data within the explicit airline data. Therefore, after obtaining one explicit airline data, it is necessary to obtain the type and primary key number of the associated implicit airline data corresponding to the explicit airline data, insert the type and primary key number of the implicit airline data into the waiting area, and move the explicit airline data from the unpublished area into the publishing area.

[0114] See Figure 6 In this step, after the explicit airline data in the unpublished area has been traversed, it may also include:

[0115] Step S301: Traverse the data in the waiting area;

[0116] Step S302: Based on the waiting area data obtained through traversal, search for target data in the implicit airline data queue in the unpublished area;

[0117] Step S303: If the target data is found, delete the data in the waiting area that has been traversed;

[0118] Step S304: Obtain the type and primary key number of the associated implicit airline data corresponding to the target data and insert it into the waiting area;

[0119] Step S305: Move the target data from the unpublished area to the published area.

[0120] The process of traversing the waiting area data further includes:

[0121] Check if the data in the waiting area has already been published. If it has, delete the data in the waiting area.

[0122] In this step, while traversing the waiting queue, the next data entry is retrieved. This next data entry refers to the implicit airline data type and primary key number, which has three possibilities: First, it's already published data, which can be queried in the publishing records of the publishing area and can be skipped. Alternatively, this waiting queue data entry (implicit airline data type and primary key number) can be deleted. Second, it's about to be published and is currently in the unpublished area. It's moved to the publishing area, and then the data type and primary key number of other related data within this data are recorded in the waiting area. Based on the data type and primary key number recorded in the waiting area, the target data is searched in the unpublished implicit airline data queue. If the target data is found, this waiting queue data entry is deleted, and the data type and primary key number of other implicit airline data related to the target data are retrieved and inserted into the waiting area. This unpublished implicit airline data entry is then inserted into the publishing area. The third possibility is that ATPCO has not yet published this data, which is a relatively unlikely exception. For exception protection and proper handling, this data will remain in the waiting area.

[0123] Step S108: Store the data in the publishing area in a file and publish it as a cropped data file to the data preprocessing module.

[0124] In this step, all data within the publishing area is stored in a file in ATPCO text format, serving as the final trimmed data file. Finally, all data within the publishing area is deleted (except for the implicit airline data index directory representing published data).

[0125] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this disclosure. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0126] The names of messages or information exchanged between multiple devices in the embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of such messages or information.

[0127] Although the operations are described in a specific order, this should not be construed as requiring these operations to be performed in the specific order shown or in a sequential order. In certain environments, multitasking and parallel processing may be advantageous.

[0128] It should be understood that the steps described in the method embodiments of this disclosure may be performed in different orders and / or in parallel. Furthermore, the method embodiments may include additional steps and / or omit the steps shown. The scope of this disclosure is not limited in this respect.

[0129] Computer program code for performing the operations of this disclosure can be written in one or more programming languages ​​or a combination thereof, including but not limited to object-oriented programming languages ​​such as Java, Smalltalk, and C++, as well as conventional procedural programming languages ​​such as the "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network—including a local area network (LAN) or a wide area network (WAN)—or can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0130] This embodiment discloses a freight rate data trimming device. For the specific working content of each unit of the device, please refer to the above method embodiment.

[0131] The following describes the freight data trimming device provided in the embodiments of the present invention. The freight data trimming device described below can be referred to in correspondence with the freight data trimming method described above.

[0132] See Figure 7 The fare data trimming device disclosed in this application embodiment may include:

[0133] Data acquisition unit A is used to acquire raw fare data, which includes: flight owner data frame and fare owner data frame;

[0134] Data deletion unit B is used to delete data in the flight owner data frame that is outside the flight owner clipping range; and to delete data in the fare owner data frame that is outside the fare owner clipping range.

[0135] Data processing unit C is used to store the remaining non-airline data in the publishing area; store the remaining explicit airline data in the unpublished area explicit airline data queue; store the remaining implicit airline data in the unpublished area implicit airline data index directory; traverse the unpublished data and migrate the unpublished data to the publishing area or waiting area; and store the data in the publishing area in a file, which is then published as a trimmed data file to the data preprocessing module of the fare calculation system.

[0136] Corresponding to the above method, when the data processing unit traverses unpublished data and migrates it to the publishing area or waiting area, it is specifically used for:

[0137] Traverse the queue of explicit airline data in the unpublished area to obtain one explicit airline data entry;

[0138] Obtain the type and primary key number of the associated implicit airline data corresponding to the explicit airline data;

[0139] Insert the type and primary key number of the implicit airline data into the waiting area;

[0140] Move the explicit airline data from the unpublished area to the published area.

[0141] Corresponding to the above method, after the data processing unit has completed traversing the explicit airline data in the unpublished area, it is also used for:

[0142] Iterate through the data in the waiting area;

[0143] Based on the waiting area data obtained through traversal, the target data is searched in the implicit airline data queue in the unpublished area.

[0144] If the target data is found, delete the data in the waiting area that has been traversed;

[0145] Obtain the type and primary key number of the associated implicit airline data corresponding to the target data and insert it into the waiting area;

[0146] Move the target data from the unpublished area to the published area.

[0147] Corresponding to the above method, after traversing the data in the waiting area, the data processing unit is also used for:

[0148] Check if the data in the waiting area has already been published. If it has, delete the data in the waiting area.

[0149] The units described in the embodiments of this disclosure can be implemented in software or hardware. The names of the units are not, in some cases, intended to limit the specific unit.

[0150] Figure 8 For a hardware structure diagram of the fare data trimming device provided in this embodiment of the invention, please refer to... Figure 8 As shown, it may include: at least one processor 100, at least one communication interface 200, at least one memory 300 and at least one communication bus 400;

[0151] In this embodiment of the invention, the number of processor 100, communication interface 200, memory 300, and communication bus 400 is at least one, and the processor 100, communication interface 200, and memory 300 communicate with each other through communication bus 400; obviously, Figure 8 The communication connections shown for the processor 100, communication interface 200, memory 300, and communication bus 400 are optional.

[0152] Optionally, the communication interface 200 can be an interface of a communication module, such as the interface of a GSM module;

[0153] Processor 100 may be a central processing unit (CPU), an application-specific integrated circuit (ASIC), or one or more integrated circuits configured to implement embodiments of the present invention.

[0154] The memory 300 may include high-speed RAM memory, and may also include non-volatile memory, such as at least one disk storage device.

[0155] Specifically, processor 100 is used for:

[0156] Obtain the raw fare data, which includes: a flight owner data frame and a fare owner data frame;

[0157] Obtain the raw fare data, which includes: a flight owner data frame and a fare owner data frame;

[0158] Delete the data in the flight owner data frame that is outside the flight owner clipping range;

[0159] Delete the data in the fare owner data frame that is outside the fare owner clipping range;

[0160] Store the remaining non-airline data in the publishing area;

[0161] Store the remaining explicit airline data in the unpublished area;

[0162] The remaining implicit airline data will be stored in the unpublished area;

[0163] Iterate through the unpublished data and migrate it to the publishing area or the waiting area;

[0164] The data in the publishing area is stored in a file and published as a cropped data file to the data preprocessing module of the fare calculation system.

[0165] Corresponding to the above-mentioned equipment, this application also discloses a fare calculation system, which applies the fare cutting equipment.

[0166] Although the subject matter has been described using language specific to structural features and / or methodological logic, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or actions described above. Rather, the specific features and actions described above are merely illustrative examples of implementing the claims.

[0167] While several specific implementation details are included in the foregoing discussion, these should not be construed as limiting the scope of this disclosure. Certain features described in the context of individual embodiments may also be implemented in combination in a single embodiment. Conversely, various features described in the context of a single embodiment may also be implemented individually or in any suitable sub-combination in multiple embodiments.

[0168] The above description is merely a preferred embodiment of this disclosure and an explanation of the technical principles employed. Those skilled in the art should understand that the scope of this disclosure is not limited to technical solutions formed by specific combinations of the above-described technical features, but should also cover other technical solutions formed by arbitrary combinations of the above-described technical features or their equivalents without departing from the above-described concept. For example, technical solutions formed by substituting the above features with (but not limited to) technical features disclosed in this disclosure that have similar functions.

Claims

1. A method for cropping freight rate data, characterized in that, Applied to freight rate calculation systems, the methods include: Obtain the raw fare data, which includes: a flight owner data frame and a fare owner data frame; Delete the data in the flight owner data frame that is outside the flight owner clipping range; Delete the data in the fare owner data frame that is outside the fare owner clipping range; Store the remaining non-airline data in the publishing area; Store the remaining explicit airline data in the unpublished area; The remaining implicit airline data will be stored in the unpublished area; Iterate through the unpublished data and migrate it to the publishing area or the waiting area; The data in the publishing area is stored in a file and published as a cropped data file to the data preprocessing module of the fare calculation system. The step of traversing unpublished data and migrating it to the publishing area or waiting area includes: Traverse the queue of explicit airline data in the unpublished area to obtain one explicit airline data entry; Obtain the type and primary key number of the associated implicit airline data corresponding to the explicit airline data; Insert the type and primary key number of the implicit airline data into the waiting area; Move the explicit airline data from the unpublished area to the published area.

2. The freight rate data trimming method according to claim 1, characterized in that, After the explicit airline data in the unpublished area has been traversed, the following is also included: Iterate through the data in the waiting area; Based on the waiting area data obtained through traversal, the target data is searched in the implicit airline data queue in the unpublished area. If the target data is found, delete the data in the waiting area that has been traversed; Obtain the type and primary key number of the associated implicit airline data corresponding to the target data and insert it into the waiting area; Move the target data from the unpublished area to the published area.

3. The freight rate data trimming method according to claim 2, characterized in that, After traversing the waiting area data, the following is also included: Check if the data in the waiting area has already been published. If it has, delete the data in the waiting area.

4. The freight rate data trimming method according to claim 1, characterized in that, Storing the data within the publishing area into a file includes: The data in the published area is stored in a file in ATPCO text format.

5. A freight rate data clipping device, characterized in that, Applied to freight rate calculation systems, the methods include: The data acquisition unit is used to acquire raw fare data, which includes: a flight owner data frame and a fare owner data frame. The data deletion unit is used to delete data in the flight owner data frame that is outside the flight owner clipping range; and to delete data in the fare owner data frame that is outside the fare owner clipping range. The data processing unit is used to store the remaining non-airline data in the publishing area; store the remaining explicit airline data in the explicit airline data queue in the unpublished area; store the remaining implicit airline data in the implicit airline data index directory in the unpublished area; traverse the unpublished data and migrate the unpublished data to the publishing area or the waiting area; and store the data in the publishing area in a file, which is then published as a trimmed data file to the data preprocessing module of the fare calculation system. Specifically, when the data processing unit traverses unpublished data and migrates it to the publishing area or waiting area, it is used for: Traverse the queue of explicit airline data in the unpublished area to obtain one explicit airline data entry; Obtain the type and primary key number of the associated implicit airline data corresponding to the explicit airline data; Insert the type and primary key number of the implicit airline data into the waiting area; Move the explicit airline data from the unpublished area to the published area.

6. The freight rate data trimming device according to claim 5, characterized in that, After the data processing unit has completed traversing the explicit airline data in the unpublished area, it is also used for: Iterate through the data in the waiting area; Based on the waiting area data obtained through traversal, the target data is searched in the implicit airline data queue in the unpublished area. If the target data is found, delete the data in the waiting area that has been traversed; Obtain the type and primary key number of the associated implicit airline data corresponding to the target data and insert it into the waiting area; Move the target data from the unpublished area to the published area.

7. The freight rate data trimming device according to claim 5, characterized in that, After traversing the data in the waiting area, the data processing unit is also used for: Check if the data in the waiting area has already been published. If it has, delete the data in the waiting area.

8. A freight rate cutting device, characterized in that, The equipment used in the freight rate calculation system includes: Memory and processor; The memory is used to store programs; The processor is configured to execute the program to achieve: Obtain the raw fare data, which includes: a flight owner data frame and a fare owner data frame; Delete the data in the flight owner data frame that is outside the flight owner clipping range; Delete the data in the fare owner data frame that is outside the fare owner clipping range; Store the remaining non-airline data in the publishing area; Store the remaining explicit airline data in the unpublished area; The remaining implicit airline data will be stored in the unpublished area; Iterate through the unpublished data and migrate it to the publishing area or the waiting area; The data in the publishing area is stored in a file and published as a cropped data file to the data preprocessing module of the fare calculation system. The step of traversing unpublished data and migrating it to the publishing area or waiting area includes: Traverse the queue of explicit airline data in the unpublished area to obtain one explicit airline data entry; Obtain the type and primary key number of the associated implicit airline data corresponding to the explicit airline data; Insert the type and primary key number of the implicit airline data into the waiting area; Move the explicit airline data from the unpublished area to the published area.

Images