Reconciliation data processing method and device, equipment and medium

Abstract

The invention provides an account checking data processing method and device, equipment and a medium, and the method comprises the steps: storing order data to an order library, storing bill data to a bill library, and enabling the order data and the bill data to comprise business side codes; encrypting order data needing to be exported in an order library and a business party code by using AES to obtain encrypted data; the encryption vector comprises a set character string and a business party code; the business party code corresponds to the order data; the order library sends the encrypted data and the order number to a bill library, the bill library inquires bill data according to the order number to obtain a corresponding business side code, a set character string and the business side code are combined to form an encryption vector, and the encrypted data are decrypted through the encryption vector to obtain decrypted data; and synchronizing the decrypted data to the bill library, thereby ensuring the safety and high efficiency of account checking data synchronization, and ensuring the normal operation of the server.

Description

Technical Field

[0001] The present invention relates to the technical field of reconciliation systems, and in particular to a reconciliation data processing method, device, equipment and medium. Background Art

[0002] In the current order system, reconciliation relies on order data crawled from third-party platforms. The original architecture stores order data and billing data in a single database. As the business scales up, this solution gradually exposes the following problems:

[0003] 1. Performance bottleneck: High-frequency read and write operations for order and billing data are concentrated in the same database, leading to intense competition for I / O resources. Especially during batch crawling of third-party data, database load surges and response latency increases significantly, directly impacting order system stability.

[0004] 2. Limited scalability: A single database cannot be independently optimized for different business scenarios, such as orders (highly concurrent writes) and billing (complex aggregate queries). The continued growth of data volume further exacerbates storage and computing pressures, making vertical expansion expensive.

[0005] When some orders of the connected business line are not in the database, the business line needs to actively synchronize the orders to the database. The existing method is to directly request all data to the server for synchronization. When there is a lot of order data and multiple business line requests are processed at the same time, it will cause memory usage to soar, memory overflow, and then lead to problems such as server restart. Summary of the Invention

[0006] The technical problem to be solved by the present invention is to provide a reconciliation data processing method, device, equipment and medium to ensure the safe and efficient synchronization of reconciliation data and the normal operation of the server.

[0007] In a first aspect, the present invention provides a method for processing reconciliation data, including an order library and a bill library, and specifically comprising the following steps:

[0008] Step 1: Store the order data in the order database and the bill data in the bill database. The order data and bill data both include the business party code.

[0009] Step 2: Encrypt the order data and business party code to be exported from the order database using AES to obtain encrypted data; the encryption vector includes a set string and the business party code; the business party code corresponds to the order data;

[0010] Step 3: The order database sends the encrypted data and order number to the billing database. The billing database queries the billing data based on the order number to obtain the corresponding business party code, combines the set string and the business party code to form an encryption vector, and decrypts the encrypted data using the encryption vector to obtain the decrypted data.

[0011] Step 4: Synchronize the decrypted data to the bill library.

[0012] In a second aspect, the present invention provides a reconciliation data processing device, including an order library and a bill library, including the following modules:

[0013] A storage module stores order data in an order library and bill data in a bill library, wherein the order data and bill data both include a business party code;

[0014] An encryption module encrypts the order data and the business party code to be exported from the order library using AES to obtain encrypted data; the encryption vector includes a set string and the business party code; the business party code corresponds to the order data;

[0015] Decryption module: The order library sends the encrypted data and order number to the billing library. The billing library queries the billing data based on the order number to obtain the corresponding business party code, combines the set string and the business party code to form an encryption vector, and decrypts the encrypted data using the encryption vector to obtain the decrypted data;

[0016] A synchronization module synchronizes the decrypted data to the bill library.

[0017] In a third aspect, the present invention provides an electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the method described in the first aspect when executing the program.

[0018] In a fourth aspect, the present invention provides a computer-readable storage medium having a computer program stored thereon, which implements the method described in the first aspect when the program is executed by a processor.

[0019] One or more technical solutions provided by the present invention have at least the following technical effects or advantages:

[0020] This invention achieves I / O isolation between order writing and bill query by setting up a bill library and an order library, reducing lock contention and increasing throughput by 20% to 50%. Queuing and on-demand synchronization processing reduce invalid data transmission by more than 80%, memory usage drops by 70%, and improves bill service stability. The order library and bill library can be iterated separately, reducing collaboration costs.

[0021] The present invention performs AES encryption on the exported Excel spreadsheet. The encryption vector includes the business party code, which is stored in both the order library and the bill library. During the encryption and decryption process, it can be verified whether the data is correct. Only when the data is correct can the decryption be successful, thus avoiding attacks such as data imitation by others.

[0022] The present invention replaces the character strings of the encrypted data and sets two or more replacement rules, which can be randomly selected to increase the difficulty of cracking.

[0023] The present invention uses a queue method to synchronize data, ensuring that the data synchronization process does not occupy too many resources, and performs data detection before synchronization to ensure that the synchronized data is correct, thereby reducing synchronization abnormalities.

[0024] The present invention also stores the data that needs to be synchronized in the cloud storage service, and only stores the link of the cloud storage service in the queue. The data is read into the memory only when the synchronization starts, which further reduces the use of memory and ensures the normal use of the server.

[0025] The above description is only an overview of the technical solution of the present invention. In order to more clearly understand the technical means of the present invention, it can be implemented in accordance with the contents of the specification. In order to make the above and other purposes, features and advantages of the present invention more obvious and easy to understand, the specific implementation methods of the present invention are specifically listed below. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] The present invention will be further described below with reference to the accompanying drawings and embodiments.

[0027] Figure 1 This is a flowchart of the method in Example 1 of the present invention;

[0028] Figure 2 This is a schematic diagram of the structure of the device in Example 2 of the present invention. DETAILED DESCRIPTION

[0029] Example 1

[0030] like Figure 1 As shown, this embodiment provides a method for processing reconciliation data, including an order library and a bill library. By synchronizing data in the order library with the bill library, reconciliation operations are performed to ensure smooth completion of the reconciliation operation. Specifically, the method includes the following steps:

[0031] Step 1: Store the order data in the order database and the bill data in the bill database. The order data and bill data both include the business party code.

[0032] Step 2: Encrypt the order data and business party code to be exported from the order database using AES to obtain encrypted data; the encryption vector includes a set string and the business party code; the business party code corresponds to the order data;

[0033] Step 3: The order database sends the encrypted data and order number to the billing database. The billing database queries the billing data based on the order number to obtain the corresponding business party code, combines the set string and the business party code to form an encryption vector, and decrypts the encrypted data using the encryption vector to obtain the decrypted data.

[0034] Step 4: Synchronize the decrypted data to the bill library.

[0035] In this embodiment, preferably, step 2 is specifically as follows: the order data and the business party code to be exported in the order library are encrypted using AES to obtain encrypted data; the encryption vector includes a set string and a business party code; the business party code corresponds to the order data; at least two conversion rules are set, and the conversion rule is to convert a set character into a string; a conversion rule is randomly extracted to convert all characters that meet the setting in the encrypted data into strings (for example: the fixed character a is changed to sdfe23@) to form converted data.

[0036] In this embodiment, preferably, step 3 is specifically as follows: the order library sends the converted data and the order number to the bill library, the bill library queries the bill data according to the order number to obtain the corresponding business party code, combines the set character string and the business party code to form an encryption vector, and according to the set rules, restores the converted characters in the converted data to obtain encrypted data, and then decrypts the encrypted data through the encryption vector to obtain decrypted data.

[0037] In this embodiment, preferably, step 4 is specifically as follows: setting a synchronization queue (using a Redis queue), which is used to synchronize data; testing the decrypted data, and when no problem is found, storing the decrypted data in an Excel file, and uploading it to a cloud storage service, storing the link corresponding to the cloud storage service in the synchronization queue, and when the synchronization queue executes a task, obtaining the decrypted data according to the link corresponding to the task (at this time, the data is written to the memory of the server corresponding to the bill library), and synchronizing the decrypted data to the bill library in a queue manner.

[0038] Based on the same inventive concept, this application also provides a device corresponding to the method in Example 1, see Example 2 for details.

[0039] Example 2

[0040] like Figure 2As shown, in this embodiment, a reconciliation data processing device is provided, including: an order library and a bill library, including the following modules:

[0041] A storage module stores order data in an order library and bill data in a bill library, wherein the order data and bill data both include a business party code;

[0042] An encryption module encrypts the order data and the business party code to be exported from the order library using AES to obtain encrypted data; the encryption vector includes a set string and the business party code; the business party code corresponds to the order data;

[0043] Decryption module: The order library sends the encrypted data and order number to the billing library. The billing library queries the billing data based on the order number to obtain the corresponding business party code, combines the set string and the business party code to form an encryption vector, and decrypts the encrypted data using the encryption vector to obtain the decrypted data;

[0044] A synchronization module synchronizes the decrypted data to the bill library.

[0045] In this embodiment, preferably, the encryption module is specifically as follows: the order data and the business party code to be exported in the order library are encrypted using AES to obtain encrypted data; the encryption vector includes a set string and a business party code; the business party code corresponds to the order data; at least two conversion rules are set, and the conversion rule is to convert a set character into a string; a conversion rule is randomly extracted to convert all characters that meet the setting in the encrypted data into strings to form converted data.

[0046] In this embodiment, preferably, the decryption module is specifically as follows: the order library sends the conversion data and the order number to the bill library, the bill library queries the bill data according to the order number to obtain the corresponding business party code, combines the set character string and the business party code to form an encryption vector, and according to the set rules, restores the converted characters in the conversion data to obtain encrypted data, and then decrypts the encrypted data through the encryption vector to obtain decrypted data.

[0047] In this embodiment, preferably, the synchronization module specifically includes: setting a synchronization queue, which is used to synchronize data; testing the decrypted data, and when no problem is found, storing the decrypted data in an Excel file, and uploading it to a cloud storage service, storing the link corresponding to the cloud storage service in the synchronization queue, and when the synchronization queue executes a task, obtaining the decrypted data according to the link corresponding to the task, and synchronizing the decrypted data to the bill library in a queue manner.

[0048] Since the device described in the second embodiment of the present invention is used to implement the method of the first embodiment of the present invention, those skilled in the art will be able to understand the specific structure and variations of the device based on the method described in the first embodiment of the present invention, and therefore will not be described in detail here. All devices used in the method of the first embodiment of the present invention fall within the scope of protection of the present invention.

[0049] Based on the same inventive concept, this application provides an electronic device embodiment corresponding to the first embodiment, see the third embodiment for details.

[0050] Example 3

[0051] This embodiment provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, any implementation method in the first embodiment can be implemented.

[0052] Since the electronic device described in this embodiment is the device used to implement the method in Example 1 of this application, based on the method described in Example 1 of this application, those skilled in the art will be able to understand the specific implementation of the electronic device of this embodiment and its various variations. Therefore, how the electronic device implements the method in the embodiment of this application will not be described in detail here. As long as the device used by those skilled in the art to implement the method in the embodiment of this application falls within the scope of protection to be provided by this application.

[0053] Based on the same inventive concept, this application provides a storage medium corresponding to Example 1, see Example 4 for details.

[0054] Example 4

[0055] This embodiment provides a computer-readable storage medium on which a computer program is stored. When the computer program is executed by a processor, any implementation method in the first embodiment can be implemented.

[0056] It will be understood by those skilled in the art that embodiments of the present invention may be provided as methods, systems, or computer program products. Thus, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware. Furthermore, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to magnetic disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0057] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowcharts and / or block diagrams, as well as combinations of processes and / or blocks in the flowcharts and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowcharts and / or block diagrams. Figure 1 a process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0058] These computer program instructions may also be stored in a computer readable memory that can direct a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 a process or multiple processes and / or boxes Figure 1 The function specified in one or more boxes.

[0059] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operational steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing the instructions executed on the computer or other programmable device for implementing the process. Figure 1 a process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.

[0060] Although the specific embodiments of the present invention are described above, those skilled in the art should understand that the specific embodiments described are merely illustrative and are not intended to limit the scope of the present invention. Equivalent modifications and changes made by those skilled in the art in accordance with the spirit of the present invention should be included within the scope of protection of the claims of the present invention.

Claims

1. A method for processing reconciliation data, characterized by: Including order library and bill library, specifically including the following steps: Step 1: Store the order data in the order database and the bill data in the bill database. The order data and bill data both include the business party code. Step 2: Encrypt the order data and business party code to be exported from the order database using AES to obtain encrypted data; the encryption vector includes a set string and the business party code; the business party code corresponds to the order data; Step 3: The order database sends the encrypted data and order number to the billing database. The billing database queries the billing data based on the order number to obtain the corresponding business party code, combines the set string and the business party code to form an encryption vector, and decrypts the encrypted data using the encryption vector to obtain the decrypted data. Step 4: Synchronize the decrypted data to the bill library.

2. The method for processing reconciliation data according to claim 1, characterized in that: The specific steps of step 2 are as follows: the order data and business party code to be exported from the order library are encrypted using AES to obtain encrypted data; the encryption vector includes a set string and a business party code; the business party code corresponds to the order data; at least two conversion rules are set, and the conversion rule is to convert a set character into a string; a conversion rule is randomly selected to convert all characters in the encrypted data that meet the set requirements into strings to form converted data.

3. The method for processing reconciliation data according to claim 2, characterized in that: Specifically, step 3 is as follows: the order library sends the converted data and the order number to the billing library; the billing library queries the billing data based on the order number to obtain the corresponding business party code; the set character string and the business party code are combined to form an encryption vector; according to the set rules, the converted characters in the converted data are restored to obtain encrypted data; and then the encrypted data is decrypted using the encryption vector to obtain decrypted data.

4. The method for processing reconciliation data according to claim 1, characterized in that: The step 4 is specifically as follows: setting a synchronization queue, which is used to synchronize data; testing the decrypted data, and when no problem is found, storing the decrypted data in an Excel file and uploading it to a cloud storage service, storing the link corresponding to the cloud storage service in the synchronization queue, and when the synchronization queue executes a task, obtaining the decrypted data according to the link corresponding to the task, and synchronizing the decrypted data to the bill library in a queue manner.

5. A reconciliation data processing device, characterized by: Including order library and bill library, including the following modules: A storage module stores order data in an order library and bill data in a bill library, wherein the order data and bill data both include a business party code; An encryption module encrypts the order data and the business party code to be exported from the order library using AES to obtain encrypted data; the encryption vector includes a set string and the business party code; the business party code corresponds to the order data; Decryption module: The order library sends the encrypted data and order number to the billing library. The billing library queries the billing data based on the order number to obtain the corresponding business party code, combines the set string and the business party code to form an encryption vector, and decrypts the encrypted data using the encryption vector to obtain the decrypted data; A synchronization module synchronizes the decrypted data to the bill library.

6. The reconciliation data processing device according to claim 5, characterized in that: The encryption module specifically includes: encrypting the order data and business party code that need to be exported from the order library using AES to obtain encrypted data; the encryption vector includes a set string and a business party code; the business party code corresponds to the order data; setting at least two conversion rules, the conversion rule is to convert a set character into a string; randomly extracting a conversion rule, converting all characters in the encrypted data that meet the setting into a string to form converted data.

7. The reconciliation data processing device according to claim 6, characterized in that: The decryption module is specifically as follows: the order library sends the converted data and the order number to the bill library, the bill library queries the bill data according to the order number to obtain the corresponding business party code, combines the set string and the business party code to form an encryption vector, and according to the set rules, restores the converted characters in the converted data to obtain encrypted data, and then decrypts the encrypted data using the encryption vector to obtain decrypted data.

8. The reconciliation data processing device according to claim 5, characterized in that: The synchronization module specifically includes: setting a synchronization queue, which is used to synchronize data; testing the decrypted data, and when no problem is found, storing the decrypted data in an Excel file and uploading it to a cloud storage service, storing the link corresponding to the cloud storage service in the synchronization queue; when the synchronization queue executes a task, obtaining the decrypted data according to the link corresponding to the task, and synchronizing the decrypted data to the bill library in a queue manner.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the program, the method according to any one of claims 1 to 4 is implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method according to any one of claims 1 to 4 is implemented.

Images