JP2000081986A - Job management method for client / server type business processing system and recording medium storing the program - Google Patents

Abstract

(57) [Summary] [PROBLEMS] To realize a job management method capable of efficiently processing batch processing involving database access in a client-server type system. A server (20) classifies jobs requested to be activated according to processing performance, a first-class job is activated immediately, and a second-class job is executed in an execution queue.
5, and a plurality of jobs are sequentially executed simultaneously by the job execution management system 30. The job of the third class is started based on an execution schedule table preset in the server 20. The job execution management system 30
It has a job execution status display function, an execution status inquiry function, and a job execution order change function (11) (12).

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a job management method in a client-server type business processing system, and more particularly, to a case where batch processing (batch processing) of a large amount of data is executed in the client-server type system. The present invention relates to a job management method capable of stably ensuring processing performance and a recording medium storing the program.

[0002]

2. Description of the Related Art Conventionally, various business processes for large amounts of data have been mainly performed by a large general-purpose computer system. In recent years, however, the performance of small computers (PCs) has been improved, and operating systems for PCs (PC OSs) and Because the functions of database management software have become more prominent, downsizing has been performed against this background. In other words, a client-server type system has been put to practical use by connecting a plurality of small computers to each other via a network, and this system has been used to perform various business processes. As a technique for executing a plurality of batch jobs systematically and efficiently by a client-server system, there is, for example, a parallel batch processing method described in Japanese Patent Application Laid-Open No. 9-16521. In the above method, a server terminal connected to a plurality of client terminals allocates a plurality of batch jobs to individual client terminals, generates schedule information including running conditions of each batch job and scheduled execution time, and generates the schedule information. Are stored in an execution management table for each client terminal, and are executed by the client terminal. On the other hand, each client terminal includes an execution management control unit and a job execution unit, and automatically executes a batch job addressed to its own terminal stored in the execution management table of the server terminal in parallel according to its running conditions and the like.
In this case, the database is maintained and managed by
It is a server terminal.

[0003]

As described above, the client-server type business processing system includes a client terminal used as an operation terminal of a business processing person, a database storing data necessary for business processing, and the database. Generally comprises a server terminal provided with a system for managing the business processing programs, a memory for storing each business processing program, and a system for managing its execution. By the way, business processing programs are roughly classified into an inquiry response type process capable of executing work instantaneously, and a batch process (batch process) for, for example, totalizing a large amount of data accumulated in a database. The batch process is a batch process of a large amount of data, and has a characteristic that the database is frequently accessed. Therefore, the efficiency of batch processing is limited by the database
Access processing efficiency occupies a large weight. In the processing method described in the above-mentioned publication, the batch processing is distributed to the client terminals other than the server terminal, so that the batch processing executed at each client terminal holds the database during the execution processing. Since data is frequently exchanged with the managed server terminal, the time that one client terminal can occupy the server terminal becomes short, and eventually the processing time is increased. However, there is a problem that expected processing performance cannot be obtained.

Accordingly, an object of the present invention is to provide a client-server type business processing system capable of solving such a conventional problem, efficiently processing batch processing involving database access, and improving server processing efficiency. An object of the present invention is to provide a job management method and a recording medium storing the program.

[0005]

In order to achieve the above object, in a job management method for a client-server type business processing system according to the present invention, when a plurality of jobs are executed simultaneously, job control mechanisms are classified into three types. In addition, the query type processing (several seconds to several tens of seconds) (hereinafter, the first class) in which the processing time of the server is the shortest, and the ad hoc batch processing (several minutes (Several ten minutes) (hereinafter referred to as the second class), and a processing schedule is determined or a large amount of data processing is performed. An execution schedule table is created, and pure batch processing (several hours to By dividing the job into several tens of hours (hereinafter, a third class), job processing is executed in a different manner for each class. A job activation request from a client is classified according to the above classification, and necessary information is registered as an execution job in a batch job management database. The job execution management system running on the server starts the waiting job by checking the registration status of the job in the batch job management database and the end status of the preceding job. As a result, the server can be operated effectively without restricting startup requests from the client, and fair processing can be obtained as a whole, and the processing efficiency of the server is reduced by performing the minimum necessary processing. Can be improved.

[0006]

Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a schematic configuration diagram of a client-server type business processing system according to an embodiment of the present invention. In this embodiment, in addition to the normal business system database 32, the client 11,
, A batch job management database 31 for registering and managing the job activation requests from. Also,
A job execution management system (program) for managing the batch job management database 31 is provided. Hereinafter, the functional operation of the job execution management system will be described. The server 20 includes clients 11, 12,
When a job activation request is received from the job, the job is classified into the following three classes based on the processing characteristics of the job, and separate processing is performed according to each classification.

If the job is a query type process in which the processing time in the server is short (several seconds to several tens of seconds), it is classified into the first class, executed immediately, and an answer is immediately sent to the client. . For example, in the case of a local government business processing system, business processing corresponding to the first class includes inhabitant record data inquiry processing, transfer-in / out processing, resident certificate issuance processing, seal certificate issuance processing, tax payment status inquiry processing for various taxes , Tax payment certificate issuance processing, various benefits payment status inquiry processing, and the like. If the job is a batch process at any time where the processing time in the server is relatively long (several minutes to several tens of minutes), the job is classified into the second class and registered in the batch job management database 31. Then, a job queue is set, and the job queue is sequentially executed to perform fair processing as a whole. The second
The business process corresponding to the class includes a demographic change statistical process of a resident record, a process of storing and deleting various tax payment data, a process of creating statistical materials relating to the status of various tax payments, and the like. If the job is a pure batch process in which a large amount of data processing (several hours to several tens of hours) is performed according to an execution schedule created in advance, the job is classified into a third class, and a schedule is generated immediately. To start execution. This third
Classes include daily databases
There are monthly processing such as backup processing, creation of fund transfer data for various taxes, and various tax levy processings performed at the beginning of the fiscal year.

FIG. 3 is a diagram showing a processing policy and a schedule table for each classification of the job execution management system according to an embodiment of the present invention. When a job start request is input from the client to the server, the job execution management system 30 determines the first class, the second class,
Classify into class and third class. That is, based on the first class in the case of the query type processing in which the processing time in the server is short, the second class in the case of the relatively long processing time in the server, and in the case of the ad hoc batch processing, based on the execution schedule created in advance. In the case of pure batch processing for processing a large amount of data, the data is classified into the third class. And the first
In the case of a class (inquiry type processing), since the processing is a business processing with a strong real-time property, the server immediately starts the corresponding processing program in response to a processing request from the client to the server, executes the processing program, and answers the result I do. Also, the second
In the case of a class (ad-hoc batch processing), as shown in FIG. 2 to be described later, it is further classified into sub-classes according to the processing time, and connected to a job queue for standby. Further, in the case of the third class (pure batch processing), it is registered in the schedule table 36 shown in FIG. 3 and is automatically started using a clock mechanism built in the server. For the processing corresponding to this, the processing execution schedule such as daily processing and monthly processing is determined in advance, and many processing requires a relatively long processing time. For this purpose, as shown in FIG. 3, job A starts at 16:00 on August 5 and ends at 19:00. Job B starts at 9:00 on August 6 and ends on August 1
It ends at 12:00 on day 0. Job C is 13 on August 10
Starts at 17:00 and ends at 17:00. And so on,
By registering and managing the job name, process number, and schedule, the program of the corresponding job is started and executed by a clock mechanism built in the server. Then, the program is ended at the end time.

FIG. 2 is a diagram for explaining the operation of a second class job management method according to an embodiment of the present invention. In FIG. 2, reference numerals 11 and 12 denote clients that issue a job start request.
Reference numeral 20 denotes a server that receives and executes a job start request, 30 denotes a job execution management system that classifies jobs and executes processing for each class according to the classification, 31
Is a batch job management database for registering and managing jobs; 34 is a job queue 1 for holding jobs having a relatively short processing time (jobs of subclass 1); and 35 is a job having a relatively long processing time (jobs of subclass 2). ) Is a job queue 2 for waiting. Note that ~
, (11) and (12) are numbers indicating the operation order. As shown in FIG. 3, when the job execution management system 30 receives a job activation request from the clients 11 and 12, the job execution management system 30 classifies the job into a first class, a second class, and a third class, and immediately executes the first class job. To send the answer back to the client. The job of the third class is the schedule table 36.
And automatically start and end by the clock mechanism.
Further, the jobs of the second class are classified into subclasses based on the estimated processing time.

(Registration of execution job) Jobs classified into the second class are further classified into subclass 1 (small random batch processing whose processing time is on the order of minutes) and subclass 2
(Medium and large-scale random batch processing in which the processing time is on the order of tens of minutes). The subclass identification keys of these subclasses 1 and 2, the user ID of the client that has requested activation, the name of the registered batch process, the registration number, and the job execution conditions (execution parameters, data, etc.)
Is registered in the job queue (1) 34 and the job queue (2) 35 attached to the batch job management database 31. The job queues 34 and 35 are provided for each of the subclasses 1 and 2. The job queue (1) 34 stores jobs corresponding to the subclass 1, the job queue (2) 35 stores jobs corresponding to the subclass 2, Register each (step). In the case of FIG. 2,
Currently, the running job 1 and the waiting job 3 are connected to the job queue (1) 34, and the job queue (2)
35, only the running job 2 is connected. At this time, the job 4 requested by the client 11 and the job 5 requested by the client 12 are connected to the job queue (1) 34 and are in a standby state.

(Job Execution Process by Job Execution Management System) On the server 20, the job execution management system 3
0 is always in the operating state, and the job execution management system 30
Refers to the job queues 34 and 35 in the batch job management database 31 at predetermined time intervals, searches for registered jobs in order of registration time, confirms whether there is a job waiting to be executed and whether there is a job being executed, and executes Start the waiting job. If the jobs registered in the job queues 34 and 35 are waiting to be executed and there is no preceding job being executed, the job execution management system 30 activates the waiting job (step). At this time, the execution conditions (execution parameters, data, etc.) of the registered job are transferred to the execution job. In addition, the execution flag is set in the corresponding area 33 of the batch job management database 31 (step).

Referring to the job queues 34 and 35, processing for starting a job is performed for each of the job queue (1) 34 and the job queue (2) 35, and a plurality of jobs are started and executed simultaneously. But start at the same time,
Regarding the number of jobs to be executed, within the range of the “number of concurrently executed jobs” set in advance by the command by the system administrator, the job execution management system sets the “number of concurrently executed jobs” And perform a check process. Also, this "number of concurrently executed jobs"
The setting can be changed at any time by a command operation of the system administrator. In FIG. 2, the running job 1 of the job queue (1) and the running job 2 of the job queue (2) are being executed simultaneously in parallel, and the current number of concurrently executing jobs is 2. For example, if there is a request from a client to start a new job N having a processing time of several minutes to tens of minutes, and this request continues for a certain period of time, a new job queue (3) is set, and By storing a new job N and starting it, three jobs 1, 2, and N can be executed concurrently. Further, the number of concurrently executing jobs can be changed from 3 to 2 at any time.

(Execution Job Completion Processing by Job Execution Management System) The job being executed issues a termination macro (notification) when the processing is completed (step). This end macro ends the running flag 33 of the corresponding area of the batch job management database 31 (step),
The end information (end time and the like) is written (step). When the execution completion notification is issued from the running job 1, the job execution management system 30 immediately starts the next waiting execution waiting job 3 (step). Similarly, when the execution of the job 3 is completed, the job 4 is started next, and the job 5 is started next. In addition to the execution management function of the batch processing at any time according to the above-described procedures (steps to), the job execution management system 30 also sends a job execution status to a job execution status inquiry (step) from the clients 11, 12 and the server 20. The job to change the execution order (step (11)) or delete the job (step (12)) of the functions to be displayed (steps) and the jobs registered in the waiting job queues (1) 34 and (2) 35 It also has a queue modification function.

Each operation step of class classification, registration in a schedule table, registration in a job queue, and sequential execution performed by the job execution management system 30 shown in FIGS. 2 and 3 is converted into a program and converted. If the program is stored in a recording medium such as a CD ROM, the contents of the recording medium can be loaded into an arbitrary personal computer, thereby realizing a client-server type business processing system using the arbitrary personal computer. A job management method can be easily executed.

As described above, in this embodiment, all the jobs requested to be started are executed by the server 20 which holds and manages the database system, and the jobs are classified according to their processing characteristics. The first class immediately executes and returns an answer, the third class is registered and managed in a schedule table, and the second class is provided with an execution waiting queue for each of its subclasses and sequentially starts jobs. I have. In this case, since a plurality of jobs are simultaneously executed within the range of “the number of concurrently executed jobs” set by the system administrator, efficient and efficient job processing can be executed according to the processing capacity of the server 20. Further, since the job execution management system 30 is provided with a function for displaying a job execution status and a function for changing a job queue registration job, the system administrator can use these functions to flexibly control job execution. And the entire system can be operated efficiently.

[0016]

As described above, according to the present invention,
Jobs running on the server are controlled according to the processing time and the server processing capacity, so that the server can be operated effectively without restricting startup requests from clients, and a job queue can be set. Therefore, fair processing can be obtained as a whole, and by executing the job execution status display and changing the execution conditions and priorities, it is possible to perform the minimum necessary processing, thereby further improving the processing efficiency of the server. it can.

[Brief description of the drawings]

FIG. 1 is a schematic configuration diagram of a client-server type business processing system according to an embodiment of the present invention.

FIG. 2 is a diagram illustrating an operation of a job execution management system for a second class according to an embodiment of the present invention.

FIG. 3 is a diagram showing a role and a schedule table of a job execution management system according to an embodiment of the present invention.

[Explanation of symbols]

11, 12 ... client, 13 ... bus, 20 ... server, 31 ... batch job management database, 32 ... business system database, 30 ... job execution management system, 34, 35 ... job queue (1) (2), 33 ... Flag area, 36 ... Schedule table.

 ──────────────────────────────────────────────────続 き Continued on the front page F term (reference) 5B085 AC03 AC12 AC13 BG07 5B098 AA10 CC02 CC10 GA02 GA03 GA08 GB01 GB14 GB15 GB16 GC01 GC08 GC14 GD02 GD14

Claims (4)

[Claims] 1. A server device connected to a plurality of client devices stores a job requested to be started by a client in a first class for immediately starting the job according to the processing characteristics of the job, and in a plurality of job queues waiting for execution. Once registered, sequentially extracted from the plurality of job queues, and executed in a second class for simultaneously executing a plurality of jobs, and registered in an execution schedule table set in advance in the server device, and then a job is started based on the schedule table. A client-server type characterized by displaying a job execution state by an inquiry from the client device or changing a registered job execution order by an instruction from the client device. Job management method for business processing system. 2. The system according to claim 1, wherein the number of jobs simultaneously executed by the server device can be arbitrarily changed within a range of “the number of concurrently executed jobs” preset by a system administrator. The job management method of the client / server type business processing system described in the above. 3. The job classification is performed by classifying the jobs according to the processing time length, and the jobs classified into the second class are further classified into a plurality of subclasses according to the processing time lengths. 3. The job management method for a client-server type business processing system according to claim 1, wherein an execution waiting job queue is provided for each classification, and the number of jobs of the subclass is simultaneously executed. 4. A program readable recording medium, wherein the operation of the job management method according to claim 1 is converted into a program, and the converted program is stored.