JPH11238010A - Management device/method for data base and recording medium recording the method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To synchronize the change of a password with the change of user data and to execute a change processing. SOLUTION: The device is constituted of a management server 1 and a client computer 2 managed by the management server 1. A data base 3 which the management server 1 manages can be updated based on the passwords allocated to the client computers 2. The client computer 2 is provided with a temporary management file 21 writing the new/old passwords at the time of changing the password and a means 22 sending new/old password data of the file to the management server 1. The management server 1 is provided with a means 11 receiving data of the temporary management file 21 from the client computer 2, a means 12 registering new/old password data in the data base and a data update means 13 which collectively and simultaneously updates the password and user data based on the new/old password.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an apparatus and method for managing a database and a recording medium on which the method is recorded, and more particularly to an apparatus for managing a database in which user data is updated in synchronization with a password change. And how to do it.

[0002]

2. Description of the Related Art A conventional database management device is configured so that a password change is made immediately upon receiving a password change. Therefore, the password change and the user data change must be synchronized. In such a case, there is a disadvantage that data cannot be changed in synchronization with the password change.

[0003]

SUMMARY OF THE INVENTION An object of the present invention is to improve the above-mentioned drawbacks of the prior art, and in particular, to provide a new database in which a change process is performed by synchronizing a password change and a user data change. An object of the present invention is to provide a management device, a method thereof, and a recording medium on which the method is recorded.

[0004]

SUMMARY OF THE INVENTION The present invention basically employs the following technical configuration to achieve the above object. That is, the first aspect of the database management device according to the present invention comprises a management server and client computers managed by the management server, and manages a database managed by the management server based on a password assigned to each client computer. In the database management device that enables updating, the client computer includes, when changing the password, a temporary management file in which new and old passwords are written, and means for transferring new and old password data of the file to the management server. And the management server includes:
Means for receiving the data of the temporary management file from the client computer, means for registering the new and old password data in a database, and means for updating data for simultaneously updating a password and user data simultaneously based on the new and old passwords In a second aspect, the management server comprises:
After the updating means simultaneously updates the password and the user data simultaneously, the management server updates the data based on the changed new password. In an aspect, the batch update processing of the data performed by the update unit is a batch process.

A first aspect of the database management method according to the present invention comprises a management server and client computers managed by the management server. The management server manages the database based on a password assigned to each client computer. In the database management method in which the database is updated, the client computer includes a temporary management file for writing new and old passwords, and when the user changes the password, writes the new and old password data to the file,
The new and old passwords are transferred to the management server, and the management server receives the old and new passwords written in the temporary management file from the client computer, and registers the new and old password data in the database, The password and the user data are updated simultaneously and collectively based on the new and old passwords.
After the management server performs batch update processing of data based on the new and old passwords, the management server updates data based on the changed new password.

A first aspect of the recording medium according to the present invention is as follows.
A recording medium comprising a management server and client computers managed by the management server, and recording a database management program for updating a database managed by the management server based on a password assigned to each client computer, A first step of receiving, from the client computer, data of a temporary management file in which the client computer writes the new and old passwords created when the password is changed, and writes the received new and old passwords in the management server; A second step of reading the temporary management file and registering a new password in the database, and following the request of the client computer to update the data in the database, the management server
And a third step of collectively updating passwords and user data simultaneously based on the new and old passwords; and a step of recording the steps in order to cause a computer to execute a series of processing. ,
In a second aspect, after the management server performs batch update processing of data based on the new and old passwords, the management server performs a fourth step of performing data update processing based on the changed new password. It is characterized by including.

[0007]

DESCRIPTION OF THE PREFERRED EMBODIMENTS A database management apparatus according to the present invention comprises a management server and client computers managed by the management server, and is managed by the management server based on a password assigned to each client computer. In the database management device configured to update the database, the client computer includes a temporary management file for writing new and old passwords, and when the user changes the password, writes the new and old password data to the file and writes the new and old password data to the file. The new and old passwords are transferred to the management server, and the management server receives the old and new passwords written in the temporary management file from the client computer, and registers the new and old password data in the database. Since collectively the password and the data based on the old and new password is obtained by adapted to update at the same time, the user data is changed in synchronization with the change of the password.

[0008]

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a block diagram showing an embodiment of a database management apparatus and method according to the present invention; FIG. 1 is a diagram showing a structure and a flow of a specific example of a database management device according to the present invention, FIG. 2 is a flowchart showing a flow of password change in a client computer, and FIG. 3 is a functional block of the present invention. In these figures, a database 3 which includes a management server 1 and client computers 2 managed by the management server 1 and is managed by the management server 1 based on a password assigned to each client computer 2 is shown. In the database management device that enables updating of the password, the client computer 2 transfers a temporary management file 21 in which new and old passwords are written when the password is changed, and transfers the new and old password data of this file to the management server 1. Means 22 for performing the temporary management in the management server 1. Means 11 for receiving the data of the application file 21 from the client computer 2, means 12 for registering the new and old password data in a database, and updating of data for simultaneously updating a password and user data simultaneously based on the new and old passwords Means 13 when the client computer 2 updates the data in the database 3, the updating means 13 in the management server 1 updates the password and the data simultaneously based on the new and old passwords. Are shown.

Next, the present invention will be described in detail. FIG.
FIG. 9 is a flowchart showing a password change routine in the client computer 2. When a user changes a password, first, when the user inputs a current password, the client computer 2 checks whether the password is an already registered password. It is checked whether or not it is (steps S1 to S3).

Here, when the formal password is input, the client computer 2 requests that a new password be input twice (steps S4 and S5).
At this time, if the password entered twice is the same password, the client computer 2 determines that the new password has been determined, writes the old and new passwords in the temporary management file 21, and writes this file 21 to the management server 1. Transfer (steps S6, S7).

When the management server 1 receives the data of the temporary management file 21 in which the new and old passwords are written from the client computer 2, it reads the temporary management file 21 in which the new and old passwords are written (step S8). After collating the old and new passwords (step S9), the new password is stored in the database 3
(Step S10), and transfers the registered new password to the client computer 2 (steps S11, S12, S13, S14).

After that, in response to a request for updating data in the database 3 of the client computer 2, the management server 1
Performs batch processing of passwords and data based on new and old passwords, and updates them collectively and simultaneously. As described above, in the present invention, the password change and the data update process are configured to be changed in synchronization with each other, so that the data can be managed more reliably.

The present invention may be configured as a recording medium on which the above-mentioned database management program is recorded. In this case, at least the temporary management file 2 in which the client computer 2 writes the new and old passwords created when the password is changed is written in the recording medium.
A first step in which the management server 1 receives the first data from the client computer 2, a second step of reading the temporary management file 21 in which the received new and old passwords are written, and registering the new password in the database 3; And a third step in which the management server 1 updates a password and data simultaneously based on the new and old passwords in accordance with a request for updating the database 3 of the client computer 2. Is desirable.

[0014]

As described above, the database management apparatus according to the present invention is configured as described above, so that user data can be updated in synchronization with a password change, and data management can be performed more reliably.

[Brief description of the drawings]

FIG. 1 is a diagram showing a flow of password management of a database management device according to the present invention.

FIG. 2 is a flowchart showing a flow of a password change process of a client computer.

FIG. 3 is a functional block diagram of the present invention.

[Explanation of symbols]

REFERENCE SIGNS LIST 1 management server 2 client computer 3 database 11 means for receiving files from client computer 12 means for registering new and old password data in database 13 data updating means for simultaneously updating password and user data simultaneously 21 file for temporary management 22 Means for sending old and new password data to the management server

──────────────────────────────────────────────────の Continued on the front page (51) Int.Cl. ⁶ Identification code FIG06F 15/40 320B 15/401 340A

Claims (7)

[Claims] 1. A database management apparatus comprising a management server and a client computer managed by the management server, wherein a database managed by the management server can be updated based on a password assigned to each client computer. The client computer is provided with a temporary management file in which new and old passwords are written when the password is changed, and means for transferring the new and old password data of this file to the management server. Means for receiving data of a file for use from the client computer;
A database management device comprising: means for registering the new and old password data in a database; and data updating means for simultaneously updating a password and user data simultaneously based on the new and old passwords. 2. The management server is characterized in that, after the updating means simultaneously updates the password and the user data collectively, the management server updates the data based on the changed new password. The database management device according to claim 1, wherein: 3. The database management device according to claim 1, wherein the batch update process of the data performed by the update unit is a batch process. 4. A database management method comprising a management server and client computers managed by the management server, wherein a database managed by the management server is updated based on a password assigned to each client computer. The client computer includes a temporary management file for writing new and old passwords, and when a user changes a password, writes new and old password data in the file and transfers the new and old passwords to the management server. Receiving the old and new passwords written in the temporary management file from the client computer, registering the old and new password data in the database, and then entering the password and user data based on the new and old passwords. Managing a database, characterized in that was collected as collectively to update simultaneously. 5. The management server updates data based on the changed new password after the management server performs batch update processing of data based on the new and old passwords. How to manage the database. 6. A recording system comprising a management server and client computers managed by the management server, and recording a database management program for updating a database managed by the management server based on a password assigned to each client computer. Medium, the management server, wherein the client computer receives, from the client computer, data of a temporary management file in which new and old passwords created when the password is changed are written; A second step of reading the temporary management file in which the new and old passwords are written and registering the new password in the database; and in response to a request to update data in the database of the client computer, the management server A third step and a recording medium characterized by recording the steps for executing the series of processes consisting of capital on the computer at the same time updating process collectively the password and user data based on the old and new password. 7. A fourth step of, after the management server performs a batch update process of data based on the new and old passwords, performing a data update process based on the changed new password. The recording medium according to claim 6, wherein: