Method and apparatus for automated batch checking of bank core systems
The method and apparatus for automated batch inspection of the bank's core system have solved the problems of low efficiency and poor accuracy in existing technologies, achieving efficient and accurate flow data inspection and supplementation, and optimizing the utilization of human resources.
Patent Information
- Application Number
- CN202211242413.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-10-11
- Publication Date
- 2026-02-06
- Estimated Expiration
- 2042-10-11
AI Technical Summary
The lack of existing tools for automated batch inspection of core banking systems leads to low inspection efficiency and slow speed. New inspectors also need to spend time learning a lot of knowledge, which can easily result in data omissions and batch execution errors.
A method and apparatus for automated batch inspection of a bank's core system are provided. By judging the status of a scheduled task, multi-threading is used to supplement transaction data, delete historical data, and generate deposit files. The transaction data is compared and supplemented in an automated manner to ensure data consistency and time accuracy.
It reduced labor costs, improved work efficiency and accuracy, shortened batch inspection time, optimized the utilization of human resources, and increased the speed and accuracy of inspections.
Smart Images

Figure CN115712647B_ABST
Abstract
Description
TECHNICAL FIELD
[0001] The present application relates to the field of automation, and in particular to a method and device for automatically checking a bank core system in batches. BACKGROUND
[0002] Currently, there is no automatic batch checking tool for a bank core system on the market. Manual checking is used, which requires a large amount of time for the checking personnel. Moreover, manual supplement of the flow sheet can only be carried out in a single thread mode, which is slow and inefficient, and some flow sheets to be supplemented can be easily missed, resulting in batch execution errors. Due to the characteristics of the bank core system, batch checking involves many knowledge points, and a large amount of documents need to be studied before the knowledge of manual batch checking, supplement of the flow sheet, etc. is known. This results in that when the batch checking is handed over to a new checking personnel, the new checking personnel still needs to learn for a period of time before being able to quickly perform batch checking. SUMMARY
[0003] The present application provides a method and device for automatically checking a bank core system in batches, which can reduce labor costs, improve work efficiency, improve accuracy, and better utilize limited human resources.
[0004] In a first aspect, an embodiment of the present application provides a method for automatically checking a bank core system in batches, which comprises:
[0005] determining whether a timing task for processing flow sheet data in an accounting database is completed, wherein processing condition information of the timing task is stored in a corresponding table of the accounting database, the processing condition information comprises a processing state, and the processing state comprises incomplete and complete, and the timing task is a task for processing the accounting database according to a preset rule;
[0006] if the processing state of the timing task is incomplete, the timing task is scheduled to process the flow sheet data in the accounting database again;
[0007] if the processing state of the timing task is complete, flow sheet data of the previous two days in the accounting database is deleted; and
[0008] comparing the flow sheet data in the accounting database with flow sheet data in a deposit database;
[0009] if the flow sheet data in the accounting database and the flow sheet data in the deposit database are inconsistent, multi-threading is used to extract matching flow sheet data from the deposit database to supplement and update the flow sheet data in the accounting database;
[0010] checking whether the processing time of the deleted and supplemented flow sheet data is consistent with the time provided by the bank core system;
[0011] If the processing time of the deleted and supplemented serial data is inconsistent with the time provided by the bank core system, output a prompt message.
[0012] Optionally, the method for automatically checking the bank core system in batches further comprises:
[0013] judging whether the system time of the bank core system is in the year-end settlement period;
[0014] If the system time of the bank core system is in the year-end settlement period, obtaining the format of the top-up file;
[0015] extracting serial data in the accounting database;
[0016] adjusting the serial data to generate a top-up file in batches according to the format of the top-up file.
[0017] Optionally, the accounting database comprises a plurality of data tables, and the method for automatically checking the bank core system in batches further comprises:
[0018] checking whether the agency number and the internal account balance in the data table in the accounting database are within the preset rules; and
[0019] checking the last heartbeat time of the bank core system to determine whether the bank core system is online normally;
[0020] If the agency number, the internal account balance and the heartbeat time are abnormal, processing the abnormal conditions of the agency number, the internal account balance and the heartbeat time according to the preset rules.
[0021] Optionally, the checking the last heartbeat time of the bank core system to determine whether the bank core system is online normally specifically comprises:
[0022] obtaining the last heartbeat time of the bank core system;
[0023] judging whether the last heartbeat time of the bank core system is changed;
[0024] If not, outputting a manual check prompt message.
[0025] Optionally, the last heartbeat time of the bank core system is stored in the database of the corresponding system.
[0026] In a second aspect, an embodiment of the present application provides an apparatus for automatically checking a bank core system in batches, which comprises:
[0027] A judging unit is configured to judge whether a timing task for processing serial data in an accounting database is completed, wherein processing condition information of the timing task is stored in a corresponding table of the accounting database, the processing condition information comprises a processing state, and the processing state comprises uncompleted and completed, and the timing task is a task for processing the accounting database according to a preset rule;
[0028] A scheduling unit is configured to schedule the timing task to process the serial data in the accounting database again if the processing state of the timing task is uncompleted.
[0029] A deleting unit is configured to delete serial data of the previous two days in the accounting database if the processing state of the timing task is completed.
[0030] A comparing unit is configured to compare the serial data in the accounting database with serial data in a deposit database.
[0031] A supplementing unit is configured to supplement and update the serial data in the accounting database with matched serial data extracted from the deposit database using multi-threading if the serial data in the accounting database is inconsistent with the serial data in the deposit database.
[0032] A viewing unit is configured to view whether processing time of the deleted and supplemented serial data is consistent with time provided by the bank core system.
[0033] A prompting unit is configured to output prompt information if the processing time of the deleted and supplemented serial data is inconsistent with the time provided by the bank core system.
[0034] Optionally, the viewing unit further comprises:
[0035] A listening unit is configured to listen to whether an agency number, an internal account balance and a heartbeat time of a data table in the accounting database are abnormal.
[0036] Optionally, the device for automatically checking the bank core system in batches further comprises a money charging unit, and the money charging unit comprises:
[0037] A calculating unit is configured to judge whether system time of the bank core system is in a year-end settlement period.
[0038] An obtaining unit is configured to obtain a format of a money charging file if the system time of the bank core system is in the year-end settlement period.
[0039] An extracting unit is configured to extract serial data in the accounting database.
[0040] A generating unit is configured to adjust the serial data to generate the money charging file in batches according to the format of the money charging file.
[0041] In a third aspect, an embodiment of the present application provides an automatic batch inspection bank core system device, the automatic batch inspection bank core system device comprising:
[0042] a memory for storing a computer executable program,
[0043] a processor for executing the computer executable program to implement the method for automatically batch inspecting a bank core system as described above.
[0044] In a fourth aspect, an embodiment of the present application provides a computer readable storage medium, characterized in that the computer readable storage medium stores computer execution instructions, and the computer execution instructions are executed by a processor to implement the method for automatically batch inspecting a bank core system as described above.
[0045] The above method and device for automatically batch inspecting a bank core system automatically check the initial state of the bank core system, complete batch state inspection, automatically supplement flow data, clean up historical flow data, and batch generate money charging files. In addition, the automatic method reduces labor costs, improves work efficiency, improves inspection accuracy, and better utilizes limited human resources. Furthermore, the multi-threaded flow data supplementing method greatly improves the flow data supplementing speed, shortens the overall batch inspection time, and indirectly speeds up the entire batch processing process. BRIEF DESCRIPTION OF DRAWINGS
[0046] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the drawings needed in the embodiments or prior art description will be briefly introduced below. Obviously, the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained from the structures shown in the drawings without creative labor.
[0047] Figure 1 A method flowchart for automatically batch inspecting a bank core system is provided for the first embodiment of the present application.
[0048] Figure 2 A method flowchart for automatically batch inspecting a bank core system is provided for the second embodiment of the present application.
[0049] Figure 3 A method flowchart for automatically batch inspecting a bank core system is provided for the third embodiment of the present application.
[0050] Figure 4 A sub-flowchart for step 302 provided for the third embodiment of the present application.
[0051] Figure 5 The device module schematic diagram of the automatic batch inspection device for the bank core system provided by the embodiment of the present application.
[0052] Figure 6 The module schematic diagram of the viewing unit in the device module of the automatic batch inspection device for the bank core system provided by the embodiment of the present application.
[0053] Figure 7 The module schematic diagram of the format unit in the device module of the automatic batch inspection device for the bank core system provided by the embodiment of the present application.
[0054] Figure 8 The device schematic diagram of the automatic batch inspection device for the bank core system provided by the embodiment of the present application.
[0055] Figure 9 The logic schematic diagram of the method of the automatic batch inspection device for the bank core system provided by the embodiment of the present application.
[0056] The implementation, functional features and advantages of the present application will be further described with reference to the accompanying drawings and embodiments. DETAILED DESCRIPTION
[0057] In order to make the purpose, technical scheme and advantages of the present application more clear, the present application will be further described in detail below by combining with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application, and are not used to limit the present application. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative labor are within the scope of protection of the present application.
[0058] The terms "first", "second", "third", "fourth" and the like (if any) in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar planning objects, and do not necessarily have to be used to describe a specific order or sequence. It should be understood that the data thus used can be interchanged under appropriate circumstances, in other words, the described embodiments are implemented in an order other than that illustrated or described herein. In addition, the terms "include" and "have" and any variations thereof can also include other contents, for example, a process, method, system, product or device including a series of steps or units does not have to be limited to only those steps or units clearly listed, but can include other steps or units not clearly listed or inherent to these processes, methods, products or devices.
[0059] It should be noted that the descriptions involving "first", "second" and the like in the present application are only for the purpose of description, and cannot be understood as indicating or implying the relative importance of the indicated technical features or implicitly indicating the number of the indicated technical features. Therefore, the features defined as "first", "second" can explicitly or implicitly include one or more of the features. In addition, the technical solutions of various embodiments can be combined with each other, but it must be based on the realization of ordinary skilled in the art, when the combination of technical solutions appears contradictory or cannot be realized, it should be considered that the combination of technical solutions does not exist, nor within the protection scope required by the present application.
[0060] Please refer to Figure 4 and Figure 9 , the bank core system 200 includes a deposit system 2001 and an accounting system 2002, the deposit system 2001 includes a deposit database, the accounting system 2002 includes an accounting database, the peripheral system 100 sends the flow data to the deposit system 2001 in real time, the deposit system 2001 sends the received data to the accounting system 2002 and the deposit system 2001 and the accounting system 2002 are in communication connection. The device 10 for automatically checking the bank core system is arranged in the bank core system 200, which is used for automatically checking the running state and business processing of the bank core system 200, and ensuring that the bank core system 200 accurately and correctly executes various business matters of the bank in operation.
[0061] As Figure 1 shown, the method for automatically checking the bank core system provided by the first embodiment of the present application specifically includes the following steps:
[0062] Step S101, judging whether the timing task for processing the flow data in the accounting database is completed, wherein the processing condition information of the timing task is stored in the corresponding table of the accounting database, the processing condition information includes the processing state, the processing state includes incomplete and complete, and the timing task is a task for processing the accounting database according to a preset rule.
[0063] Specifically, the accounting database includes a plurality of data tables, the flow data in each data table is processed in real time by the timing task, and the processing condition information of the flow data is recorded in the corresponding data table of the accounting database. In some feasible embodiments, a timing task information table can be established in the accounting database, wherein the timing task information table has processing state information, the processing state information includes complete and incomplete, and the device 10 for automatically checking the bank core system extracts the key of the processing state information to judge the completion of the timing task.
[0064] For example, a timing task is preset to update the customer label status in the flow data table every day. If the label status of some customers in the flow data table is "frozen", but the label status of the customers is no longer "frozen" after one day, the timing task will automatically change the status of these labels every day.
[0065] For another example, the customer management fee in some flow data tables needs to be filled in batches. Understandably, the customer management fee in a flow data table is the same. At this time, using a timing task to batch fill these management fees can save a lot of time. After the timing task updates the label status and user management fee to be batch edited, the execution of the timing task will be automatically recorded in the task information table. The task information table has record items such as processing item, processing time and processing status. The automatic batch checking device 10 of the bank core system will obtain the task information table and extract the processing status keyword to determine whether the timing task has been executed. Understandably, the processing status has only two states: completed and not completed. When the automatic batch checking device 10 extracts the keyword "completed", it is determined that the timing task has been executed. When the automatic batch checking device 10 extracts the keyword "not completed", it is determined that the timing task has not been executed.
[0066] Step S102: If the processing status of the timing task is not completed, the timing task is scheduled to process the flow data in the accounting database again.
[0067] Specifically, according to step S101, when the automatic batch checking device 10 of the bank core system extracts the processing status information in the timing task information table as "not completed", the timing task is automatically scheduled to process the flow data again.
[0068] It should be noted that in order to ensure that the entire flow data is correct and accurate when it is summarized and accounted in the later period, the automatic batch checking device 10 of the bank core system must detect that the processing status of the timing task processing data is "completed". Otherwise, the automatic batch checking device 10 of the bank core system will call the timing task again until the processing status of the timing task is completed.
[0069] In some possible embodiments, if the automatic batch checking device 10 of the bank core system schedules the timing task to process the flow data multiple times, and the processing status of the timing task is still "not completed", the automatic batch checking device 10 of the bank core system can pop up a prompt information to inform the user.
[0070] Step S103: If the processing status of the timing task is completed, the flow data of the previous two days in the accounting database is deleted.
[0071] Understandably, the deposit system 2001 does not send the flow data to the accounting system 2002 at all times, and the flow data received by the accounting system 2002 is stored in the accounting database day by day, and when the flow data in the accounting database is more and more, it will inevitably make the accounting system 2002 in a slow state of operation or even cause system collapse, so the automatic checking device 10 is necessary to delete some historical flow data which has no significance for the current accounting.
[0072] For example, because the accounting system 2002 accounts for the flow data every day, the automatic bulk checking device 10 of the bank core system will automatically delete the historical data of the previous two days, and in some feasible embodiments, the automatic bulk checking device 10 of the bank core system can also delete the flow data which has no great significance for the current accounting according to the amount of accounting tasks of the accounting system 2002, for example, the accounting system 2002 will account for the flow data during the year-end period, and the automatic bulk checking device 10 of the bank core system will delete the historical flow data of the previous two years, if the accounting system 2002 will account for the flow data of the current month, the automatic bulk checking device 10 will delete the flow data of the previous months, and the deleted flow data is set according to the situation, which is not limited.
[0073] Step S104, comparing the flow data in the accounting database with the flow data in the deposit database.
[0074] Specifically, the deposit system 2001 is directly connected with the peripheral system 100, and it is understandable that the data in the deposit system 2001 is the original data of the accounting system 2002, and all the flow data is stored in the deposit database first, so the deposit database is the reference data of the accounting database.
[0075] Step S105, if the flow data in the accounting database and the flow data in the deposit database are inconsistent, using multi-thread to extract the matching flow data from the deposit database to supplement and update the flow data in the accounting database.
[0076] Specifically, due to network or system reasons, when the deposit system 2001 sends the flow data to the accounting system 2002, the data of the accounting database of the accounting system 2002 can be delayed or not updated, when the automated batch checking device 10 of the bank core system detects that the flow data in the accounting data table is inconsistent with the data in the deposit data table, the automated batch checking device 10 of the bank core system extracts the matching flow data from the deposit database for supplementary update. In the embodiment, a certain number of threads are created in the thread pool of the background code of the automated batch checking device 10 of the bank core system, and then each thread only processes the flow data of the corresponding data table of the accounting database and extracts the flow data from the data table of the deposit database and inserts it into the corresponding data table of the accounting database in a double-threaded manner to realize the supplementary of the flow data, which can effectively reduce the processing time and improve the efficiency of the flow data supplement.
[0077] For example, when a user opens an account in a bank, the user data table of the deposit database will increase a user information data, but the automated batch checking device 10 of the bank core system compares the user data table in the accounting database with the user data table in the deposit database and finds that there is no flow data of the user in the user data table of the accounting database, at this time, the automated checking device 10 will update the user data table of the accounting database according to the user data table in the deposit data table to make the data in the two data tables consistent.
[0078] Step S106, checking whether the processing time of the deleted and supplemented flow data is consistent with the time provided by the bank core system.
[0079] Step S107, if the processing time of the deleted and supplemented flow data is inconsistent with the time provided by the bank core system, outputting prompt information.
[0080] Specifically, each accounting data table has a remark column, and the current flow data editing time is stored in the remark column. In order to prevent the accounting system 2002 and the deposit system 2001 from working in an offline state, the automated batch checking device 10 of the bank core system extracts the time in the editing column of the data table in the accounting database after completing the supplement and deletion of the flow data and judges whether the current time in each data table is consistent with the time provided by the bank core system, and if not, outputs prompt information to inform the user.
[0081] The device for automatically and batch checking the bank core system judges whether the timing task for processing the flow data in the accounting database is completed, if not, the timing task is scheduled to process the flow data in the accounting database again, if yes, the historical flow data of the previous two days is automatically deleted, and the data in the accounting database is automatically checked to be consistent with the data in the deposit database, if not, the matched data is extracted from the deposit database to fill and update the data in the accounting database by using the double-thread mode, and finally, it is checked whether the editing time of the deleted and supplemented flow data is consistent with the time provided by the bank core system, so as to ensure that the device for automatically and batch checking the bank core system does not work when the bank core system is offline. The application adopts the automatic and batch mode to check the running state and business processing of the bank core system, reduces the labor cost, improves the work efficiency, improves the checking accuracy, and better utilizes the limited human resources.
[0082] Referring to Figure 2 which is a flow chart of a method for automatically and batch checking a bank core system according to the second embodiment of the application, and specifically includes the following steps:
[0083] Step 201, judging whether the system time of the bank core system is in the year-end settlement period.
[0084] Step 202, if the system time of the bank core system is in the year-end settlement period, obtaining the format of the money charging file.
[0085] Step 203, extracting the flow data in the accounting database.
[0086] Step 204, adjusting the flow data to batch generate the money charging file according to the format of the money charging file.
[0087] Specifically, when the device 10 for automatically and batch checking the bank core system performs batch checking in the year-end settlement period (generally, the year-end settlement period is December of the current year), the money charging file is automatically generated according to the preset rule. Understandably, the money charging file has a fixed file format, but the flow data sent by the peripheral system 100 is messy, so the device 10 for automatically and batch checking the bank core system obtains the format of the money charging file, extracts the matched flow data in the corresponding table of the accounting database, fills the data according to the format of the money charging file, and generates the money charging file. In some feasible embodiments, the device 10 for automatically and batch checking can directly send the money charging file to the money charging interface machine, so that the money charging interface machine can receive the money charging file and use it for business processing, or the device 10 for automatically and batch checking the bank core system saves the money charging file in the database of the accounting system 2002 as the pre-embedded data for subsequent business.
[0088] Referring to Figure 3A method flow chart for automatically checking a bank core system in batches provided by the third embodiment of the present application, and specifically comprising the following steps:
[0089] Step 301, checking whether the agency number and the internal account balance of the data table in the accounting database are within the preset rules.
[0090] Step 302, checking the last heartbeat time of the bank core system to determine whether the bank core system is normally online.
[0091] Step 303, if not, processing the abnormal conditions of the agency number, the internal account balance and the heartbeat time according to the preset rules.
[0092] Specifically, the accounting database comprises a plurality of data tables, each data table has a corresponding agency number and account balance, and the device 10 for automatically checking the bank core system in batches checks whether the agency number of each data table conforms to the bank standard, whether the balance of the internal account is within the preset value, and whether the heartbeat of the virtual machine is abnormal, and the like. Understandably, when the device 10 for automatically checking the bank core system in batches detects that one of the items is in an abnormal state, it will automatically process these abnormal conditions according to the preset rules. The state detection items are increased according to actual needs, which are illustrated herein as examples and are not limited.
[0093] For example, the bank stipulates that the agency number is eight digits, but the device 10 for automatically checking the bank core system in batches detects that the agency number is sixteen digits, at which time the device 10 for automatically checking the bank core system in batches automatically refreshes the agency number.
[0094] For another example, when the device 10 for automatically checking the bank core system in batches detects that the balance of the internal account is lower than the threshold value preset by the bank, it automatically calls the corresponding interface to charge money.
[0095] For another example, when the device 10 for automatically checking the bank core system in batches detects that the connection communication of the virtual machine is abnormal, it automatically refreshes the connection state. In some feasible embodiments, when the device 10 for automatically checking the bank core system in batches cannot process some abnormal conditions, a prompt dialog box is popped up to inform the user to manually process.
[0096] Please refer to Figure 4 A sub-flow chart of step 302 provided by the third embodiment of the present application, comprising the following steps:
[0097] Step 401, obtaining the last heartbeat time of the bank core system.
[0098] Step 402, determining whether the last heartbeat time of the bank core system is changed.
[0099] If no change, output manual inspection prompt information in step 403.
[0100] Specifically, in order to prevent the communication connection between the deposit system 2001 and the accounting system 2002 from being interrupted, the device 10 for automatically and batch checking the bank core system checks whether the communication of the two systems is online, the heartbeat time of the deposit system 2001 and the accounting system 2002 is stored in the data table of the respective database in real time, the device 10 for automatically and batch checking the bank core system respectively acquires the heartbeat record data table of the two systems, and respectively compares the last heartbeat time in the same data table with the last heartbeat time, judges whether the two times are changed, if the two times are different, it means that the heartbeat time is updated, the communication connection is normal, if the two times are the same, it means that the heartbeat time is not updated, at this time, the system is in a down state, at this time, the device 10 for automatically checking performs communication refreshing, if the refreshing fails for many times, the manual inspection prompt information is output.
[0101] Please refer to Figure 5 It is a device module schematic diagram of the device 10 for automatically and batch checking the bank core system provided by the embodiment of the application, the device 10 for automatically and batch checking the bank core system includes a judgment unit 101, a scheduling unit 102, a deletion unit 103, a comparison unit 104, a supplement unit 105, a viewing unit 106 and a prompt unit 107.
[0102] The judgment unit 101 is used for judging whether a timing task for processing flow data in an accounting database is completed, wherein processing condition information of the timing task is stored in a corresponding table of the accounting database, the processing condition information includes a processing state, the processing state includes uncompleted and completed, and the timing task is a task for processing the accounting database according to a preset rule.
[0103] The scheduling unit 102 is used for scheduling the timing task to process the flow data in the accounting database again if the processing state of the timing task is uncompleted.
[0104] The deletion unit 103 is used for deleting the flow data of the previous two days in the accounting database if the processing state of the timing task is completed.
[0105] The comparison unit 104 is used for comparing the flow data in the accounting database with flow data in a deposit database.
[0106] The supplement unit 105 is used for using multi-thread to extract matched flow data from the deposit database to supplement and update the flow data in the accounting database if the flow data in the accounting database and the flow data in the deposit database are inconsistent.
[0107] The viewing unit 106 is configured to view whether the processing time of the deleted and supplemented flow data is consistent with the time provided by the bank core system.
[0108] The prompting unit 107 is configured to output prompt information if the processing time of the deleted and supplemented flow data is inconsistent with the time provided by the bank core system.
[0109] Referring to Figure 6 The viewing unit 106 further includes a monitoring unit 1061 configured to monitor whether the agency number, internal account balance and heartbeat time of the data table in the accounting database are abnormal.
[0110] Referring to Figure 7 The format unit 108 includes a calculation unit 1081, an acquisition unit 1082, an extraction unit 1083 and a generation unit 1084.
[0111] The calculation unit 1081 is configured to determine whether the system time of the bank core system is in the year-end settlement period.
[0112] The acquisition unit 1082 is configured to acquire the format of the money charging file if the system time of the bank core system is in the year-end settlement period.
[0113] The extraction unit 1083 is configured to extract the flow data in the accounting database.
[0114] The generation unit 1084 is configured to generate the money charging file in batches according to the format of the money charging file.
[0115] Referring to Figure 8 The automatic batch checking bank core system device 30 includes a processor 301 and a memory 302 connected with the processor 301, and the memory 302 stores computer execution instructions.
[0116] The processor executes the computer execution instructions stored in the memory to realize the scheme provided by any of the method embodiments of the automatic batch checking bank core system, and the specific functions and the technical effects that can be achieved will not be repeated here.
[0117] The computer readable storage medium stores computer execution instructions, and the computer execution instructions are executed by the processor to realize the scheme provided by any of the method embodiments of the automatic batch checking bank core system, and the specific functions and the technical effects that can be achieved will not be repeated here.
[0118] Obviously, many modifications and variations of the present application are possible in light of the above teachings. It is, therefore, to be understood that within the scope of the appended claims and their equivalents, the application can be practiced otherwise than as specifically described.
[0119] The above embodiments are only preferred embodiments of the present application, and thus are not intended to limit the scope of the present application. Therefore, equivalent changes and modifications of the present application are included in the scope of the present application as defined by the appended claims and their equivalents.
Claims
1. A method for automated batch inspection of a bank's core system, characterized in that, The method for automated batch inspection of the bank's core system includes: Determine whether a scheduled task for processing transaction data in an accounting database has been completed. The processing status information of the scheduled task is stored in a corresponding table in the accounting database. The processing status information includes a processing status, which includes incomplete and completed. The scheduled task is a task that processes the accounting database according to preset rules. If the scheduled task processing status is incomplete, the scheduled task will be rescheduled to process the transaction data in the accounting database again. If the scheduled task processing status is complete, delete the transaction data for the previous two days from the accounting database; and The transaction data in the accounting database is compared with the transaction data in the deposit database; If the transaction data in the accounting database and the transaction data in the deposit database are inconsistent, multi-threading is used to extract matching transaction data from the deposit database to supplement and update the transaction data in the accounting database. Check whether the processing time for deleted and supplemented transaction data is consistent with the time provided by the bank's core system; If the processing time for deleted and supplemented transaction data is inconsistent with the time provided by the bank's core system, a prompt message will be output.
2. The method for automated batch inspection of a bank's core system as described in claim 1, characterized in that, The method for automated batch inspection of the bank's core system also includes: Determine whether the system time of the bank's core system is within the year-end settlement period; If the system time of the bank's core system is during the year-end settlement period, obtain the format of the recharge file; Extract the transaction data from the accounting database; Based on the format of the recharge file, the transaction data is adjusted to generate recharge files in batches.
3. The method for automated batch inspection of a bank's core system as described in claim 1, characterized in that, The accounting database includes multiple data tables, and the method for automated batch inspection of the bank's core system further includes: Check whether the organization number and internal account balance of the data table in the accounting database are within the preset rules; and Check the last heartbeat time of the bank's core system to determine whether the bank's core system is online normally; If there are any abnormalities in the organization number, internal account balance, or heartbeat time, the abnormalities in the organization number, internal account balance, and heartbeat time will be handled according to preset rules.
4. The method for automated batch inspection of a bank's core system as described in claim 3, characterized in that, The step of checking the last heartbeat time of the bank's core system to determine whether the bank's core system is online normally includes: Obtain the last heartbeat time of the bank's core system; Determine whether the last heartbeat time of the bank's core system has changed; If no changes have been made, a manual inspection prompt message will be displayed.
5. The method for automated batch inspection of a bank's core system as described in claim 4, characterized in that, The last heartbeat time of the bank's core system is stored in the data tables of the respective systems.
6. An apparatus for automated batch inspection of a bank's core system, characterized in that, The device for automated batch inspection of the bank's core system includes: The judgment unit determines whether the timed task for processing the transaction data in the accounting database has been completed. The processing status information of the timed task is stored in the corresponding table of the accounting database. The processing status information includes the processing status, which includes incomplete and completed. The timed task is a task that processes the accounting database according to preset rules. The scheduling unit is used to schedule the scheduled task to process the transaction data in the accounting database again if the processing status of the scheduled task is incomplete. The deletion unit is configured to delete the transaction data for the previous two days from the accounting database if the scheduled task processing status is complete; and The comparison unit is used to compare the transaction data in the accounting database with the transaction data in the deposit database; The supplementary unit is used to use multiple threads to extract matching transaction data from the deposit database to supplement and update the transaction data in the accounting database if the transaction data in the accounting database and the transaction data in the deposit database are inconsistent. The viewing unit is used to check whether the processing time of deleted and supplemented transaction data is consistent with the time provided by the bank's core system; The prompting unit is used to output a prompt message if the processing time of deleted and supplemented transaction data is inconsistent with the time provided by the bank's core system.
7. The apparatus for automated batch inspection of a bank's core system as described in claim 6, characterized in that, The viewing unit also includes: The monitoring unit is used to monitor whether the organization number, internal account balance, and heartbeat time of the data tables in the accounting database are abnormal.
8. The apparatus for automated batch inspection of a bank's core system as described in claim 6, characterized in that, The device for automated batch inspection of the bank's core system also includes a money-charging unit, which comprises: The calculation unit is used to determine whether the system time of the bank's core system is within the year-end settlement period; The acquisition unit is used to acquire the format of the recharge file if the system time of the bank's core system is during the year-end settlement period. Extraction unit, used to extract transaction data from the accounting database; The generation unit is used to adjust the transaction data according to the format of the recharge file to generate recharge files in batches.
9. An automated batch inspection device for a bank's core system, characterized in that, The automated batch inspection system equipment for the bank's core system includes: Memory, used to store executable programs in a computer. A processor for executing the computer-executable program to implement the method for automating batch inspection of a bank's core system as described in any one of claims 1-5.
10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer-executable instructions, which, when executed by a processor, are used to implement the method for automated batch inspection of a bank's core system as described in any one of claims 1-5.
Citation Information
Patent Citations
Fund account checking method and system
CN107944996A
Data processing method and system for realizing bank uninterrupted service
CN1553393A