Information processing system, server device, client device and recording medium

Description: TECHNICAL FIELD [Detailed description of the invention]

【0001】

[Technical field to which the invention belongs]

In the present invention, for example, information that manages the data of the resident register with a server device and can register and update the data of the resident register from the terminal device (client device) of each department such as the resident section and the tax affairs section of the local government. Regarding the processing system, an information processing system in which the server device exclusively controls a plurality of requests, particularly when the use of shared resources is requested by a plurality of client devices, the server devices and client devices constituting this system, and this server device. The present invention relates to a recording medium in which a computer program for realizing the above is recorded.

【0002】

[Conventional technology]

For example, in a local government, a master file such as a resident register used by multiple departments such as the Residents Division and the Tax Affairs Division is managed by a server device as a shared file of multiple departments, and the person in charge is a terminal device assigned to each department. A system has been constructed that allows the server device to be accessed from (client device) to view, register, and update shared files.

【0003】

In a system that shares resources as described above, if multiple client devices access a shared file at the same time to register or update data, double registration, double update, or deadlock may occur. .. Further, when another client device accesses the shared file referenced from the file being referenced, registered, or updated to register or update the data, the reliability of the data is impaired.

【0004】

Therefore, the server device should accept only one registration / update request for one shared file, and reject the registration / update request for the shared file referenced from the file being referenced, registered, or updated. Controls (exclusive control) to prevent double registration, double update, deadlock of data in the shared file, and data change of the shared file referenced from the file being referenced, registered, or updated.

【0005】

In such exclusive control, generally, when one client device is accessing the shared file first for registration or update, another client device is accessing this shared file or from this shared file. When requesting the update or registration of the referenced shared file, the server device rejects the request of the client device later. At this time, a system is provided that notifies the client device requested later with a message such as "cannot be used because it is being used elsewhere".

【0006】

[Problems to be Solved by the Invention]

However, even if the message is notified as described above, the person in charge of the client device who is refused to use the shared file does not know which person in charge is using the common file in which client device and how. Is. Therefore, the person in charge who is denied the request to use the shared file has information such as which person in which department should negotiate with which person in which department, such as when the person in charge wants to update the shared file immediately or in an emergency that must be done. I can't get it.

【0007】

In addition, since it is not possible to obtain information such as how long the shared file has been used, it is unclear how long the shared file should be waited for before the shared file can be used. Therefore, the person in charge of the client device who is refused to use the shared file will do other work first if the waiting time is likely to be long, or wait until it becomes available if it seems to be finished soon. As such, work cannot be scheduled due to the length of waiting time.

【0008】

The present invention has been made to solve such a problem, and when a request for use such as registration or update of a resource shared by a plurality of client devices is not accepted by exclusive control of the server device. A client whose request has been rejected by providing usage status information, including information such as which terminal device is in use and how long the usage has elapsed, to the client device whose request has been rejected. The person in charge of the equipment can know the negotiating partner when he / she wants to use the resource immediately, and he / she can estimate the time until it becomes available and perform other work first or wait. It is an object of the present invention to provide an information processing system for which a schedule is set, a server device and a client device constituting this system, and a recording medium in which a computer program for realizing this server device on a computer is recorded.

【0009】

[Means for solving problems]

The information processing system of the present invention is an information processing system in which a server device exclusively controls usage requests for resources shared by a plurality of client devices. The server device uses memory and resources from the client device. When a request is received, a means for storing information on the usage status of the resource including a resource to be exclusively controlled and information for identifying the client device in the memory, and a case where the use of the resource by the client device is completed. , A means for deleting the corresponding usage status information from the memory, and a means for detecting whether or not the resource usage status information is stored in the memory when the client device requests the use of the resource. When the information on the usage status of the resource is stored in the memory, the request for the usage of the resource from the client device is rejected, and the information on the usage status of the resource is received in response to the request from the client device. The client device is provided with a means for transmitting the information to the client device, and the client device is provided with a means for receiving information on the usage status of resources from the server device and a means for outputting the information on the usage status. To do.

【0010】

The server device of the present invention is a server device that exclusively controls the request for use of resources shared by a plurality of external devices, and should be exclusively controlled when a request for use of resources from a memory and an external device is received. A means for storing information on the usage status of the resource including information for identifying the resource and the device in the memory, and when the use of the resource by the device is completed, the corresponding usage information is deleted from the memory. When a resource is requested to be used by an external device, the means for detecting whether or not the resource usage status information is stored in the memory, and the resource usage status information are the memory. When stored in the device, the device is provided with a means for rejecting the request for use of the resource from the device and transmitting information on the usage status of the resource to the device in response to the request from the device. It is a feature.

【0011】

The client device of the present invention is a client device in which a request for use of a resource shared with another client device is exclusively controlled, and the client device for which the request for use of the resource is accepted and the information for identifying the resource, respectively. It is characterized in that it is provided with a means for receiving information on the usage status of the resource including the above and a means for outputting the information on the usage status.

【0012】

The recording medium of the present invention records a computer program that causes a computer to exclusively control a request for use of a resource shared by a plurality of external devices, and is a recording medium that can be read by the computer and is external to the computer. When a request for the use of resources from a device is received, a program code means for storing information on the usage status of resources including resources to be exclusively controlled and information for identifying the device in a memory, and a computer using the device. When the use of the resource is completed, the program code means for deleting the corresponding usage status information from the memory, and when the computer is requested to use the resource from an external device, the resource usage status information is provided. When the program code means for detecting whether or not it is stored in the memory and the information on the usage status of the resource are stored in the memory in the computer, the request for the use of the resource from the device is rejected. At the same time, a computer program including a program code means for transmitting information on the usage status of the resource to the device in response to a request from the device is recorded.

【0013】

In the present invention, when the server device receives a request for use such as registration or update of a resource such as a file shared by a plurality of client devices, a file name that specifies this resource and a resource referred to from this resource. Information such as information and usage status information including information such as a terminal number that identifies a client device that uses resources is stored in a memory. When the use of this resource is completed, the information on the corresponding usage status of the memory is deleted.

【0014】

When the client device requests the use of a resource, the server device detects whether or not the usage status information of this resource is stored in the memory, and if the usage status information is stored in the memory, the server device detects whether or not the usage status information is stored in the memory. The request for the use of resources from this client device is rejected, and the information on the usage status of this resource is transmitted to the client device that rejects the request in response to the transmission request from this client device. The client device that receives the resource usage information from the server device outputs the usage information to a display or the like.

【0015】

Therefore, the person in charge of the client device whose usage request is rejected should contact any client device when he / she wants to immediately register or update the shared resource under exclusive control, or in an emergency when he / she must do so. You can get information about whether to negotiate.

【0016】

Further, the information processing system of the present invention is characterized in that the usage status information includes information related to the elapsed usage time of the resource.

【0017】

Further, the server device of the present invention is characterized in that the usage status information includes information related to the elapsed usage time of the resource.

【0018】

In the present invention, the usage status information includes information related to the resource usage elapsed time such as the resource usage start date and time, and the person in charge of the client device who is denied the request for the use of the shared resource is the person in charge of the resource usage progress. You can know the time.

【0019】

Therefore, the person in charge of the client device whose request is rejected has an idea of how long the waiting time should be before the shared file can be used, and if the waiting time is likely to be long, other work is done first. You can schedule work such as doing it in the future or waiting if it seems to be finished soon.

【0020】

Further, for example, if the client device goes down while using the shared resource, the shared resource cannot be used in the state of being exclusively controlled unless the exclusive control is released on the server device side. Therefore, the administrator of the server device checks the elapsed usage time of the shared resource regularly or irregularly to confirm the cause when the shared resource is occupied for an unnaturally long time, and for the shared resource. If the client device being registered or updated is down, or if it is under exclusive control even though it is not being used by another client device, the exclusive control is released to improve the operational efficiency of the system. Can be planned.

【0021】

Further, the information processing system of the present invention is a means for transmitting the usage status information stored in the memory to the client device when the server device receives a request for transmission of resource usage status information from the client device. It is characterized by having.

【0022】

Further, the server device of the present invention is characterized by comprising means for transmitting the usage status information stored in the memory to the device when a request for transmission of resource usage status information is received from an external device. And.

【0023】

In the present invention, when the client device requests to transmit the resource usage status information, the server device transmits the usage status information stored in the memory to the client device.

【0024】

Therefore, the person in charge of the client device shares whether or not there is a shared resource that is exclusively controlled and which shared resource is exclusively controlled before requesting the server device to use the shared resource for registration and update. You can know the usage status of resources. As a result, when the resource to be used is exclusively controlled, the use of this resource can be postponed, or the use of another resource that is not exclusively controlled can be requested first, so that the work efficiency is improved.

【0025】

BEST MODE FOR CARRYING OUT THE INVENTION

FIG. 1 is a block diagram of the information processing system of the present invention. For example, the person in charge of each section of the local government accesses the file managed by the server device 20 from the client devices 10a, 10b, 10c such as the personal computer assigned to each section to refer to the data. Perform work such as registration and update.

【0026】

The exclusive control file 201 of the server device 20 is the terminal number of the client device 10 that has received the request when the client device 10 requests the shared file such as the resident file 202 to be used for update or registration. If there is a shared file to be updated / registered and a shared file referenced from this shared file, the file name, the staff number of the person in charge of business, the process to be executed (job used), the process start time, and the client device 10. It is a file that stores information on the usage status of shared files such as the terminal number, personal number to be processed, and household number.

【0027】

FIG. 2 is a conceptual diagram of the exclusive control file 201. When the client device 10 requests the server device 20 to use for updating and registration, the server device 20 rejects the request if the information on the usage status of the requested shared file is stored in the exclusive control file 201. ..

【0028】

When the client device 10 requests the transmission of usage status information, the server device 20 sends the usage status information of the exclusive control file 201 to the client device 10 that has requested the use of the shared file that is exclusively controlled. , Information on the usage status of the requested shared file is transmitted, and information on the usage status of all the shared files that are exclusively controlled is transmitted to the client device 10 that has not requested the use of the shared file.

【0029】

When the client device 10 normally completes the update / registration process for the shared file, the server device 20 deletes the corresponding usage status information of the exclusive control file 201.

【0030】

In the resident file 202, the data of each individual resident who digitized the contents of the so-called resident register is registered, and the data of each individual is managed by the individual number and the household number. In the staff file 203, the staff number, staff code number, department name, name, etc. of the local government staff are registered. In the terminal number management file 204, the department name in which the client device 10 is located, the terminal number that identifies the client device 10, and the like are registered.

【0031】

The CPU 205 uses the exclusive control file 201 to perform exclusive control of the shared file managed by the server device 20, and in response to the transmission request from the client device 10, the client device 10 that rejects the request for use is requested. It controls the usage status information of shared files and the usage status information of all shared files that are exclusively controlled to the client device 10 that does not request the use, and also controls the operation timing of each device and each part. Control data transfer between. The communication control unit 206 transmits / receives data to / from the client device 10 using a predetermined communication protocol.

【0032】

The administrator of the server device 20 periodically or irregularly checks the usage status information of the exclusive control file 201, and if the shared file is occupied for an unnaturally long time, confirms the cause and shares the file. If the client device 10 that is updating or registering a file goes down, or if the client device 10 is not using it but is in exclusive control, the shared file and related shared files are excluded. Release control.

【0033】

In the above, the case where the usage status information of the client device using the exclusive controlled shared file is transmitted to the client device whose use is refused has been described, but the exclusive controlled shared file has been described. Information such as the existence or nonexistence of the client device whose use has been refused and the terminal number (placement unit name) of the client device may be included in the usage status information.

【0034】

In this case, a means for requesting the transmission of usage status information from the client device using the shared file under exclusive control is provided, and the person in charge of this client device who receives the usage status information in response to the request uses the file. You can know the waiting status for the shared file inside.

【0035】

Further, in the above description, the case where exclusive control is performed in file units has been described as an example, but exclusive control may be performed in other units such as record units.

【0036】

Next, the procedure of exclusive control in the information processing system of the present invention will be described based on the diagram of the screen operation example of the usage status display of FIG. 3 and the flowchart of FIG. In this example, the case where the usage status information is transmitted to the client device whose use of the resident file (A file) is refused, and the case where exclusive control is performed for each file will be described as an example. When the business code is input on the initial screen of the client device 10, the business code is set in the register in the server device 20 (step S1), and when the password / staff number is input on the password input screen, these input data are entered. Is set in the register (step S2).

【0037】

When a business (A file / personal item) is selected on the business menu screen of the client device 10, the business code and the person in charge code are set in the register (step S3), and the individual number / household number to be processed is set. Set the data input on the screen to each register (step S4). When the person in charge of the client device 10 presses the "update" button on this screen, the update process is requested from the client device 10 to the server device 20.

【0038】

Next, it is determined whether or not the process requested from the client device 10 is an update process (including registration process) (step S5), and if the request is other than the update process, the process proceeds to the routine of the requested process. .. On the other hand, if the requested process is an update process, it is checked whether the file name to be processed is written in the exclusive control file 201 (step S6).

【0039】

If the file name is not stored in the exclusive control file 201, the file name of this file, and if there is a shared file referenced from this file, its file name, the staff number of the person in charge of business, and the processing to be executed. Write the usage status information of the shared file such as (job used), processing start time, terminal number of client device 10, personal number to be processed, household number, etc. to the exclusive control file 201 (step S7), and this client device 10 Monitor whether the update process is completed.

【0040】

When the update process is completed, it is determined whether or not the update process is completed normally (step S8), and when the update process is completed, the information on the corresponding usage status of the exclusive control file 201 is deleted (step S9). If it does not end normally, it shifts to error processing.

【0041】

If the file name of the file requested to be used for update by the client device 10b exists in the exclusive control file 201 (YES in step S6), the server device 20 sends a message indicating that the file is in use to the client device 10b. (Step S10).

【0042】

When a message in use of a file (eg "cannot be updated") is displayed on the client device 10b, the person in charge of the client device 10b presses the "status" button to send information on the usage status of the file to the server device 20. Can be requested.

【0043】

It is determined whether or not the usage status information transmission is requested from the client device 10b (step S11), and if not, the process proceeds to step S13. On the other hand, when the transmission of usage status information is requested, the usage status information (file name / staff) of the shared file that is exclusively controlled is referred to by referring to the exclusive control file 201, the staff file 203, and the terminal number management file 204. The name (staff number), the job used, the processing start time, the department name where the client device 10a using the shared file is located, the personal number, and the household number) are transmitted to the client device 10b (step S12). At this time, the difference between the processing start time and the current time may be calculated and the difference may be displayed as the elapsed time. This allows you to see at a glance which business, how long, and how long the shared file has already been used.

【0044】

When the usage status information is received, the client device 10b displays this information on the display and outputs the information. The person in charge who referred to the usage status information on the client device 10b is in charge of the client device 10a using the shared file when he / she wants to register or update the shared file immediately or in an emergency when he / she must do it. Can negotiate with a person. Also, figure out how long you should wait before you can use the shared file, and if the waiting time is likely to be long, do other work first, or if it is likely to end soon, wait. You can make a schedule of work such as.

【0045】

If there is no request from the client device 10b to display the usage status information, or if the client device 10b waits until the shared file usage request becomes available without canceling the request, the server device 20 uses the exclusive control file 201. From, monitor whether or not the usage information of this shared file has been deleted (step S13). Monitor whether the usage status information display is requested from the client device 10b before it is deleted (step S11), and if so, send the usage status information to the client device 10b as described above. (Step S12).

【0046】

When it is detected that the usage status information of the shared file has been deleted from the exclusive control file 201 (YES in step S13), the process returns to step S1 and the above-mentioned client is contacted with respect to the client device 10b that has been waiting. Perform the same processing as for device 10a.

【0047】

Further, other functions in the information processing system of the present invention and their operation procedures will be described. [Help display by screen] Based on the conceptual diagram of the basic help file in Fig. 5, the conceptual diagram of the help file with memo in Fig. 6, and the screen operation example in Fig. 7, the help display function by screen and its function. The operation procedure will be described.

【0048】

In the basic help file, the "contents (functions / operation methods)" are registered for each screen such as the personal item input / correction screen and the move-out destination input screen. When the operator presses the "Help" button on an open screen, the "content" corresponding to that screen is displayed in a separate window.

【0049】

It is also possible to write a memo in the "content" column, and the written memo is stored in the basic help file. When a memo is attached to the "content", when the operator presses the "help" button on the open screen (Fig. 7), the "content" with the memo corresponding to that screen is displayed in a separate window. At this time, the added memo is given a code (asterisk in this example) indicating that it is a memo. In addition, such a basic help file may be provided for each person in charge so that the person in charge can write and use necessary memos.

【0050】

[Personal setting memo display] The memo display function is based on the conceptual diagram of the allowance recipient file in Fig. 8, the conceptual diagram of the culture monitor file in Fig. 9, the memo file in Fig. 10, and the screen operation example in Fig. 11. And its operation procedure will be described. Each resident has various attributes in addition to the basic attributes registered in the resident file, and the attribute information is registered across multiple files such as the allowance recipient file and the culture monitor file. ing. There is also attribute information that you do not want to publicly register in the file.

【0051】

For example, in the allowance recipient file, information related to receiving the allowance such as "name code", "name", "target person's name", "relationship", and "target person's date of birth" is registered. In addition, information related to the culture monitor such as "classification", "name code", "name", "district", and "organization" is registered in the culture monitor file. In the memo file (Fig. 10), each individual's attribute information such as frequently referred attribute information and attribute information that you do not want to publicly register in the file is registered as a "memo" for each "name code" and "name". ing.

【0052】

When the operator points to a personal name in the "Name" field and clicks the memo button while opening the list of cultural monitor files, or moves the cursor to that field, the contents of the memo about that person will be displayed. It will be displayed in a separate window (Fig. 11).

【0053】

[Input code list display using function keys] The function and operation procedure of input code list display using function keys will be described with reference to the screen operation example of FIG. In a computer that can use a mouse, it is often the case that a data input item is selected and input by a mouse operation from a list of input data candidates in a pull-down menu. However, for operators who are accustomed to keyboard operation and for work with a large amount of input data, switching from keyboard operation to mouse operation reduces work efficiency.

【0054】

In order to solve this problem, a function to display a list of codes to be input on the keyboard instead of displaying a list by pull-down menu for selecting by mouse operation on any of the function keys generally attached to the keyboard. Have. On the input screen shown in FIG. 12, when the operator moves the cursor to a field such as "relationship" or "address" and presses a predetermined function key, a code list of the contents to be entered in that field is displayed in a separate window. .. The operator can refer to this code list and enter the relationship code in the "relationship" field and the address code in the "address" field using the keyboard without switching to the mouse operation.

【0055】

The exclusive control computer program as described above can be provided by pre-installing it on a computer, or can be provided by a portable recording medium such as a CD-ROM or MO. It is also possible to provide it via a line.

【0056】

Further, in the above description, the case where the shared resource is a file has been described, but the resource is not limited to the file.

【0057】

[Effect of the invention]

As described above, in the present invention, when a request for use such as registration or update for a resource shared by a plurality of client devices is not accepted by exclusive control of the server device, which terminal device is in use is determined. Since the usage status information including the information such as how long the usage elapsed time is provided to the client device whose request is rejected, the person in charge of the client device whose request is rejected wants to use the resource immediately. It has excellent effects such as being able to know the negotiating partner in the case and planning work such as performing other work first or waiting with an estimate of the time until it becomes available. ..

[Simple explanation of drawings]

[Figure 1]

It is a block diagram of the information processing system of this invention.

[Figure 2]

It is a conceptual diagram of an exclusive control file.

[Fig. 3]

It is a figure of the screen operation example of the usage status display.

[Fig. 4]

It is a flowchart of exclusive control procedure.

[Fig. 5]

It is a conceptual diagram of a basic help file.

[Fig. 6]

It is a conceptual diagram of a help file with a memo.

[Fig. 7]

It is a figure of the screen operation example of a help display.

[Fig. 8]

It is a conceptual diagram of the allowance beneficiary file.

[Fig. 9]

It is a conceptual diagram of a culture monitor file.

[Fig. 10]

It is a conceptual diagram of a memo file.

[Fig. 11]

It is a figure of the screen operation example of the memo display.

[Fig. 12]

It is a figure of the screen operation example of the code input using a function key.

[Explanation of symbols]

10,10a, 10b, 10c Client device 20 Server device 201 Exclusive control file 202 Resident File 203 staff file 204 Terminal number management file 205 CPU 206 Communication control unit