CN110888917A

CN110888917A - Batch running task execution method, device, server and storage medium

Info

Publication number: CN110888917A
Application number: CN201911149020.4A
Authority: CN
Inventors: 况雨平
Original assignee: Shenzhen Lexin Software Technology Co Ltd
Current assignee: Shenzhen Lexin Software Technology Co Ltd
Priority date: 2019-11-21
Filing date: 2019-11-21
Publication date: 2020-03-17

Abstract

The embodiment of the invention discloses a batch running task execution method, a batch running task execution device, a batch running task execution server and a storage medium, wherein the method comprises the following steps: querying a target database for a target bill that expires the day before the current date but is not processed; inquiring a calculation result of the target bill in a bill calculation data table of the previous day through the bill number of the target bill, wherein the bill calculation table is a data table obtained by calculating unprocessed bills due in the previous day in advance on the previous day of the current date; and updating the calculation result to the target database to complete the batch running task. By the technical scheme of the embodiment of the invention, the efficiency, stability and accuracy of overdue batch running after morning loan cutting can be improved, the batch running result can be quickly, stably and accurately output by data within the time range required by timeliness, and normal settlement is ensured.

Description

Batch running task execution method, device, server and storage medium

Technical Field

The embodiment of the invention relates to the technical field of computers, in particular to a batch running task execution method, a batch running task execution device, a batch running task execution server and a storage medium.

Background

In the loan-assisting industry, after a loan-assisting company takes funds of a fund party and borrows the funds to a user, a post-loan batch running task is executed, namely, after 12:00 o 'clock in the morning every day, the user needs to process overdue and unrelied orders of the user, for example, the user is calculated to pay interest, the user is informed to pay timely, the information needing to be paid to the fund party every day is normally settled with an external fund party, and the time efficiency is required to be finished before 3 o' clock.

The conventional batch running scheme after credit is to execute batch running after 12:00 pm, namely after a bill which is not paid currently is inquired, a batch running calculation module is called through a remote service interface to finish tasks such as calculating bill amount. However, in the morning, the batch running tasks of each system server are multiple, the system and the database are high in pressure and centralized, and the timeliness, the accuracy and the stability of the execution of overdue batch running tasks after loan cannot be guaranteed. If the batch running task fails, the subsequent process and normal settlement of a capital side are influenced, so that the loan-aid company occupies capital of the capital side, more interest needs to be given to the capital side, and even the user and the capital side are overdue, the risk of passive credit investigation of the user exists, and the normal development of the business of the loan-aid company is influenced.

Disclosure of Invention

The embodiment of the invention provides a batch running task execution method, a batch running task execution device, a batch running task execution server and a storage medium, which are used for shortening the time of executing a batch running settlement task on the same day, improving the system stability and reducing the batch running settlement failure rate.

In a first aspect, an embodiment of the present invention provides a batch running task execution method, including:

querying a target database for a target bill that expires the day before the current date but is not processed;

inquiring a calculation result of the target bill in a bill calculation data table of the previous day through the bill number of the target bill, wherein the bill calculation table is a data table obtained by calculating unprocessed bills due in the previous day in advance on the previous day of the current date;

and updating the calculation result to the target database to complete the batch running task.

Optionally, the calculating, in advance, the unprocessed bills due on the previous day before the current date includes:

at the current moment of bill calculation in the previous day, obtaining a bill which is due and not processed in the previous day;

and calling an overdue bill calculation module to calculate the bill which is expired and not processed on the previous day and storing the calculation result in a bill calculation data table on the previous day.

Optionally, the calling overdue bill calculation module calculates the bill that has not been processed due on the previous day, including;

and calling an overdue bill calculation module through a remote procedure call protocol to calculate the bill which is not processed before the expiration of the previous day.

Optionally, the calculation result includes: the bill is overdue and interest bearing.

In a second aspect, an embodiment of the present invention further provides a batching task executing apparatus, including:

the target bill acquiring module is used for inquiring the target bill which is expired before the current date but is not processed in the target database;

the result query module is used for querying the calculation result of the target bill in a bill calculation data table of the previous day through the bill number of the target bill, wherein the bill calculation table is a data table obtained by calculating unprocessed bills due in the previous day in advance on the previous day of the current date;

and the database updating module is used for updating the calculation result to the target database so as to complete the batch running task.

Optionally, the apparatus further includes a data table generating module, configured to:

Optionally, the data table generating module is specifically configured to:

In a third aspect, an embodiment of the present invention further provides a server, where the server includes:

one or more processors;

a memory for storing one or more programs;

when executed by the one or more processors, cause the one or more processors to implement the batching task execution method steps as provided by any of the embodiments of the present invention.

In a fourth aspect, the embodiments of the present invention further provide a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the batch task execution method provided in any of the embodiments of the present invention.

The embodiment of the invention has the following advantages or beneficial effects:

by calculating the running batch calculation task after cutting in the morning in advance in the previous day and directly inquiring the calculation result of the target bill in the bill calculation data table in the running batch task in the previous day, the efficiency, stability and accuracy of overdue running batch after cutting in the morning can be improved, the running batch result can be quickly, stably and accurately output by data within the time range required by timeliness, and normal settlement is guaranteed.

Drawings

FIG. 1 is a schematic illustration of batch task execution in the prior art;

FIG. 2 is a flow chart of a batch task execution method according to an embodiment of the present invention;

FIG. 3 is a schematic diagram of batch task execution according to an embodiment of the present invention;

FIG. 4 is a schematic structural diagram of a batching task executing device according to a second embodiment of the present invention;

fig. 5 is a schematic structural diagram of a server according to a third embodiment of the present invention.

Detailed Description

The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.

Example one

Fig. 2 is a flowchart of a batch running task execution method according to an embodiment of the present invention, which is applicable to a situation where a batch runs a task of performing overdue interest calculation on a loan and other services. The method can be executed by a batching task executing device, which can be realized by software and/or hardware and is integrated in equipment with application development function. The method specifically comprises the following steps:

and S110, inquiring the target bill which is expired on the previous day of the current date and is not processed in the target database.

The target database may be a database related to loan transaction, such as a database in which a lending company records details of a loan relationship between a loan user and a fund, and records user information, a loan amount, loan interest, a loan term, a repayment date, a repayment mode, and the like of a certain user in detail.

Because the timeliness requirement of the overdue settlement batch running calculation task is high, the batch running task is usually completed at 0-3 am after the morning of each day. Specifically, the current date may be day T +1 in fig. 1 and 3, and the day before the current date is day T in fig. 1 and 3. In the T +1 day, the loan bill which is due but not yet paid on the T day is the target bill which is processed but not yet paid, and the target bill needs to be calculated according to data such as overdue interest and the like. On each bill of the loan, there is a corresponding mark to indicate whether the bill has been paid in time, and whether the bill is a target bill which is not paid is determined according to the mark.

And S120, inquiring a calculation result of the target bill in a bill calculation data table of the previous day through the bill number of the target bill, wherein the bill calculation table is a data table obtained by calculating unprocessed bills due in the previous day in advance on the previous day of the current date.

Specifically, in the embodiment, when the batch running calculation task is executed at 0-3 points on T +1 day, the corresponding calculation result is directly inquired in the bill calculation data table storing pre-calculated data of overdue interest and the like according to the bill number of the target bill, and thus the corresponding batch running task is completed.

It should be noted that the bill calculation data table is the yearly library day table in fig. 3, which means that a data table may be created for each day of the year by running a script, so as to store the calculation result of data such as overdue interest of bills that expire but have not been processed in each day, and the date of the day may be used as the name of the table. The bill calculation data table is the result of calculation at 0-24 points of T day. In other words, the wrong peak in the batch running calculation process in the morning of the T +1 day is calculated by advancing to 0-24 points of the T day. In the specific calculation process, in the T day, bills which are due on the current day of the T day but are not paid back until the calculation time is reached are obtained, overdue interest calculation is carried out on the bills in advance by calling an overdue bill calculation module through a remote procedure call protocol, and a temporary annual bank day table (bill calculation data table) is obtained as a calculation result. The remote procedure call protocol is an rpc interface in fig. 1 and 3, and the overdue bill calculation module can execute a corresponding calculation function by calling the interface.

For example, in the process of executing the batch running task, loan bills which are paid but are not paid are acquired at 9 am on T day, and data such as overdue interest and the like are calculated for the bills, so that the bills are not calculated as overdue bills within the T day, and only at T +1 day, the unreturned bills in the bills are called as overdue unprocessed bills and are target bills of the batch running task on T +1 day. Further, if a bill that was not paid for on day T at 9 am, and perhaps some users of the loan performed a payment operation on day T at 4 pm, then the target bill determined on day T +1 does not include the bill that was paid. In the embodiment, the calculation amount of the account statement data is relatively increased, that is, overdue interest is calculated for bills which are not overdue for T +1 day, but the calculation process is carried out for T day before, and is not carried out for 0-3 points of T +1 day, so that the efficiency of overdue running batch after loan is improved. Moreover, when the batch running calculation process is executed in the daytime of T days, if the server has the problems of crash, crash and the like, manual intervention detection can be timely carried out, and system repair is carried out.

And S130, updating the calculation result to the target database to complete the batch running task.

And after the calculation result is obtained by inquiring the bill calculation data table, the result can be updated to the target database to complete the batch running task. And further settling accounts with a fund party according to the calculation result, or informing the loan user of interest of overdue repayment, prompting the loan user to timely repay and the like.

In a specific example, when the number of the target orders is thirty thousand, if the batch running calculation process needs to be executed in the execution mode in fig. 1 for 3 hours in the T +1 day, and the batch running time in the morning of the T +1 day can be shortened to less than 15 minutes by performing the batch running calculation in advance in the T day by the off-peak batch running calculation method in the execution mode in fig. 3, so that the normal settlement between the target orders and the fund side is greatly ensured; the pressure of a business system and a database in the morning is reduced, the utilization rate of a CPU is increased to 85% before and is stably reduced to about 30%, and the stability of the system is improved; the abnormal accidents of batch running on the line are effectively reduced; the method provides reliable, stable and efficient platform support for the development of the business of the loan-aid company, and further improves the platform capability.

According to the technical scheme, the running batch calculation task after cutting in the morning is calculated in advance in the previous day, the calculation result of the target bill is directly inquired in the bill calculation data table in the running batch task in the previous day, the efficiency, the stability and the accuracy of overdue running batch after cutting and lending in the morning can be improved, the running batch result can be quickly, stably and accurately output within the time range required by the timeliness, and normal settlement is guaranteed.

Example two

Fig. 4 is a schematic structural diagram of a batch running task execution device according to a second embodiment of the present invention, which is applicable to a situation where a batch runs a calculation task of overdue interest for a loan and other services, and the device specifically includes: target bill acquiring module 210, result querying module 220 and database updating module 230.

The target bill acquiring module 210 is configured to query the target database for target bills that expire but are not processed the day before the current date; a result query module 220, configured to query a calculation result of the target bill in a bill calculation data table of a previous day through a single number of the target bill, where the bill calculation table is a data table obtained by calculating an unprocessed bill due on the previous day in advance on the previous day of the current date; a database update module 230 for updating the calculation result to the target database to complete the batch task.

Optionally, the batching task executing device further comprises a data table generating module, configured to:

Optionally, the data table generating module is specifically configured to:

The batch task execution device provided by the embodiment of the invention can execute the batch task execution method provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects for executing the batch task execution method.

EXAMPLE III

Fig. 5 is a schematic structural diagram of a server according to a third embodiment of the present invention. FIG. 5 illustrates a block diagram of an exemplary server 12 suitable for use in implementing embodiments of the present invention. The server 12 shown in fig. 5 is only an example, and should not bring any limitation to the function and the scope of use of the embodiment of the present invention.

As shown in FIG. 5, the server 12 is in the form of a general purpose computing device. The components of the server 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that couples various system components including the system memory 28 and the processing unit 16.

Bus 18 represents one or more of any of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, and a processor or local bus using any of a variety of bus architectures. By way of example, such architectures include, but are not limited to, Industry Standard Architecture (ISA) bus, micro-channel architecture (MAC) bus, enhanced ISA bus, Video Electronics Standards Association (VESA) local bus, and Peripheral Component Interconnect (PCI) bus.

The server 12 typically includes a variety of computer system readable media. Such media may be any available media that is accessible by server 12 and includes both volatile and nonvolatile media, removable and non-removable media.

The system memory 28 may include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM)30 and/or cache memory 32. The server 12 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 5, and commonly referred to as a "hard drive"). Although not shown in FIG. 5, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 by one or more data media interfaces. System memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.

A program/utility 40 having a set (at least one) of program modules 42 may be stored, for example, in system memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. Program modules 42 generally carry out the functions and/or methodologies of the described embodiments of the invention.

The server 12 may also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), with one or more devices that enable a user to interact with the server 12, and/or with any devices (e.g., network card, modem, etc.) that enable the server 12 to communicate with one or more other computing devices. Such communication may be through an input/output (I/O) interface 22. Also, the server 12 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the Internet) via the network adapter 20. As shown, the network adapter 20 communicates with the other modules of the server 12 via the bus 18. It should be understood that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the server 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, among others.

The processing unit 16 executes various functional applications and data processing by executing programs stored in the system memory 28, for example, implementing a batching task execution method provided by the present embodiment, the method comprising:

Of course, those skilled in the art can understand that the processor can also implement the technical solution of the batch task execution method provided by any embodiment of the present invention.

Example four

A fourth embodiment provides a computer-readable storage medium, on which a computer program is stored, the program, when executed by a processor, implementing the steps of the batch task execution method provided by any embodiment of the invention, the method including:

Computer storage media for embodiments of the invention may employ any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. The computer-readable storage medium may be, for example but not limited to: an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.

Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.

Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).

It will be understood by those skilled in the art that the modules or steps of the invention described above may be implemented by a general purpose computing device, they may be centralized on a single computing device or distributed across a network of computing devices, and optionally they may be implemented by program code executable by a computing device, such that it may be stored in a memory device and executed by a computing device, or it may be separately fabricated into various integrated circuit modules, or it may be fabricated by fabricating a plurality of modules or steps thereof into a single integrated circuit module. Thus, the present invention is not limited to any specific combination of hardware and software.

It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims

1. A method of batch task execution, comprising:

2. The method of claim 1, wherein pre-calculating the outstanding bills due on the previous day prior to the current day comprises:

3. The method of claim 2 wherein the invoking an overdue bill calculation module calculates the bill that has not yet been processed due the previous day, including;

4. The method of any of claims 1-3, wherein the computed result comprises: the bill is overdue and interest bearing.

5. A batching task executing apparatus, comprising:

6. The apparatus of claim 5, further comprising a data table generation module configured to:

7. The apparatus of claim 6, wherein the data table generation module is specifically configured to:

8. The apparatus of any of claims 5-7, wherein the computed result comprises: the bill is overdue and interest bearing.

9. A server, characterized in that the server comprises:

one or more processors;

a memory for storing one or more programs;

when executed by the one or more processors, cause the one or more processors to implement the batching task execution method as recited in any one of claims 1-4.

10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out a batching task execution method according to any one of claims 1-4.