Asynchronous batch accounting processing method and system based on Oracle MQ

Abstract

The invention provides an asynchronous batch accounting processing method and system based on Oracle MQ. The method comprises the steps that an Oracle MQ message queue is created, a channel end initiates a batch accounting processing request, a core system receives and judges whether a request processing mode is synchronous or asynchronous, and if the request mode is synchronous, the batch accounting processing request is synchronously processed; if the request mode is asynchronous, putting the received request data into an Oracle MQ message queue, and asynchronously processing batch accounting processing requests by the message queue; and finally, a batch accounting processing response is returned. According to the method and the device, the received request data is put into the Oracle MQ message queue, and the message queue asynchronously processes batch accounting processing requests, so that system resources are fully utilized, the processing speed is improved, the waiting time is shortened, the pressure of a large number of concurrent requests on a system is avoided, and the risk of system faults is reduced. And large-scale businesses can be supported, increasing business requirements of banks can be met, and rapid increase of transaction volume can be adapted.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and more specifically, to an asynchronous batch account processing method and system based on Oracle MQ. Background Art

[0002] Oracle MQ (Oracle Message Queue) is a message middleware product, a middleware technology used for asynchronous communication between different systems or components. It allows applications to send messages to queues, and other applications to receive and process these messages from queues. Oracle MQ provides a reliable message delivery mechanism to ensure the reliability, sequence and persistence of messages. It can achieve functions such as application decoupling, traffic peak shaving and asynchronous processing, and improve the scalability and fault tolerance of the system.

[0003] In banking business, due to the continuous growth of account transaction volume and the increase in business complexity, the traditional synchronous account processing method faces tight system resources, slow processing speed and long response time. Therefore, in order to improve processing efficiency, reduce costs, support large-scale business and provide high-quality customer experience, while meeting regulatory requirements and ensuring the accuracy and timeliness of accounts, it is very necessary for banks to adopt asynchronous batch processing of accounts. Oracle MQ message queue asynchronously processes large-scale bank account transactions. The channel end that initiates the business application can receive the response result in real time without waiting. It has high processing efficiency, takes up less resources, and supports large-scale account business. Summary of the invention

[0004] In view of the technical problems existing in the prior art, an asynchronous batch account processing method and system based on Oracle MQ are provided. By putting the received request data into the Oracle MQ message queue, the message queue asynchronously processes the batch account processing requests. The purpose is to solve the problems of tight system resources, slow processing speed and long response time faced by the traditional synchronous account processing method in banking business due to the continuous growth of account transaction volume and the increase of business complexity.

[0005] According to a first aspect of the present invention, there is provided an asynchronous batch account processing method based on Oracle MQ, comprising the following steps:

[0006] Create an Oracle MQ message queue, the channel end initiates a batch accounting processing request, the core system receives it and determines whether the request processing mode is synchronous or asynchronous:

[0007] If the request mode is synchronous, batch accounting processing requests are processed synchronously;

[0008] If the request mode is asynchronous, the received request data is placed in the Oracle MQ message queue, and the message queue asynchronously processes the batch accounting processing request;

[0009] Finally, the batch account processing response is returned.

[0010] Based on the above technical solution, the present invention can also make the following improvements.

[0011] Optionally, the step of placing the received request data into an Oracle MQ message queue and asynchronously processing the batch account processing request by the message queue includes the following steps:

[0012] The core system processes batch accounting processing request messages in the Oracle MQ queue;

[0013] Register verification information into the batch business registration table to verify batch accounting processing information;

[0014] If the verification is passed, the registration status in the batch business registration table is updated as: S - Processing successful;

[0015] If the verification fails, the registration status in the batch business registration table will be updated as: F - Processing failed.

[0016] Optionally, it also includes: reading and parsing the file according to the file path in the request, and verifying the accounting details in the file:

[0017] If the verification is passed, the account details in the batch file will be recorded in the account details registration table, and the processing status will be set to: N - unprocessed;

[0018] If the verification fails, the registration status in the batch business registration table will be updated as: F - Processing failed.

[0019] Optional, if verification is passed, also includes:

[0020] According to the file path in the request, read and parse the file, verify the account details in the file, if the verification passes, register the account details in the batch file into the account details registration table, and set the processing status to: N-unprocessed; if the verification fails, update the registration status in the batch business registration table to: F-processing failed;

[0021] Start polling and processing. The processing status of this batch in the account detail information registration table is: N - unprocessed details.

[0022] Optionally, the batch business registration form records the batch number, channel number, business number, transaction date, registration status, total number of batches, batch processing status, batch processing result file path and number of successfully processed transactions; the account details information registration form records the batch number, serial number, debit account number, debit amount, debit account type, debit currency, credit account number, credit amount, credit account type, credit currency, transaction date, transaction status, transaction error code and transaction error description.

[0023] Optionally, the processing status of the batch in the account detail information registration table when starting polling is: N-unprocessed details include:

[0024] Polling process for each account queried;

[0025] When all account details in the batch are processed, the number of successfully processed items is calculated;

[0026] Obtain the result file generation directory according to the configuration in the file directory configuration table, generate the batch account detail processing result file in this directory, and check the generated result file;

[0027] If the result file is generated successfully, the batch processing status of the batch in the batch business registration table is updated to: S-processing successful, and the batch processing result file path and the number of successful transactions are updated at the same time;

[0028] If the result file generation fails, update the batch processing status of the batch in the batch business registration table to: F - processing failed.

[0029] Optionally, each account queried by the polling process includes:

[0030] Verify and process each account. If the account is processed successfully, update the status of the account in the account details information registration table to: S-processing successful. If the account is processed unsuccessfully, update the status of the account in the account details information registration table to: F-processing failed. At the same time, update the transaction error code and transaction error description.

[0031] Optionally, the returned batch account processing response includes:

[0032] The channel initiates a batch accounting processing result query request to query the batch accounting processing results of the batch. The core system returns a response to the query of the batch accounting processing results, and the transaction ends.

[0033] Optionally, the querying of the batch accounting processing results includes:

[0034] The channel side initiates a batch accounting processing result query request, and the core system receives the batch accounting processing result query request;

[0035] According to the batch number, the batch processing result status, batch processing result file path and number of successful processing of the batch are queried in the batch business registration table, and the core system assembles the queried information;

[0036] The business processing is completed, and the core system returns a batch accounting processing result query response of "Successfully queried batch results!", and the transaction is completed.

[0037] According to a second aspect of the present invention, there is provided an asynchronous batch account processing system based on Oracle MQ, comprising:

[0038] The processing request initiation module is used to create an Oracle MQ message queue and initiate batch accounting processing requests on the channel side;

[0039] The processing request judgment processing module is used by the core system to receive and judge whether the request processing mode is synchronous or asynchronous: if the request mode is synchronous, the batch accounting processing request is processed synchronously; if the request mode is asynchronous, the received request data is placed in the Oracle MQ message queue, and the message queue processes the batch accounting processing request asynchronously; finally, the batch accounting processing response is returned.

[0040] Technical effects and advantages of the present invention:

[0041] The present invention provides an asynchronous batch account processing method and system based on Oracle MQ, which puts received request data into an Oracle MQ message queue, and asynchronously processes batch account processing requests by the message queue, which not only fully utilizes system resources, improves processing speed, reduces waiting time, avoids pressure on the system caused by a large number of concurrent requests, and reduces the risk of system failure. It can also support large-scale business, meet the growing business needs of banks, and adapt to the rapid growth of transaction volume.

[0042] Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or understood by practicing the present invention. The purpose and other advantages of the present invention can be realized and obtained by the structures pointed out in the description, claims and drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] Figure 1 A flowchart of an asynchronous batch account processing method based on Oracle MQ provided in an embodiment of the present invention;

[0044] Figure 2 A flow chart of processing batch account requests in an Oracle MQ queue provided by an embodiment of the present invention;

[0045] Figure 3A flowchart of processing account details information provided by an embodiment of the present invention;

[0046] Figure 4 A flow chart of querying batch account processing results provided by an embodiment of the present invention; DETAILED DESCRIPTION

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

[0048] In order to improve processing efficiency, reduce costs, support large-scale business and provide high-quality customer experience, while meeting regulatory requirements and ensuring the accuracy and timeliness of accounts, the traditional synchronous account processing method faces the problems of tight system resources, slow processing speed and long response time due to the continuous growth of account transaction volume and the increase of business complexity in banking business.

[0049] It is understandable that, based on the defects in the background technology, the embodiment of the present invention proposes an asynchronous batch account processing method based on Oracle MQ, specifically as follows: Figure 1 As shown, the following steps are included:

[0050] Create an Oracle MQ message queue. The channel end initiates a batch accounting processing request. The core system receives and determines whether the request processing mode is synchronous or asynchronous. If the request mode is synchronous, the batch accounting processing request is processed synchronously. If the request mode is asynchronous, the received request data is placed in the Oracle MQ message queue, and the message queue processes the batch accounting processing request asynchronously.

[0051] Returns batch account processing response.

[0052] Specific as Figure 2 As shown, the received request data is placed into the Oracle MQ message queue, and the message queue asynchronously processes the batch account processing request, including:

[0053] The core system processes batch accounting processing request messages in the Oracle MQ queue;

[0054] Register verification information in the batch business registration table to verify batch accounting processing information: the batch business registration table contains the batch number, channel number, business number, transaction date, registration status, total number of batches, batch processing status, batch processing result file path, and number of successfully processed transactions;

[0055] If the verification is passed, the registration status in the batch business registration table is updated as: S - Processing successful;

[0056] According to the file path in the request, read and parse the file, verify the account details in the file, if the verification passes, register the account details in the batch file into the account details registration table, and set the processing status to: N-unprocessed, if the verification fails, update the registration status in the batch business registration table to: F-processing failed; the batch number, serial number, debit account number, debit amount, debit account type, debit currency, credit account number, credit amount, credit account type, credit currency, transaction date, transaction status, transaction error code and transaction error description are registered in the account details registration table;

[0057] Start polling processing. The processing status of this batch in the account details information registration table is: N-unprocessed details;

[0058] If the verification fails, the registration status in the batch business registration table is updated as: F-processing failed;

[0059] Finally, commit the current transaction.

[0060] Polling processing batch account details such as Figure 3 As shown, the processing status of the batch in the account detail information registration table after the polling process is started is: N-unprocessed details include:

[0061] Polling and processing each account queried, including: verifying and processing each account. If the account is processed successfully, update the status of the account in the account details information registration table to: S-processing successful; if the account is processed unsuccessfully, update the status of the account in the account details information registration table to: F-processing failed, and update the transaction error code and transaction error description at the same time;

[0062] When all account details in the batch are processed, the number of successfully processed items is calculated;

[0063] According to the configuration in the file directory configuration table, obtain the result file generation directory, generate the batch account detail processing result file in this directory, and check the generated result file:

[0064] If the result file is generated successfully, the batch processing status of the batch in the batch business registration table is updated to: S-processing successful, and the batch processing result file path and the number of successful transactions are updated at the same time;

[0065] If the result file generation fails, update the batch processing status of the batch in the batch business registration table to: F - processing failed.

[0066] Finally, the business processing is completed, and the core system returns a batch accounting processing response of "Asynchronous processing request accepted!", and the transaction is completed;

[0067] The channel initiates a batch accounting processing result query request to query the batch accounting processing results of the batch. The core system returns a response to the query of the batch accounting processing results, and the transaction ends.

[0068] like Figure 4 As shown in the figure, the batch account processing query results include:

[0069] The channel side initiates a batch accounting processing result query request, and the core system receives the batch accounting processing result query request;

[0070] According to the batch number, the batch processing result status, batch processing result file path and number of successful processing of the batch are queried in the batch business registration table, and the core system assembles the queried information;

[0071] The business processing is completed, and the core system returns a batch accounting processing result query response of "Successfully queried batch results!", and the transaction is completed.

[0072] In summary, the asynchronous batch account processing method based on Oracle MQ provided by the embodiment of the present invention can process large-batch bank account transactions, and the channel end can receive the return result response of the request in real time without waiting, and the transaction is completed. The specific batch account is processed asynchronously by the Oracle MQ message queue. The processing efficiency is high, the resource occupation is small, and the large-batch account business is supported to ensure the accuracy and timeliness of the account.

[0073] According to a second aspect of the present invention, there is provided an asynchronous batch account processing system based on Oracle MQ, comprising:

[0074] The processing request initiation module is used to create an Oracle MQ message queue and initiate batch accounting processing requests on the channel side;

[0075] The processing request judgment processing module is used for the core system to receive and judge whether the request processing mode is synchronous or asynchronous: if the request mode is synchronous, the batch accounting processing request is processed synchronously; if the request mode is asynchronous, the received request data is placed in the Oracle MQ message queue, and the message queue processes the batch accounting processing request asynchronously; and returns the batch accounting processing response.

[0076] It can be understood that the asynchronous batch account processing system based on Oracle MQ provided by the present invention corresponds to the asynchronous batch account processing method based on Oracle MQ provided in the aforementioned embodiments. The relevant technical features of the asynchronous batch account processing system based on OracleMQ can refer to the relevant technical features of the asynchronous batch account processing method based on Oracle MQ, which will not be repeated here.

[0077] Finally, it should be noted that the embodiment of the present invention aims to solve the problems of tight system resources, slow processing speed and long response time faced by traditional synchronous account processing methods due to the continuous growth of account transaction volume and the increase in business complexity in banking business.

[0078] Through the description of the above implementation methods, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus a necessary general hardware platform, and of course, it can also be implemented by hardware. Based on this understanding, the above technical solution is essentially or the part that contributes to the prior art can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiments.

[0079] Finally, it should be noted that the above is only a preferred embodiment of the present invention and is not intended to limit the present invention. Although the present invention has been described in detail with reference to the aforementioned embodiments, it is still possible for those skilled in the art to modify the technical solutions described in the aforementioned embodiments or to make equivalent substitutions for some of the technical features therein. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the protection scope of the present invention.

Claims

1. An asynchronous batch account processing method based on Oracle MQ, characterized in that: include: Create an Oracle MQ message queue, the channel end initiates a batch accounting processing request, the core system receives it and determines whether the request processing mode is synchronous or asynchronous: If the request mode is synchronous, batch accounting processing requests are processed synchronously; If the request mode is asynchronous, the received request data is placed in the Oracle MQ message queue, and the message queue asynchronously processes the batch accounting processing request; Finally, the batch account processing response is returned.

2. The method for asynchronous batch accounting processing based on Oracle MQ according to claim 1, characterized in that: The step of placing the received request data into an Oracle MQ message queue and asynchronously processing the batch account processing request by the message queue includes the following steps: The core system processes batch accounting processing request messages in the Oracle MQ queue; Register verification information into the batch business registration table to verify batch accounting processing information; If the verification is passed, the registration status in the batch business registration table is updated as: S - Processing successful; If the verification fails, the registration status in the batch business registration table will be updated as: F - Processing failed.

3. The method for asynchronous batch accounting processing based on Oracle MQ according to claim 2, characterized in that: Also includes: According to the file path in the request, read and parse the file and verify the account details in the file: If the verification is passed, the account details in the batch file will be recorded in the account details registration table, and the processing status will be set to: N - unprocessed; If the verification fails, the registration status in the batch business registration table will be updated as: F - Processing failed.

4. The method for asynchronous batch accounting processing based on Oracle MQ according to claim 3, characterized in that: The batch business registration form records the batch number, channel number, business number, transaction date, registration status, total number of batches, batch processing status, batch processing result file path and number of successfully processed transactions; the account details registration form records the batch number, serial number, debit account number, debit amount, debit account type, debit currency, credit account number, credit amount, credit account type, credit currency, transaction date, transaction status, transaction error code and transaction error description.

5. The method for asynchronous batch accounting processing based on Oracle MQ according to claim 3, characterized in that: If the verification is passed, it also includes: According to the file path in the request, read and parse the file, verify the account details in the file, if the verification passes, register the account details in the batch file into the account details registration table, and set the processing status to: N-unprocessed; if the verification fails, update the registration status in the batch business registration table to: F-processing failed; Start polling and processing. The processing status of this batch in the account detail information registration table is: N - unprocessed details.

6. The method for asynchronous batch accounting processing based on Oracle MQ according to claim 5, characterized in that: The processing status of the batch in the account details information registration table after polling is started is: N-unprocessed details include: Polling process for each account queried; When all account details in the batch are processed, the number of successfully processed items is calculated; Obtain the result file generation directory according to the configuration in the file directory configuration table, generate the batch account detail processing result file in this directory, and check the generated result file; If the result file is generated successfully, the batch processing status of the batch in the batch business registration table is updated to: S-processing successful, and the batch processing result file path and the number of successful transactions are updated at the same time; If the result file generation fails, update the batch processing status of the batch in the batch business registration table to: F - processing failed.

7. The method for asynchronous batch accounting processing based on Oracle MQ according to claim 6, characterized in that: Each account queried by the polling process includes: Verify and process each account. If the account is processed successfully, update the status of the account in the account details information registration table to: S-processing successful. If the account is processed unsuccessfully, update the status of the account in the account details information registration table to: F-processing failed. At the same time, update the transaction error code and transaction error description.

8. The method for asynchronous batch accounting processing based on Oracle MQ according to claim 1, characterized in that: The returned batch account processing response includes: The channel initiates a batch accounting processing result query request to query the batch accounting processing results of the batch. The core system returns a response to the query of the batch accounting processing results, and the transaction ends.

9. The method for asynchronous batch accounting processing based on Oracle MQ according to claim 8, characterized in that: The query of the batch accounting processing results includes: The channel side initiates a batch accounting processing result query request, and the core system receives the batch accounting processing result query request; According to the batch number, the batch processing result status, batch processing result file path and number of successfully processed transactions of the batch are queried in the batch business registration table, and the core system assembles the queried information; The business processing is completed, and the core system returns a batch accounting processing result query response of "Successfully queried batch results!", and the transaction is completed.

10. An asynchronous batch accounting processing system based on Oracle MQ, characterized in that: include: The processing request initiation module is used to create an Oracle MQ message queue and initiate batch accounting processing requests on the channel side; The processing request judgment processing module is used by the core system to receive and judge whether the request processing mode is synchronous or asynchronous: if the request mode is synchronous, the batch accounting processing request is processed synchronously; if the request mode is asynchronous, the received request data is placed in the Oracle MQ message queue, and the message queue processes the batch accounting processing request asynchronously; finally, the batch accounting processing response is returned.

Images