JPH0934762A - Method and system for processing data base - Google Patents

Abstract

PROBLEM TO BE SOLVED: To designate the date and time of processing execution/transmission execution by receiving the processing executed result stored in a server computer system and storing it in an external storage device or displaying it on a display when there is a reserved extraction/updating processing executed result possessing request. SOLUTION: According to a reserved processing request possessed from terminal equipment 101 by a reserved processing content possessing part 10 of a client computer system 105, an SQL for requesting extraction/update to a data base 103 is generated by a batch SQL generating part 11 and the SQL required for series of reserved processing is constituted and issued to a server computer system 104. When there is the reserved extraction/update processing executed result possessing request, the processing executed result stored in the server computer system 104 is received and stored in an external storage device 102 or displayed on a display 101. Thus, not only the delivery destination of the processing executed result but also the date and time of processing execution/transmission execution can be designated.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention, in a client / server system, means for processing a database extraction / update processing request requested by a client asynchronously with a client who is a processing requester, and notifying the execution result to the client. And a system for processing a database of a client / server system having

[0002]

2. Description of the Related Art There is a need to import data from a workstation / mainframe database into a personal computer and use distribution software to process / edit the data. In this case, the workstation / mainframe that has the database is the server computer system, and the personal computer that has the means for issuing the extraction / update request and receiving the result is the client computer system. Has been realized.

In this system, a processing requester who issues a request for extracting / updating data from the database from a client goes through the processing request processing, the processing request processing, and the processing request completion notification until the server computer system. An operation that is synchronized with the processing progress of the database processing execution unit of was required.

[0004]

In the above prior art, when performing the extraction / update process for the database of the server computer system, the process requester synchronizes with the process progress of the database process execution control unit of the server computer system. Since an operation is required, other processing cannot be executed while the processing request is being executed, and the operation terminal is occupied because of waiting for the completion of the processing, which causes a reduction in work efficiency.

A first object of the present invention is to collectively notify a series of extraction / update processing requests to a database, and to enable processing to be executed asynchronously with a client computer system in a server computer system. It is possible to disconnect the session after completion of the request and release the occupation of the operation terminal, thereby enabling execution of processing other than the processing in the client computer system.

Further, in the above-mentioned conventional technique, the execution status of the batch requested processing contents must be confirmed by reestablishing a session from the client computer system at an arbitrary timing.

A second object of the present invention is to notify the client computer system of the request processing execution status asynchronously to the client computer system by using the notifying means of the server computer system, so that the processing requester can complete the batch processing request in real time. It aims to improve work efficiency by providing a means to know and omitting session establishment work for confirmation of processing completion. Further, in the above-mentioned conventional technology, the processing status and the processing result for the batch processing request have only means for notifying only the terminal which has made the processing request, and the processing result cannot be delivered to other terminals. Even when the same processing is performed on the server computer system, it is necessary to make a request from each client computer system.

A third object of the present invention is to specify the address of the resulting delivery destination client computer system at the time of batch processing request, so that the mobile client computer connected not only in the same network but also by a wireless network or the like. Another object of the present invention is to provide means for notifying a result to a terminal having an address desired by a processing requester by providing a processing result notifying means to a client computer system of another network.

Further, in the above-mentioned conventional technique, the data is simply transmitted to the designated distribution destination, and it is not possible to designate the date and time of execution of processing and transmission.

A fourth object of the present invention is to specify not only the delivery destination of the process execution result but also the date and time of the process execution / transmission execution when the reservation process request is made. It is to provide means for requesting a reservation process in consideration of the load state of.

[0011]

To achieve the first object, in the database processing system of the present invention, reservation extraction / selection for a server computer system having a database in a client computer system having a display, an input device, and an external storage device. It has means for making an update processing request, means for notifying and displaying the reservation acceptance ID from the server computer system, and means for executing the reservation processing asynchronously to the server computer system. Furthermore, the client computer system has means for confirming the reservation process execution status from the server computer system at an arbitrary timing.

In order to achieve the above second object, in the database processing system of the present invention, the server computer system has an asynchronous notifying means for the client computer system of the execution status of the reservation extraction / update processing request.

In order to achieve the third object, the database processing system of the present invention has a means for the server computer system to notify the client computer system of the destination address notified at the time of the processing request of the reservation processing result. .

To achieve the fourth object, the database processing system of the present invention has means for designating the processing execution and the execution result transmission date and time in the client computer system, and the server computer system for time monitoring / It has a controllable means.

[0015]

[Operation] A client computer system in which a server computer system having a database and a client computer system having a display, an input device and an external storage device are connected.
In the server system, (1) The reservation process content acquisition unit and the batch SQL creation unit are necessary for a series of reservation extraction / update process requests when the process requester requests reservation extraction / update processes for the client computer system. SQL is a database operation language
Are assembled and issued collectively to the server computer system. In addition, the reservation processing reception management unit in the server computer system extracts reservations from the client computer system /
Reservation extraction / update processing for the database is accepted by the reservation processing execution control unit in response to an update processing request. The reservation process execution control unit performs SQL execution control on the database management unit according to the content of the received reservation extraction / update process. The reservation processing result storage unit stores the completion status of the received reservation processing and the result of the processing execution, and notifies the client computer system of the content of the result.

This reservation processing content acquisition unit and batch SQL
Reservation extraction / update processing is requested from the client computer system to the server computer system due to the existence of the creation section, and processing is performed asynchronously with the client computer system due to the existence of the reservation processing reception management section, reservation processing execution control section, and reservation processing result storage section. Is executed.

(2) The reservation processing result storage section notifies the completion result distribution / notification control section of a reservation processing completion notice. The completion result distribution / notification control unit notifies the reservation processing completion status notification to the reservation processing status receiving unit of the client computer system used by the reservation processing requester.

The presence of the reservation processing result storage section and the completion result distribution / notification control section makes it possible to notify the completion status of the reservation processing asynchronously with the client computer system.

(3) The completion result distribution / notification control unit distributes the reservation processing result asynchronously with the client computer system based on the address of the client computer system notified to the reservation processing reception management unit when the reservation processing is received. Distribute and send to the client computer system.

Due to the existence of the reservation process reception management unit and the completion result distribution / notification control unit, the reservation process requester can simultaneously display the contents of the reservation process execution result to any terminal other than the terminal used by the requester. It can be distributed asynchronously with the client computer system.

(4) The reservation process content acquisition unit acquires the designation information of the process start date and time of the reservation process and the process result transmission start date and time when the reservation process is accepted. The reservation process acceptance management unit analyzes the specified condition issued by the client computer system, and issues a time monitoring / control request to the time monitoring control unit to start reservation process execution and start execution result transmission. Due to the existence of this reservation confirmation reception management unit and time monitoring control unit,
It is possible for a reservation process requester to specify a process execution date and time and a transmission start date and time of an execution result for the reservation process.

[0022]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below in detail with reference to the drawings.

FIG. 1 is a schematic configuration diagram of an entire system according to an embodiment of the present invention.

In FIG. 1, 105 is a client computer system and 104 is a server computer system. The client computer system 105 has a database processing request unit 50 for the database of the server, and the server computer system 104 controls the database 103. It has a processing request reception control section 52 that receives a processing request from the database management section 51 and the client computer system, and a completion result notification section 531 that notifies the processing execution result. This system also shows that the communication control units 20 and 21 are performing communication between networks.

The first embodiment will be described with reference to FIGS. 2 and 5.

In accordance with the reservation processing request acquired from the terminal device 101 by the reservation processing content acquisition unit 10 of the client computer system 105, the batch SQL generation unit 11 executes the database 10
The SQL for performing the extraction / update request for 3 is generated, the SQL required for a series of reservation processing is configured, and issued to the server computer system 104 (processing 800). In the server computer system 104, the reservation processing request from the client computer system 105 is received by the reservation processing reception management unit 22, and the reservation processing is received and managed (processing 801). When the reservation processing request is normally received, the reservation processing reception management unit 22 notifies the reservation reception completion reception unit 12 of the reception ID.
(Process 802). When the reservation reception completion reception unit 12 of the client computer system 105 receives the reception ID, the reservation reception completion display unit 13 displays a screen as shown in FIG. 7 on the display 101. The reservation process reception management unit 22 passes the reservation process requests queued at arbitrary timings to the reservation process execution control unit 23, and the reservation process execution control unit 23 sequentially manages the SQLs handed over in batches according to the processing. A processing request is issued to the unit 25 (processing 803). The reservation process execution control unit 23 transfers the execution result to the reservation process result storage unit 24 during execution of a series of reservation processes.

The reservation processing result storage unit 24 stores the passed processing result until a request is made from the client computer system 105 (processing 804). When the series of reservation processes is completed in the reservation process execution control unit 23, the process completion status is passed to the reservation process result storage unit 24. The reservation processing result storage unit 24 stores the passed processing status until there is a request from the client computer system 105 (processing 804). The reservation processing status confirmation unit 14 of the client computer system 105 makes a reservation processing status confirmation request to the reservation processing result storage unit 24 of the server computer system according to the reservation processing status confirmation request acquired from the terminal device 101 ( Process 805). The reservation processing status notified from the reservation processing result storage unit 24 is received by the reservation processing status receiving unit 15 of the client computer system 105, and the reservation processing status display unit 16 displays the terminal device.
It is displayed on 101 (process 806). By confirming the content displayed on the terminal device 101 by the reservation processing status display unit 16 (process 807) and issuing a reservation process result transfer request to the reservation process result storage unit 24 (process 808), the reservation process result storage unit 24 Transfers the storage process execution result to the client computer system 105 (process 80
9), the process execution result receiving unit 17 of the client computer system 105 displays the process execution result on the terminal 101 by the process execution result display unit 18, or stores the process execution result by the external device storage unit 19 in the external storage device 102. To provide a series of processing.

According to the present embodiment, conventionally, the client computer system 105 had to wait for completion of processing while the extraction / update request from the client computer system 105 was being processed by the server computer system 104. By making a reservation processing request, the client computer system 105 can execute another work without being aware of the processing progress of the server computer system 104, and the execution result of the reservation processing can be used at any timing, thus improving work efficiency. Can be improved.

The second embodiment will be described with reference to FIGS.

In the first embodiment, when the reservation processing result storage unit 24 of the server computer system 104 is notified of the reservation processing status (process 810), the reservation processing result storage unit 24 notifies the contents of the completion result distribution / notification. Notify the control unit 26 (process 811),
The completion result distribution / notification control unit 26 notifies the reservation processing status to the client computer system 105 that made the reservation processing request, without depending on the state of the client computer system 105 (processing 812). It is effective to use a mail system or the like to notify the reservation processing status. Furthermore, in the case of notification of the reservation processing result, ring the bell of the terminal device 101,
It is effective to display a reception message or the like.

In the present embodiment, the confirmation of the reservation processing status does not have to be taken into consideration when the client computer system 105 is performing another work, and when the reservation processing is completed, it is automatically notified as in the mail system, which is convenient. Can be improved.

Third Embodiment FIG. 2, FIG. 3 and FIG.
It will be explained by.

In the second embodiment, the reservation processing request is issued from the client computer system 105 by the reservation processing reception management unit 2.
When it is accepted by 2 (process 813), the reservation process content acquisition unit 10
Acquires the address of the reservation process result transfer destination terminal device 110 of the transfer destination client computer system from the terminal device 101, and accepts the notification to the reservation process reception management unit 22 (process 81
3). Reservation processing result storage unit 2 of server computer system 104
When the reservation processing status is notified to 4 (processing 810), the reservation processing result storage unit 24 outputs the contents thereof to the completion result distribution / notification control unit 26.
To the transfer destination terminal of the address accepted by the reservation process acceptance management unit 22 (step 811).
The reservation processing result is notified to 110, and the reservation processing status is notified to the client computer system 105 that made the reservation processing request without depending on the state of the client computer system 105 (processing 812). In the case of this notification of the reservation processing result, it is effective to ring the bell of the transfer destination terminal device 110 or display a reception message or the like.

In this embodiment, the execution result of the reservation process is not transferred only to the terminal device 101 of the requester of processing, but to the transfer destination terminal device 110 of the transfer destination client computer system desired by the requester of reservation processing. Also, since the execution result of the reservation processing can be notified without depending on the work content of the client computer system 105, not only is it unnecessary to issue the same reservation processing request from each transfer destination terminal device 110,
Since the processing is executed internally at once, the work efficiency can be greatly improved.

A fourth embodiment will be described with reference to FIG.

In the third embodiment, when the terminal device 101 issues a reservation processing request to the client computer system 105, and when the execution start date and time and the execution result transmission date and time are specified, the client computer system 105
The reservation processing content acquisition unit 10 confirms the specified content and requests the reservation processing acceptance management unit 22 of the server computer system 104 to accept the reservation processing. Reservation processing reception management unit 22
Receives a request from the reservation processing content acquisition unit 10, analyzes the designated condition, and notifies the time monitoring control unit 28 of necessary information. The time monitoring control unit 28 monitors a designated date and time for the reservation processing, requests a reservation processing execution control unit 23 for a processing request when the designated time comes, and transmits a processing result to the reservation processing result storage unit 24. Ask.

In this embodiment, the execution start date and time of the reservation process and the execution result transfer start date and time can be designated, thereby making it possible to distribute the load on the processing capacity of the server.
Improve processing efficiency. Further, by executing the transmission at the time when the communication load is small, the improvement of the processing efficiency in the reduction of the communication time is realized.

[0038]

Since the present invention is constructed as described above, it has the following effects.

Conventionally, in a client / server system in which a server computer system having a database and a client computer system having a display, an input device, and an external storage device are connected, an extraction / update processing request from the client computer system to the server computer system. In order to perform, the operation that was synchronized with the processing progress status of the server computer system had to be performed.

According to the present invention, after the reservation extraction / update processing request is made, the client computer system can execute the processing of the server computer system and the independent processing, which is effective in improving the work efficiency.

Further, according to the present invention, it becomes possible for the processing requester to know the processing completion for the reservation extraction / update processing request without being aware of it, and it is possible to further effectively utilize the database processing method. is there.

Further, according to the present invention, it becomes possible to notify the reservation processing execution result notification to the processing requester without being limited, and the processing work efficiency for the multi-client of the database processing method can be improved.

Further, according to the present invention, it becomes possible to specify the execution date and time and the execution result transmission date and time for the reservation process.
The processing load of the computer can be distributed, and the execution result can be transmitted in consideration of the communication load, which is effective in providing a means for improving efficiency in the operation of the actual business.

[Brief description of drawings]

FIG. 1 is a schematic configuration diagram of an entire system according to an embodiment of the present invention.

FIG. 2 is a detailed configuration diagram of an entire system according to an embodiment of the present invention.

FIG. 3 is a system configuration diagram of a multi-client according to an embodiment of the present invention.

FIG. 4 is a system configuration diagram of a conventional technique.

FIG. 5 is a flow chart showing processing of the first exemplary embodiment of the present invention.

FIG. 6 is a flowchart showing the processing of the second and third embodiments of the present invention.

FIG. 7 is a diagram showing one screen of a reservation process acceptance completion notification displayed on the display of the client computer system side according to the first embodiment of this invention.

FIG. 8 is a diagram showing a screen for confirming the reservation processing completion status displayed on the display of the client computer system side according to the first embodiment of this invention.

FIG. 9 is a diagram showing one screen of a reservation processing completion asynchronous notification displayed on the display on the client computer system side according to the second and third embodiments of this invention.

[Explanation of symbols]

 10 Reservation processing content acquisition unit 11 Batch SQL creation unit 12 Reservation reception completion reception unit 13 Reservation reception completion display unit 14 Reservation processing status confirmation unit 15 Reservation processing status reception unit 16 Reservation reception status display unit 17 Processing execution result reception unit 18 Processing execution Result display unit 19 External device storage unit 20 Communication control unit (client computer system side) 21 Communication control unit (server computer system side) 22 Reservation processing reception management unit 23 Reservation processing execution control unit 24 Reservation processing result storage unit 25 Database management unit 26 Completion Result Distribution / Notification Control Unit 28 Time Monitoring Control Unit 31 Process Execution Acquisition Unit 32 Process Execution Display Unit 33 Process Completion Acquisition Unit 34 Process Completion Display Unit 35 Process Execution Result Transfer Request Unit 36 Process Execution Control Unit 50 Database Process Request unit 51 Processing request reception control unit 52 Completion result notification unit 101 End End device, display 102 External storage device 103 Database 104 Server computer system 105 Client computer system (requester) 110 Transfer destination client computer system (multiple units)

Claims (5)

[Claims] 1. A client / server system in which a server computer system having a database and a client computer system having a display, an input device, and an external storage device are connected by a network, and the database of the server computer system in the client computer system. When a reservation extraction / update processing request is issued to the server computer system, a reservation extraction / update processing request is issued to the server computer system, and after confirming the reservation acceptance completion, the session with the server computer system can be disconnected. When the server computer system confirms and accepts the reservation extraction / update processing request to the database, the processing corresponding to the reservation extraction / update processing request is sequentially executed asynchronously with the client computer system, and the execution status thereof And fruit A result is stored, and the stored execution status and the stored execution result are transferred to the client computer system in response to a request from the client computer system, and the client computer system executes the reservation extraction / update process from the server computer system. When the status is received and displayed on the display, and the reservation extraction / update processing execution result acquisition request is made, the processing execution result stored in the server computer system is received,
A database processing method, characterized by storing in the external storage device or displaying on the display. 2. A client / server system in which a server computer system having a database and a client computer system having a display, an input device, and an external storage device are connected by a network, wherein the client computer system is provided in the server computer system. Communication means, means for receiving a reservation processing request, means for executing processing on the database according to the received reservation processing request, means for managing the database according to the processing, and processing execution status for the database. And a means for storing the processing execution result for the database, and a means for notifying the client computer system of the stored contents.
In the client computer system, a means for communicating with the server computer system, a means for obtaining reservation processing content, a means for generating an SQL of a database operation language based on the reservation processing content, and a plurality of SQLs at once Means for issuing to the server computer system, means for receiving and displaying on the display the acceptance completion of the reservation processing, means for confirming the processing status of the reservation processing on the server computer system, and receiving the processing status of the reservation processing Means for displaying on the display, means for receiving the processing execution result by the notification of the completion of the reservation processing, means for receiving the processing result of the reservation processing and displaying it on the display, and storing the processing result of the reservation processing in the external storage device. A database processing system having means. 3. The server computer system according to claim 2, further comprising: when a series of reservation extraction / update processes is completed, a mail system or the like is used to indicate the completion result of the reservation processing status to the client computer system. A means for notifying the client computer system asynchronously is provided, and when the completion result is asynchronously notified in the client computer system, the bell of the terminal is ringed, a reception message or the like is displayed, and the processing requester And a means for notifying the completion of the reservation processing request, and the server computer system arbitrarily notifies the client computer system of the stored reservation processing completion status without being aware of the state of the client computer system. , A database processing system characterized by transmitting the completion of the processing to a processing requester. 4. The means according to claim 3, further comprising means for notifying the server computer systems of the addresses of the distributed client computer systems to which the reservation process execution results are to be delivered in the client computer system, and the reservation process from another system. When the execution result is delivered asynchronously, the server computer is provided with means for ringing the bell of the terminal, displaying a reception message, etc., and notifying the destination terminal operator of the completion of transmission of the reservation processing execution result. In the system, the process execution result of the reservation process is sent to the client computer system having the process execution result delivery destination address designated by the client computer system that made the reservation process request.
A means for notifying using a mail system or the like, delivering the result executed by the reservation process to the specified client computer system, and notifying the destination terminal operator of the completion of the process result delivery. And database processing system. 5. The means according to claim 4, further comprising: means for designating an execution start date and time for the reservation process and a transmission execution start date and time for an execution result of the reservation process in the client computer system. Means for monitoring the date and time designated by the reservation processing request in the server computer system, analyzing the time designation contents relating to the reservation processing, and executing control by time monitoring and execution request at the scheduled time. A database processing system, comprising means for performing, and enabling a processing requester to specify an execution date and time of a reservation extraction / update process and a transmission date and time of an execution result.