Batch business back-to-back query processing method and device

Abstract

This invention proposes a method and apparatus for batch business backtracking and query processing, relating to big data processing technology and the fintech field. The method includes: obtaining batch business processing instructions; determining a business batch table and an instruction details table; packaging the batch business and marking each with a business category identifier; setting up an online processing thread for each business category, with the online processing thread consuming record threads according to the business category identifier; for each business category, the corresponding business transaction system pulls record threads, processes the corresponding business data packets, and returns the transaction results to the online processing thread; consuming the transaction results from the online processing thread to update the instruction details table, modifying the business status corresponding to the transaction processing result to "processed"; performing backtracking processing based on the business category identifier corresponding to the transaction result, updating the batch status of the business batch table; and querying the business status in the instruction details table and the batch status in the business batch table according to the query instruction initiated by the queryer.

Description

Technical Field

[0001] This invention relates to big data processing technology and the field of financial technology, and more particularly to a method and apparatus for batch business backtracking and query processing. Background Technology

[0002] This section is intended to provide background or context for the embodiments of the invention set forth in the claims. The description herein is not an admission that it is prior art simply because it is included in this section.

[0003] In batch transaction scenarios, after a customer initiates a batch transaction, the bank will use an agency service to process and adjust the account to ensure the funds are credited to the account. After the account is adjusted, the customer can check the transaction details to see if the transaction was successful.

[0004] However, conventional account reversal processing requires unified aggregation, merging, and backtracking after processing on the mainframe. Customers can only view the business processing results after the backtracking update. This method is slow. Typically, waiting for the backtracking operation requires all three third-party processing applications to complete their processing before merging, inevitably causing files to wait for each other to complete. Generally, it takes 30-60 minutes to update; on peak days, when there are queues in the account reversal process, the waiting time will be even longer. During this time, the customer's instruction status will remain "pending processing." Furthermore, traceability is poor; while the customer waits for the account reversal system to process, the front-end status continuously indicates "waiting for bank processing," but the customer cannot trace whether the instruction has actually been processed, whether the system is stuck, or which processing stage it is currently in, thus unable to know approximately when it will be completed, causing confusion for the customer. In addition, it wastes server resources; because the intermediate application processing in the agency business involves splitting, merging, and waiting processing stages, it expands the thread design and file temporary storage usage in the file transfer process, not only wasting server resources but also lengthening the transaction chain, easily leading to production queuing problems.

[0005] In summary, existing technologies suffer from problems such as slow update speed, poor traceability, waste of server resources, and inability for customers to query business processing results in a timely and effective manner. Therefore, there is an urgent need for a batch business backlog query processing technology solution that can overcome the above defects. Summary of the Invention

[0006] To address the problems existing in the prior art, this invention proposes a method and apparatus for batch business back-to-work query processing.

[0007] In a first aspect of the present invention, a batch service backlog query processing method is proposed, comprising:

[0008] Obtain batch business processing instructions;

[0009] The batch processing instruction is used to determine the batch processing table and the instruction details table.

[0010] Package the batch services corresponding to the batch service processing instructions into a package, and mark each service data packet with a service category flag during the packaging process;

[0011] Set up an online processing thread for each business category, and have the online processing thread consume the record thread according to the business category flag;

[0012] For each business category, the corresponding business transaction system pulls the record thread, processes the corresponding business data packet, and returns the transaction result to the online processing thread;

[0013] Update the transaction result details table of the online consumption processing thread to change the business status corresponding to the transaction processing result to "processed";

[0014] Perform a recount based on the business category flag corresponding to the transaction results, and update the batch status of the business batch table.

[0015] Based on the query instruction initiated by the user, the query instruction details table shows the business status, and the business batch table shows the batch status.

[0016] In a second aspect of the present invention, a batch service backlog query processing apparatus is provided, comprising:

[0017] The instruction acquisition module is used to acquire batch business processing instructions;

[0018] The enterprise online banking server is used to determine the business batch table and instruction details table based on the batch business processing instructions;

[0019] The enterprise online banking data packet return server is used to package the batch business corresponding to the batch business processing instructions, and to mark each business data packet with a business category flag during the packaging process.

[0020] The proxy business intermediate processing module is used to set up online processing threads for each business category, and the online processing threads consume record threads according to the business category flags;

[0021] The business transaction system is used to retrieve records from the corresponding business transaction system for each business category, process the relevant business data packets, and return the transaction results to the online processing thread.

[0022] The enterprise online banking server is used to update the transaction result details table of the online transaction processing thread and modify the business status corresponding to the transaction processing result to "processed".

[0023] The enterprise online banking package return server is used to perform return processing based on the business category flag corresponding to the transaction results and update the batch status of the business batch table.

[0024] The instruction acquisition module is used to acquire the query instruction initiated by the queryer, and based on the query instruction initiated by the queryer, to query the business status in the instruction details table and the batch status in the business batch table.

[0025] In a third aspect of the present invention, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement a batch business back-to-disk query processing method.

[0026] In a fourth aspect of the present invention, a computer-readable storage medium is provided, the computer-readable storage medium storing a computer program, which, when executed by a processor, implements a batch business back-to-disk query processing method.

[0027] In a fifth aspect of the present invention, a computer program product is provided, the computer program product comprising a computer program, wherein when the computer program is executed by a processor, a batch business back-to-disk query processing method is implemented.

[0028] The batch business replay query processing method and apparatus proposed in this invention adds an online processing thread and an intermediate table to the intermediate application of agency business. The existing data packet splitting and merging process is moved forward to the corporate online banking package replay service side. Data is directly retrieved and consumed through the online processing thread, and the intermediate table status is registered. The status of the instruction details and batch package are updated before and after the data replay, significantly shortening the time for updating details. The overall solution of this invention provides corporate banking customers with a faster, more accurate, and controllable batch business query mechanism. Furthermore, the business processing process can be traced through the online processing thread. By improving the processing method of the intermediate application of agency business, the batch business replay and the processing of each business detail are synchronized, reducing server resource consumption and greatly improving the efficiency of batch business queries. This meets customers' requirements for the progress of batch business query details and provides strong technical support for batch business scenarios. Attached Figure Description

[0029] To more clearly illustrate the technical solutions of the embodiments of this application, the drawings used in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0030] Figure 1This is a schematic diagram of a batch business back-to-work query processing method according to an embodiment of the present invention.

[0031] Figure 2 This is a schematic diagram of the architecture of a batch business return query processing device according to an embodiment of the present invention.

[0032] Figure 3 This is a schematic diagram of the architecture in the application scenario of existing technologies.

[0033] Figure 4 This is a schematic diagram of the architecture of a specific embodiment of the present invention.

[0034] Figure 5 This is a schematic diagram of a computer device structure according to an embodiment of the present invention. Detailed Implementation

[0035] The principles and spirit of the invention will now be described with reference to several exemplary embodiments. It should be understood that these embodiments are given merely to enable those skilled in the art to better understand and implement the invention, and are not intended to limit the scope of the invention in any way. Rather, these embodiments are provided to make this disclosure more thorough and complete, and to fully convey the scope of this disclosure to those skilled in the art.

[0036] Those skilled in the art will recognize that embodiments of the present invention can be implemented as a system, apparatus, device, method, or computer program product. Therefore, this disclosure can be specifically implemented in the following forms: entirely hardware, entirely software (including firmware, resident software, microcode, etc.), or a combination of hardware and software.

[0037] According to embodiments of the present invention, a method and apparatus for batch transaction backlog query processing are proposed, relating to big data processing technology and the field of financial technology. This invention provides corporate banking clients with a faster, more accurate, and more controllable payroll transaction query service, greatly improving the efficiency of enterprises in querying the transaction details and progress of payroll transactions.

[0038] The principles and spirit of the present invention will be explained in detail below with reference to several representative embodiments.

[0039] Figure 1 This is a schematic flowchart of a batch business back-to-work query processing method according to an embodiment of the present invention. Figure 1 As shown, the method includes:

[0040] Step S101: Obtain batch business processing instructions;

[0041] Step S102: Determine the business batch table and instruction details table according to the batch business processing instruction;

[0042] Step S103: Package the batch services corresponding to the batch service processing instruction into a package, and mark each service data packet with a service category flag during packaging;

[0043] Step S104: Set up an online processing thread for each service category, and have the online processing thread consume the record thread according to the service category flag;

[0044] Step S105: For each business category, the corresponding business transaction system pulls the record thread, processes the corresponding business data packet, and returns the transaction result to the online processing thread.

[0045] Step S106: Update the transaction result details table of the online consumption processing thread to change the business status corresponding to the transaction processing result to "processed";

[0046] Step S107: Perform a recount based on the business category flag corresponding to the transaction results, and update the batch status of the business batch table.

[0047] Step S108: Based on the query instruction initiated by the queryer, query the business status in the query instruction details table and the batch status in the business batch table.

[0048] In practical applications, the batch business backtracking query processing method of the present invention works as follows: A batch business processing instruction is obtained; a business batch table and an instruction details table are determined based on the batch business processing instruction; the batch business corresponding to the batch business processing instruction is packaged, and each business data packet is marked with a business category flag during packaging; an online processing thread is set for each business category, and the online processing thread consumes record threads according to the business category flag; for each business category, the corresponding business transaction system pulls record threads, processes the corresponding business data packets, and returns the transaction results to the online processing thread; the transaction results from the online processing thread are consumed to update the instruction details table, and the business status corresponding to the transaction processing result is modified to "processed"; backtracking is performed based on the business category flag corresponding to the transaction result, and the batch status of the business batch table is updated; based on the query instruction initiated by the queryer, the business status in the instruction details table and the batch status in the business batch table are queried.

[0049] This invention optimizes the data packet splitting and merging process by adding an online processing thread to directly retrieve and consume business data, register the status of intermediate tables, and update the status of instruction details and batch packets respectively. This significantly shortens the time for data rollback updates, providing corporate banking customers with more accurate and faster transaction queries. Furthermore, the online processing thread can trace the business processing process, improving the processing method of the intermediate application in the agency business to achieve synchronous processing of batch business rollbacks and individual business details, reducing server resource consumption, greatly improving the efficiency of batch business queries, meeting customers' requirements for detailed progress in batch business queries, and providing strong technical support for batch business scenarios.

[0050] To provide a clearer explanation of the batch transaction backlog query processing method described above, each step will be explained in detail below.

[0051] Step S101: Obtain batch business processing instructions.

[0052] In one embodiment, the batch processing instruction is an instruction submitted by the customer through the corporate online banking system, such as a code-based payroll instruction.

[0053] Step S102: Determine the business batch table and instruction details table according to the batch business processing instruction.

[0054] Specifically, based on the batch business processing instruction, the corresponding dispatch file is parsed, verified, and a business category flag is determined to generate a business batch table and an instruction details table.

[0055] The initial batch status in the business batch table is "Pending Return"; the business status in the instruction details table is "Pending Processing".

[0056] In practical applications, the business category identifiers include at least the business category identifiers corresponding to personal financial services, credit card services, and corporate services.

[0057] Step S103: Package the batch services corresponding to the batch service processing instruction into a package, and mark each service data packet with a service category flag during packaging.

[0058] Specifically, the entire batch of business corresponding to the batch business processing instruction is packaged; and business category markers corresponding to personal financial business, credit card business, or corporate business are added to the data within the package.

[0059] Step S104: Set up an online processing thread for each service category, and have the online processing thread consume the record thread according to the service category flag.

[0060] Specifically, a new Kafka online processing thread is added for each business category flag, and a consumer thread and a pull thread are added to the intermediate table for registration;

[0061] The intermediate table is used to register business data that needs to be moved and the status of the movement.

[0062] Step S105: For each business category, the corresponding business transaction system pulls the record thread, processes the corresponding business data packet, and returns the transaction result to the online processing thread.

[0063] Specifically, the business transaction system pulls the business data that needs to be processed from the intermediate table of the Kafka online processing thread and completes the registration of the transaction instructions; the current transaction status of the intermediate table is pending transaction.

[0064] The transaction is processed according to the registered transaction instructions, and the transaction results are returned to the intermediate table of the Kafka online processing thread. The transaction status of the intermediate table is then updated to "transaction completed".

[0065] Step S106: Update the transaction result details table of the online consumption processing thread to change the business status corresponding to the transaction processing result to "processed", including:

[0066] The enterprise online banking server consumes the transaction results registered in the intermediate table of the Kafka online processing thread and updates them in the instruction details table; the business status of each business is updated independently.

[0067] Step S107: Perform a recount based on the business category flag corresponding to the transaction change result, and update the batch status of the business batch table, including:

[0068] The corporate online banking package return server re-merges the return data according to the business category flag corresponding to the transaction results and returns it to the corporate online banking server, which then updates the batch status of the business batch table.

[0069] If there are unprocessed return requests within the same batch of transactions, the batch status will be "Pending Return Request"; if all return requests within the same batch are processed, the batch status will be updated to "Processed".

[0070] Step S108: Based on the query instruction initiated by the queryer, query the business status in the query instruction details table and the batch status in the business batch table.

[0071] When querying batch status, if there are any transactions that have not been returned to disk, the batch status in the transaction batch table will be "not returned to disk". When querying instruction details, you can find the status of each transaction as "incomplete", "processed successfully", or "processed unsuccessfully".

[0072] Based on the above method, the data packet splitting and merging process is optimized. By adding an online processing thread, business data is directly retrieved and consumed, and the intermediate table status is registered. The status of instruction details and batch packets are updated respectively, which greatly shortens the time for data rollback updates. This provides corporate banking customers with more accurate and faster transaction queries. Furthermore, the online processing thread can trace the business processing process, improve the processing method of the intermediate application of the agency business, realize the synchronous processing of batch business rollback and individual business details, reduce server resource consumption, greatly improve the efficiency of batch business queries, meet customers' requirements for detailed progress of batch business queries, and provide strong technical support for batch business scenarios.

[0073] It should be noted that although the operation of the method of the present invention has been described in a specific order in the above embodiments and figures, this does not require or imply that the operations must be performed in that specific order, or that all the operations shown must be performed to achieve the desired result. Additionally or alternatively, certain steps may be omitted, multiple steps may be combined into one step, and / or one step may be broken down into multiple steps.

[0074] After introducing the method of exemplary embodiments of the present invention, the following references are made. Figure 2 The present invention will now describe a batch service backlog query processing apparatus according to an exemplary embodiment of the present invention.

[0075] The implementation of the batch business return query processing device can refer to the implementation of the above method, and the repeated parts will not be described again. The term "module" or "unit" used below can be a combination of software and / or hardware to implement a predetermined function. Although the device described in the following embodiments is preferably implemented in software, hardware implementation, or a combination of software and hardware, is also possible and contemplated.

[0076] Based on the same inventive concept, this invention also proposes a batch business back-to-work query processing device, such as... Figure 2 As shown, the device includes:

[0077] Instruction acquisition module 210 is used to acquire batch business processing instructions;

[0078] Enterprise online banking server 220 is used to determine the business batch table and instruction details table according to the batch business processing instructions;

[0079] The enterprise online banking data packet return server 230 is used to package the batch business corresponding to the batch business processing instructions, and to mark each business data packet with a business category flag during packaging.

[0080] The agent business intermediate processing module 240 is used to set up online processing threads for each business category, and the online processing threads consume record threads according to the business category flags;

[0081] The business transaction system 250 is used to retrieve records from the corresponding business transaction system for each business category, process the corresponding business data packets, and return the transaction results to the online processing thread.

[0082] The enterprise online banking server 220 is used to update the transaction result details table of the online transaction processing thread and modify the business status corresponding to the transaction processing result to "processed".

[0083] The enterprise online banking package return server 230 is used to perform return processing based on the business category flag corresponding to the transaction results and update the batch status of the business batch table.

[0084] The instruction acquisition module 210 is used to acquire the query instruction initiated by the queryer, and according to the query instruction initiated by the queryer, query the business status in the instruction details table and the batch status in the business batch table.

[0085] In one embodiment, the enterprise online banking server 220 determines a business batch table and an instruction details table based on the batch business processing instructions, including:

[0086] Based on the batch business processing instruction, the corresponding delivery file is parsed, verified, and the business category flag is determined to generate a business batch table and an instruction details table.

[0087] The initial batch status in the business batch table is "awaiting return"; the business status in the instruction details table is "pending processing"; and the business category flags include at least the business category flags corresponding to personal financial business, credit card business, and corporate business.

[0088] In one embodiment, the enterprise online banking data packet return server 230 packages the batch business corresponding to the batch business processing instruction, and marks each business data packet with a business category flag during packaging, including:

[0089] Package the batch services corresponding to the batch service processing instructions; during packaging, mark the service category according to the service category corresponding to each service data.

[0090] In one embodiment, the proxy service intermediate processing module 240 sets up an online processing thread for each service category, and the online processing thread consumes record threads according to the service category flag, including:

[0091] Add a new Kafka online processing thread for each business category flag, and add consumer and pull threads registered in the intermediate table;

[0092] The intermediate table is used to register business data that needs to be moved and the status of the movement.

[0093] In one embodiment, the business transaction system 250, for each business category, has a record-pulling thread corresponding to that business category, processes the corresponding business data packets, and returns the transaction results to the online processing thread, including:

[0094] The business transaction system pulls the business data that needs to be processed from the intermediate table of the Kafka online processing thread and completes the registration of the transaction instructions; the current transaction status of the intermediate table is pending transaction.

[0095] The transaction is processed according to the registered transaction instructions, and the transaction results are returned to the intermediate table of the Kafka online processing thread. The transaction status of the intermediate table is then updated to "transaction completed".

[0096] In one embodiment, the enterprise online banking server 220 updates the transaction result details table of the online transaction processing thread, modifying the business status corresponding to the transaction processing result to "processed," including:

[0097] The transaction results registered in the intermediate table of the enterprise online banking server 220's Kafka online processing thread are updated in the instruction details table; among them, the business status of each business is updated independently.

[0098] In one embodiment, the enterprise online banking batching and resubmission server 230 performs resubmission processing based on the business category flag corresponding to the transaction results, and updates the batch status of the business batch table, including:

[0099] The corporate online banking package return server 230 re-merges the return data of the business category flag according to the business category flag of the transaction result and returns it to the corporate online banking server 220, which then updates the batch status of the business batch table.

[0100] If there are unprocessed return requests within the same batch of transactions, the batch status will be "Pending Return Request"; if all return requests within the same batch are processed, the batch status will be updated to "Processed".

[0101] In one embodiment, the batch processing instruction is a code-based payroll instruction submitted by the customer through the corporate online banking system.

[0102] Based on the optimized data packet splitting and merging process using the aforementioned device, the newly added online processing thread directly retrieves and consumes business data, registers the status of intermediate tables, and updates the status of instruction details and batch packets respectively. This significantly shortens the time for data rollback updates, providing corporate banking customers with more accurate and faster transaction queries. Furthermore, the online processing thread can trace the business processing process, improving the processing method of the intermediate application in the agency business to achieve synchronous processing of batch business rollbacks and individual business details, reducing server resource consumption, greatly improving the efficiency of batch business queries, meeting customers' requirements for detailed progress in batch business queries, and providing strong technical support for batch business scenarios.

[0103] It should be noted that although several modules of the batch business callback query processing device are mentioned in the detailed description above, this division is merely exemplary and not mandatory. In fact, according to embodiments of the present invention, the features and functions of two or more modules described above can be embodied in one module. Conversely, the features and functions of one module described above can be further divided and embodied by multiple modules.

[0104] The following detailed explanation of the batch business backlog query processing method is based on a specific embodiment.

[0105] Taking corporate payroll processing as an example, corporate payroll processing refers to the process by which corporate clients use financial institutions to distribute wages, subsidies, or service fees to their employees. This is generally handled by banks and is a basic business of the bank's corporate banking system. Currently, when corporate clients use bank payment services for payroll processing, the bank will process the transaction through an intermediary agency to ensure that the wages are credited to their accounts. After the transaction is processed, the client can check the transaction details to confirm its success.

[0106] refer to Figure 3 This is a schematic diagram of the architecture in an application scenario of existing technologies. For example... Figure 3 As shown, the application scenario of the existing technology involves five parties: the front-end query terminal, the corporate online banking server, the corporate online banking packaging and return server, the agent business intermediate application, and the host processing terminal. The specific processing flow is as follows:

[0107] 1. The customer submits a payroll disbursement instruction on the enterprise website.

[0108] 2. Update the batch table and instruction table status to pending.

[0109] 3. Package the data back to the server via the corporate online banking system, and then send the package to the bank's agency business application server via GTP.

[0110] 4. The intermediary applications for agency business are divided into three categories: personal debit cards, personal credit cards, and corporate accounts.

[0111] 5. Agency business is handled separately by the personal financial business application, credit card application, and corporate settlement product service back-end mainframe accounting system through fixed-session batch processing.

[0112] 6. After the host processing is completed, the transaction processing result is sent.

[0113] 7. In the middle of the agency business, the results of the transaction processing are summarized and merged into a unified return instruction package, which is then returned to the corporate online banking package return server through the GTP task.

[0114] 8. The server parses and returns the enterprise online banking packaged files to disk.

[0115] 9. Update the transaction results to the corporate online banking payroll product database by scanning with threads, and simultaneously update the status of the payroll batch table and the internal detailed instruction table from pending to processed.

[0116] 10. Customers can check all processing results of the payroll order through the corporate online banking payroll transaction query page.

[0117] After submitting the instruction, the customer has to wait for a period of time to check the results of the payout, and during this period, the customer cannot track the progress of the payout transaction.

[0118] refer to Figure 4 This is a schematic diagram of the architecture of a specific embodiment of the present invention. Figure 4 As shown, five parties are involved: the front-end query terminal ( Figure 2 The instruction acquisition module acquires instructions initiated by the customer, the enterprise online banking server, the enterprise online banking package return server, and the agent business middleware application. Figure 2 The middle processing module for proxy business), the host processing end ( Figure 2 (Business transaction system).

[0119] Corporate online banking server: This server handles the basic processing after the payroll disbursement instruction is submitted, and is the initiator of the business process described in this invention.

[0120] Corporate online banking file packaging and return server: An application backend that packages and returns outgoing files.

[0121] Application in agency business: Provides methods for processing corporate payroll services.

[0122] Main processing end: The background account processing system receives and processes the information sent by the agency business and returns the results to the agency business.

[0123] The batch status table, or batch table, stores overall information about the batch numbers of instructions generated after a customer submits them. Customers can check the status of their submitted batches under the transaction query section to see if they are being processed, including pending, processed, pending return, and other error information from the parsing steps. This information is displayed by reading the batch status table. Figure 3 In the existing process, this table needs to wait for the disk file to be parsed before it can be updated. This invention keeps the update method unchanged.

[0124] The instruction details table, or instruction table, is used to record the detailed information of each specific payout instruction within each batch. Customers can access the details of each payout instruction within a batch by clicking the specific batch number link in the transaction query section. The instructions are numbered sequentially as -1, -2, -3, and so on, and include information on whether the processing was successful or failed, as well as the specific reason for each failed transaction. This information is displayed by reading the status of the instruction table. Figure 3 In the existing process, the status of this table must be updated after the return file is parsed and updated together with the batch table, resulting in a time difference between the transaction activity and the status update. This invention will change the process so that the status of this table is updated first, allowing customers to track and query transactions.

[0125] The intermediate table, also known as the agency business intermediate table, is newly added to record the status changes of an instruction during the intermediate application processing of the agency business, which facilitates downstream account adjustments and upstream queries.

[0126] like Figure 4 As shown, the specific process for account activity processing and inventory reconciliation is as follows:

[0127] 1. When a customer submits a payroll disbursement instruction on the enterprise website, the current batch table / instruction table status is "pending".

[0128] 2. The corporate online banking server receives the instruction and performs basic processing on the file, such as compliance parsing, protocol verification, and uploading flags, and records the current status of the transaction as pending.

[0129] 3. The corporate online banking data is packaged and returned to the server. The server packages the basic backend processing data and adds a new upload flag field (Personal Finance 1, Credit Card 2, Corporate Account 0). This step will ( Figure 3 Existing technology involves packaging agency business upfront, directly arranging data by sending up flags.

[0130] 4. For each agent application, add a new Kafka thread for different upload flags, and add consumption and retrieval threads registered in the intermediate table. The intermediate table is used to register which data needs to be processed and what the processing status is.

[0131] Taking personal finance (marked as 1) as an example, the data marked as 1 in the packaged data is scanned and registered in the intermediate table. At this time, the account name, account number, and untouched account flag of these data are recorded in the intermediate table.

[0132] 5. The host processing terminal retrieves the data to be manipulated from the intermediate table of the agent business intermediate application and completes the registration of the instruction to manipulate the account. At this time, the dynamic status of the agent business intermediate table is pending manipulation.

[0133] 6. Send the data to the host processing end for transaction processing, and return the transaction result to the intermediate table of the Kafka system in the middle application of the agency business, updating the status to "transaction completed".

[0134] 7. Update the transaction results registered in the intermediate table of direct consumption agency business on the corporate online banking server to the instruction details table (after the update is completed, proceed to step 8).

[0135] Meanwhile, the corporate online banking package return server re-merges the return data with different flags according to the upload flag and returns it to the corporate online banking server. This step moves the original return data merging to the corporate online banking side, reducing the waiting time on the agency business side (after the update is completed, jump to step 9).

[0136] 8. The enterprise online banking server-side thread updates the status of the instruction details table to the processing result.

[0137] At this point, the customer's batch status is "Pending Return," but the query instruction details show either "Processed Successfully" or "Processed Failed." The customer can then query the results of individual completed instructions. This step, processed through an online thread, achieves real-time updates of each instruction's status, significantly reducing the waiting time compared to the original batch return process. It eliminates the need to wait for return updates, instantly returning the detailed status to the instruction table.

[0138] 9. The enterprise online banking server-side thread scans the disk files.

[0139] 10. Update the overall batch status to "Processed". At this point, customers can query the batch status and see "Processed", while querying the command details will show either "Processed Successfully" or "Processed Failed". The update is now complete. This step retains the relevant processing modules for updating the status on disk in the original workflow, ensuring the integrity of the overall delivery process. Furthermore, in the event of a survival issue, the disk file can be cross-validated with the real-time updates from Kafka, enabling traceability of the business processing and ensuring the accuracy of the results.

[0140] This invention adds a Kafka registration thread and an intermediate table to the agency business application, moving the original data packet splitting and merging process to the enterprise online banking packaging and back-to-disk service side. The data to be sent is directly pulled and consumed through the Kafka thread, the intermediate table status is registered, and the instruction details status and batch package status are updated before and after, respectively. This greatly shortens the back-to-disk update time to within 10 minutes, while the existing technology requires 30-60 minutes to complete the back-to-disk processing.

[0141] This invention provides clearer progress control for corporate online banking payroll customers' transaction inquiries, solving the problems of excessively long waiting times for transaction status and unchanging query status. It offers corporate banking customers more accurate and faster transaction inquiries, reduces technical performance issues such as host power consumption, and greatly improves the requirements of enterprises for the progress of payroll transaction inquiries.

[0142] Based on the aforementioned inventive concept, such as Figure 5 As shown, the present invention also proposes a computer device 500, including a memory 510, a processor 520, and a computer program 530 stored in the memory 510 and executable on the processor 520. When the processor 520 executes the computer program 530, it implements the aforementioned batch service back-to-disk query processing method.

[0143] Based on the aforementioned inventive concept, the present invention proposes a computer-readable storage medium storing a computer program, which, when executed by a processor, implements the aforementioned batch business back-to-disk query processing method.

[0144] Based on the aforementioned inventive concept, this invention proposes a computer program product, which includes a computer program that, when executed by a processor, implements a batch business back-to-work query processing method.

[0145] The batch business replay query processing method and apparatus proposed in this invention adds an online processing thread and an intermediate table to the intermediate application of agency business. The existing data packet splitting and merging process is moved forward to the corporate online banking package replay service side. Data is directly retrieved and consumed through the online processing thread, and the intermediate table status is registered. The status of the instruction details and batch package are updated before and after the data replay, significantly shortening the time for updating details. The overall solution of this invention provides corporate banking customers with a faster, more accurate, and controllable batch business query mechanism. Furthermore, the online processing thread can trace the business processing process, improving the processing method of the intermediate application of agency business to achieve synchronous processing of batch business replay and individual business details, reducing server resource consumption, greatly improving the efficiency of batch business queries, meeting customers' requirements for batch business query detail progress, and providing strong technical support for batch business scenarios.

[0146] The acquisition, storage, use, and processing of data in this application comply with relevant laws and regulations.

[0147] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, apparatus, or computer program products. Therefore, the present invention can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0148] This invention is described with reference to flowchart illustrations and / or block diagrams of methods and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations 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, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0149] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1The function specified in one or more boxes.

[0150] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0151] Finally, it should be noted that the above-described embodiments are merely specific implementations of the present invention, used to illustrate the technical solutions of the present invention, and not to limit it. The scope of protection of the present invention is not limited thereto. Although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that any person skilled in the art can still modify or easily conceive of changes to the technical solutions described in the foregoing embodiments within the technical scope disclosed in the present invention, or make equivalent substitutions for some of the technical features; and these modifications, changes, or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention, and should all be covered within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be determined by the scope of the claims.

Claims

1. A batch business back-to-back query processing method, characterized in that, include: Obtain batch business processing instructions; The batch processing instruction is used to determine the batch processing table and the instruction details table. Package the batch services corresponding to the batch service processing instructions into a package, and mark each service data packet with a service category flag during the packaging process; Set up an online processing thread for each business category, and have the online processing thread consume the record thread according to the business category flag; For each business category, the corresponding business transaction system pulls the record thread, processes the corresponding business data packet, and returns the transaction result to the online processing thread; Update the transaction result details table of the online consumption processing thread to change the business status corresponding to the transaction processing result to "processed"; Perform a recount based on the business category flag corresponding to the transaction results, and update the batch status of the business batch table. Based on the query instruction initiated by the queryer, the business status in the query instruction details table and the batch status in the business batch table; Perform a recount based on the business category flag corresponding to the transaction status result, and update the batch status of the business batch table, including: The corporate online banking package return server re-merges the return data according to the business category flag corresponding to the transaction results and returns it to the corporate online banking server, which then updates the batch status of the business batch table. If there are unprocessed return requests within the same batch of transactions, the batch status will be "Pending Return Request"; if all return requests within the same batch are processed, the batch status will be updated to "Processed".

2. The method according to claim 1, characterized in that, The batch processing instruction determines the batch processing table and instruction details table, including: Based on the batch business processing instruction, the corresponding delivery file is parsed, verified, and the business category flag is determined to generate a business batch table and an instruction details table. The initial batch status in the business batch table is "Pending Return"; the business status in the instruction details table is "Pending Processing".

3. The method according to claim 1, characterized in that, The business category identifiers include at least the business category identifiers corresponding to personal financial services, credit card services, and corporate services. The batch services corresponding to the batch service processing instructions are packaged, and each service data packet is marked with a service category flag during packaging, including: Package the entire batch of services corresponding to the batch service processing instruction. Add business category labels corresponding to personal financial services, credit card services, or corporate services to the data within the package.

4. The method according to claim 1, characterized in that, Each service category has an online processing thread, which consumes record threads according to the service category flag, including: Add a new Kafka online processing thread for each business category flag, and add consumer and pull threads registered in the intermediate table; The intermediate table is used to register business data that needs to be moved and the status of the movement.

5. The method according to claim 1, characterized in that, For each business category, the corresponding business transaction system retrieves records via a dedicated thread, processes the relevant business data packets, and returns the transaction results to the online processing thread, including: The business transaction system pulls the business data that needs to be processed from the intermediate table of the Kafka online processing thread and completes the registration of the transaction instructions; the current transaction status of the intermediate table is pending transaction. The transaction is processed according to the registered transaction instructions, and the transaction results are returned to the intermediate table of the Kafka online processing thread. The transaction status of the intermediate table is then updated to "transaction completed".

6. The method according to claim 1, characterized in that, The details table of transaction processing results update instructions for the online consumption processing thread modifies the business status corresponding to the transaction processing result to "processed," including: The enterprise online banking server consumes the transaction results registered in the intermediate table of the Kafka online processing thread and updates them in the instruction details table; the business status of each business is updated independently.

7. The method according to claim 1, characterized in that, The batch processing instructions are code-based payroll instructions submitted by customers through the corporate online banking system.

8. A batch business rollback query processing device, characterized in that, include: The instruction acquisition module is used to acquire batch business processing instructions; The enterprise online banking server is used to determine the business batch table and instruction details table based on the batch business processing instructions; The enterprise online banking data packet return server is used to package the batch business corresponding to the batch business processing instructions, and to mark each business data packet with a business category flag during the packaging process. The proxy business intermediate processing module is used to set up online processing threads for each business category, and the online processing threads consume record threads according to the business category flags; The business transaction system is used to retrieve records from the corresponding business transaction system for each business category, process the relevant business data packets, and return the transaction results to the online processing thread. The enterprise online banking server is used to update the transaction result details table of the online transaction processing thread and modify the business status corresponding to the transaction processing result to "processed". The enterprise online banking package return server is used to perform return processing based on the business category flag corresponding to the transaction results and update the batch status of the business batch table. The instruction acquisition module is used to acquire the query instruction initiated by the queryer, and based on the query instruction initiated by the queryer, to query the business status in the instruction details table and the batch status in the business batch table; The enterprise online banking data package return server performs return processing based on the business category flag corresponding to the transaction results, and updates the batch status of the business batch table, including: The corporate online banking package return server re-merges the return data of the business category flag according to the business category flag corresponding to the transaction results and returns it to the corporate online banking server, which then updates the batch status of the business batch table. If there are unprocessed return requests within the same batch of transactions, the batch status will be "Pending Return Request"; if all return requests within the same batch are processed, the batch status will be updated to "Processed".

9. A computer device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the computer program, it implements the method of any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when executed by a processor, implements the method of any one of claims 1 to 7.

11. A computer program product, characterized in that, The computer program product includes a computer program that, when executed by a processor, implements the method of any one of claims 1 to 7.

Images