WO2002069190A1

WO2002069190A1 - Database system

Info

Publication number: WO2002069190A1
Application number: PCT/JP2001/001567
Authority: WO
Inventors: Yukio Kawakami
Original assignee: Digitcom Inc.
Priority date: 2001-02-28
Filing date: 2001-02-28
Publication date: 2002-09-06

Abstract

A database system for quickly searching for and retrieving information concerning a specific individual excellent in security and maintenability, characterized in that the database system (1) is constructed for each individual, an individual database (11) where information concerning each individual is stored has a registered first server (10), and a client can retrieve information concerning an individual stored in the individual database (11) through a client terminal capable of accessing the first server (10).

Description

Description Database System Technical Field

The present invention relates to a data base system provided with a data base in which information on individuals is stored and stored. Background art

As shown in Fig. 8, conventional data management has a tabular table for specific items (personal information, financial information, administrative information, inspection information, etc.), and the table contains information on each individual. (For example, in the case of the database 100a, the ID number, name, gender, birthday, etc.) are often stored in the database.

In other words, the conventional database is a form in which information about multiple individuals is stored in one table for a specific item, and information about multiple individuals is collected and organized in one database. It will be stored. In addition, the tables in each database are related by an ID number assigned to each individual (in this sense, each database is called a relational database (RDB)). When extracting information about an individual, the relational database 100a to 100d was searched using the ID number assigned to the specific individual as a key, and stored in a table relating to the desired item. It is possible to extract information. However, in conventional data management based on relational data, when extracting information about a specific individual, it is necessary to search among multiple relational databases using ID numbers as keys. However, there is a problem that it takes time and effort. In addition, even if the location of a relational database having a table for a desired item is clear, it is not possible to extract information about a specific individual. In this method, personal information of another person stored in the same table is searched, which takes time and has problems in security.

In addition, if a failure occurs, such as when a table is accidentally erased, for one relational database, information on all individuals stored in the table must be collected and rearranged. This is extremely troublesome, especially when information about each individual before accumulation is scattered in various places. Also, in the event of a failure such as the information about a specific individual being erased by mistake, or when it becomes necessary to modify the information about a specific individual, the information on all the individuals stored in the same table is There is a problem that the information may be affected and the maintainability is poor.

The problem described above is especially useful for extracting information (inspection data, credit data, etc.) of individuals scattered around the country, such as the medical and financial industries, in a form that is summarized for each individual. It can be said that improvement is desired in various industries.

The present invention has been made in order to solve the problems of the related art, and provides a data base system that can quickly search and extract information on a specific individual and has excellent security and maintainability. The task is to Disclosure of the invention

In order to solve the above-mentioned problems, the present invention comprises a first server, which is constructed for each individual, and in which a personal database in which information on each individual is stored and stored is registered, and which accesses the first server. It is an object of the present invention to provide a database system characterized in that it is possible to obtain information on an individual stored in each of the personal databases through a client terminal for obtaining the information.

According to such an invention, since a personal database is provided for each individual and information about each individual is stored and stored, information on a specific individual can be quickly searched through a client terminal. Can be extracted. Also, since the database is built for each individual, when searching for and extracting information about a specific individual, There is no need to search for personal information, and it is excellent in security and provides a maintainable database system without affecting the personal information of others in the event of any failure. Note that the term “first server” does not mean only a single physical server, but refers to a case in which a personal database is registered in each server and is physically composed of multiple servers. The server is also used as a generic term.

Preferably, the database system according to the present invention further comprises: a second server in which an index database in which position information of a place where each of the personal databases is stored is registered, and wherein each of the personal data bases is registered. Is assigned an ID number, and the second server determines, from the index database, a location where the personal database corresponding to the ID number is located, based on the ID number input through the client terminal. It is configured to search for position information and present it to the client terminal.

According to the invention, by inputting the ID number to the second server through the client terminal, the location information (for example, the IP address) of the place where the personal database corresponding to the ID number is located is indexed overnight. Since it is retrieved from the web site and presented to the client terminal, it is possible to easily access the desired personal database using the ID number as a key. Even if each personal database is distributed and registered on a plurality of different servers, it can be easily accessed as long as the ID number is known, as described above. This has the advantage that damage can be suppressed even if a failure occurs in the server that registers the service itself. It should be noted that the ID number can be entered each time through a keyboard or the like provided in the client terminal, or the ID number can be stored in the IC card, and the ID number stored in the IC card can be read by the client terminal. Alternatively, the correspondence between the fingerprint and the ID number may be stored in the client terminal in advance, and the fingerprint may be read by the fingerprint reader included in the terminal, and the corresponding ID number may be read. It is also possible to adopt a configuration in which the number is input to the second server. Note that, similarly to the first server, the term “second server” does not mean only a single physical server, but includes a plurality of physical servers in which an index database is registered in each server. The plurality of servers when configured are also used as a generic term. In addition to the case where the first server and the second server are constituted by physically separate servers, they may be constituted by physically the same server.

Preferably, in the database system according to the present invention, position information of a location where a backup file corresponding to each personal database is located, and an ID number assigned to each personal database are stored and stored. A third server in which a database is registered, wherein the third server is configured to perform a backup corresponding to the ID number from the backup database based on the ID number input through the client terminal. It is configured to search for the file location information, read the backup file located at the location, and restore the personal database using the read backup file.

According to the invention, by inputting the ID number to the third server through the client terminal, the location information of the backup file of the personal database corresponding to the ID number is retrieved from the backup database, and The packed application file is read out and the personal database is restored. Therefore, in the event of a failure such as storing erroneous information in the personal database or erasing the information, it can be easily restored, and the data base can be easily maintained. System is provided. In addition, the backup database stores the location information of the location where the backup file is located, and reads out the corresponding backup file using the ID number as a clue, so each backup file can be transferred to multiple different servers. It can be distributed and registered, and even if the hardware itself that registers backup files, such as a server, fails, damage can be suppressed. In addition, separate backup files for each personal database Because of this, there is no need to search for personal information stored in a backup file of another person when restoring a personal database for a specific individual, which is advantageous in terms of security. Note that, like the first and second servers, the term “third server” does not mean only a single physical server, but a plurality of physical servers in each of which a backup database is registered. In the case where it is composed of servers, it is also used as a generic term for the plurality of servers. In addition, the third server, the first server and the second server may be constituted by physically the same server, in addition to being constituted by physically separate servers.

More preferably, in the backup database, basic information on an individual stored and stored in each of the personal databases is stored and stored in association with an ID number assigned to each of the personal databases. The third server retrieves an ID number corresponding to the basic information from the backup database based on the basic information on the individual input through the client terminal, transmits the ID number to the second server, The second server is configured to search, based on the transmitted ID number, position information of a location where a personal database corresponding to the ID number is located from the index database, and present it to the client terminal.

According to such an invention, even when the ID number is unknown due to forgetting, etc., it is possible to input basic information (name, date of birth, gender, address, etc.) about the individual to the third server. Then, the ID number is searched, and the location information where the personal data base corresponding to the ID number is located is presented to the client terminal. Therefore, in the case where the ID number is key-inputted on the keyboard of the client terminal each time, even if the ID number is unknown, it can be searched based on the basic information, and the convenience is improved. An excellent system is provided. BRIEF DESCRIPTION OF THE FIGURES

FIG. 1 is an explanatory diagram showing an outline of a data base system according to an embodiment of the present invention. is there.

FIG. 2 is a flowchart showing an outline of a processing procedure when a new personal database is generated.

Fig. 3 is a flowchart showing the outline of the processing procedure when creating a personal database using an existing relational database.

FIG. 4 is a flowchart showing an outline of a processing procedure when acquiring personal information from a personal database.

FIG. 5 is a flowchart showing an outline of a processing procedure for accessing the personal data base when the ID number is unknown.

Figure 6 is a flowchart outlining the procedure for backing up a personal database.

FIG. 7 is a flowchart showing an outline of a processing procedure when restoring a personal database.

FIG. 8 is an explanatory diagram for explaining a conventional management method using a database. BEST MODE FOR CARRYING OUT THE INVENTION

Hereinafter, an embodiment of the present invention will be described with reference to the accompanying drawings.

FIG. 1 is an explanatory diagram showing an outline of a data base system according to an embodiment of the present invention. As shown in FIG. 1, a database system 1 according to the present embodiment includes a first server 10 in which a plurality of personal databases (personal DBs) 11 are registered, an index server (index DB) 2 1 and a second server 20 in which a backup database (BKDB) 22 is registered. Each of the servers 10 and 20 is connected by a telecommunication line such as the Internet, and It is possible to send and receive data at any time. The first server 10 and the second server 20 can be accessed through a client terminal (not shown) such as a personal computer or a mobile phone. The personal database 11 registered in the first server 10 is constructed for each individual. That is, information on each individual is stored and stored in a form stored in a table for specific items (in the example of FIG. 1, basic information, medical information, and financial information). Such information stored and stored in the personal database 11 can be obtained through the client terminal that has accessed the first server 10. Each personal database 11 is given an ID number (such as “; ipaa001” in the example of FIG. 1) so that it can be distinguished from other personal databases 11. The number is the name of each personal database 11.

The index database 21 registered in the second server 20 has an ID number, location information (IP address) of the location where each personal data base 11 corresponding to the ID number is located, and Are stored in a table format. The second server 20 retrieves the IP address of the personal database 11 corresponding to the ID number from the index database 21 based on the ID number input through the client terminal, and sends the IP address to the client terminal. It is configured to present. When the number of personal databases 11 increases and a large number of index data bases 21 are provided in response to this, the index database 21 is made to have a tree structure, and each index data base 21 belongs to a higher order. It is also possible to further provide a table indicating the position information of the index database (the upper index database is provided with a table indicating the position information of the lower index database 21 belonging to the database). . In the case of such a tree structure, when the IP address of the personal database 11 corresponding to the ID number does not exist in the lower index database 21, via the upper index database to which the lower index database 21 belongs, It will search in the other lower index database 21.

The backup database 22 registered in the second server 20 has the location information (URL) of the location where the backup file 23 corresponding to each personal database 11 is located and the backup database 22 assigned to each personal database 11. The ID number is stored. The second server 20 performs a backup based on the ID number entered through the client terminal. Backup database 2 2 corresponding to the ID number

It is configured to search for the URL, read the location 3 to the URL, and restore the personal data by the backup file 23. In addition, as shown in FIG.

The file 23 is stored in the second server 20 in the same manner as the backup database 22.

In the backup database 22, basic information (name, date of birth, gender, address, etc.) on individuals stored and stored in each personal database 11 was assigned to each personal database 11. It is stored and stored in association with the ID number. The second server 20 retrieves an ID number corresponding to the basic information from the knock-down database 22 based on the basic information input through the client terminal. Further, the second server searches the index database 21 for the IP address of the location where the personal database 11 corresponding to the ID number is located based on the searched ID number, and presents it to the client terminal. It is configured to be.

The database system 1 according to the present embodiment has the configuration described above, but the present invention is not limited to this, and various changes can be made. That is, in this embodiment, each personal device 11 is registered in the single first server 10, but it is needless to say that the personal data 11 is distributed and registered in a plurality of different servers. It is possible, and in consideration of maintainability in the event of a server failure, distributed registration is preferable. Similarly, in the present embodiment, the index database 21 and the backup database 22 are registered in the single second server 20. Of course, the index database 21 and the backup database 22 are registered in separate servers, and the Can be connected to each other by a telecommunication line so that transmission and reception can be performed overnight. Further, a plurality of index de - when evening provided a base ₂ 1, each index database 2 1 may be registered on a separate server, respectively. Further, the Zokup file 23 can be distributed and registered on a server separate from the second server 20. Hereinafter, the processing content in the database system 1 having the above configuration will be described in detail with reference to FIGS.

(1) New generation of personal database

First, a procedure for generating the personal data base 11 registered in the first superuser 10 will be described. FIG. 2 is a flowchart showing an outline of a processing procedure when a new personal database 11 is generated. The user of the system 1 who wants to register personal information first accesses the first server 10 and inputs basic information (name, date of birth, gender, address, etc.) about the individual through the client terminal. The input basic information is transmitted to the second server 20 and a search is made from the backup database 22 as to whether or not there is any information corresponding to the transmitted basic information (step 100). ). Here, if there is already a corresponding personal database, generation of a new personal database 11 is not permitted, and the process ends. On the other hand, if it does not exist, the fact is transmitted from the second server 20 to the first server 10, and the first server 10 stores a personal database 11 having a predetermined ID number as a name. And the basic information is stored and stored in the personal database 11 (step 101). In addition, the second server 20 adds the ID number of the generated personal database 11 and the location information (IP address) of the location to the index database 21 so as to store and store the data (step). Step 102). Further, the generated personal data base 11 is automatically backed up and stored in the second server 20 as a backup file 23 (step 103). Information on individuals other than basic information (medical information, financial information, etc.) can be input from the client terminal when the personal database 11 is generated (step 101) as necessary. Personal database with basic information

1 Stored in 1

(2) Generating a personal database using an existing relational database Figure 3 shows the processing procedure for generating a personal database 11 using an existing relational database (indicated by reference numeral 3 in Figure 1). Is a flowchart showing an outline of You. In such a case, as in the case of the new generation described with reference to FIG. 2, the user of the present system 1 who desires to register personal information first accesses the first server 10 and then transmits the personal information through the client terminal. Enter basic information about The input basic information is transmitted to the second server 20 and the backup data base 22 is searched to determine whether or not the transmitted basic information is present (step 11). 0). Here, if there is a corresponding one, the second server 20 locates the personal database 11 corresponding to the ID number from the index database 21 based on the ID number corresponding to the basic information. Search for the IP address of the location to be used and present it to the client terminal. The user may access the personal database 11 having the IP address presented to the client terminal, fetch necessary information from the existing relational database 3 and additionally store it ( Step 1 1 1).

On the other hand, if there is no information corresponding to the transmitted basic information, the fact is transmitted from the second server 20 to the first server 10, and the first server 10 transmits a predetermined ID number A personal data base 11 as a name is generated at a predetermined place, and the personal information is stored in the personal data base 11 (step 112). In addition, the user is configured to access the personal database 11 through the client terminal, and to acquire and store necessary information from the existing relational database 3 (step 112). Further, the second server 20 additionally stores the ID number and the location information (IP address) of the generated personal database 11 in the index database 21 (step 1). 13 ) . Further, the generated personal database 11 is automatically backed up and stored in the second server 20 as a backup file 23 (step 114). As described above, it is possible to generate a personal data base 11 by effectively using the existing relational database 3.

(3) Acquisition of information from personal database

Next, the individual stored in the personal database 11 generated as described above The procedure for acquiring information will be described. FIG. 4 is a flowchart showing an outline of a processing procedure when acquiring personal information from the personal database 11. The user of the system 1 who wants to obtain personal information first accesses the second server 20 and inputs an ID number corresponding to a predetermined personal database 11 through a client terminal. As a result, the second server 20 searches the index database 21 for the location information of the location where the personal database 11 corresponding to the input ID number is located (step 120), and Is presented to the client terminal (step 1 2 1). Therefore, the user can access the personal database 11 based on the presented location information and acquire the stored personal information (step 122). Note that the ID number can be entered each time through a key board or the like provided in the client terminal, or the ID number can be stored in the IC card, and the ID number stored in the IC card can be stored by the client terminal. The configuration may be such that the fingerprint is read, or the correspondence between the fingerprint and the ID number may be stored in the client terminal in advance, and the fingerprint may be read by the fingerprint reader included in the terminal.

(4) Access to personal database with unknown ID number

Next, a procedure for accessing the personal database 11 when the ID number is unknown is described. FIG. 5 is a flowchart showing an outline of a processing procedure for accessing the personal database 11 in such a case. If the ID number is unknown, the user of the system 1 accesses the second server 20 through the client terminal and searches for the ID number to obtain basic information on the individual (name, date of birth, gender, address, etc.). Etc.) (Step 130). As a result, the second server 20 searches the backup database 22 for the ID number corresponding to the input basic information, and retrieves the location information (IP address) of the location where the personal database 11 corresponding to the ID number is located. The address is retrieved from the index database 21 and presented to the client terminal (step 13 1). Therefore, the user can access the personal database 11 based on the presented location information and acquire the stored personal information. (5) Backup of personal database

Next, a procedure for backing up the personal database 11 will be described. FIG. 6 is a flowchart showing an outline of a processing procedure when the personal database 11 is backed up. When backing up the personal database 11, first access the first server 10 through a client terminal and select the ID number of the personal database 11 desired to be backed up. The first server 10 generates a backup file 23 based on the selected personal database 11 (step 140), and transmits the backup file 23 to the second server 20 (step 141). The second server 20 searches whether or not the ID number corresponding to the transmitted backup file 23 already exists in the backup database 22 (Step 142). Here, if the ID number exists, the second server 20 saves the backup file 23 corresponding to the ID number and located at a predetermined location (URL) under another name (step 143). The transmitted backup file 23 is stored in the URL (step 145).

On the other hand, ID number corresponding to the backup file 23 sent backup data - if that does not exist in the base ₂ 2, the second server 20, predetermined location determined in advance in order to save the Pakkuatsu flop file 23 transmitted After storing the location information (URL) and the ID number in the backup database 22 (step 144), the transmitted backup file 23 is stored in the URL (step 145). As described above, the personal database 11 is backed up. The personal database 11 is automatically backed up when the personal database 11 described with reference to FIGS. 2 and 3 is generated, but the processing procedure in this case should be backed up. The personal database 11 is the same as the above except that the user does not need to select it because it has been determined.

(6) Restore personal database (restore)

Finally, a procedure for restoring the personal database 11 will be described. Figure 7 shows an individual 9 is a flowchart illustrating an outline of a processing procedure when restoring a database ii. When restoring the personal database 11, the user of the system 1 must use the second server

Access 20 and enter the ID number corresponding to the predetermined personal database 11 that you want to restore through the client terminal. The second server 20 is entered

The backup file 23 corresponding to the ID number is searched from the backup file 22 for the URL of the backup file 23, the backup file 23 located at the URL is read, and the personal database 11 is restored using the read backup file 23. (Step 150). The personal database 1 1 restored will be registered in the IP address corresponding to the ID number stored stored in the index database ₂ 1.

As described above, according to the database system according to the present invention, since a personal database constructed for each individual and storing information on each individual is provided, information on a specific individual is provided through a client terminal. Can be searched and extracted quickly. In addition, since the database is constructed for each individual, it is not necessary to search for personal information of other people when searching and extracting information about a specific individual, which is excellent in security and causes some troubles. In this case as well, it has an excellent effect of providing a database system with good maintainability without affecting the personal information of others.

Claims

The scope of the claims

1. A first server is provided for each individual, and has a first server in which personal data is stored in which information on the individual is stored and stored.

A database system, wherein information on an individual stored and stored in each of the personal databases can be obtained through a client terminal capable of accessing the first server.

2. It further comprises a second server in which an index database storing location information of a place where each of the personal databases is stored is registered,

Each personal database has an ID number,

The second server searches the index database for location information of a location where a personal database corresponding to the ID number is located, based on the ID number input through the client terminal, and presents the location information to the client terminal. 2. The database system according to claim 1, wherein:

3. A third server in which a backup database storing the location information of the location of the backup file corresponding to each personal database and the ID number assigned to each personal database is registered. Further comprising

The third server retrieves the location information of the backup file corresponding to the ID number from the packed update base based on the ID number input through the client terminal, and reads the backup file located at the location. 3. The database system according to claim 1, wherein the personal database is restored using the read backup file.

4. In the backup database, basic information on an individual stored and stored in each of the personal databases is stored and stored in association with the ID number assigned to each of the personal databases.

The third server is a server for personal information input through the client terminal. Based on the information, an ID number corresponding to the basic information is searched from the backup database and transmitted to the second server,

The second server searches the index database for location information of a location where a personal database corresponding to the ID number is located based on the transmitted ID number, and presents the location information to the client terminal. 4. The data base system according to claim 3, wherein: