International freight rate search processing multi-OFFICE query method, system and device and medium
By pre-grouping and re-grouping of multiple OFFICE query requests, and selecting representative office for logical verification and calculation, the calculation pressure problem of the international freight search system during multiple OFFICE query is solved, and system performance and resource utilization are improved.
Patent Information
- Application Number
- CN202411897390.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-20
- Publication Date
- 2025-08-15
AI Technical Summary
When the existing international freight search system handles multiple OFFICE query requests, the calculation pressure is too high, which affects the processing time and leads to poor customer experience.
Through the pre-grouping and re-grouping methods, based on the office information and RS1 data content, select the representative office for logical verification and calculation, reduce repeated operations, and merge the same calculation results.
It significantly reduces the system's computing volume, improves processing performance, optimizes the processing capacity of international freight search engines, and improves system resource utilization.
Smart Images

Figure CN120492711A_ABST
Abstract
Description
Technical Field
[0001] The present disclosure belongs to the technical field of freight rate search, and in particular relates to a method, system, device and medium for international freight rate search and multi-OFFICE query processing. Background Art
[0002] With the widespread use of the internet and the rapid development of digital technology, people can generate and access information through a variety of channels, such as the internet and mobile devices. With the continuous growth of economic, political, tourism, and communication needs, the demand for international routes is also rapidly increasing. International freight rate search systems serve as internet-based intermediaries between airlines and users, providing services to both airlines and customers. This also places high demands on the performance of international freight rate search systems.
[0003] Office information (the identity of the requester; when initiating a shopping query, the requester must send this office information as part of the request to the shopping service. Office information is part of the customer's identity and also forms part of the basic data for the international freight rate search system. Office information affects the AV information, freight rates, and rules information that the customer can access). As part of the customer's identity, this information is essential when a customer initiates an international freight rate search request. The office also forms part of the basic data for the international freight rate search system. Different flight information, cabin space information, freight rates, and rules information may be sent to different offices. Therefore, when a customer initiates an international freight rate search request, passing different offices will result in different query results.
[0004] To obtain diverse results and the lowest possible prices, and thus profit from the sales process, agents typically submit multiple office numbers for multi-office queries when initiating international freight rate search requests.
[0005] As an international freight rate search engine, when receiving a customer's multi-office request (mostly seen in agent requests; a shopping request initiated by an agent containing information about more than one office is considered a multi-office request), according to traditional processing logic, it is necessary to perform a separate and complete search logic for each office number in the customer's request. This causes excessive pressure on the engine, seriously affecting processing time, and also brings a poor experience to customers.
[0006] Therefore, it is necessary to provide a new international freight rate search and processing multi-OFFICE query method, system, device and medium to solve the above technical problems. Summary of the Invention
[0007] The purpose of the present disclosure is to provide a method, system, device and medium for searching and processing multi-OFFICE queries for international freight rates in order to solve the above problems.
[0008] The present disclosure achieves the above objectives through the following technical solutions:
[0009] A method for searching and processing multi-OFFICE queries for international freight rates includes the following steps:
[0010] Determine whether the request entered by the user is a multi-office request. If so, pre-group it.
[0011] Regroup the pre-grouping results based on the RS1 data content related to office information in the inspection rules, and group offices with consistent rules into one group;
[0012] Take the first office from each group as the representative office of the current group for logical verification and calculation;
[0013] Merge different office groups with the same calculation results.
[0014] As a further optimization solution of the present disclosure, before determining whether the request input by the user is a multi-office request, it is necessary to deduplicate the request input by the user.
[0015] As a further optimization solution of the present disclosure, determining whether the request input by the user is a multi-office request, and if so, pre-grouping includes:
[0016] Determine the number of offices in the request. If the number of offices is greater than 1, group the offices together. Otherwise, do not group the offices together.
[0017] Analyze each office information in the user request and use the channel, POS country code, and key customer code information in the office information as the key for pre-grouping.
[0018] As a further optimization solution of the present disclosure, the pre-grouping results are regrouped according to the RS1 data content related to the office information in the inspection rules, and the offices with the same rules are grouped into a group including:
[0019] Traverse the RS1 records in the rule;
[0020] For each RS1, traverse each office in the multi-office request. If there is one or more offices that can match an RS1, set the flag bit for the office that matches the RS1.
[0021] Regrouping is performed based on the matching results and pre-grouping results.
[0022] An international freight rate search and processing multi-office query system, comprising:
[0023] The pre-grouping module is used to determine whether the request input by the user is a multi-office request. If so, pre-grouping is performed;
[0024] The grouping module is used to regroup the pre-grouping results according to the RS1 data content related to the office information in the verification rules, and the offices with the same rules are grouped together;
[0025] The logic verification and freight rate calculation module is used to select the first office from each group as the representative office of the current group for logic verification and calculation;
[0026] The integration module is used to merge different office groups with the same calculation results.
[0027] As a further optimization solution of the present disclosure, the pre-grouping module needs to deduplicate the request input by the user before determining whether the request input by the user is a multi-office request.
[0028] As a further optimization solution of the present disclosure, the pre-grouping module determines whether the request input by the user is a multi-office request. If so, the pre-grouping includes:
[0029] Determine the number of offices in the request. If the number of offices is greater than 1, group the offices together. Otherwise, do not group the offices together.
[0030] Analyze each office information in the user request and use the channel, POS country code, and key customer code information in the office information as the key for pre-grouping.
[0031] As a further optimization solution of the present disclosure, the grouping module regroups the pre-grouping results according to the RS1 data content related to the office information in the inspection rule, and the offices with the same rules are grouped into a group including:
[0032] Traverse the RS1 records in the rule;
[0033] For each RS1, traverse each office in the multi-office request. If there is one or more offices that can match an RS1, set the flag bit for the office that matches the RS1.
[0034] Regrouping is performed based on the matching results and pre-grouping results.
[0035] An electronic device comprises a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory communicate with each other via the communication bus;
[0036] Memory for storing computer programs;
[0037] The processor is used to execute the program stored in the memory to implement the international freight rate search and multi-OFFICE query method.
[0038] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements a multi-OFFICE query method for searching and processing international freight rates.
[0039] The beneficial effects of the present disclosure are:
[0040] The present disclosure discloses a multi-office pre-grouping method. Before performing rule verification and freight rate calculation, the consistency of offices is first predicted based on the correlation between offices, and the offices are grouped according to the correlation between the offices. Instead of performing rule verification and freight rate calculation for each office in the request, a representative office is selected from the group for rule verification and freight rate calculation. This significantly reduces the computational workload of the search system, improves the system's processing performance, saves system resources, and can effectively improve the performance of an international freight rate search engine in processing multi-office requests, thereby ensuring strong support for the construction of a high-performance international freight rate search engine. BRIEF DESCRIPTION OF THE DRAWINGS
[0041] Figure 1 is a flow chart of a method in an embodiment of the present disclosure;
[0042] Figure 2 is a system structure block diagram in an embodiment of the present disclosure;
[0043] Figure 3 It is a block diagram of the device structure in an embodiment of the present disclosure. DETAILED DESCRIPTION
[0044] The present application will be described in further detail below in conjunction with the accompanying drawings. It is necessary to point out that the following specific implementation methods are only used to further illustrate the present application and cannot be understood as limiting the scope of protection of the present application. Technicians in this field can make some non-essential improvements and adjustments to the present application based on the above application content.
[0045] like Figure 1 As shown, a method for searching and processing multi-OFFICE queries for international freight rates includes the following steps:
[0046] Determine whether the request entered by the user is a multi-office request. If so, pre-group it.
[0047] Regroup the pre-grouping results based on the RS1 data content related to office information in the inspection rules, and group offices with consistent rules into one group;
[0048] Take the first office from each group as the representative office of the current group for logical verification and calculation;
[0049] Merge different office groups with the same calculation results.
[0050] In this embodiment, it specifically includes:
[0051] The office information entered in the customer request is as follows, for a total of 6 offices:
[0052]
[0053]
[0054] A. Pre-grouping of multiple offices:
[0055] Determine the number of offices in the request. If the number of offices is greater than 1, group the offices. Otherwise, do not group multiple offices.
[0056] According to the user request, the user entered 6 offices, and subsequent operations require grouping of multiple offices.
[0057] Analyze the office data in the user request and pre-group the offices. Based on the information of each office, use the channel, POS country code, and key customer code information in the office information as the key to pre-group.
[0058] The six offices in the request are numbered from the beginning to the end, 0->5.
[0059] Among the six offices above, only the sixth office's grouping information is inconsistent with the other offices' grouping information: office 0-4: channel: 1E POS area code: CN (China) Key customer code: empty Office 5:channel: C POS area code: HK (Hong Kong, China) Key customer code: empty In summary, the pre-grouping results are: Group 1: 0 1 2 3 4 Group 2: 5 B. Regroup office modules according to RS1 rules: Traverse the RS1 records in the rule: extract the RS1 records from the rule data, each RS1 record.
[0060] For each RS1, traverse each office in the multiple offices in the request. If there are one or more offices that can match this RS1, set the flag bit for these offices that match this RS1.
[0061] Regroup the matching results and pre-grouping results.
[0062] If all offices match the previous RS1 data or none of them match the previous RS1 data, no further grouping is performed and the original grouping is maintained.
[0063] If some offices match the same RS1 data, while other offices do not, a flag is set for the matching offices.
[0064] example:
[0065] RS1 data is as follows:
[0066] RS1[CXR=QF,ServiceCode=YR,ServiceSubCode=I,SeqNo=0019090,TravelDa
[0067] te_Eff=2019-11-01,POS_Location=NCN,PCC_IATA=T,PCC_IATA_Code=CKG177,ServiceFe
[0068] e_TaxIndicator=X,ServiceFee=0.0USD
[0069] PCC_IATA_Code = CKG177, indicating that the rules derived from this RS1 are all targeted at office number CKG177. This RS1 matches office number 2 in the user request, but not other offices. Therefore, the flag bits for all offices in this RS1 are set to:
[0070] 0 0 1 0 0 0 (the subscript starts at 0, 0 means no match, 1 means match);
[0071] For the above matching results and pre-grouping results, further grouping is performed, and the grouping information is as follows:
[0072] Pre-grouping results:
[0073] Group 1: 0 1 2 3 4;
[0074] Group 2: 5;
[0075] Since office number 2 and other offices are not grouped together after RS1 processing, the grouping information is as follows:
[0076] Group 1: 0 1 3 4;
[0077] Group 2: 5;
[0078] Group 3: 2;
[0079] Repeat the above steps until all RS1 records are traversed.
[0080] The final grouping information is as follows:
[0081] Group 1: 0 3 4;
[0082] Group 2: 1;
[0083] Group 3: 2;
[0084] Group 4: 5;
[0085] C. Logical verification of freight rate calculation:
[0086] During the logic verification and calculation of international freight rates, office verification is not performed on each office in the request. Instead, the first office in each group is selected as the representative office for logic verification and calculation based on the final grouping results. Because the offices in the current group have undergone the final grouping, the consistency of the verification logic and calculation results is guaranteed.
[0087] When performing logic verification and freight rate calculation for international freight rates, we no longer traverse all offices to perform overall logic verification and freight rate calculation. Instead, we determine the offices that need verification and calculation according to the office grouping.
[0088] The final grouping results are shown in Table 1 below:
[0089] Table 1
[0090] Group number Grouping Office that needs verification Group 1 0、3、4 0 Group 2 1 1 Group 3 2 2 Group 4 5 5
[0091] D. Integration of multiple office results:
[0092] For freight rate calculation results, if the information in the results of different office groups is consistent, in order to reduce the amount of result data, different office groups with the same calculation results are merged.
[0093] For example, five groups of offices return five groups of results. The office groups and result groups are shown in Table 2 below:
[0094] Table 2
[0095] Group number Grouping Calculation results Group 1 0、3、4 fare1+tax1 Group 2 1 fare1+tax2 Group 3 2 fare1+tax2 Group 4 5 fare2+tax1
[0096] From the results, we can see that the results of Group 2 and Group 3 are the same, so we merge the office information of these two groups, and the result becomes four groups. The grouping after merging is as follows:
[0097]
[0098] The purpose of merging results is mainly to reduce the amount of data returned, which helps to improve the response time of the system.
[0099] like Figure 2 As shown, an embodiment of the present disclosure provides an international freight rate search and processing multi-OFFICE query system, including:
[0100] The pre-grouping module 11 is used to determine whether the request input by the user is a multi-office request, and if so, perform pre-grouping;
[0101] The grouping module 12 is used to regroup the pre-grouping results according to the RS1 data content related to the office information in the inspection rules, and group the offices with the same rules into one group;
[0102] The logic check and freight rate calculation module 13 is used to select the first office from each group as the representative office of the current group for logic check and calculation;
[0103] The integration module 14 is used to merge different office groups with the same calculation results.
[0104] The implementation process of the functions and effects of each module in the above system is specifically described in the implementation process of the corresponding steps in the above method, which will not be repeated here.
[0105] For the system embodiment, since it basically corresponds to the method embodiment, the relevant parts can be referred to the partial description of the method embodiment. The system embodiment described above is only schematic, wherein the modules described as separate components may or may not be physically separated, and the components displayed as modules may or may not be physical modules, that is, they may be located in one place, or they may be distributed on multiple network modules. Some or all of the modules can be selected according to actual needs to achieve the purpose of the disclosed solution. Those of ordinary skill in the art can understand and implement it without paying any creative work.
[0106] In the above embodiment, any number of all modules can be combined into one module for implementation, or any one of the modules can be split into multiple modules. Alternatively, at least some of the functions of one or more of these modules can be combined with at least some of the functions of other modules and implemented in one module. At least one of all modules can be at least partially implemented as a hardware circuit, such as a field programmable gate array (FPGA), a programmable logic array (PLA), a system on a chip, a system on a substrate, a system on a package, an application specific integrated circuit (ASIC), or can be implemented by hardware or firmware such as any other reasonable way of integrating or packaging the circuit, or implemented in any one of the three implementation modes of software, hardware and firmware or in a suitable combination of any of them. Alternatively, at least one of all modules can be at least partially implemented as a computer program module, which can perform the corresponding function when the computer program module is run.
[0107] See also Figure 3 The electronic device provided by an embodiment of the present disclosure includes a processor 1110, a communication interface 1120, a memory 1130 and a communication bus 1140, wherein the processor 1110, the communication interface 1120, and the memory 1130 communicate with each other through the communication bus 1140;
[0108] Memory 1130, for storing computer programs;
[0109] The processor 1110 is configured to implement the following international freight rate search and multi-OFFICE query method when executing the program stored in the memory 1130 .
[0110] The communication bus 1140 can be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus. The communication bus 1140 can be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, the figure shows only one thick line, but this does not mean that there is only one bus or only one type of bus.
[0111] The communication interface 1120 is used for communication between the electronic device and other devices.
[0112] The memory 1130 may include a random access memory (RAM) or a non-volatile memory, such as at least one disk storage. Alternatively, the memory 1130 may be at least one storage device located away from the processor 1110.
[0113] The above-mentioned processor 1110 can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field-programmable gate array (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components.
[0114] The embodiments of the present disclosure further provide a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the above-mentioned international freight rate search and multi-office query method.
[0115] The computer-readable storage medium may be included in the device / apparatus described in the above embodiments, or may exist independently and not incorporated into the device / apparatus. The computer-readable storage medium carries one or more programs that, when executed, implement the multi-office query method for international freight rate search processing according to the embodiments of the present disclosure.
[0116] According to an embodiment of the present disclosure, a computer-readable storage medium may be a non-volatile computer-readable storage medium, such as, but not limited to, 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), a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.
[0117] The above-described embodiments merely represent several implementation methods of the present disclosure. While the descriptions are relatively specific and detailed, they should not be construed as limiting the scope of the present disclosure. It should be noted that a person skilled in the art would be able to make numerous variations and improvements without departing from the scope of the present disclosure, all of which fall within the scope of protection of the present disclosure.
Claims
1. A method for searching and processing international freight rates in multiple offices, characterized in that: The following steps are involved: Determine whether the request entered by the user is a multi-office request. If so, pre-group it. Regroup the pre-grouping results based on the RS1 data content related to office information in the inspection rules, and group offices with consistent rules into one group; Take the first office from each group as the representative office of the current group for logical verification and calculation; Merge different office groups with the same calculation results.
2. The method for searching and processing international freight rates in multiple offices according to claim 1, characterized in that: Before determining whether a request input by a user is a multi-office request, the request input by the user needs to be deduplicated.
3. The method for searching and processing international freight rates in multiple offices according to claim 2, characterized in that: Determine whether the request entered by the user is a multi-office request. If so, pre-group it, including: Determine the number of offices in the request. If the number of offices is greater than 1, group the offices together. Otherwise, do not group the offices together. Analyze each office information in the user request and use the channel, POS area code, and key customer code information in the office information as keys for pre-grouping.
4. The method for searching and processing international freight rates in multiple offices according to claim 1, characterized in that: Based on the RS1 data content related to office information in the inspection rules, the pre-grouping results are regrouped. Offices with the same rules are grouped into the following groups: Traverse the RS1 records in the rule; For each RS1, traverse each office in the multi-office request. If there is one or more offices that can match an RS1, set the flag bit for the office that matches the RS1. Regrouping is performed based on the matching results and pre-grouping results.
5. An international freight rate search and processing multi-office query system, characterized by: include: The pre-grouping module is used to determine whether the request input by the user is a multi-office request. If so, pre-grouping is performed; The grouping module is used to regroup the pre-grouping results according to the RS1 data content related to the office information in the verification rules, and the offices with the same rules are grouped together; The logic verification and freight rate calculation module is used to select the first office from each group as the representative office of the current group for logic verification and calculation; The integration module is used to merge different office groups with the same calculation results.
6. The international freight rate search and processing multi-office query system according to claim 5, characterized in that: Before determining whether a request input by a user is a multi-office request, the pre-grouping module needs to deduplicate the request input by the user.
7. The international freight rate search and processing multi-office query system according to claim 6, characterized in that: The pre-grouping module determines whether the request input by the user is a multi-office request. If so, pre-grouping includes: Determine the number of offices in the request. If the number of offices is greater than 1, group the offices together. Otherwise, do not group the offices together. Analyze each office information in the user request and pre-group it using the channel, POS area code, and key customer code information in the office information as the key.
8. The international freight rate search and processing multi-office query system according to claim 5, characterized in that: The grouping module regroups the pre-grouping results according to the RS1 data content related to the office information in the inspection rules, and the offices with the same rules are grouped into a group including: Traverse the RS1 records in the rule; For each RS1, traverse each office in the multi-office request. If there is one or more offices that can match an RS1, set the flag bit for the office that matches the RS1. Regrouping is performed based on the matching results and pre-grouping results.
9. An electronic device, characterized in that: The processor, the communication interface, the memory and the communication bus are connected to each other via the communication bus. Memory for storing computer programs; The processor is configured to execute a program stored in the memory to implement the international freight rate search and multi-OFFICE query method according to any one of claims 1 to 4.
10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the multi-OFFICE query method for searching and processing international freight rates according to any one of claims 1 to 4 is implemented.
