Unified storage method for published freight rate and private freight rate and related equipment

Abstract

The embodiment of the invention provides a unified storage method for published freight rates and private freight rates and related equipment, and relates to the technical field of aviation data processing.The method comprises the steps that all published freight rate data sets and all private freight rate data sets to be imported are obtained, each published freight rate data set and each private freight rate data set which are subjected to the storage format conversion operation are imported into an initial general freight rate table to obtain a general freight rate table, the general freight rate table is stored, and the storage format conversion operation executed on each published freight rate data set is stored in the general freight rate table; the published freight rate data processed through the storage format conversion operation meets the storage format requirement of the initial general freight rate table, and the storage format requirement of the initial general freight rate table is consistent with the storage format requirement of the private freight rate data set. According to the invention, the framework complexity of the freight rate release system is reduced, and the service execution efficiency of the freight rate calculation system is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of aviation data processing, and in particular to a unified storage method for published freight rates and private freight rates and related equipment. Background Art

[0002] There are two main types of existing flight fares: one is the published fare, which is the fare that can be sold by all sales channels, and the other is the private fare, which is the fare that can only be sold by specific sales channels. When calculating the fare, the fare calculation system needs to obtain both the published fare and the private fare from the fare publishing system to solve the optimal fare.

[0003] However, since the published freight rate data is stored in the form of key values, while the private freight rate data is stored in the form of protocol files, there are significant differences in the data management methods of the two types of freight rate data. This requires the existing freight rate publishing system to establish storage architectures for the two types of freight rates, and to build interactive interfaces between the two storage architectures and the freight rate calculation system. This not only increases the complexity of the system architecture and the cost of subsequent system upgrades and maintenance, but also requires the configuration of repeated data acquisition logic in the business logic of the freight rate calculation system, reducing the business execution efficiency of the freight rate calculation system. Summary of the invention

[0004] The purpose of the embodiment of the present invention is to provide a unified storage method and related equipment for published freight rates and private freight rates, so as to reduce the architectural complexity of the freight rate publishing system and improve the business execution efficiency of the freight rate calculation system. The specific technical solution is as follows:

[0005] A unified storage method for published freight rates and private freight rates, the method comprising:

[0006] Obtaining each published freight rate data set and each private freight rate data set to be imported;

[0007] performing a storage format conversion operation on each of the published freight rate data sets, and importing each of the published freight rate data sets and each of the private freight rate data sets that have undergone the storage format conversion operation into an initial universal freight rate table to obtain a universal freight rate table, and storing the universal freight rate table,

[0008] Wherein, the storage format conversion operation performed on each published freight rate data set includes: according to the format conversion type of each published freight rate data in the published freight rate data set, performing the corresponding storage format conversion operation on each published freight rate data, so that the published freight rate data processed by the storage format conversion operation meets the storage format requirement of the initial universal freight rate table, the storage format conversion operation and the format conversion type have a corresponding relationship, and the storage format requirement of the initial universal freight rate table is consistent with the storage format requirement of the private freight rate data set.

[0009] Optionally, the format conversion type includes: converting a virtual code string and converting a real freight rate, and the storage format conversion operation corresponding to each published freight rate data is performed on each published freight rate data according to the format conversion type of each published freight rate data set, including:

[0010] In the case where the format conversion type is the conversion virtual coding string, character string recognition is performed on the published freight rate data to obtain a character string to be encoded; a preset encoding script is called to generate a virtual coding string based on the character string to be encoded, and the content of the published freight rate data is updated to the virtual coding string;

[0011] When the format conversion type is the conversion of the real freight rate, character string recognition is performed on the published freight rate data to obtain the basic freight rate and the discount ratio in the published freight rate data, and the content of the published freight rate data is updated to the product of the basic freight rate and the discount ratio.

[0012] Optionally, the method further includes:

[0013] Before updating the content of the published freight rate data to the virtual code string, a first mapping relationship between the unupdated published freight rate data and the virtual code string is established, and the first mapping relationship and the identifier of the initial universal freight rate table are associated and stored in a preset mapping relationship table.

[0014] Optionally, the method further includes:

[0015] Before updating the content of the published freight rate data to the product, a second mapping relationship among the published freight rate data, the basic freight rate in the published freight rate data and the product is established, and the second mapping relationship and the identifier of the initial universal freight rate table are associated and stored in a preset mapping relationship table.

[0016] Optionally, the method further includes:

[0017] When receiving a published freight rate update request, searching the preset mapping relationship table for the virtual code string having the first mapping relationship with the published freight rate data to be updated according to the published freight rate data to be updated in the published freight rate update request;

[0018] The identifier of the initial universal freight rate table associated with the first mapping relationship is searched, and a published freight rate update operation is performed based on the searched identifier of the initial universal freight rate table, the virtual code string and the published freight rate data to be updated.

[0019] Optionally, the method further includes:

[0020] When receiving a published freight rate update request, searching the preset mapping relationship table for the product having the second mapping relationship with the published freight rate data to be updated according to the published freight rate data to be updated in the published freight rate update request;

[0021] The identifier of the initial universal freight rate table associated with the second mapping relationship is searched, and the published freight rate update operation is performed based on the searched identifier of the initial universal freight rate table, the basic freight rate in the published freight rate data to be updated, and the published freight rate data to be updated.

[0022] Optionally, after performing the storage format conversion operation corresponding to each of the published freight rate data, the method further includes:

[0023] A label containing the published freight rate is added to each of the published freight rate data after the storage format conversion operation.

[0024] A unified storage system for published freight rates and private freight rates, the system comprising:

[0025] A data acquisition module, used to obtain various published freight rate data sets and various private freight rate data sets to be imported;

[0026] a conversion storage module, configured to perform a storage format conversion operation on each of the published freight rate data sets, and import each of the published freight rate data sets and each of the private freight rate data sets that have undergone the storage format conversion operation into an initial universal freight rate table, obtain a universal freight rate table, and store the universal freight rate table,

[0027] Wherein, the storage format conversion operation performed on each published freight rate data set includes: according to the format conversion type of each published freight rate data in the published freight rate data set, performing the corresponding storage format conversion operation on each published freight rate data, so that the published freight rate data processed by the storage format conversion operation meets the storage format requirement of the initial universal freight rate table, the storage format conversion operation and the format conversion type have a corresponding relationship, and the storage format requirement of the initial universal freight rate table is consistent with the storage format requirement of the private freight rate data set.

[0028] Optionally, the format conversion type includes: converting a virtual code string and converting a real freight rate, and the conversion storage module is set to:

[0029] In the case where the format conversion type is the conversion virtual coding string, character string recognition is performed on the published freight rate data to obtain a character string to be encoded; a preset encoding script is called to generate a virtual coding string based on the character string to be encoded, and the content of the published freight rate data is updated to the virtual coding string;

[0030] When the format conversion type is the conversion of the real freight rate, character string recognition is performed on the published freight rate data to obtain the basic freight rate and the discount ratio in the published freight rate data, and the content of the published freight rate data is updated to the product of the basic freight rate and the discount ratio.

[0031] Optionally, the system further includes:

[0032] The first mapping establishment module is used to establish a first mapping relationship between the unupdated published freight rate data and the virtual code string before updating the content of the published freight rate data to the virtual code string, and associate the first mapping relationship with the identifier of the initial universal freight rate table and store it in a preset mapping relationship table.

[0033] Optionally, the system further includes:

[0034] The second mapping establishment module is used to establish a second mapping relationship between the published freight rate data, the basic freight rate in the published freight rate data and the product before updating the content of the published freight rate data to the product, and associate the second mapping relationship with the identifier of the initial universal freight rate table and store it in a preset mapping relationship table.

[0035] Optionally, the system further includes:

[0036] A first freight rate updating module is used for searching the virtual code string having the first mapping relationship with the published freight rate data to be updated from the preset mapping relationship table according to the published freight rate data to be updated in the published freight rate update request when receiving the published freight rate update request;

[0037] The identifier of the initial universal freight rate table associated with the first mapping relationship is searched, and a published freight rate update operation is performed based on the searched identifier of the initial universal freight rate table, the virtual code string and the published freight rate data to be updated.

[0038] Optionally, the system further includes:

[0039] A second freight rate updating module is used for searching the product having the second mapping relationship with the published freight rate data to be updated from the preset mapping relationship table according to the published freight rate data to be updated in the published freight rate update request when receiving the published freight rate update request;

[0040] The identifier of the initial universal freight rate table associated with the second mapping relationship is searched, and the published freight rate update operation is performed based on the searched identifier of the initial universal freight rate table, the basic freight rate in the published freight rate data to be updated, and the published freight rate data to be updated.

[0041] Optionally, after performing the storage format conversion operation corresponding to each of the published freight rate data, the system further includes:

[0042] The label adding module is used to add a label with the content of the published freight rate to each of the published freight rate data after the storage format conversion operation.

[0043] A unified storage device for published freight rates and private freight rates, the storage device comprising:

[0044] processor;

[0045] a memory for storing instructions executable by the processor;

[0046] The processor is configured to execute the instructions to implement the unified storage method of the published freight rates and private freight rates as described in any one of the above.

[0047] A computer-readable storage medium, when the instructions in the computer-readable storage medium are executed by a processor of a unified storage device for published freight rates and private freight rates, enables the unified storage device for published freight rates and private freight rates to execute any of the above-mentioned unified storage methods for published freight rates and private freight rates.

[0048] The embodiment of the present invention provides a unified storage method and related equipment for published freight rates and private freight rates. By performing corresponding storage format conversion operations on each published freight rate data in the published freight rate data set according to its format conversion type, the published freight rate data meet the storage format requirements of the initial general freight rate table. And each published freight rate data set and each private freight rate data set that have undergone the storage format conversion operation are imported into the initial general freight rate table to obtain a general freight rate table, thereby realizing the unified storage of the published freight rate data and the private freight rate data without the need to construct storage architectures separately. Due to the unified storage of the published freight rate data and the private freight rate data, the freight rate calculation system does not need to execute repeated data acquisition logic, and only one general freight rate table is obtained to obtain the published freight rate data and the private freight rate data, thereby improving the business execution efficiency of the freight rate calculation system. It can be seen that the present invention improves the business execution efficiency of the freight rate calculation system while reducing the architectural complexity of the freight rate publishing system.

[0049] Of course, it is not necessary to achieve all of the advantages described above at the same time to implement any product or method of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0050] The above and other features, advantages and aspects of the embodiments of the present disclosure will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings. Throughout the accompanying drawings, the same or similar reference numerals represent the same or similar elements. It should be understood that the drawings are schematic and the originals and elements are not necessarily drawn to scale.

[0051] Figure 1 A flowchart of a unified storage method for published freight rates and private freight rates provided by an embodiment of the present invention;

[0052] Figure 2 A block diagram of a unified storage system for published freight rates and private freight rates provided by an embodiment of the present invention;

[0053] Figure 3 A block diagram of a unified storage device for published freight rates and private freight rates provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0054] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be construed as being limited to the embodiments described herein, which are instead provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are only for exemplary purposes and are not intended to limit the scope of protection of the present disclosure.

[0055] The term "including" and its variations used herein are open inclusions, i.e., "including but not limited to". The term "based on" means "based at least in part on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". The relevant definitions of other terms will be given in the following description.

[0056] It should be noted that the concepts such as "first" and "second" mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0057] It should be noted that the modifications of "one" and "plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".

[0058] The embodiment of the present invention provides a unified storage method for published freight rates and private freight rates, such as Figure 1 As shown, the unified storage method of the published freight rates and private freight rates includes:

[0059] S101. Obtaining each published freight rate data set and each private freight rate data set to be imported.

[0060] It should be noted that, in actual application scenarios, the above-mentioned published fare data set can be a collection of published fare data received by the fare publishing system and approved by the upstream review system. The above-mentioned private fare data set is a collection of private fare data received by the fare publishing system and sent by the airline's fare management system or private fare front end. Among them, the published fare data of the above-mentioned published fare data set is data in the form of key value, and the above-mentioned private fare data is data in the form of protocol file.

[0061] S102, performing a storage format conversion operation on each published freight rate data set, and importing each published freight rate data set and each private freight rate data set that have undergone the storage format conversion operation into an initial universal freight rate table, obtaining a universal freight rate table, and storing the universal freight rate table,

[0062] The storage format conversion operation performed on each published freight rate data set includes: performing corresponding storage format conversion operations on each published freight rate data according to the format conversion type of each published freight rate data in the published freight rate data set, so that the published freight rate data processed by the storage format conversion operation meets the storage format requirements of the initial general freight rate table, the storage format conversion operation and the format conversion type have a corresponding relationship, and the storage format requirements of the initial general freight rate table are consistent with the storage format requirements of the private freight rate data set.

[0063] It should be noted that, in actual application scenarios, since the existing published freight rate data are mostly stored in relational databases in the form of key values, the data storage format in the form of key values ​​is prone to data consistency problems, thereby affecting the calculation accuracy of subsequent freight rate data. The above-mentioned private freight rate data exists in the form of a protocol file, which will not cause data consistency problems. Therefore, the present invention configures the storage format requirements of the initial general freight rate table to be consistent with the storage format requirements of the private freight rate data set, and performs a storage format conversion operation on the published freight rate data set, so that the published freight rate data processed by the storage format conversion operation meets the storage format requirements of the initial general freight rate table, thereby avoiding data consistency problems caused by the key value form of the published freight rate data.

[0064] Optionally, in an optional embodiment of the present invention, when searching for published freight rates and private freight rates, the existing freight rate calculation system needs to send index conditions of the published freight rates and private freight rates to the freight rate publishing system respectively. However, by obtaining a universal freight rate table storing the published freight rate data set and the private freight rate data set, when searching for freight rates, it is only necessary to search for the private freight rate with the search conditions, and the private freight rate and the published freight rate associated therewith can be obtained, thereby improving the freight rate search efficiency of the freight rate calculation system.

[0065] The present invention performs corresponding storage format conversion operations on each published freight data in the published freight data set according to its format conversion type, so that the published freight data meets the storage format requirements of the initial general freight table. And each published freight data set and each private freight data set that have undergone the storage format conversion operation are imported into the initial general freight table to obtain a general freight table, thereby realizing the unified storage of the published freight data and the private freight data, without the need to construct storage architectures separately. Due to the unified storage of the published freight data and the private freight data, the freight calculation system does not need to execute repeated data acquisition logic, and only one general freight table is required to obtain the published freight data and the private freight data, thereby improving the business execution efficiency of the freight calculation system. It can be seen that the present invention improves the business execution efficiency of the freight calculation system while reducing the architectural complexity of the freight publishing system.

[0066] Optionally, the format conversion type includes: converting a virtual code string and converting a real freight rate. According to the format conversion type of each published freight rate data in the published freight rate data set, performing the corresponding storage format conversion operation on each published freight rate data, including:

[0067] When the format conversion type is to convert a virtual coding string, character string recognition is performed on the published freight rate data to obtain a character string to be encoded; a preset encoding script is called to generate a virtual coding string based on the character string to be encoded, and the content of the published freight rate data is updated to the virtual coding string;

[0068] When the format conversion type is to convert the real freight rate, character string recognition is performed on the published freight rate data to obtain the basic freight rate and discount ratio in the published freight rate data, and the content of the published freight rate data is updated to the product of the basic freight rate and the discount ratio.

[0069] It should be noted that, in actual application scenarios, the above-mentioned character string to be encoded may be a character string used for freight rate calculation in the above-mentioned published freight rate data. The present invention generates a virtual coding string based on the character string to be encoded by calling a preset coding script, and generates a virtual coding string that uniquely identifies a piece of published freight rate data, so that the freight rate calculation system can perform freight rate calculation based on the virtual coding string without modifying the published freight rate data.

[0070] Optionally, in another optional embodiment of the present invention, the above-mentioned format conversion type may include, in addition to the above-mentioned conversion of the virtual code string and the conversion of the real fare, the conversion of the fare generation date. Because the existing fare publishing system publishes the fare data with the date accurate to the natural day. Since the private fare data is published by the airlines themselves, there are cases where it is published multiple times in one day, so the release date of the private fare data will be accurate to the second. Therefore, by integrating the format of the generation date of the above-mentioned published fare data with the private fare data, the fare calculation system does not need to configure additional parsing rules for the generation date of the published fare data.

[0071] It should be noted that, in actual application scenarios, in order for the freight rate calculation system to recognize the above virtual coding string, it is necessary to configure the coding rules in the above preset coding script in the freight rate calculation system. The above coding rules can be set according to the actual application scenario, and the present invention does not make too many restrictions and redundant descriptions on this.

[0072] It should be noted that, in actual application scenarios, the above-mentioned published freight rate data and the above-mentioned private freight rate data include data in the same format, such as: flight segment identifier, data source identifier (such as airline identifier), service level identifier, cabin identifier, flight type, etc. For the above-mentioned data in the same format, it is not necessary to perform the above-mentioned storage format conversion operation, and it can be directly imported into the storage location of the corresponding freight rate data in the general freight rate table.

[0073] It can be understood by those skilled in the art that, in actual application scenarios, published freight rate data can be divided into normal freight rates and special freight rates, wherein the special freight rate is a discounted freight rate based on the normal freight rate (the normal freight rate is the base freight rate of the special freight rate). In the prior art, when publishing and calculating special freight rates, the freight rate publishing system usually publishes them in the form of discounts. For example, the freight rate for cabin Y is 1,575 yuan, and the freight rate for cabin B is 8.5% of that for cabin Y. Then the freight rate for cabin B is a special freight rate, and its publication form is cabin Y*0.85. Since this special freight rate can also be used as the base freight rate for other special freight rates, the publication form of the freight rate based on this special freight rate is cabin Y*0.85*A discount*B discount*…**N discount. In addition, since the actual freight rates used for sales will be calculated by rounding, this will cause the calculated values ​​of the above-mentioned other special freight rates to deviate greatly from the actual values. Therefore, the present invention updates the content of the published freight rate data to the product of the basic freight rate and the discount ratio through configuration to store the actual calculation results of each special freight rate, thereby avoiding the risk of distortion of the calculation results of the freight rate due to cumulative multiplication of discounts.

[0074] Optional, as above Figure 1 The unified storage method for published freight rates and private freight rates shown also includes:

[0075] Before updating the content of the published freight rate data to the virtual code string, a first mapping relationship between the unupdated published freight rate data and the virtual code string is established, and the first mapping relationship and the identifier of the initial universal freight rate table are associated and stored in the preset mapping relationship table.

[0076] Optional, as above Figure 1 The unified storage method for published freight rates and private freight rates shown also includes:

[0077] Before updating the content of the published freight rate data to the product, a second mapping relationship among the published freight rate data, the basic freight rate in the published freight rate data and the product is established, and the second mapping relationship and the identifier of the initial universal freight rate table are associated and stored in the preset mapping relationship table.

[0078] It should be noted that, in actual application scenarios, since the published freight rate data is the freight rate data that can be sold by all sales channels, it is unique. Therefore, before the updated target published freight rate data is published, it is necessary to cut off the target published freight rate data that has not been updated in the freight rate publishing system, so as to avoid publishing two published freight rate data for the same route at the same time. By constructing the above-mentioned preset mapping relationship table, the present invention can find the identifier of the corresponding initial general freight rate table based on the mapping relationship in the above-mentioned preset mapping relationship table when it is necessary to update the published freight rate data, thereby updating the published freight rate data imported into the above-mentioned initial general freight rate table.

[0079] Optional, as above Figure 1 The unified storage method for published freight rates and private freight rates shown also includes:

[0080] When receiving a published freight rate update request, searching a preset mapping relationship table for a virtual code string having a first mapping relationship with the published freight rate data to be updated according to the published freight rate data to be updated in the published freight rate update request;

[0081] The identifier of the initial universal freight rate table associated with the first mapping relationship is searched, and a published freight rate update operation is performed based on the found identifier of the initial universal freight rate table, the virtual code string, and the published freight rate data to be updated.

[0082] Optional, as above Figure 1 The unified storage method for published freight rates and private freight rates shown also includes:

[0083] When receiving a published freight rate update request, searching a preset mapping relationship table for a product having a second mapping relationship with the published freight rate data to be updated according to the published freight rate data to be updated in the published freight rate update request;

[0084] The identifier of the initial universal freight rate table associated with the second mapping relationship is searched, and the published freight rate update operation is performed based on the found identifier of the initial universal freight rate table, the basic freight rate in the published freight rate data to be updated, and the published freight rate data to be updated.

[0085] It should be noted that in actual application scenarios, there are many implementation methods for the above-mentioned operation of publishing and updating freight rates, and an exemplary implementation method is provided here:

[0086] Assume that the published freight rate data to be updated in the current published freight rate update request has a virtual code string having the above-mentioned first mapping relationship.

[0087] First, based on the published fare data to be updated and the first mapping relationship in which it is located, the identifier of at least one initial universal fare table associated with the first mapping relationship is searched from the preset mapping relationship table to obtain the universal fare table storing the published fare data to be updated. Among them, the identifier of an initial universal fare table corresponds to one universal fare table.

[0088] Subsequently, a storage format conversion operation is performed on the updated published freight rate data in the current published freight rate update request, and the content of the published freight rate data to be updated in the above-mentioned general freight rate table is updated to the updated published freight rate data that has undergone the above-mentioned storage format conversion operation, so as to complete the above-mentioned published freight rate update operation.

[0089] Optionally, after performing the storage format conversion operations corresponding to each published freight rate data, the method further includes:

[0090] A label containing the published freight rate is added to each published freight rate data after the storage format conversion operation.

[0091] It should be noted that in actual scenarios, since the formats of published freight rate data and private freight rate data stored in the general freight rate table are the same, in order to facilitate the calculation of the freight rate calculation system and accurate distinction during inquiries at the sales front end, it is necessary to add the above content to the published freight rate data as a label of the published freight rate, thereby avoiding the risk of freight rate calculation errors or sales front-end query errors.

[0092] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present disclosure. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some implementations as replacements, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0093] The names of the messages or information exchanged between multiple devices in the embodiments of the present disclosure are only used for illustrative purposes and are not used to limit the scope of these messages or information.

[0094] Although operations are depicted in a particular order, this should not be understood as requiring that the operations be performed in the particular order shown or in a sequential order.Multitasking and parallel processing may be advantageous under certain circumstances.

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

[0096] Computer program code for performing the operations of the present disclosure may 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, C++, and conventional procedural programming languages, such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate 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 a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., through the Internet using an Internet service provider).

[0097] Corresponding to the above method embodiment, the present invention also provides a unified storage system for published freight rates and private freight rates, such as Figure 2 As shown, the unified storage system for published freight rates and private freight rates includes:

[0098] The data acquisition module 201 is used to obtain each published freight rate data set and each private freight rate data set to be imported;

[0099] The conversion storage module 202 is used to perform storage format conversion operations on each published freight rate data set, and import each published freight rate data set and each private freight rate data set that have undergone storage format conversion operations into an initial universal freight rate table to obtain a universal freight rate table, and store the universal freight rate table.

[0100] The storage format conversion operation performed on each published freight rate data set includes: performing corresponding storage format conversion operations on each published freight rate data according to the format conversion type of each published freight rate data in the published freight rate data set, so that the published freight rate data processed by the storage format conversion operation meets the storage format requirements of the initial general freight rate table, the storage format conversion operation and the format conversion type have a corresponding relationship, and the storage format requirements of the initial general freight rate table are consistent with the storage format requirements of the private freight rate data set.

[0101] Optionally, the format conversion type includes: converting a virtual code string and converting a real freight rate. The conversion storage module 202 is set to:

[0102] When the format conversion type is to convert a virtual coding string, character string recognition is performed on the published freight rate data to obtain a character string to be encoded; a preset encoding script is called to generate a virtual coding string based on the character string to be encoded, and the content of the published freight rate data is updated to the virtual coding string;

[0103] When the format conversion type is to convert the real freight rate, character string recognition is performed on the published freight rate data to obtain the basic freight rate and discount ratio in the published freight rate data, and the content of the published freight rate data is updated to the product of the basic freight rate and the discount ratio.

[0104] Optional, as above Figure 2 The unified storage system for published freight rates and private freight rates shown also includes:

[0105] The first mapping establishment module is used to establish a first mapping relationship between the unupdated published freight rate data and the virtual code string before updating the content of the published freight rate data to the virtual code string, and associate the first mapping relationship with the identifier of the initial universal freight rate table and store it in a preset mapping relationship table.

[0106] Optional, as above Figure 2 The unified storage system for published freight rates and private freight rates shown also includes:

[0107] The second mapping establishment module is used to establish a second mapping relationship between the published freight rate data, the basic freight rate in the published freight rate data and the product before updating the content of the published freight rate data to the product, and associate the second mapping relationship with the identifier of the initial general freight rate table and store it in the preset mapping relationship table.

[0108] Optional, as above Figure 2 The unified storage system for published freight rates and private freight rates shown also includes:

[0109] A first freight rate updating module is used to search a virtual code string having a first mapping relationship with the published freight rate data to be updated from a preset mapping relationship table according to the published freight rate data to be updated in the published freight rate update request when a published freight rate update request is received;

[0110] The identifier of the initial universal freight rate table associated with the first mapping relationship is searched, and a published freight rate update operation is performed based on the found identifier of the initial universal freight rate table, the virtual code string, and the published freight rate data to be updated.

[0111] Optional, as above Figure 2 The unified storage system for published freight rates and private freight rates shown also includes:

[0112] A second freight rate updating module is used to search for a product having a second mapping relationship with the published freight rate data to be updated from a preset mapping relationship table according to the published freight rate data to be updated in the published freight rate update request when a published freight rate update request is received;

[0113] The identifier of the initial universal freight rate table associated with the second mapping relationship is searched, and the published freight rate update operation is performed based on the found identifier of the initial universal freight rate table, the basic freight rate in the published freight rate data to be updated, and the published freight rate data to be updated.

[0114] Optionally, after performing the storage format conversion operation corresponding to each published freight rate data, the above Figure 2 The unified storage system for published freight rates and private freight rates shown also includes:

[0115] The label adding module is used to add a label with the content of the published freight rate to each published freight rate data after the storage format conversion operation.

[0116] The functions described above herein may be performed at least in part by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), and the like.

[0117] The embodiment of the present invention also provides a unified storage device for published freight rates and private freight rates, such as Figure 3 As shown, the unified storage device for the published freight rates and private freight rates includes:

[0118] Processor 301;

[0119] A memory 302 for storing instructions executable by the processor 301;

[0120] The processor 301 is configured to execute instructions to implement any of the above-mentioned unified storage methods for published freight rates and private freight rates.

[0121] An embodiment of the present invention also provides a computer-readable storage medium. When the instructions in the computer-readable storage medium are executed by a processor of a unified storage device for published freight rates and private freight rates, the unified storage device for published freight rates and private freight rates can execute any of the above-mentioned unified storage methods for published freight rates and private freight rates.

[0122] In the context of the present disclosure, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or equipment, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0123] It should be noted that the computer-readable medium disclosed above may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program that may be used by or in combination with an instruction execution system, device or device. In the present disclosure, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, in which a computer-readable program code is carried. This propagated data signal may take a variety of forms, including but not limited to an electromagnetic signal, an optical signal, or any suitable combination of the above. The computer readable signal medium may also be any computer readable medium other than a computer readable storage medium, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer readable medium may be transmitted using any suitable medium, including but not limited to: wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.

[0124] The computer-readable medium may be included in the electronic device, or may exist independently without being incorporated into the electronic device.

[0125] Although the subject matter has been described in language specific to structural features and / or methodological logical actions, 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. On the contrary, the specific features and actions described above are merely example forms of implementing the claims.

[0126] Although several specific implementation details are included in the above discussion, these should not be interpreted as limiting the scope of the present disclosure. Certain features described in the context of a separate embodiment can also be implemented in a single embodiment in combination. On the contrary, the various features described in the context of a single embodiment can also be implemented in multiple embodiments individually or in any suitable sub-combination.

[0127] The above description is only a preferred embodiment of the present disclosure and an explanation of the technical principles used. Those skilled in the art should understand that the scope of disclosure involved in the present disclosure is not limited to the technical solutions formed by a specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above disclosed concept. For example, the above features are replaced with the technical features with similar functions disclosed in the present disclosure (but not limited to) by each other to form a technical solution.

Claims

1. A unified storage method for published and private freight rates, It is characterized in that The method comprises: Obtaining each published freight rate data set and each private freight rate data set to be imported; performing a storage format conversion operation on each of the published freight rate data sets, and importing each of the published freight rate data sets and each of the private freight rate data sets that have undergone the storage format conversion operation into an initial universal freight rate table to obtain a universal freight rate table, and storing the universal freight rate table, Wherein, the storage format conversion operation performed on each published freight rate data set includes: according to the format conversion type of each published freight rate data in the published freight rate data set, performing the corresponding storage format conversion operation on each published freight rate data, so that the published freight rate data processed by the storage format conversion operation meets the storage format requirement of the initial universal freight rate table, the storage format conversion operation and the format conversion type have a corresponding relationship, and the storage format requirement of the initial universal freight rate table is consistent with the storage format requirement of the private freight rate data set.

2. The method according to claim 1, It is characterized in that The format conversion types include: converting virtual code strings and converting real freight rates. The format conversion types of each published freight rate data in the published freight rate data set are used to perform the storage format conversion operations corresponding to each of the published freight rate data, including: In the case where the format conversion type is the conversion virtual coding string, character string recognition is performed on the published freight rate data to obtain a character string to be encoded; a preset encoding script is called to generate a virtual coding string based on the character string to be encoded, and the content of the published freight rate data is updated to the virtual coding string; When the format conversion type is the conversion of the real freight rate, character string recognition is performed on the published freight rate data to obtain the basic freight rate and the discount ratio in the published freight rate data, and the content of the published freight rate data is updated to the product of the basic freight rate and the discount ratio.

3. The method according to claim 2, It is characterized in that The method further comprises: Before updating the content of the published freight rate data to the virtual code string, a first mapping relationship between the unupdated published freight rate data and the virtual code string is established, and the first mapping relationship and the identifier of the initial universal freight rate table are associated and stored in a preset mapping relationship table.

4. The method according to claim 2, It is characterized in that The method further comprises: Before updating the content of the published freight rate data to the product, a second mapping relationship among the published freight rate data, the basic freight rate in the published freight rate data and the product is established, and the second mapping relationship and the identifier of the initial universal freight rate table are associated and stored in a preset mapping relationship table.

5. The method according to claim 3, It is characterized in that The method further comprises: When receiving a published freight rate update request, searching the preset mapping relationship table for the virtual code string having the first mapping relationship with the published freight rate data to be updated according to the published freight rate data to be updated in the published freight rate update request; The identifier of the initial universal freight rate table associated with the first mapping relationship is searched, and a published freight rate update operation is performed based on the searched identifier of the initial universal freight rate table, the virtual code string and the published freight rate data to be updated.

6. The method according to claim 4, It is characterized in that The method further comprises: When receiving a published freight rate update request, searching the preset mapping relationship table for the product having the second mapping relationship with the published freight rate data to be updated according to the published freight rate data to be updated in the published freight rate update request; The identifier of the initial universal freight rate table associated with the second mapping relationship is searched, and the published freight rate update operation is performed based on the searched identifier of the initial universal freight rate table, the basic freight rate in the published freight rate data to be updated, and the published freight rate data to be updated.

7. The method according to claim 1, It is characterized in that After performing the storage format conversion operations corresponding to the respective published freight rate data, the method further includes: A label containing the published freight rate is added to each of the published freight rate data after the storage format conversion operation.

8. A unified storage system for published and private freight rates, It is characterized in that The system comprises: A data acquisition module, used to obtain various published freight rate data sets and various private freight rate data sets to be imported; a conversion storage module, configured to perform a storage format conversion operation on each of the published freight rate data sets, and import each of the published freight rate data sets and each of the private freight rate data sets that have undergone the storage format conversion operation into an initial universal freight rate table, obtain a universal freight rate table, and store the universal freight rate table, Wherein, the storage format conversion operation performed on each published freight rate data set includes: according to the format conversion type of each published freight rate data in the published freight rate data set, performing the corresponding storage format conversion operation on each published freight rate data, so that the published freight rate data processed by the storage format conversion operation meets the storage format requirement of the initial universal freight rate table, the storage format conversion operation and the format conversion type have a corresponding relationship, and the storage format requirement of the initial universal freight rate table is consistent with the storage format requirement of the private freight rate data set.

9. A unified storage device for published and private freight rates, It is characterized in that The storage device comprises: processor; a memory for storing instructions executable by the processor; The processor is configured to execute the instructions to implement the unified storage method for published freight rates and private freight rates according to any one of claims 1 to 7.

10. A computer-readable storage medium, It is characterized in that When the instructions in the computer-readable storage medium are executed by a processor of a unified storage device for published freight rates and private freight rates, the unified storage device for published freight rates and private freight rates is enabled to execute the unified storage method for published freight rates and private freight rates as described in any one of claims 1 to 7.

Images