Freight rate information reconciliation processing method and device, electronic equipment and storage medium

By receiving, verifying, and reconciling fare information, the calculation and search problems caused by invalid data in the international fare system have been solved, and the effective push and correct processing of data have been achieved.

CN119003883APending Publication Date: 2024-11-22TRAVELSKY TECHNOLOGY LIMITED
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411208847.9
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-30
Publication Date
2024-11-22

AI Technical Summary

Technical Problem

Invalid data records in the international freight rate publishing system can cause performance issues and failures in calculations and searches.

Method used

By responding to users' fare publication requests, receiving and verifying fare information, storing or modifying database data according to action codes, and performing reconciliation processing to remove invalid data, the data packets are pushed to the international fare calculation and search system according to a preset time pattern.

Benefits of technology

Effectively remove invalid data records to avoid impacting calculation and search performance, and prevent calculation errors and search failures.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119003883A_ABST
    Figure CN119003883A_ABST
Patent Text Reader

Abstract

The invention discloses a freight rate information reconciliation processing method and device, electronic equipment and a storage cut-off, the method and device are applied to the electronic equipment, specifically, in response to a ticket price issuing request of a user, ticket price information input by the user is received, the ticket price issuing request comprises action codes, and the action codes are newly added codes, modified codes and cancelled codes; according to the action code, the ticket price information is stored in a database or a certain piece of original data stored in the database is modified or cancelled; carrying out reconciliation processing on all original data in the database to cancel all invalid data in the database; and packaging all data in the database into a data packet according to a preset time rule, and pushing the data packet to an international freight rate calculation system and an international freight rate search system. The scheme not only comprises the input and push of the ticket price information, but also comprises the reconciling processing of the ticket price information, and invalid information in the ticket price information is removed through the reconciling processing, so that invalid data records are not included when the ticket price information is pushed to an international freight rate calculation system and an international freight rate search system; the influence on calculation and search performance and calculation errors can be avoided, so that search failures can be avoided.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of information technology, and more specifically, to a method, device, electronic device and storage medium for reconciling and processing freight rate information. Background Art

[0002] The international freight rate publishing system is used to publish freight rate information to specific objects. For example, it will regularly push freight rate information to the international freight rate calculation system and the international freight rate search system. The freight rate information is divided into two types: incremental data and full data. Among them, the incremental data has multiple changes in a certain data in the same publishing cycle. The system automatically modifies or terminates the original data according to the data primary key, resulting in multiple layers of invalid data records with expired or inverted time in the incremental data. If the incremental data containing these invalid data records is pushed to the international freight rate calculation system and the international freight rate search system, it will affect the calculation and search performance and cause calculation errors, thereby causing search failures. Summary of the invention

[0003] In view of this, the present application provides a method, device, electronic device and storage medium for reconciling and processing freight rate information, which are used to solve the search failure caused by invalid data records in the freight rate information.

[0004] In order to achieve the above objectives, the proposed solution is as follows:

[0005] A method for reconciling and processing freight rate information is applied to electronic equipment, and the method for reconciling and processing comprises the following steps:

[0006] Responding to a user's fare release request and receiving fare information input by the user, the fare release request including an action code, which is a new addition code, a modification code, and a cancellation code;

[0007] storing the fare information in a database or modifying or cancelling a piece of original data stored in the database according to the action code;

[0008] Performing reconciliation processing on all original data in the database so as to eliminate all invalid data in the database;

[0009] All data in the database are packaged into data packets according to a preset time rule, and the data packets are pushed to the international freight rate calculation system and the international freight rate search system.

[0010] Optionally, responding to the user's fare release request and receiving fare information input by the user comprises the steps of:

[0011] receiving the fare information according to the ticket issuance request;

[0012] Verify the effective date, sale-by date, legality and currency type of the fare information;

[0013] After verification, the fare information is saved.

[0014] Optionally, the reconciliation process of all the original data in the database comprises the steps of:

[0015] Performing reconciliation processing on the incremental data in the original data;

[0016] The whole amount of data in the original data is harmonized.

[0017] Optionally, the reconciliation processing of the incremental data in the original data comprises the steps of:

[0018] Filter out upside-down records in the incremental data;

[0019] Ignore the records in the incremental data that have been modified only once;

[0020] For the cancelled records that have been changed multiple times in the incremental data within the same cycle, filtering and reconciliation are performed;

[0021] The records after filtering and reconciliation are sorted in the order of publication. If the effective date of the reconciled positive record in the same logical primary key is less than or equal to the effective date of the canceled record, the canceled record is removed.

[0022] Optionally, the step of reconciling the incremental data in the original data further includes the following steps:

[0023] If there is change data with the action code of cancel, only one record is generated in the incremental data under the same logical primary key.

[0024] Optionally, the reconciliation processing of the full amount of data in the original data comprises the steps of:

[0025] Filter out non-canceled upside-down records in the full amount of data;

[0026] Filter out the cancellation records in the entire data.

[0027] Optionally, the following steps are also included:

[0028] In response to a calculation request or a search request initiated by an agent or a passenger, according to the condition information input by the user when initiating the request, the database is searched for information that meets the condition and the information is fed back to the agent or the passenger.

[0029] A device for reconciling and processing freight rate information, applied to electronic equipment, the device comprising:

[0030] The fare publishing module is configured to respond to the fare publishing request of the user and receive the fare information input by the user, wherein the fare publishing request includes an action code, and the action code is a new addition code, a modification code and a cancellation code;

[0031] A data storage module is configured to store the fare information into a database or modify or cancel a piece of original data stored in the database according to the action code;

[0032] A reconciliation execution module is configured to reconcile all original data in the database so as to cancel all invalid data in the database;

[0033] The data push module is configured to package all the data in the database into data packets according to a preset time rule, and push the data packets to the international freight rate calculation system and the international freight rate search system.

[0034] An electronic device, comprising at least one processor and a memory connected to the processor, wherein:

[0035] The memory is used to store computer programs or instructions;

[0036] The processor is used to execute the computer program or instruction so that the electronic device can implement the above-mentioned method for reconciling and processing freight rate information.

[0037] A storage medium is applied to an electronic device, the storage medium carries one or more computer programs, and the one or more computer programs can be executed by the electronic device, so that the electronic device implements the above-mentioned method for reconciling and processing freight rate information.

[0038] It can be seen from the above technical scheme that the present application discloses a method, device, electronic device and storage cutoff for reconciliation processing of fare information. The method and device are applied to electronic devices, specifically to respond to the user's fare release request, receive the fare information input by the user, the fare release request includes an action code, and the action code is a new code, a modification code and a cancellation code; according to the action code, the fare information is stored in the database or a certain original data stored in the database is modified or cancelled; all the original data in the database are reconciled to cancel all invalid data in the database; all the data in the database are packaged into data packets according to a preset time rule, and the data packets are pushed to the international fare calculation system and the international fare search system. This scheme not only includes the input and push of fare information, but also includes the reconciliation processing of fare information. The invalid information is removed through the reconciliation processing, so that the information pushed to the international fare calculation system and the international fare search system does not contain invalid data records, which can avoid affecting the calculation and search performance and avoid calculation errors, thereby avoiding search failures. BRIEF DESCRIPTION OF THE DRAWINGS

[0039] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0040] Figure 1 A flowchart of a method for reconciling freight rate information according to an embodiment of the present application;

[0041] Figure 2 A flowchart of another method for reconciling and processing freight rate information according to an embodiment of the present application;

[0042] Figure 3 A block diagram of a device for reconciling and processing freight rate information according to an embodiment of the present application;

[0043] Figure 4 A block diagram of another device for reconciling and processing freight rate information according to an embodiment of the present application;

[0044] Figure 5 A block diagram of an electronic device according to an embodiment of the present application. DETAILED DESCRIPTION

[0045] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0046] Figure 1 The present invention is a flowchart of a method for reconciling and processing freight rate information according to an embodiment of the present application.

[0047] like Figure 1 As shown, the reconciliation processing method of freight rate information provided in this embodiment is applied to an electronic device so that the freight rate information received by the international freight rate calculation system and the international freight rate search system does not contain invalid information. The electronic device can be understood as a computer, server or cloud platform with data computing and information processing capabilities. The reconciliation processing method includes the following steps:

[0048] S1. Fare information input by the user's fare release request receiver.

[0049] The user here refers to the administrator who manages the fare information. He sends the fare release request to the system according to the relevant instructions received, and enters the fare information based on the request. The fare information includes information such as [airline] [rule number] [origin] [destination] [fare basis] [voyage type] [effective date] [deadline] [route map] [currency] [amount].

[0050] In addition, to ensure the legitimacy of the business dimension of the fare information, the fare information is verified, and the verification content includes but is not limited to:

[0051] The verification effective date is later than the current date;

[0052] The sales-by date must be later than the effective date;

[0053] Verify the legitimacy of data input;

[0054] Check currency type;

[0055] After successful verification, save and publish the above data.

[0056] Finally, within the same cycle, the above fare information can be modified or cancelled multiple times and the data can be published.

[0057] The fare release request in this application also includes an action code, which refers to the type of operation performed on the relevant data of the input fare information. For example, the action codes in this application include a new code, a modification code, and a cancellation code. The new code refers to adding a new operation to the fare information, the modification code refers to modifying the original data in the database based on the input data, and the cancellation code refers to deleting the original data in the database.

[0058] S2. Execute corresponding operations on corresponding data according to the action code.

[0059] That is, according to the action code, the fare information is stored in the database, or a certain original data stored in the database is modified or cancelled. Specifically, the system determines based on the action code. When the action code is modification or cancellation, the system searches for the valid original data in the current database according to the logical primary key of the data, and modifies the expiration date of the original data to the day before the effective date of the new data.

[0060] S3. Reconcile the original data in the database.

[0061] 1. Perform the following processing on the incremental files in the original data.

[0062] 1. Filter out non-canceled and inverted records (inverted: the effective date is later than the deadline)

[0063] 2. If only one change operation (cancel, add, modify) is performed on the record with the same logical primary key within the same file change cycle (for example, the change frequency is 1 hour, this frequency depends on the system configuration), then this change record is generated to the file and no reconciliation is required.

[0064] 3. If multiple changes are made to the records with the same logical primary key within the same file change cycle (multiple cancellation / modification / addition, or cancellation accompanied by addition and modification, etc.), the records with the action code of cancellation need to be filtered and reconciled:

[0065] 1) The final result of taking out all new records with the same current logical primary key and the original records modified in this release change cycle (including all non-canceled upside-down records at this time): new records refer to new records released in the current change cycle, and original records refer to original records that were previously released and automatically terminated by the system in the database of this change cycle, and they are arranged in the order of actual release, with the original records in front of the new records;

[0066] 2) Confirm whether to generate based on the scope of the cancel record:

[0067] A. If the deadline for canceling a record only applies to the original record (there are two situations: canceling the record removes the deadline for the original record), but not to the new record, then it does not need to be deleted and the file needs to be generated (the corresponding business scenario is to cancel first and then add):

[0068] B. If the deadline of the cancellation record only applies to new records other than the cancellation record (i.e. the cancellation record has exceeded the deadline of the new record), then this cancellation record will be removed.

[0069] C. If the deadline for canceling a record does not apply to the original record or the new record, that is, the cancellation record never terminates any record, no cancellation record will be generated in the file.

[0070] 4. Take the reconciliation results of the previous step (including the original record and the new record), sort them in the order of release, and if the effective date of the reconciled positive record (excluding the inverted record) in the same logical primary key is <= the effective date of the canceled record, then remove the canceled record. (Because if the effective date of the positive record is smaller, it means that the previous record is inverted or expired, and the expiration date of the original record can be expired according to the effective date of the positive record. The canceled record can be not generated).

[0071] 5. After the reconciliation is completed, all non-canceled inversion records will not be generated in the file.

[0072] Scenario 1:

[0073] Original record 10.5-10.6

[0074] Now do this in order:

[0075] Cancel the original record 1 10.5-10.4

[0076] New record 2 10.5-10.8

[0077] If the effective date of the final forward record is equal to the effective date of the cancellation record, the cancellation record is deleted and does not need to be generated into a file.

[0078] Scenario 2:

[0079] Original record 10.5-10.6

[0080] Now do this in order:

[0081] Cancel the original record 1 10.5-10.4

[0082] Added record 2 10.1-10.8

[0083] Now the cancellation record 1 will be generated.

[0084] If the effective date of the final forward record is less than the effective date of the cancellation record, the cancellation record is deleted and does not need to be generated into the file.

[0085] Scenario 3:

[0086] Original record 10.5-10.6

[0087] Now do this in order:

[0088] Cancel the original record 1 10.5-10.4

[0089] Added record 2 10.6-10.8

[0090] If the effective date of the final forward record is greater than the effective date of the cancellation record, the cancellation record will not be eliminated and needs to be generated into the file.

[0091] Scenario 4:

[0092] Original record: 10,10-10.20

[0093] Do it in sequence: Modify records 10.10-10.20

[0094] Unrecorded 10.10-10.9

[0095] Finally, there is no positive record, and a cancellation record needs to be generated to the file

[0096] Scenario 5:

[0097] Original record: 10.10-10.20

[0098] Do it in sequence: Modify records 10.15-10.20

[0099] Cancellation record: 10.15-10.14

[0100] Cancellation record: 10.10.10-9

[0101] All records are cancelled and the latest cancellation record of 10.10-10.9 needs to be generated into the file.

[0102] 6. After the adjustment is completed, if there is change data with the action code canceled, at most one record should be generated in the data file under the same logical primary key.

[0103] Example 1:

[0104] The current time is 20230901 11:30. The file needs to be generated. Within the one-hour change range, the user can perform modification and cancellation operations on the international freight rate publishing front-end DI T as follows

[0105] Action code and record number Effective Date expiration date illustrate Added (original record) 20230801 999999 There is an original record, published on 20230801 Modify (record 1) 20230901 202309 New record: Batch01 modified and released Cancel(record 2) 20230910 202309 New record: Batch02 unpublished

[0106] Data reconciliation of international freight rate publishing system:

[0107]

[0108] After reconciliation, only the data file of record 2 needs to be generated in this release cycle.

[0109] 2. For the full amount of data:

[0110] 1. Filter out non-canceled and upside-down records

[0111] 2. Filter out the cancel records (the cancel records have already taken effect, and the canceled ones are canceled, so there is no need to generate them into the file).

[0112] S4. Push operations are performed on the data in the database according to a preset time rule.

[0113] For example, every hour on the hour, the published and coordinated fare information in the database during this publishing cycle can be automatically packaged and the packaged data can be pushed to the international freight rate calculation system and the international freight rate search system.

[0114] It can be seen from the above technical scheme that this embodiment provides a method for reconciling and processing fare information, which is applied to electronic devices, specifically responding to a user's fare release request, receiving fare information input by the user, the fare release request includes an action code, and the action code is a new code, a modification code, and a cancellation code; according to the action code, the fare information is stored in a database or a certain original data stored in the database is modified or cancelled; all the original data in the database are reconciled to cancel all invalid data in the database; all the data in the database are packaged into data packets according to a preset time rule, and the data packets are pushed to the international fare calculation system and the international fare search system. This scheme not only includes the input and push of fare information, but also includes the reconciliation of fare information. The invalid information is removed through the reconciliation, so that the information pushed to the international fare calculation system and the international fare search system does not contain invalid data records, which can avoid affecting the calculation and search performance and avoid calculation errors, thereby avoiding search failures.

[0115] In addition, in a specific implementation of this embodiment, the following steps are also included: Figure 2 shown.

[0116] S5. Provide feedback on freight rate products based on requests from agents or passengers.

[0117] When an agent or passenger initiates a fare calculation or search request, the fare calculation or search database is searched for fare products that meet the condition information based on the condition information in the request, and the fare products that meet the condition information are fed back.

[0118] 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.

[0119] 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.

[0120] 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.

[0121] 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 via any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer.

[0122] Figure 3A block diagram of a freight rate information reconciliation and processing device according to an embodiment of the present application.

[0123] like Figure 3 As shown, the reconciliation processing device for freight rate information provided in this embodiment is applied to an electronic device so that the freight rate information received from the international freight rate calculation system and the international freight rate search system does not contain invalid information. The electronic device can be understood as a computer, server or cloud platform with data computing and information processing capabilities. The reconciliation processing device includes a freight rate publishing module 10, a data storage module 20, a reconciliation execution module 30 and a data push module 40.

[0124] The fare publishing module is used to publish the fare information input by the user's fare request receiver.

[0125] The user here refers to the administrator who manages the fare information. He sends the fare release request to the system according to the relevant instructions received, and enters the fare information based on the request. The fare information includes information such as [airline] [rule number] [origin] [destination] [fare basis] [voyage type] [effective date] [deadline] [route map] [currency] [amount].

[0126] In addition, to ensure the legitimacy of the business dimension of the fare information, the fare information is verified, and the verification content includes but is not limited to:

[0127] The verification effective date is later than the current date;

[0128] The sales-by date must be later than the effective date;

[0129] Verify the legitimacy of data input;

[0130] Check currency type;

[0131] After successful verification, save and publish the above data.

[0132] Finally, within the same cycle, the above fare information can be modified or cancelled multiple times and the data can be published.

[0133] The fare release request in this application also includes an action code, which refers to the type of operation performed on the relevant data of the input fare information. For example, the action codes in this application include a new code, a modification code, and a cancellation code. The new code refers to adding a new operation to the fare information, the modification code refers to modifying the original data in the database based on the input data, and the cancellation code refers to deleting the original data in the database.

[0134] The data saving module is used to perform corresponding operations on corresponding data according to the action code.

[0135] That is, according to the action code, the fare information is stored in the database, or a certain original data stored in the database is modified or cancelled. Specifically, the system determines based on the action code. When the action code is modification or cancellation, the system searches for the valid original data in the current database according to the logical primary key of the data, and modifies the expiration date of the original data to the day before the effective date of the new data.

[0136] The reconciliation execution module is used to reconcile the original data in the database.

[0137] 1. Perform the following processing on the incremental files in the original data.

[0138] 1. Filter out non-canceled and inverted records (inverted: the effective date is later than the deadline)

[0139] 2. If only one change operation (cancel, add, modify) is performed on the record with the same logical primary key within the same file change cycle (for example, the change frequency is 1 hour, this frequency depends on the system configuration), then this change record is generated to the file and no reconciliation is required.

[0140] 3. If multiple changes are made to the records with the same logical primary key within the same file change cycle (multiple cancellation / modification / addition, or cancellation accompanied by addition and modification, etc.), the records with the action code of cancellation need to be filtered and reconciled:

[0141] 1) The final result of taking out all new records with the same current logical primary key and the original records modified in this release change cycle (including all non-canceled upside-down records at this time): new records refer to new records released in the current change cycle, and original records refer to original records that were previously released and automatically terminated by the system in the database of this change cycle, and they are arranged in the order of actual release, with the original records in front of the new records;

[0142] 2) Confirm whether to generate based on the scope of the cancel record:

[0143] A. If the deadline for canceling a record only applies to the original record (there are two situations: canceling the record removes the deadline for the original record), but not to the new record, then it does not need to be deleted and the file needs to be generated (the corresponding business scenario is to cancel first and then add):

[0144] B. If the deadline of the cancellation record only applies to new records other than the cancellation record (i.e. the cancellation record has exceeded the deadline of the new record), then this cancellation record will be removed.

[0145] C. If the deadline for canceling a record does not apply to the original record or the new record, that is, the cancellation record never terminates any record, no cancellation record will be generated in the file.

[0146] 4. Take the reconciliation results of the previous step (including the original record and the new record), sort them in the order of release, and if the effective date of the reconciled positive record (excluding the inverted record) in the same logical primary key is <= the effective date of the canceled record, then remove the canceled record. (Because if the effective date of the positive record is smaller, it means that the previous record is inverted or expired, and the expiration date of the original record can be expired according to the effective date of the positive record. The canceled record can be not generated).

[0147] 5. After the reconciliation is completed, all non-canceled inversion records will not be generated in the file.

[0148] Scenario 1:

[0149] Original record 10.5-10.6

[0150] Now do this in order:

[0151] Cancel the original record 1 10.5-10.4

[0152] New record 2 10.5-10.8

[0153] If the effective date of the final forward record is equal to the effective date of the cancellation record, the cancellation record is deleted and does not need to be generated into a file.

[0154] Scenario 2:

[0155] Original record 10.5-10.6

[0156] Now do this in order:

[0157] Cancel the original record 1 10.5-10.4

[0158] Added record 2 10.1-10.8

[0159] Now the cancellation record 1 will be generated.

[0160] If the effective date of the final forward record is less than the effective date of the cancellation record, the cancellation record is deleted and does not need to be generated into the file.

[0161] Scenario 3:

[0162] Original record 10.5-10.6

[0163] Now do this in order:

[0164] Cancel the original record 1 10.5-10.4

[0165] Added record 2 10.6-10.8

[0166] If the effective date of the final forward record is greater than the effective date of the cancellation record, the cancellation record will not be eliminated and needs to be generated into the file.

[0167] Scenario 4:

[0168] Original record: 10,10-10.20

[0169] Do it in sequence: Modify records 10.10-10.20

[0170] Unrecorded 10.10-10.9

[0171] Finally, there is no positive record, and a cancellation record needs to be generated to the file

[0172] Scenario 5:

[0173] Original record: 10.10-10.20

[0174] Do it in sequence: Modify records 10.15-10.20

[0175] Cancellation record: 10.15-10.14

[0176] Cancellation record: 10.10.10-9

[0177] All records are cancelled and the latest cancellation record of 10.10-10.9 needs to be generated into the file.

[0178] 6. After the adjustment is completed, if there is change data with the action code canceled, at most one record should be generated in the data file under the same logical primary key.

[0179] Example 1:

[0180] The current time is 20230901 11:30. The file needs to be generated. Within the one-hour change range, the user can perform modification and cancellation operations on the international freight rate publishing front-end DI T as follows

[0181]

[0182]

[0183] Data reconciliation of international freight rate publishing system:

[0184]

[0185] After reconciliation, only the data file of record 2 needs to be generated in this release cycle.

[0186] 2. For the full amount of data:

[0187] 1. Filter out non-canceled and upside-down records

[0188] 2. Filter out the cancel records (the cancel records have already taken effect, and the canceled ones are canceled, so there is no need to generate them into the file).

[0189] The data push module is used to push data in the database according to a preset time rule.

[0190] For example, every hour on the hour, the published and coordinated fare information in the database during this publishing cycle can be automatically packaged and the packaged data can be pushed to the international freight rate calculation system and the international freight rate search system.

[0191] It can be seen from the above technical scheme that this embodiment provides a device for reconciling and processing fare information, which is applied to electronic devices, specifically responding to the user's fare release request, receiving the fare information input by the user, the fare release request includes an action code, and the action code is a new code, a modification code, and a cancellation code; according to the action code, the fare information is stored in the database or a certain original data stored in the database is modified or cancelled; all the original data in the database are reconciled to cancel all invalid data in the database; all the data in the database are packaged into data packets according to a preset time rule, and the data packets are pushed to the international fare calculation system and the international fare search system. This scheme not only includes the input and push of fare information, but also includes the reconciliation of fare information. The invalid information is removed through the reconciliation, so that the information pushed to the international fare calculation system and the international fare search system does not contain invalid data records, which can avoid affecting the calculation and search performance and avoid calculation errors, thereby avoiding search failures.

[0192] In addition, in a specific implementation of this embodiment, an information feedback module 50 is also included, such as Figure 4 shown.

[0193] The information feedback module is used to provide feedback on freight products based on requests from agents or passengers.

[0194] When an agent or passenger initiates a fare calculation or search request, the fare calculation or search database is searched for fare products that meet the condition information based on the condition information in the request, and the fare products that meet the condition information are fed back.

[0195] The units involved in the embodiments described in the present disclosure may be implemented by software or hardware. The name of a unit does not limit the unit itself in some cases. For example, the first acquisition unit may also be described as a "unit for acquiring at least two Internet Protocol addresses".

[0196] 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.

[0197] Figure 5 A block diagram of an electronic device according to an embodiment of the present application.

[0198] Reference below Figure 5 , which shows a schematic diagram of the structure of an electronic device suitable for implementing the embodiments of the present disclosure. The terminal device in the embodiments of the present disclosure may include, but is not limited to, mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), vehicle-mounted terminals (such as vehicle-mounted navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. The electronic device is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

[0199] The electronic device may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 501, which can perform various appropriate actions and processes according to a program stored in a read-only memory ROM 502 or a program loaded from an input device 506 into a random access memory RAM 503. In the RAM, various programs and data required for the operation of the electronic device are also stored. The processing device, ROM, and RAM are connected to each other via a bus 504. An input / output (I / O) interface 505 is also connected to the bus 504.

[0200] Typically, the following devices may be connected to the I / O interface: input devices including, for example, a touch screen, a touchpad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; output devices 507 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; storage devices 508 including, for example, a magnetic tape, a hard disk, etc.; and communication devices 509. The communication device 509 may allow the electronic device to communicate with other devices wirelessly or by wire to exchange data. Although the figure shows an electronic device with various devices, it should be understood that it is not required to implement or have all the devices shown. More or fewer devices may be implemented or have alternatively.

[0201] The present application also provides an embodiment of a computer-readable storage medium.

[0202] The storage medium is applied to an electronic device and carries one or more computer programs. When the one or more computer programs are executed by the electronic device, the electronic device responds to the user's fare release request and receives the fare information input by the user. The fare release request includes an action code, which is a new code, a modification code, and a cancellation code; according to the action code, the fare information is stored in a database or a certain original data stored in the database is modified or cancelled; all the original data in the database are reconciled to cancel all invalid data in the database; all the data in the database are packaged into data packets according to a preset time rule, and the data packets are pushed to the international freight rate calculation system and the international freight rate search system. This scheme not only includes the input and push of fare information, but also includes the reconciliation of fare information. The invalid information is removed through the reconciliation, so that the information pushed to the international freight rate calculation system and the international freight rate search system does not contain invalid data records, which can avoid affecting the calculation and search performance and avoid calculation errors, thereby avoiding search failures.

[0203] 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.

[0204] 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, apparatus, 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, which carries a computer-readable program code. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. A 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 combination 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.

[0205] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the various embodiments can be referenced to each other.

[0206] Although the preferred embodiments of the present invention have been described, those skilled in the art may make additional changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the embodiments of the present invention.

[0207] Finally, it should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or terminal device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or terminal device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the existence of other identical elements in the process, method, article or terminal device including the elements.

[0208] The technical solution provided by the present invention is introduced in detail above. Specific examples are used in this article to illustrate the principle and implementation mode of the present invention. The description of the above embodiments is only used to help understand the method of the present invention and its core idea. At the same time, for those skilled in the art, according to the idea of ​​the present invention, there will be changes in the specific implementation mode and application scope. In summary, the content of this specification should not be understood as limiting the present invention.

Claims

1. A method for reconciling and processing freight rate information, applied to electronic equipment, characterized in that: The blending method comprises the steps of: Responding to a user's fare release request and receiving fare information input by the user, the fare release request including an action code, which is a new addition code, a modification code, and a cancellation code; storing the fare information in a database or modifying or cancelling a piece of original data stored in the database according to the action code; Performing reconciliation processing on all original data in the database so as to eliminate all invalid data in the database; All data in the database are packaged into data packets according to a preset time rule, and the data packets are pushed to the international freight rate calculation system and the international freight rate search system.

2. The blending method according to claim 1, characterized in that: The step of responding to the user's fare release request and receiving the fare information input by the user comprises the following steps: receiving the fare information according to the ticket issuance request; Verify the effective date, sale-by date, legality and currency type of the fare information; After verification, the fare information is saved.

3. The blending method according to claim 1, characterized in that: The reconciliation process of all the original data in the database comprises the steps of: Performing reconciliation processing on the incremental data in the original data; The whole amount of data in the original data is harmonized.

4. The blending method according to claim 3, characterized in that: The step of reconciling the incremental data in the original data comprises the following steps: Filter out upside-down records in the incremental data; Ignore the records in the incremental data that have been modified only once; For the cancelled records that have been changed multiple times in the incremental data within the same cycle, filtering and reconciliation are performed; The records after filtering and reconciliation are sorted in the order of publication. If the effective date of the reconciled positive record in the same logical primary key is less than or equal to the effective date of the canceled record, the canceled record is removed.

5. The blending method according to claim 4, characterized in that: The reconciliation process of the incremental data in the original data further includes the steps of: If there is change data with the action code of cancel, only one record is generated in the incremental data under the same logical primary key.

6. The blending method according to claim 3, characterized in that: The reconciliation process of the full amount of data in the original data comprises the steps of: Filter out non-canceled upside-down records in the full amount of data; The cancellation records in the entire data are filtered out.

7. The method for ground conditioning according to any one of claims 1 to 6, characterized in that: Also includes the steps: In response to a calculation request or a search request initiated by an agent or a passenger, according to the condition information input by the user when initiating the request, the database is searched for information that meets the condition and the information is fed back to the agent or the passenger.

8. A device for reconciling and processing freight rate information, applied to electronic equipment, characterized in that: The blending device comprises: The fare publishing module is configured to respond to the user's fare publishing request and receive the fare information input by the user, wherein the fare publishing request includes an action code, and the action code is a new addition code, a modification code, and a cancellation code; A data storage module is configured to store the fare information into a database or modify or cancel a piece of original data stored in the database according to the action code; A reconciliation execution module is configured to reconcile all original data in the database so as to cancel all invalid data in the database; The data push module is configured to package all the data in the database into data packets according to a preset time rule, and push the data packets to the international freight rate calculation system and the international freight rate search system.

9. An electronic device, characterized in that: The electronic device comprises at least one processor and a memory connected to the processor, wherein: The memory is used to store computer programs or instructions; The processor is used to execute the computer program or instruction so that the electronic device implements the method for reconciling and processing freight rate information according to any one of claims 1 to 7.

10. A storage medium, applied to an electronic device, characterized in that: The storage medium carries one or more computer programs, and the one or more computer programs can be executed by the electronic device, so that the electronic device implements the method for reconciling and processing freight rate information as described in any one of claims 1 to 7.