JP2000348035A - Database search system, database search method, and storage medium - Google Patents

Abstract

(57) [Summary] [Problem] To enable a user to search for data at his own site or another site without being conscious of the location where the data is recorded. The database search system includes a host computer having a database, and a plurality of D connected to the host computer via a network.
B servers 11, 12,... 19 and DB server 11
And a search terminal 51 connected through the search terminal 41. By specifying a site search mode on a search key input screen of the search terminal 51, information on the own site or another site is automatically searched. .

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database search system, a database search method, and a storage medium for efficiently searching, for example, data from a plurality of sites.

[0002]

2. Description of the Related Art Generally, there is a business of accepting an application of an applicant and issuing a permit or an ID card. To maintain the convenience of applicants, work at branch offices (sites) established in each prefecture. Also, in order to manage the data distributed for each prefecture as a whole, the entire data is managed by a host computer, and control is performed so as not to duplicate the data at a plurality of sites.

[0003] When an applicant loses or loses a permit or ID card, the applicant submits a request to the nearest site and receives a reissue. Acceptance of re-issuance is often performed at a site (branch) set for example in each prefecture according to the applicant's address.
In that case, in order to prevent spoofing, identity verification is performed by referring to the photo and signature attached to the original application form. Create a database on the computer to manage the vast amount of past application forms, record and manage the applicant's code information, application form image, signature image, and applicant's photo image, and search them when reissuing. Such an application management system has been put to practical use.

[0004]

However, the conventional application management system has the following problems. First, if the applicant relocates to a site other than the one where the application was made due to moving, etc., there is no original data at the site where the re-grant was applied. I have to ask. In this case, there is a problem that it takes time in addition to manual intervention.

Second, since data management methods and image / image file formats are different for each site, simply connecting a line does not mean that other sites can be searched.

Third, when there is out-of-date data at the own site, old data must be used in consideration of the trouble of requesting to another site.

[0007] Fourth, when there is data at another site,
When the host stopped or data was lost from the host due to maintenance or the like, it was not possible to find the data at any other site, and it was impossible to search even in an emergency.

The present invention has been made to solve such a problem, and allows a user to search for data at his own site or another site without being conscious of the location where the data is recorded. Another object of the present invention is to provide a database search system, a database search method, and a storage medium that can search for data at another site without human intervention, thereby reducing the labor and time required for manual intervention.

[0009]

According to a first aspect of the present invention, there is provided a database search system comprising: a plurality of database servers connected via a line network; A search terminal connected to at least one of the search terminals, wherein the search terminal specifies whether to search from a database server to which the search terminal is connected or to search another database server. Search mode specifying means, input means for inputting search target information for each search item, and search key information input from the input means according to the search mode specified by the search mode specifying means. Means for sequentially or simultaneously searching the plurality of database servers.

According to a second aspect of the present invention, there is provided a database search system comprising: a plurality of database servers connected via a network; a host computer for managing the plurality of database servers; and at least one of the plurality of database servers. A database search system having a search terminal connected to one, wherein the search terminal specifies whether to search from a connected database server or another database server. Means, input means for inputting search target information for each search item, and, according to a search mode specified by the search mode specifying means, the search target information input from the input means as a search key, Search multiple database servers and host computers sequentially or all at once It is characterized by comprising a stage.

According to a third aspect of the present invention, there is provided a database search method for searching a database of the database server from a search terminal connected to a plurality of database servers connected via a network. Specify whether to search from the database server to which the search terminal is connected or to search for another database server, enter the information to be searched for each search item, and enter the information according to the specified search mode. Using the information to be searched as a search key, the plurality of database servers are searched sequentially or all at once.

According to a fourth aspect of the present invention, there is provided a storage medium storing a computer readable program for operating a computer connected to a database server, the computer displaying a search input screen. The search input screen specifies whether to search from the database server to which the computer is connected or to search for another database server connected via the network, and to search information for each search item. By inputting, a program for sequentially or simultaneously searching the database server is stored using the input search target information as a search key in accordance with a specified search mode.

According to the present invention, search mode designating means for designating whether to search from a database server connected to a computer or another database server connected via a line network is provided. By inputting the search target information, the user can search multiple database servers in order or all at once using the input search target information as a search key according to the specified search mode. You can search for data on your own site or on other sites without having to be aware of where it is being done. In addition, since data on another site can be searched without human intervention, labor and time for manual intervention can be reduced.

Specifically, a database server (hereinafter referred to as a DB server) at its own site to which a search terminal or a computer on which a search program is installed is connected, a host computer having a database, a DB server at another site, etc. A database search system is constructed by connecting via a network.

The DB server of the own site records and manages the certificate number, first and last name, date of birth, gender, transfer flag, and face image. The transfer flag indicates that the recorded application data has been registered or updated at another site after registration. The database of the host computer manages the certificate number, first and last name, date of birth, gender, and DB server code. The DB server code indicates a site where the application data is recorded and managed. The database of the DB server of the other site records and manages the certificate number, first and last name, date of birth, gender, transfer flag, and face image in the same manner as the DB server of the own site. Further, each DB server has a site information data table and a search protocol pattern data table.
A DB server code, a DB server name, a server address, and the like are managed, and a search protocol pattern data table manages a search protocol pattern, a face image image file format, and the like. By setting a search protocol pattern and a face image file format for each of the other sites to be searched, it is possible to support various types of DB servers.

On the search key input screen, the certificate number, first and last name, date of birth, and gender of the application to be searched are specified. The other site search mode sets whether or not to search for another site when searching. On the search applicable candidate list screen, the searched candidates are displayed in a list, and a candidate display is selected to perform a detailed display. On the detail display screen, all the information managed and recorded such as the applicant information and the face image are displayed on the screen.

As a search mode designating means for designating a search mode and an input means for inputting information to be searched for each search item, for example, a search key input screen or the like is displayed on a search terminal. Input and search the site DB server. This search result,
When there is the corresponding data and there is one or more data whose transfer flag of the corresponding data is “0”, a search applicable candidate list screen is displayed or detailed display is performed. If there is no corresponding data with the transfer flag “0” in the own site DB server search, the host computer is searched. If there is a corresponding data, the corresponding data is recorded in the DB server database. The address of the other site, the search protocol pattern, and the face image file format are obtained, and the search of the other site is performed using a search message matching the communication protocol pattern and the file format. Then, if there is a search applicable candidate in another site, the search applicable candidate list screen is displayed. If there is no match in the host computer search and other site search, search for other sites by simultaneous broadcast.

[0018]

Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a diagram showing one embodiment of a database search system according to the present invention.

As shown in FIG. 1, the database search system comprises a host computer 2 having a database 1 and a plurality of database servers 11, 12,... 19 connected to the host computer 2 via a network 3.
(Hereinafter referred to as DB servers 11, 12, ... 19) and each DB
It comprises a search terminal 51 connected to the server 11 via a network such as a LAN 41. In addition, DB
A search terminal is also connected to each of the DB servers 12... 19 other than the server 11, but illustration thereof is omitted here. Each of the DB servers 11, 12,... 19 has a database 21, 22,.
9 is connected. Note that each of the DB servers 11, 12,...
19 also have their own data tables inside.

The host computer 2 is a computer that records and manages summary data of all the information of the applicant recorded in all the sites and a storage site name.

In this embodiment, the database 2
Each of the DB servers 11, 12,... 19 including 1, 22,..., 29 is referred to as a site, and it is assumed that a plurality of sites store data of inhabitants in organizational units, for example, in municipalities. When a person submits a transfer or transfer notification (application) to the government office that manages each site and confirms and receives it at the government office, the staff of the government office searches for data at each site, If there is no deficiency, the application data shall be entered and registered.

Also, in this embodiment, it is assumed that a search operation is performed from the search terminal 51, and the site (the DB server 11 and the database 21) to which the search terminal 51 is connected is the own site, and the site other than this site. Is called another site.

The DB server 11 is a computer that receives a search from its own site, and records and stores applicant information and a face image. The search terminal 51 is a computer for inputting search keys and displaying search results, and includes a keyboard,
It has input / output means such as a mouse, monitor, and printer, storage means such as a hard disk drive and memory, storage medium reading and writing means such as a floppy disk drive, control means such as a CPU, and communication means such as a LAN card. . The LAN card connects the DB server 11 and the LAN. An operating system (OS) and database search software operating under the OS environment are installed in the hard disk device of the search terminal 51. A data table of site information, a data table of a search protocol pattern, and the like are set in the hard disk devices of the DB servers 11, 12,...

DB servers 12... 19 at other sites
It is a computer having the same function as the DB server 11, and is installed and managed in an organization in a different region from the DB server 11. In this embodiment, the DB of another site is used.
Although there are two servers 12... 19 (computers), there are usually several tens. The network 3 is a communication network such as a public network, a frame relay network, a packet switching network, etc., and can be connected to each other. When the search terminal 51 searches the host computer 2 or another site, the DB server 1 of the own site is used.
1 is performed.

FIG. 2 is a diagram showing an example of information (contents) recorded and stored in the database 21 of the DB server 11 of the own site. As shown in FIG.
Has the number of application data managed by the own site. For each application data, data such as certificate number, first and last name, date of birth, gender, transfer flag, and face image are recorded.

The certificate number is the issued number of the applied permit or ID, and is used as a unique key. The transfer flag is a flag indicating that the recorded application data has been registered or updated at another site after registration. If the transfer flag is "1", there is new data updated at another site. Is shown. Whether it has been updated on other sites,
It can be determined by obtaining information updated at another site via the host computer 2. In addition to the data to be managed, an address, a kanji name, a registration date, a registration number, and the like may be added.

FIG. 3 is a diagram showing an example of information registered and stored in the database 1 of the host computer 2. As shown in the figure, the database 1 has the number of application data managed in all sites. Certificate number, first and last name, date of birth, gender and D per application data
The B server code is associated and managed. DB
The server code indicates a site where the application data is recorded and managed. At each site, the registered data is notified to the host computer 2, and if new, the data is added to the host computer 2, and if it is existing data, the site information is updated.

FIG. 4 is a diagram showing an example of information registered and stored in databases 22... 29 of DB servers 12. As shown in FIG.
The database 22 of the server 12 has the number of application data managed by the site. DB server 11
Similarly to the above, data such as a certificate number, first and last name, date of birth, gender, transfer flag, and face image are recorded for each application data. As data to be managed, an address, a kanji name, a registration date, a registration number, and the like may be added. In addition, the database layout does not necessarily need to match each site, and it is sufficient that necessary information is registered.

FIG. 5 is a diagram showing an example of a site information data table set in each of the DB servers 11, 12,... As shown in FIG.
.. 19, information such as a DB server name, a server address, a search protocol pattern, and a face image file format is recorded in association with the codes (DB server codes) of the databases 11, 21,. And is managed. "0" of DB server code
“0” is the code of the host computer 2, and “11” of the DB server code is the code of the DB server 11.

That is, the DB server code is a unique number assigned to each site, and matches the DB server code registered and managed in the database 1 of the host computer 2. The DB server name indicates the name of the installed site. The server address indicates the address of each DB server. The search protocol pattern is used for each of the DB servers 11 and 12
.. Indicate the patterns of electronic messages used when searching the respective databases of. By registering a message pattern that can be used at each site in the search protocol pattern column, a search for each site is performed using a message corresponding to the pattern number. The face image file format managed by each site is registered as the face image file format. By setting the search protocol pattern and the face image file format for each site to be searched, it is possible to handle DB servers that manage data in different protocols or file formats.

FIG. 6 is a diagram showing an example of a data table of the search protocol pattern set in each of the DB servers 11, 12,... As shown in the figure, a plurality of communication protocols and communication message types are recorded and managed in this data table in association with the search protocol pattern numbers.

This search protocol pattern number is a pattern number of a message used when searching each site, and matches the search protocol pattern of the database of each of the DB servers 11, 12,... The communication protocol indicates a communication protocol used in the site to be searched. In addition to TCP / IP, which is a general communication protocol, a communication protocol unique to each host computer, for example, A
-HOST or the like may be used. The communication message type indicates the type of the communication message. Different request message and response message format specifications are defined for each type, and the database search software transmits and receives communication messages according to the communication message specifications of this data table and performs search processing to other sites.

FIG. 7 shows an example of a search key input screen. As shown in the figure, in this search key input screen,
Specify one or more search keys among the certificate number, first and last name, date of birth, and gender of the application to be searched.

An AND search is performed using the search key input on the search key input screen. In the other site search mode, whether or not another site is searched at the time of search is set.

If the value is "0", no search for another site is performed. If the value is "1", a search for another site is also performed. In the case of "2", if there is no corresponding search in other sites, a simultaneous broadcast search is performed for all sites. By setting the other site search mode, it is possible to specify that a search for another site is not performed in a hurry. After setting the key, press the search button to start the search.

FIG. 8 is a view showing an example of the search target catching screen. As shown in FIG.
As a result of the search, applicable candidates are displayed in a list. Clicking and selecting one of the candidate displays and clicking the details button displays the detailed information linked to one of the candidates.

FIG. 9 is a view showing an example of the detail display screen. As shown in the figure, on the detailed display screen, all the recorded and managed information such as the certificate number, first and last name, date of birth, gender, site name and face image are displayed.

Next, the operation of the database search system will be described with reference to the flowchart of FIG. In the case of this database search system, the search terminal 51 at its own site is started, and by performing a predetermined operation, database search software is started, and the search key input screen shown in FIG. 7 is displayed on the monitor. In this search key input screen, items such as a certificate number, first and last name (kana), date of birth, gender, and site search mode are set, and a search key is input for each item. When a plurality of search keys are input, an AND search is performed.

In this case, if a search key such as Atsushi Murakami is entered in the first and last name (kana) field on the search key input screen, the database search software firstly
The set value in the site search mode column in the search key input screen is checked, and it is determined whether the site search mode is “0” or the other modes “1” and “2”.

Here, when "0" indicating the own site search mode is set as the site search mode, only the own site search is searched, and the search to another site is not performed.

When, for example, "1" is set as the site search mode, another site search is performed, but simultaneous broadcast search is not performed.

Further, when "2" is set as the site search mode, for example, other sites are searched and simultaneous broadcast search is performed. It should be noted that since searching for other sites and simultaneous broadcasting take time, normally, "0" of the own site search mode is set as a default value in the site search mode column.

In this case, since the site search mode is "0", the database search software first searches the own site DB server.

As a result of the search, the corresponding data exists (S10
3 (Yes in S104), and when there is one or more data whose transfer flag of the corresponding data is “0” (Yes in S104), a search applicable candidate list screen as shown in FIG. 8 is displayed (S10).
5).

When a detailed display is requested on the search applicable candidate list screen, a detailed display screen as shown in FIG. 9 is displayed (S106). If the "end" button is pressed in the processing of S105 and S106, the screen returns to the search key input screen of S101. After returning to the search key input screen, the search can be performed again. When the "end" button is pressed on this search key input screen, the database search software itself ends. On the other hand, the own site DB of S102
In the server search process, when there is no corresponding data whose transfer flag is “0” (No in S104) and the site search mode is set to “1” or “2” (S1
(No in 07), the host computer 2 is accessed to search the database 1 (S108).

Here, if there is a corresponding search (S109)
Yes), the database search software of the search terminal 51 obtains information such as the address of the other site where the data corresponding to this database 1 is recorded, the number of the search protocol pattern, and the format of the face image file (S110). . Then, the database search software determines the communication protocol and the type of the communication message by comparing the acquired search protocol pattern with the data table of the search protocol pattern shown in FIG. 6, and matches the protocol pattern and format. The other site is accessed using the search message and the database is searched (S111).

As a result of this search, if there is a search applicable candidate in another site (Yes in S112), the process proceeds to the display of a search applicable candidate list screen in S105.

If there is no match in the DB search (S108) and other site search (S111) of the host computer 2 (No in S112), and if the site search mode is "2" (No in S113), Other sites are searched by simultaneous broadcast (S114). This search process is performed for all sites having the DB server name (site name) recorded in the site information data table of the DB server 11 of the own site.

If there is a corresponding candidate in this search processing (S
115, Yes), the process proceeds to S105 as described above.

If there is no corresponding candidate for both the own site and the other site (No in S115), an error message is displayed (S116), and the process returns to S101.

As described above, according to the database search system of this embodiment, one or more search keys and one or more of the certificate number, first and last name, date of birth, and gender of the application to be searched are displayed on the search key input screen. Search mode “0”,
By designating either “1” or “2”, data is automatically searched in order from the DB of the own site to the DB of the other site, so that the user is aware of the location where the data is recorded. You can search your own site or other sites without having to.

Since data at another site can be searched without human intervention, labor and time required for manual intervention can be reduced.

Further, even if the data recorded at the own site has been transferred in the past, the latest data at the other site can be searched, so that an erroneous judgment can be prevented from the past data.

Further, since the search is performed by changing the search message or the image file format according to the site to be searched, the search can be performed for any site in the same procedure.

Further, when the recorded site is unknown, all sites can be searched simultaneously. As a result, labor and labor can be reduced, and it is clear that the data does not exist and is not recorded at all sites. Further, the search can be performed even when the host computer managing the entire data is stopped.

It should be noted that the present invention is not limited to the above-described embodiment, and various modifications can be made without departing from the gist of the invention.

In the above embodiment, the operation of the search terminal is shown in a flowchart, but this operation is performed by software incorporated in the search terminal (computer).

The software may be stored in a computer-readable storage medium such as a floppy disk. In this case, the software (program) stored in the storage medium is read out by the computer, whereby each embodiment is executed. Processing becomes possible.

As a storage medium, a magnetic disk,
Floppy disk, hard disk, optical disk (C
D-ROM, CD-R, DVD, etc.), a magneto-optical disk (MO, etc.), a semiconductor memory, or any other storage medium that can store programs and that can be read by a computer. May be.

An OS (Operating System) running on the computer based on the instructions of the program installed in the computer from the storage medium.
Alternatively, MW (middleware) such as database management software and network software may execute a part of each process for realizing the present embodiment.

Further, the storage medium is not limited to a medium independent of the computer, but also includes a storage medium in which a program transmitted via a LAN or the Internet is downloaded and stored or temporarily stored.

Further, the number of storage media is not limited to one, and the case where the processing in this embodiment is executed from a plurality of media is also included in the recording medium of the present invention, and any media configuration may be used.

The computer executes each processing in the present embodiment based on a program stored in a storage medium. The computer includes one device such as a personal computer and a system in which a plurality of devices are connected to a network. Any of these configurations may be used.

The computer is not limited to a personal computer, but also includes an arithmetic processing unit, a microcomputer, and the like included in information processing equipment, and is a general term for equipment and devices capable of realizing the functions of the present invention by a program. .

[0065]

As described above, according to the present invention, it is specified and searched whether to search from a database server to which a computer is connected or to search another database server connected via a line network. By inputting the search target information for each item, the input search target information is used as a search key according to the specified search mode.
Since a plurality of database servers are searched sequentially or all at once, the user can search for data in the own site or another site without being conscious of the location where the data is recorded. In addition, since data at another site can be searched, collated, and confirmed without human intervention, labor and time required for manual intervention can be reduced.

[Brief description of the drawings]

FIG. 1 is a diagram showing a configuration of a database search system according to one embodiment of the present invention.

FIG. 2 is a diagram showing a database of its own site in this database search system.

FIG. 3 is a diagram showing a database of a host computer in the database search system.

FIG. 4 is a diagram showing a database of another site in the database search system.

FIG. 5 is a diagram showing a site information data table in this database search system.

FIG. 6 is a diagram showing a data table of a search protocol pattern in the database search system.

FIG. 7 is a diagram showing a search key input screen displayed on the search terminal.

FIG. 8 is a diagram showing a search applicable candidate list screen displayed on the search terminal.

FIG. 9 is a diagram showing a detailed display screen displayed on the search terminal.

FIG. 10 is a flowchart showing the operation of the database search system.

[Explanation of symbols]

1, 2, 22, 29 ... database, 2 ... host computer, 3 ... line network, 11, 12, 19 ... DB server, 41 ... LAN, 51 ... search terminal.

Claims (4)

[Claims] 1. A database search system comprising: a plurality of database servers connected via a line network; and a search terminal connected to at least one of the plurality of database servers. A search mode designating unit for designating whether to search from the database server to which it is connected or another database server; an input unit for entering information to be searched for each search item; Means for searching the plurality of database servers sequentially or all at once by using search target information input from the input means as a search key in accordance with a search mode specified by the means. Database search system. 2. A plurality of database servers connected via a network, a host computer for managing the plurality of database servers, and a search terminal connected to at least one of the plurality of database servers. A search mode designating means for designating whether to search from a database server to which the search terminal is connected or another database server, and a search target for each search item. Input means for inputting information, and according to the search mode specified by the search mode specifying means, using the information of the search target input from the input means as a search key, the plurality of database servers and the host computer in order, Alternatively, a database comprising means for searching all at once Search system. 3. A database search method for searching a database of the database server from a search terminal connected to a plurality of database servers connected via a line network, wherein the database terminal is connected to the database server to which the search terminal is connected. Specify whether to search or to search another database server and input search target information for each search item. According to the specified search mode, the input search target information is used as a search key, A database search method characterized by searching a plurality of database servers sequentially or simultaneously. 4. A storage medium storing a computer-readable program for operating a computer connected to a database server, wherein the computer displays a search input screen, and the computer displays a search input screen on the search input screen. Specify whether to search from the connected database server or another database server connected via the network, and enter the information to be searched for each search item, so that the specified search A storage medium storing a program for sequentially or simultaneously searching the database server using input search target information as a search key according to a mode.