CN113010566A - Batch processing result checking method and device - Google Patents

Batch processing result checking method and device Download PDF

Info

Publication number
CN113010566A
CN113010566A CN202110352516.2A CN202110352516A CN113010566A CN 113010566 A CN113010566 A CN 113010566A CN 202110352516 A CN202110352516 A CN 202110352516A CN 113010566 A CN113010566 A CN 113010566A
Authority
CN
China
Prior art keywords
batch processing
checking
result
batch
check
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202110352516.2A
Other languages
Chinese (zh)
Other versions
CN113010566B (en
Inventor
周纪宇
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
CCB Finetech Co Ltd
Original Assignee
CCB Finetech Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by CCB Finetech Co Ltd filed Critical CCB Finetech Co Ltd
Priority to CN202110352516.2A priority Critical patent/CN113010566B/en
Publication of CN113010566A publication Critical patent/CN113010566A/en
Application granted granted Critical
Publication of CN113010566B publication Critical patent/CN113010566B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2457Query processing with adaptation to user needs
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/215Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Quality & Reliability (AREA)
  • Debugging And Monitoring (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a method and a device for checking batch processing results, which relate to the technical field of automatic program design, wherein the method comprises the following steps: after the batch processing work flow of the business item is finished, receiving a starting instruction of a batch processing check operation; checking the batch processing result of the service item according to the call instruction and a preset batch processing checking strategy to obtain a batch processing checking result; and writing the batch processing inspection result into a preset inspection result recording table. The invention can efficiently and accurately check the batch processing result.

Description

Batch processing result checking method and device
Technical Field
The invention relates to the technical field of automatic program design, in particular to a batch processing result checking method and device.
Background
This section is intended to provide a background or context to the embodiments of the invention that are recited in the claims. The description herein is not admitted to be prior art by inclusion in this section.
In daily work, a bank usually executes batch processing operation in an online transaction valley period, so that a CPU of a server can be fully utilized, and the data volume processed by a general batch processing program is large, and ranges from tens of thousands to millions or even hundreds of millions. After the batch execution is completed, the worker does not need to check whether the program is normally finished, and also needs to check whether the result of the execution data is accurate. At present, workers can only wait for the completion of a batch processing program and manually check whether a data result is correct, so that on one hand, the workload is large, and on the other hand, inaccurate or missing places can be seen when the data result is possibly checked.
When the data volume is small, the execution result can be checked in a manual checking mode, even if the data volume reaches ten thousands, the result is difficult to check in a manual checking mode, and the batch processing module is generally carried out in non-working time periods such as late night, so that the manual checking is more difficult.
Disclosure of Invention
The embodiment of the invention provides a batch processing result checking method, which is used for efficiently and accurately checking a batch processing result and comprises the following steps:
after the batch processing work flow of the business item is finished, receiving a starting instruction of a batch processing check operation;
checking the batch processing result of the service item according to the call instruction and a preset batch processing checking strategy to obtain a batch processing checking result;
and writing the batch processing inspection result into a preset inspection result recording table.
In an embodiment, the batch processing result checking method may further include:
upon detecting that there is a batch check job that fails processing, a start timing task initiates a check for the batch check job that fails processing.
In an embodiment, the batch processing result checking method may further include:
checking whether checking result data before a preset time interval exists or not at regular time; and if so, deleting the inspection result data.
In an embodiment, the batch processing result checking method may further include:
and recording error data or data which does not need to be displayed during the checking process of the batch processing result in a log file.
In one embodiment, writing the batch inspection result into a preset inspection result record table may include: and writing the batch processing inspection result into an inspection result record table of an Oracle database.
In an embodiment, the batch processing result checking method may further include:
and when the batch processing checking result is a defective batch processing checking result, outputting the defective batch processing checking result to the client.
In an embodiment, the batch processing result checking method may further include:
receiving a query request about historical batch processing inspection results sent by a client; the query request comprises a job name and a query condition of business days;
and returning the obtained related query result to the client according to the query request.
An embodiment of the present invention further provides an apparatus for checking a batch processing result, so as to efficiently and accurately check the batch processing result, where the apparatus includes:
the system comprises a receiving unit, a processing unit and a processing unit, wherein the receiving unit is used for receiving a starting instruction of a batch processing check job after the batch processing workflow of a service item is finished;
the checking unit is used for checking the batch processing result of the service item according to the call instruction and a preset batch processing checking strategy to obtain a batch processing checking result;
and the writing unit is used for writing the batch processing check result into a preset check result record table.
In an embodiment, the apparatus for checking the batch processing result may further include:
and the timing processing unit is used for starting the timing task to initiate the check of the batch processing check job with the processing failure when detecting that the batch processing check job with the processing failure exists.
In an embodiment, the apparatus for checking the batch processing result may further include:
the cleaning unit is used for regularly checking whether checking result data before a preset time interval exists or not; and if so, deleting the inspection result data.
In an embodiment, the apparatus for checking the batch processing result may further include:
and the log processing unit is used for recording error reporting data or data which does not need to be displayed in the process of checking the batch processing result in a log file.
In one embodiment, the writing unit is specifically configured to: and writing the batch processing inspection result into an inspection result record table of an Oracle database.
In an embodiment, the apparatus for checking the batch processing result may further include:
and the output unit is used for outputting the batch processing checking result with the problem to the client when the batch processing checking result is the batch processing checking result with the problem.
In an embodiment, the apparatus for checking the batch processing result may further include:
the query unit is used for receiving a query request about historical batch processing check results sent by a client; the query request comprises a job name and a query condition of business days;
and the feedback unit is used for returning the obtained related query result to the client according to the query request.
The embodiment of the invention also provides computer equipment which comprises a memory, a processor and a computer program which is stored on the memory and can run on the processor, wherein the processor realizes the batch processing result checking method when executing the computer program.
An embodiment of the present invention further provides a computer-readable storage medium, where a computer program for executing the batch processing result checking method is stored in the computer-readable storage medium.
In the embodiment of the invention, the checking scheme of the batch processing result is as follows: after the batch processing work flow of the business item is finished, receiving a starting instruction of a batch processing check operation; checking the batch processing result of the service item according to the call instruction and a preset batch processing checking strategy to obtain a batch processing checking result; and writing the batch processing inspection result into a preset inspection result recording table, so that the batch processing result can be efficiently and accurately inspected.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. In the drawings:
FIG. 1 is a flow chart illustrating a method for checking batch processing results according to an embodiment of the present invention;
FIG. 2 is a schematic diagram illustrating the checking of batch process results according to an embodiment of the present invention;
FIG. 3 is a flowchart illustrating a batch process result checking method according to another embodiment of the present invention;
FIG. 4 is a flowchart illustrating a batch process result checking method according to another embodiment of the present invention;
FIG. 5 is a schematic diagram of an apparatus for inspecting batch processing results according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of a computer device in an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention.
Before describing the embodiments of the present invention, terms related to the embodiments of the present invention will be described.
1. Batch processing (Batch), also known as Batch script. As the name implies, batch processing is the processing of a batch of objects, generally known as a simplified scripting language, which is used in DOS and Windows systems. The extension of the batch file is bat. The currently more common batch processes include two types: DOS batch and PS batch. PS batching is based on Microsoft's powerful PowerShell's script that is used to batch some tasks; DOS batch processing is based on DOS commands, and scripts for automatically executing DOS commands in batches to implement particular operations. More complicated cases require the use of if, for, goto, etc. commands to control the program's operation, as in high level languages such as C, Basic. If more complex applications are to be implemented, it is necessary to use external programs, including external commands provided by the system itself and tools or software provided by third parties. Batch programs, although running in a command line environment, can not only use command line software, any program currently running under the system can be put into a batch file to run.
2. Online transaction: the system refers to a single counter transaction in a bank working day and a non-working date, and a transaction which is initiated by self-service equipment and accessed by various channels and needs to be responded in time. Such as over-the-counter deposit and withdrawal, loan, atm withdrawal, large and small amount, and the like. Typically, the output of the online transaction is various summons, receipts, and the like. Participation in online transactions requires host, front-end, self-service equipment, channels, etc.
3. Batch processing service: batch processing services are understood in two ways: one, daytime (online) batch services, such as posting, receipt, etc. of intermediate services (various generation receipts); and secondly, carrying out batch processing service after connection. Various accounting processes (such as settlement) performed after the online state is switched, a register, a daily statement, and the like, the output of which is various reports. Batch processing after connection is typically accomplished by calling a set of programs at night on a background host.
Oracle RAC: the abbreviation of Oracle Real Application Cluster is a Real-time Application Cluster, and is the core technology of an Oracle database supporting network environment computing. The cluster supports multi-node load balancing; the method has the advantages of high availability, fault tolerance and seamless switching function; the response time of the cluster transaction is fast, and the number of transactions per second and the number of connections are large; the hardware cost is low, a plurality of cheap PC servers can be used for replacing expensive mini-computers or mainframe computers, and the corresponding maintenance cost is saved; the cluster has good expandability, and can conveniently add and delete nodes and expand hardware resources.
Log: a Log (Log) refers to a collection of certain operations of objects specified by a system and their results in time order. The log file is a log file, records interactive information between a system and a user of the system, and is a data collection method for automatically capturing the interactive type, content or time between a person and a system terminal; for web searches, a log is an electronic record of a user searching for information using a web search engine interacting with the web search engine during the search for information. Most log files can be used for seeing their roles from file names, such as uninstantall log, which is usually a record generated during the installation of software and is provided for an uninstaller to use in the future, or error log, which is usually used for recording some error information during the operation of software.
The inventor finds technical problems in the prior art, and provides a batch processing result checking scheme, which aims to realize full-automatic checking of the execution result of batch processing, display the final analysis result and make the result clear when manual intervention is finally carried out. Specifically, the scheme realizes the inspection of all execution results through a pre-programmed inspection program, then outputs the inspection results after the inspection is finished, the output results are more visual, and simultaneously problematic data can be displayed at a client, so that bank workers can see the batch processing problems at a glance. The inspection scheme of the batch result will be described in detail below.
Fig. 1 is a schematic flow chart of a batch processing result checking method according to an embodiment of the present invention, as shown in fig. 1, the method includes the following steps:
step 101: after the batch processing work flow of the business item is finished, receiving a starting instruction of a batch processing check operation;
step 102: checking the batch processing result of the service item according to the call instruction and a preset batch processing checking strategy to obtain a batch processing checking result;
step 103: and writing the batch processing inspection result into a preset inspection result recording table.
In the embodiment of the invention, the method for checking the batch processing result comprises the following steps: after the batch processing work flow of the business item is finished, receiving a starting instruction of a batch processing check operation; checking the batch processing result of the service item according to the call instruction and a preset batch processing checking strategy to obtain a batch processing checking result; and writing the batch processing inspection result into a preset inspection result recording table, so that the batch processing result can be efficiently and accurately inspected.
The steps involved in the embodiments of the present invention are described in detail below with reference to fig. 2 to 4.
First, the preparation steps before the above step 101 are described.
In specific implementation, a small project with spring, spring MVC and mybatis as basic frameworks can be pre-built (the spring framework is a J2EE application framework of open source code, the spring MVC is a framework design provided by spring for Web application, and the mybatis is a persistent layer framework based on Java). The front end and the back end are not separated, the front end is written on a jsp file (jsp is a file type and is based on Java language as scripting language), and the calling of background transaction is realized through a rest service (the rest service is a http-based rest software architecture).
In specific implementation, an inspection result record table, multitennacyid multi-entity identifiers, aplPrtnNo # application partition number, object id batch job name and busnDate business date are used as main keys, and a checkResult inspection result and an errorescription error description field are designed in advance.
In specific implementation, some batch inspection strategies may be configured in advance, for example, in specific inspection code development, each job has an independent inspection method (program, strategy). For example, checking a full-volume archive job, first configuring sql through mapper. If the primary keys are inconsistent, the primary keys of all the records are required to be acquired for comparison, and finally, the inconsistent primary key records are screened out and stored in the errorDescription field in the table. For example, in the operation check of the day end measurement, the day end calculation component of the main item needs to be applied to calculate and compare the money.
Next, the above step 101 is described.
In specific implementation, firstly, after the batch processing workflow of the large-scale business project is finished, a batch processing inspection project is called. Whether the dispatching is successful or not does not influence the previous batch dispatching. The main project is called by another thread, and the service data of the main project cannot be influenced whether the calling is successful or not, so that the safety of service processing is improved.
In specific implementation, the batch result inspector according to the embodiment of the present invention can be implemented by a Java inspection item (job) as shown in fig. 2, and if the batch job changes, a corresponding function needs to be developed to redeploy the batch inspection item. Of course, other programming language types of inspection jobs are also possible
During specific implementation, automatic data verification is achieved through projects, the complexity of manual verification is omitted, the data verification can be reused at the later stage, if new operation is carried out, the procedure only needs to be directly developed on the original basis, and the efficiency and flexibility of batch processing result inspection are improved.
Third, next, the above step 102 is introduced.
In specific implementation, as shown in fig. 2, when the Java inspection job receives a batch job invocation instruction (an invocation instruction of a batch inspection job), the Java inspection job inspects the batch processing result of the service item according to some batch processing inspection policies configured in advance as mentioned in "one" above, so as to obtain a batch processing inspection result.
In specific implementation, the batch processing check may be, for example, checking a full-volume downloaded job, first configuring sql through mapper. For example, in the operation check of the day end measurement, the day end calculation component of the main item needs to be applied mechanically to calculate and compare the money.
Fourth, next, the above step 103 is described.
In specific implementation, after the execution is successful, the relevant execution result is written into the check result record table, because the system switches the day after the execution completes the batch processing, the busnDate field is the read day before the system business day, the execution result is written into the checkResult field, the success or failure occurs, and if the failure occurs, the data key with the problem of the check is recorded in the errorescription field and is distinguished by a separator.
In one embodiment, writing the batch inspection result into a preset inspection result record table may include: and writing the batch processing inspection result into an inspection result record table of an Oracle database.
In specific implementation, Oracle refers to a database for storing inspection results after batch inspection is completed. The batch processing result checking method provided by the embodiment of the invention can store the checking result record table through the Oracle database, further store the batch processing checking result, and improve the safety of data storage and the efficiency and convenience of subsequently acquiring data.
Fifth, some other preferred embodiments related to the embodiments of the present invention will be described next.
In an embodiment, the batch processing result checking method may further include:
upon detecting that there is a batch check job that fails processing, a start timing task initiates a check for the batch check job that fails processing.
In implementation, if the startup is not successful, the timing task is started up every day, and whether the startup of each job is successful is checked. Specifically, if the call fails after batch running, the integrated spring task timing task (a timing task function provided by spring) can check whether data for checking the yesterday batch running job exists in the table by the job name and the business day at five morning each day, and if not, the check for the job is initiated independently, so that the accuracy of batch processing check is improved. Each job is called through the thread pool, and the jobs are independent of each other, so that the safety of batch processing inspection is improved. In addition, the configuration of the maximum thread number is 10, so that excessive operation pressure on the server is avoided, and the stability of system operation is improved on the basis of improving the efficiency of batch processing inspection.
In an embodiment, the batch processing result checking method may further include:
checking whether checking result data before a preset time interval exists or not at regular time; and if so, deleting the inspection result data.
When the method is specifically implemented, after other processes are finished, the timing task can check whether check data before three months exist or not every day, if yes, the data are directly deleted, so that the problems that the later data are too much, the increasing and deleting speed of the table is influenced, and the running speed of the system is further improved are solved.
In an embodiment, the batch processing result checking method may further include:
and recording error data or data which does not need to be displayed during the checking process of the batch processing result in a log file.
During specific implementation, in the execution process of a project, if a program needs to report an error or some data which does not need to be displayed needs to be stored, the program can be recorded in a Log file, so that subsequent query is facilitated, and convenience is improved.
In the specific implementation, the data of the key nodes are recorded in the execution process. If the program has problems, the specific problems can be analyzed and solved in a log checking mode, and the operation and maintenance efficiency is improved.
In an embodiment, as shown in fig. 3, the method for checking the batch processing result may further include step 104:
and when the batch processing checking result is a defective batch processing checking result, outputting the defective batch processing checking result to the client.
During concrete implementation, the batch processing inspection result with problems is output to the client, so that the staff can be clear at a glance for wrong data, the previous verification result can be saved, one-stage comparison is facilitated, and the working efficiency of bank staff and operation and maintenance staff is improved.
In specific implementation, the client displays the previous execution result in a default mode, the data list corresponds to each column of the table, and only the error description field needs to be clicked for checking due to more fields.
In an embodiment, as shown in fig. 4, the method for checking the batch processing result may further include:
step 201: receiving a query request about historical batch processing inspection results sent by a client; the query request comprises a job name and a query condition of business days;
step 202: and returning the obtained related query result to the client according to the query request.
In specific implementation, a user can query the checking result through the client, and the job name, the execution date and the like can be used as the screening conditions of the query.
When the method is specifically implemented, the client has the job name and the business day as query conditions, so that the user can check the previous check result. The client can also inquire the check result of the batch result in the previous night to obtain the wrong main key, and the reason for the mistake needs to be checked manually and specifically.
The method for checking the batch processing result provided by the embodiment of the invention has the beneficial technical effects that:
1. a thread is started by the main project to invoke the batch processing check operation, and the service data of the main project (large service project) can not be influenced whether the invoking is successful or not.
2. If the set-up was not successful, there is also a timing task to set-up the point every day and check if the set-up was successful for each job.
3. The automatic data verification is realized through a project (a batch processing result checking method), the complexity of manual verification is saved, the data can be repeatedly used at the later stage, and if new operation is carried out, the program only needs to be directly developed on the original basis.
4. The error data of the batch processing result check is clear at a glance, and the previous check result can be stored, so that one-stage comparison is convenient.
The embodiment of the invention also provides a batch processing result checking device, which is described in the following embodiment. Because the principle of solving the problems of the device is similar to the batch processing result checking method, the implementation of the device can refer to the implementation of the method, and repeated parts are not described again.
Fig. 5 is a schematic structural diagram of an apparatus for checking a batch processing result according to an embodiment of the present invention, as shown in fig. 5, the apparatus includes:
the receiving unit 01 is used for receiving a call-up instruction of a batch processing check job after the batch processing workflow of the service item is finished;
the checking unit 02 is configured to check the batch processing result of the service item according to the call instruction and a preset batch processing checking policy to obtain a batch processing checking result;
and the writing unit 03 is configured to write the batch processing inspection result into a preset inspection result record table.
In the embodiment of the present invention, the batch processing result checking apparatus is configured to: the receiving unit 01 receives a call-up instruction of a batch inspection job after the batch processing workflow of a service item is finished; the checking unit 02 checks the batch processing result of the service item according to the call instruction and a preset batch processing checking strategy to obtain a batch processing checking result; the writing unit 03 writes the batch processing inspection result into a preset inspection result recording table, so that the batch processing result can be efficiently and accurately inspected.
In an embodiment, the apparatus for checking the batch processing result may further include:
and the timing processing unit is used for starting the timing task to initiate the check of the batch processing check job with the processing failure when detecting that the batch processing check job with the processing failure exists.
In specific implementation, the timing processing unit executes: if the set-up was not successful, there is also a timing task to set-up the point every day and check if the set-up was successful for each job. Specifically, if the call fails after batch running, the integrated spring task timing task (a timing task function provided by spring) can check whether data for checking the yesterday batch running job exists in the table by the job name and the business day at five morning each day, and if not, the check for the job is initiated independently, so that the accuracy of batch processing check is improved. Each job is called through the thread pool, and the jobs are independent of each other, so that the safety of batch processing inspection is improved. In addition, the configuration of the maximum thread number is 10, so that excessive operation pressure on the server is avoided, and the stability of system operation is improved on the basis of improving the efficiency of batch processing inspection.
In an embodiment, the apparatus for checking the batch processing result may further include:
the cleaning unit is used for regularly checking whether checking result data before a preset time interval exists or not; and if so, deleting the inspection result data.
When the method is implemented specifically, the cleaning unit executes: after other processes are finished, the timing task can check whether check data before three months exist or not every day, if yes, the data are directly deleted, so that the influence on the speed of adding, deleting, modifying and checking the table due to excessive data at the later stage is avoided, and the running speed of the system is further improved.
In an embodiment, the apparatus for checking the batch processing result may further include:
and the log processing unit is used for recording error reporting data or data which does not need to be displayed in the process of checking the batch processing result in a log file.
In specific implementation, the log processing unit executes: in the execution process of the project, if the program needs to report errors or some data which does not need to be displayed needs to be stored, the data can be recorded in the Log file, so that the follow-up query is facilitated, and the convenience is improved.
In specific implementation, the log processing unit executes: and recording the data of the key nodes in the execution process. If the program has problems, the specific problems can be analyzed and solved in a log checking mode, and the operation and maintenance efficiency is improved.
In one embodiment, the writing unit is specifically configured to: and writing the batch processing inspection result into an inspection result record table of an Oracle database.
In specific implementation, Oracle refers to a database for storing inspection results after batch inspection is completed. The batch processing result checking device provided by the embodiment of the invention can store the checking result record table through the Oracle database, further store the batch processing checking result, and can be realized through the writing unit, thereby improving the safety of data storage, and the efficiency and convenience of subsequent data acquisition.
In an embodiment, the apparatus for checking the batch processing result may further include:
and the output unit is used for outputting the batch processing checking result with the problem to the client when the batch processing checking result is the batch processing checking result with the problem.
In specific implementation, the following steps are executed through the output unit: the batch processing inspection result with the problem is output to the client, so that the staff is clear at a glance for wrong data, the previous verification result can be saved, one-stage comparison is facilitated, and the working efficiency of bank staff and operation and maintenance staff is improved.
In specific implementation, the client displays the previous execution result in a default mode, the data list corresponds to each column of the table, and only the error description field needs to be clicked for checking due to more fields.
In an embodiment, the apparatus for checking the batch processing result may further include:
the query unit is used for receiving a query request about historical batch processing check results sent by a client; the query request comprises a job name and a query condition of business days;
and the feedback unit is used for returning the obtained related query result to the client according to the query request.
In specific implementation, the client has a job name and a business day as query conditions, so that the user can find the previous check result, and the search can be realized through the query unit and the feedback unit. The client can also inquire the check result of the batch result in the previous night to obtain the wrong main key, and the reason for the mistake needs to be checked manually and specifically.
In specific implementation, a user may query the checking result of the batch processing result through the client, and the job name and the execution date may be used as the screening condition of the query.
An embodiment of the present invention further provides a computer device, as shown in fig. 6, which includes a memory 302, a processor 304, and a computer program stored in the memory and executable on the processor, and when the processor executes the computer program, the processor implements any of the receiver circuits and the operation method of the terminal described above.
In particular, the computer device may be a computer terminal, a server or a similar computing device.
An embodiment of the present invention further provides a computer-readable storage medium, which stores a computer program for executing any of the above-mentioned receiver circuits and operating methods of a terminal.
In particular, computer-readable storage media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer-readable storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable storage medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
The batch processing result checking scheme provided by the embodiment of the invention has the beneficial technical effects that:
in the embodiment of the invention, the checking scheme of the batch processing result is as follows: after the batch processing work flow of the business item is finished, receiving a starting instruction of a batch processing check operation; checking the batch processing result of the service item according to the call instruction and a preset batch processing checking strategy to obtain a batch processing checking result; and writing the batch processing inspection result into a preset inspection result recording table, so that the batch processing result can be efficiently and accurately inspected.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may 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, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may 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, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.

Claims (15)

1. A method for checking a batch result, comprising:
after the batch processing work flow of the business item is finished, receiving a starting instruction of a batch processing check operation;
checking the batch processing result of the service item according to the call instruction and a preset batch processing checking strategy to obtain a batch processing checking result;
and writing the batch processing inspection result into a preset inspection result recording table.
2. The method of inspecting batch results of claim 1, further comprising:
upon detecting that there is a batch check job that fails processing, a start timing task initiates a check for the batch check job that fails processing.
3. The method of inspecting batch results of claim 1, further comprising:
checking whether checking result data before a preset time interval exists or not at regular time; and if so, deleting the inspection result data.
4. The method of inspecting batch results of claim 1, further comprising:
and recording error data or data which does not need to be displayed during the checking process of the batch processing result in a log file.
5. The method for checking batch processing results according to claim 1, wherein writing the batch processing checking results into a preset checking result record table comprises: and writing the batch processing inspection result into an inspection result record table of an Oracle database.
6. The method of inspecting batch results of claim 1, further comprising:
and when the batch processing checking result is a defective batch processing checking result, outputting the defective batch processing checking result to the client.
7. The method of inspecting batch results of claim 1, further comprising:
receiving a query request about historical batch processing inspection results sent by a client; the query request comprises a job name and a query condition of business days;
and returning the obtained related query result to the client according to the query request.
8. An apparatus for checking a batch result, comprising:
the system comprises a receiving unit, a processing unit and a processing unit, wherein the receiving unit is used for receiving a starting instruction of a batch processing check job after the batch processing workflow of a service item is finished;
the checking unit is used for checking the batch processing result of the service item according to the call instruction and a preset batch processing checking strategy to obtain a batch processing checking result;
and the writing unit is used for writing the batch processing check result into a preset check result record table.
9. The apparatus for inspecting results of a batch process of claim 8, further comprising:
and the timing processing unit is used for starting the timing task to initiate the check of the batch processing check job with the processing failure when detecting that the batch processing check job with the processing failure exists.
10. The apparatus for inspecting results of a batch process of claim 8, further comprising:
the cleaning unit is used for regularly checking whether checking result data before a preset time interval exists or not; and if so, deleting the inspection result data.
11. The apparatus for checking batch processing results according to claim 8, wherein the writing unit is specifically configured to: and writing the batch processing inspection result into an inspection result record table of an Oracle database.
12. The apparatus for inspecting results of a batch process of claim 8, further comprising:
and the output unit is used for outputting the batch processing checking result with the problem to the client when the batch processing checking result is the batch processing checking result with the problem.
13. The apparatus for inspecting results of a batch process of claim 8, further comprising:
the query unit is used for receiving a query request about historical batch processing check results sent by a client; the query request comprises a job name and a query condition of business days;
and the feedback unit is used for returning the obtained related query result to the client according to the query request.
14. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any one of claims 1 to 7 when executing the computer program.
15. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program for executing the method of any one of claims 1 to 7.
CN202110352516.2A 2021-03-31 2021-03-31 Batch processing result checking method and device Active CN113010566B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110352516.2A CN113010566B (en) 2021-03-31 2021-03-31 Batch processing result checking method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110352516.2A CN113010566B (en) 2021-03-31 2021-03-31 Batch processing result checking method and device

Publications (2)

Publication Number Publication Date
CN113010566A true CN113010566A (en) 2021-06-22
CN113010566B CN113010566B (en) 2023-01-13

Family

ID=76387775

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110352516.2A Active CN113010566B (en) 2021-03-31 2021-03-31 Batch processing result checking method and device

Country Status (1)

Country Link
CN (1) CN113010566B (en)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2012146049A (en) * 2011-01-11 2012-08-02 Hitachi Systems Ltd Batch job delay alarm automatic raising system, automatic alarm raising method and program therefor
CN104317960A (en) * 2014-11-14 2015-01-28 中国建设银行股份有限公司 Method and device for processing batch job
US20190065533A1 (en) * 2017-08-29 2019-02-28 Bank Of America Corporation System for determining the impact to databases, tables and views by batch processing
CN111400288A (en) * 2019-01-02 2020-07-10 中国移动通信有限公司研究院 Data quality inspection method and system
CN112416727A (en) * 2020-11-23 2021-02-26 中国建设银行股份有限公司 Batch processing operation checking method, device, equipment and medium

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2012146049A (en) * 2011-01-11 2012-08-02 Hitachi Systems Ltd Batch job delay alarm automatic raising system, automatic alarm raising method and program therefor
CN104317960A (en) * 2014-11-14 2015-01-28 中国建设银行股份有限公司 Method and device for processing batch job
US20190065533A1 (en) * 2017-08-29 2019-02-28 Bank Of America Corporation System for determining the impact to databases, tables and views by batch processing
CN111400288A (en) * 2019-01-02 2020-07-10 中国移动通信有限公司研究院 Data quality inspection method and system
CN112416727A (en) * 2020-11-23 2021-02-26 中国建设银行股份有限公司 Batch processing operation checking method, device, equipment and medium

Also Published As

Publication number Publication date
CN113010566B (en) 2023-01-13

Similar Documents

Publication Publication Date Title
US20190303779A1 (en) Digital worker management system
US8140565B2 (en) Autonomic information management system (IMS) mainframe database pointer error diagnostic data extraction
CN100461130C (en) Method for testing a software application
US11144311B2 (en) Static analysis of higher-order merge conflicts in large software development projects
US20110029822A1 (en) Tracking of java objects during request processing
CN108897686B (en) Full-entry automatic testing method and device
CN113515297A (en) Version updating method and device, electronic equipment and storage medium
CN113094362A (en) Method and device for reliably delivering and processing asynchronous message
US11269997B2 (en) Automated dynamic security testing
CN113014445A (en) Operation and maintenance method, device and platform for server and electronic equipment
CN112650688A (en) Automated regression testing method, associated device and computer program product
US11341030B2 (en) Scriptless software test automation
CN112506772B (en) Web automatic test method, device, electronic equipment and storage medium
CN113010566B (en) Batch processing result checking method and device
US11481376B2 (en) Platform for handling data corruptions
US11238017B2 (en) Runtime detector for data corruptions
CN111552648A (en) Automatic verification method and system for application
CN116594887A (en) CFD software-based automatic test method and system
CN111124370A (en) Data processing method and related equipment
CN114547206A (en) Data synchronization method and data synchronization system
CN113079046A (en) Data access method and device, electronic equipment and medium
JP5101447B2 (en) Test support system
CN115981525A (en) Test data construction method, device, equipment and medium
WO2018042022A1 (en) System and apparatus for providing different versions of a type of data journey
CN114253852A (en) Automatic testing method, device, equipment and medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant