JPH08235192A - Device and method for data base retrieval - Google Patents

Abstract

PURPOSE: To provide the data base retrieval device which performs retrieval based upon a retrieval request and judgement based upon restrictions imposed on a user without increasing the burden on the user at the time of data base retrieval. CONSTITUTION: This device consists of a user information part 80 which includes user information regarding the user who performs data base retrieval, and a verifying means 70 which is connected to the user information part 80 and inputs a retrieval result including verification information limiting the user to be given the result of retrieval from a retrieval object data base 60 and the user information from the user information part 80 and decides whether or not there is a contradiction between the user information inputted to judge whether or not the retrieval result is given to the user and verification information on the retrieval result.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database retrieval apparatus and a database retrieval method for retrieving a database in response to a retrieval request from a user, and more particularly to determining whether or not the retrieved information should be provided to the user. The present invention relates to a database search device and a database search method.

[0002]

2. Description of the Related Art Conventionally, a database search device which searches a database in response to a search request from a user and judges whether or not the searched information should be provided to the user, that is, handles a constraint on the user is known. Has been. Figure 10
FIG. 1 is a configuration diagram of a conventional typical database search device. A conventional database search device includes an input unit 40 for inputting a user's search request and obtaining database search conditions,
The search condition of the user is input from the input unit 40, the database 60 is searched, and the search unit 50 that obtains the search result matching the search condition is connected to the search unit 50. And an output unit 90 for converting the format. For example, the following three methods are known as methods for handling restrictions on users in such conventional database search devices.

According to the first method, the restriction on the user is presented to the user together with the information of the search result which meets the user's search request. The user who is presented with the constraint
By looking at the constraint, the information of the search result corresponding to the constraint satisfying the user information is selected.

According to the second method, the restriction on the user is described as one of the search requests. For example, when the recruiting side searches a job information database that imposes age restrictions on users, the users need to obtain information that has restrictions for users who satisfy their age information. Describe age as one of the search requests.

The third method describes whether or not a search is possible in database units, and restricts a user who is restricted by the user from accessing the database.

[0006]

However, each of the above methods has the following problems. In the first method, the user pays attention to the restriction on the user after searching the database in order to obtain the information having the restriction satisfying the information on the user, and manually judges, that is, selects the search result. is necessary.

In the second method, although the restriction on the user is originally due to the information in the database, it is searched as one of the search requests at the time of searching the database. It should be treated as if it were a search request. Therefore, the user's search request,
It is not possible to clearly separate two types of information that are essentially different, that is, restrictions on users on the database side.

[0008] In the third method, since access is restricted for the entire database, it is difficult to describe restrictions on the user for each record in the database. Therefore, uniform restrictions are imposed on the entire database. The present invention, in order to solve the above problems,
It is an object of the present invention to provide a data verification device that does not increase the burden on a user when searching a database and performs a search based on a search request and a determination based on a constraint on the user separately.

It is a further object of the present invention to provide a data retrieval device capable of making a judgment based on a constraint for a user on a record-by-record basis in a database including the data verification device. Another object of the present invention is to provide a database search device in which the user can appropriately set user information so as to reduce the burden on the user when searching the database.

[0010]

FIG. 1 is a block diagram showing the principle of a database search apparatus according to the present invention. In the figure, a data verification device 30 of the present invention includes a user information section 80 including user information regarding a user who searches a database,
A search result including verification information that limits the users who are connected to the user information unit 80 and are provided with the database search result, and the user information from the user information unit 80 are input.
The verification unit 70 determines whether the user information input to determine whether or not to provide the search result to the user is inconsistent with the verification information of the search result.

The data search device 20 of the present invention is connected to the search target database 60 containing the search information which is the target of the user's database search; the search conditions are input from the user; The search target database 60 is searched based on the search result, and the search means 50 that outputs and obtains the search result matching the search condition. The data search device 20 of the present invention includes a search target database 60.
Further has verification information for limiting the users of the search information corresponding to the search information, and the apparatus 20 includes a user information section 80 including user information regarding the users; a searching means 50 and a user information section 80. The search result obtained from the search means 50 and the verification information corresponding to the search result are input, the user information is input from the user information section 80, and whether the search result is provided to the user is determined. It is characterized by further comprising a verification means 70 for judging whether or not the inputted user information for judgment is inconsistent with the verification information.

Further, the database search device including the data search device 20 of the present invention is characterized by having a user information acquisition unit for acquiring the user information set in the user information unit 80. In another aspect of the present invention, a database search method for limiting users of search information obtained by searching a search target database includes a search request for a database search from a user; To obtain the search information; retrieve the verification information that limits the users of the search information corresponding to the search information; determine whether the information about the user and the verification information are inconsistent, and the result of the determination is not inconsistent In this case, the search information is provided to the user, and when the determination result is inconsistent, the provision of the search information to the user is stopped.

[0013]

According to the data verification device 30 of the present invention, the verification information included in the search result information obtained by the database search and the search result information are separately provided in the user information section 8.
Since the user information stored in 0 is used to determine whether or not the search result is provided to the user, it is determined whether the input user information is inconsistent with the verification information of the search result. The search based on the search request and the determination based on the restriction on the user are separately performed without increasing the burden on the user when searching the database.

According to the data search apparatus 20 of the present invention, the search target database 60 has the search information and the verification information for limiting the users of the search results corresponding to the search information. Verification information can be attached. Therefore, the verification unit 7 that receives the search result searched by the search unit 50 from the search target database 60.
0 can use the verification information attached to each record of the search result to make a judgment based on the constraint on the user on a record-by-record basis of the search target database 60.

According to the database search device of the present invention,
The user can set his or her own user information in the user information section 80 via the user information acquisition section, and the user information necessary for verification at the time of database search is not being searched for in the database. Since it can be set, the burden on the user when searching the database is reduced.

[0016]

2 is a block diagram of a database search device 10 according to an embodiment of the present invention. Database search device 1
0 is an input unit 40 that inputs a user's search request and obtains a search condition for the database; and a data search that inputs the user's search condition from the input unit 40, searches the database, and obtains search results that match the search condition. The data search unit 20 includes a unit 20 and an output unit 90 which is connected to the data search unit 20 and receives a search result from the data search unit 20 and converts the search result into an output format.

The data search unit 20 includes a search target database 60 that includes search information that is a target of a user's database search, and verification information that corresponds to the search information and limits the users of the search information, and an input unit 40. Search target database 6
0, the search unit 50 inputs search conditions from the input unit 40, searches the search target database 60 based on the search conditions, and obtains search results that match the search conditions;
And a data verification unit 30 that is connected to the output unit 90 and determines whether or not to provide the search result to the user.

The data verification unit 30 is connected to the user information unit 80 containing the user information about the user, the user information unit 80, and also connected between the search unit 50 and the output unit 90, and searched. The search result obtained from the unit 50 and the verification information corresponding to the search result are input, the user information is input from the user information unit 80, and it is determined whether the input user information is inconsistent with the verification information. If there is a contradiction, the output of the search result to the output unit 90 is stopped, and if there is no contradiction, the search result is output to the output unit 90.

The hardware for implementing the database search device 10 may be any device including a CPU and a memory, for example, and can be configured by a device such as a computer system. The input unit 40 of the database search device 10 is connected to a device for inputting a user's search request, for example, an input device 100 such as a keyboard, another computer system, or an information filing system. The output unit 90 of the database search device 10 is
It is connected to an output device 102 such as a display, a printer, or another computer system that outputs the search result.

The search target database 60 may, for example, describe the verification information corresponding to the search information for each record of the search information, as long as the verification information corresponding to each search information can be obtained. Any format is acceptable. By describing a pair of search information and verification information in one record of the search target database 60, there is an advantage that one record obtained as a search result can be used as an input to the data verification unit 30.

FIG. 3 is a diagram for explaining the logical field structure of the search target database 60 according to an embodiment of the present invention. One logical record 62 of the search target database 60
Is the key for searching the search target database, or
A search key field 64 indicating a search condition and a restriction on the user corresponding to the search information of the record, that is,
It comprises a data verification field 66 representing search information and a search data body, that is, a data body field 68 representing search information.

In the following, the search target database 60
Will be described assuming that it is a database that can be searched using a logical expression of a keyword.
Is not limited to a database that can be searched by the above logical expression of keywords.

The user information section 80 provides the verification section 70 with user information about the user who searches the database. As the user information, for example, the name of the individual user,
Physical information such as age and occupation, and mental information such as hobbies and preferences can be used. FIG. 4 is a diagram for explaining a logical field configuration of the user information section 80 according to the embodiment of the present invention. The one logical record 82 of the user information section 80 includes a user ID field 84 for distinguishing users, an attribute name field 86 indicating the name of an attribute included in the record, and a value of the attribute included in the record. And an attribute value field 88 representing

FIG. 5 is a flow chart for explaining the operation of the database search device 10 according to one embodiment of the present invention. Hereinafter, the operation of the database search device 10 will be described in detail with reference to FIG. (Step 1): The input unit 40 receives a user search request from the input device 100. At this time, the user ID of the user who has issued the search request is received.

(Step 2): The input unit 40 converts the input search request into a format that can be used for a search using the search target database 60 (hereinafter referred to as a search condition). Specifically, the search request from the user is converted into a keyword logical expression. The logical expression of the converted keyword is sent to the search unit 50 together with the user ID.

(Step 3): Search unit 50 is input unit 40
The logical expression of the keyword, that is, the search condition is received, and the search target database 60 is searched using the search condition. (Step 4): When the search is successful and the search result is obtained, the search unit 50 sends the search result together with the user ID to the verification unit 70, and proceeds to Step 5. When the search is unsuccessful, information indicating that the search is unsuccessful is sent to the output unit 90, and the process proceeds to step 8.

(Step 5): The verification unit 70 uses the search unit 50.
Upon receiving the search result obtained in step 1, the search result is compared with the user information obtained from the user information section 80, and the presence or absence of contradiction is verified. (Step 6): The search unit 50 indicates that the data verification result is O.
K, that is, if there is no contradiction, the search result is sent to the output unit 90, and the process proceeds to step 7. If the result of the data verification is NG, that is, if there is a contradiction, the fact that there is a contradiction is sent to the output unit 90, and the process proceeds to step 9.

(Step 7): The output unit 90 is the verification unit 70.
The search result received from is output to the output device 102, and the database search process ends. (Step 8): The output unit 90 is the search target database 6
The fact that the search for 0 has failed is output to the output device 102, and the database search processing ends.

(Step 9): The output unit 90 outputs to the output device 102 that the verification information corresponding to the search information obtained from the search target database 60 does not satisfy the user information of the user information unit 80, and the database is output. The search process ends. By the processing from step 1 to step 9 above,
The search target database is searched based on the search request from the user, the user information of the user who performs the search is compared with the restriction on the user corresponding to the search information, that is, the verification information, and the verification information is obtained. When the user information is satisfied, the search result is provided to the user. When the verification information does not satisfy the user information, the output of the search result is stopped, and the fact that the verification information does not satisfy the user information is output.

Next, the data verification processing operation (step 5 in FIG. 5) of the data verification unit 30 in one embodiment of the present invention will be described in more detail with reference to FIG. 6 showing the operation flow of the data verification processing. . (Step 5a): The verification unit 70 of the data verification unit 30
The information of the data verification field is obtained from the search result obtained by the search unit 50, specifically, the information of the search result having the logical field format shown in FIG.

(Step 5b): The verification section 70 searches the user information section 80 using the user ID sent from the search section 50 together with the search result, and the attribute name of the user-
Get an attribute-value pair. (Step 5c): The verification unit 70 confirms the contents of the data verification field obtained in Step 5a and Step 5b.
The attribute name-attribute value pairs relating to the user obtained in step 3 are compared.

(Step 5d): The verification unit 70 verifies that the content of the data verification field obtained in Step 5a does not conflict with the attribute name-attribute value pair relating to the user obtained in Step 5b, that is, the verification. If the information constraint satisfies the user information, the process proceeds to step 5e. If there is a contradiction, that is, if the constraint of the verification information does not satisfy the user information, the process proceeds to step 5f.

(Step 5e): Since the verification unit 70 has no contradiction in the data verification, the result of the data verification is set to OK.
Step 5 is ended, and the process returns to step 6 of the main flow shown in FIG. (Step 5f): Since the verification unit 70 has a contradiction in the data verification, the result of the data verification is set to NG, the step 5 ends, and the process returns to step 6 of the main flow shown in FIG.

According to the above embodiment of the present invention, the verification unit 7
User I for searching user information section 80 at 0
D is supposed to be obtained together with the search request when the user makes a search request, but the method of obtaining the user ID is not particularly limited. As described above, in the database search device according to the embodiment of the present invention, since the user's search request and the constraint on the user on the database side can be clearly separated, the constraint on the user on the database side is used. Users can search the database without being aware of it. In addition, it is possible to describe restrictions on users for each record in the database.

A recruitment information search database system using the database search device 10 according to an embodiment of the present invention will be described below. FIG. 7 is a diagram showing an example of specific contents of the search target database 60 in the recruitment information search database system. For example, in the record described in the top row, “hourly wage = 1000 yen” and “business type = fast food” are described as search keys in the search key field, and “age ≧ 18 years old” in the data verification field. , "Occupation ≠ student" is described,
In the data body field, "Store name = ○○ Burger",
“Place = Yokosuka City XX” and the like are described.

FIG. 8 is a diagram showing an example of the specific contents of the user information described in the user information section 80. For example, the “attribute name-attribute value” pair of the personal information about the user with the user ID = 0001 described at the top is:
It is shown that "name-information Taro", "age-21 years", "occupation-freeter", and "health-good".

First, a user having a user ID = 0001 makes a search request via the input device 100,
The operation of the job information search database system will be described on the assumption that "I want to know the job information for fast food with an hourly wage of 1000 yen or more" is input.

The input section 40 receives the search request and the user ID (step 1 in FIG. 5). The input unit 40 is
The search request "I want to know the job offer information of fast food with an hourly wage of 1000 yen or more" can be searched in the search target database 60, that is, "search key = (hourly wage ≥ 1000
(Yen) and (business type = fast food) ”, and sends it to the search unit 50 together with the user ID (step 2 in FIG. 5).
There is no limitation on the procedure of such conversion.

Next, the search unit 50 searches the search target database 60 using "search key = (hourly salary ≧ 1000 yen) and (business type = fast food)" (step 3 in FIG. 5). Here, in the search target database 60 shown in FIG. 7, the search key field is “hourly rate = 1000.
Since a record consisting of "yen" and "industry = fast food" is described, the search was successful and the following search results were obtained from the search key field and the data body field: -Hourly wage = 1000 yen-Industry = fast food-Store name = ○○ Burger ・ Location = Yokosuka City × × ・ Time = 10: 00-17: 00 ・ Day of the week = Saturday and Sunday are obtained, and from the data verification field: ・ Age ≧ 18 years old ・ Occupation ≠ student is obtained. The search unit 50 sends these pieces of information including the user ID = 0001 to the verification unit 70 (step 4 in FIG. 5).

The verification unit 70 acquires the information "age ≧ 18 years old, occupation ≠ student” in the data verification field from the obtained search results (step 5a in FIG. 6). Then, the user information section 80 is searched with the user ID = 0001, and the following user information is obtained: -name = information Taro-age = 21 years-occupation = freeter-health = good (step 5b in FIG. 6) .

The verification unit 70 uses the contents of the data verification field “age ≧ 18 years old, occupation ≠ student” and user information “name = information Taro, age = 21 years old, occupation = freeter, health =”
"Good" (step 5c in FIG. 6). Since the user information does not conflict with the contents of the data verification field (step 5d in FIG. 6), the verification unit 70 sets the result of the data verification to OK (step 5e in FIG. 6). Since the result of the data verification is OK, the verification unit 70 causes the search result “hourly wage = 1000 yen, industry = fast food, store name = ○○”.
Burger, place = Yokosuka City XX, time = 10: 00-17: 00,
“Day of week = Saturday, Sunday” is sent to the output unit 90 (step 6 in FIG. 5).

Output unit 90 that obtains the search result from verification unit 70
Outputs the search result to the output device 102 (step 7 in FIG. 5). Next, assuming that a user having a user ID = 0002 inputs "I want to know the job offer information for fast food with an hourly wage of 1000 yen or more" as a search request through the input device 100, the job offer is assumed. The operation of the information retrieval database system will be described.

In this case, the search by the search unit 50 is successful, and the following search results are obtained from the search key field and the data body field: -Hourly wage = 1000 yen-Industry = fast food-Store name = OO burger-Location = Yokosuka City ×× ・ Time = 10: 00-17: 00 ・ Day of the week = Saturday and Sunday are obtained, and from the data verification field, ・ Age ≧ 18 years old ・ Occupation ≠ student has the user ID = 0001 It is similar to the case of the search by the user. The search unit 50 uses the user I
These pieces of information including D = 0002 are sent to the verification unit 70 (step 4 in FIG. 5).

The verification unit 70 acquires the information "age ≧ 18 years old, occupation ≠ student” in the data verification field from the obtained search results (step 5a in FIG. 6). Then, the user information section 80 is searched with the user ID = 0002, and the following user information: ・ Name = Information Jiro ・ Age = 19 years old ・ Occupation = Student ・ Health = Good ・ Physical strength = Confident ・ Hobbies = Reading , Get sports (step 5b in FIG. 6).

The verification unit 70 uses the contents of the data verification field “age ≧ 18 years old, occupation ≠ student” and user information “name = information Jiro, age = 19 years old, occupation = student, health = good, physical strength = confidence”. Yes, hobby = reading, sports ”(step 5c in FIG. 6), the user information is inconsistent with the contents of the data verification field, that is, age satisfies the constraint but occupation is inconsistent. It is understood that this is done (step 5d in FIG. 6). Therefore, the verification unit 70 sends the result of data verification as NG to the output unit 90 (see FIG. 6).
Step 5f). Since the result of the data verification is NG, the output unit 90 outputs the search result indicating that there is no information satisfying the user information in the search target database 60.
2 (step 9 in FIG. 5).

FIG. 9 is a diagram showing the structure of a database search device 10 according to another embodiment of the present invention. The configuration and function of the data search unit 20 are similar to those of the data search unit 20 of the embodiment of the present invention shown in FIG. The same reference numerals as those in FIG. 2 are attached in FIG. 9 to the components corresponding to those of the database search apparatus in FIG.

The database search device 10 inputs the user's search request and obtains the search conditions of the database.
0, the search condition of the user is input from the input unit 40, the database is searched, and the data search unit 20 that obtains the search result that matches the search condition is connected to the data search unit 20 and the search from the data search unit 20 is performed. An output unit 90 that receives the result and converts it into an output format, and a user information acquisition unit 110 that is connected to the input device and acquires information about the user from the user, that is, user information. The user information acquisition unit 110 allows the user to add or update the user information directly to the database search device.

[0048]

As described above, according to the present invention, by separately describing and handling the user's search request and the restriction on the user, the user need only specify the original search request item. Therefore, the operability of the database search device at the time of database search is improved, and the efficiency of the database search device is increased.

Further, since the search target database and the user information are separately described, such information can be managed for each information source, which has an advantage that information can be easily updated and added. According to the present invention, since the user information can be directly added or updated by the user himself / herself to the database search device, there is an advantage that the reliability of the user information is improved and the accuracy of the database search result is increased. To be

[Brief description of drawings]

FIG. 1 is a principle configuration diagram of the present invention.

FIG. 2 is a configuration diagram of a database search device according to an embodiment of the present invention.

FIG. 3 is a configuration diagram of logical fields of a search target database of the database search device according to the embodiment of the present invention.

FIG. 4 is a configuration diagram of a logical field of user information of the database search device according to the embodiment of the present invention.

FIG. 5 is a flowchart illustrating an operation of the database search device according to the embodiment of the present invention.

FIG. 6 is a flowchart illustrating an operation of a data verification process in the database search device according to the embodiment of the present invention.

FIG. 7 is a diagram showing an example of contents of a search target database of the database search device according to the embodiment of the present invention.

FIG. 8 is a diagram showing an example of contents of user information of the database search device according to the embodiment of the present invention.

FIG. 9 is a configuration diagram of a database search device according to another embodiment of the present invention.

FIG. 10 is a configuration diagram of a conventional database search device.

[Explanation of symbols]

 10 database search device 20 data search device 30 data verification device 40 input unit 50 search unit 60 search target database 62 search target database logical field 64 search key field 66 data verification field 68 data body field 70 verification unit 80 user information unit 82 Logical field of user information 84 User ID field 86 Attribute name field 88 Attribute value field 90 Output unit 100 Input device 102 Output device 110 User information acquisition unit

Claims (7)

[Claims] 1. A user information section including user information regarding a user who conducts a database search, and verification information for limiting a user who is connected to the user information section and is provided with the result of the database search. The search result and the user information from the user information section are input,
A data verification device, comprising: a verification unit that determines whether the input user information is inconsistent with the verification information of the search result to determine whether to provide the search result to the user. 2. A search target database including search information that is a target of a user database search; connected to the search target database, inputting search conditions from the user, and performing the search based on the search conditions. A data retrieval device comprising a retrieval means for retrieving a target database and obtaining and outputting a search result satisfying the search condition, wherein the retrieval target database limits users of the retrieval information corresponding to the retrieval information. The apparatus further comprises verification information for performing a search result obtained from the user information unit including user information about the user, the search unit, and the user information unit. And the verification information corresponding to the search result are input, the user information is input from the user information section, and the input use is performed to determine whether to provide the search result to the user. Person Broadcast data retrieval apparatus characterized by further having a determining verification means whether conflict with the verification information. 3. Input means for obtaining a search condition representing a search request of a user of a database search; a search target database including search information which is a target of the database search of the user; and the input means and the search target. A search unit connected to the database, inputting the search condition from the input unit, searching the search target database based on the search condition, and obtaining a search result matching the search condition; A database search device comprising output means for outputting the obtained search result: the search target database further has verification information for limiting a user of the search information corresponding to the search information; Is connected to the user information section including user information about the user, the user information section, and between the search means and the output means, and the search means And the verification information corresponding to Luo 該得 obtained search result and the search result is input,
The user information is input from the user information section, it is determined whether or not the input user information is inconsistent with the verification information, and in the case of inconsistency, the output of the search result to the output means is stopped. A database search device further comprising a verification unit that outputs the search result to the output unit when there is no contradiction. 4. The database search device according to claim 3, further comprising user information acquisition means for acquiring the user information from the user. 5. The database search device according to claim 3, wherein the search information is composed of a plurality of fields, and the search target database is a set of pairs of the search information and the verification information. 6. The database search device according to claim 3, wherein the user information is personal information of the user. 7. A database search method for limiting users of search information obtained by searching a search target database: a search request for database search from a user, and the search target according to the search request. The database is searched to obtain the search information, the verification information that limits the user of the search information corresponding to the search information is extracted, and it is determined whether the information about the user conflicts with the verification information. A database search method comprising: providing the search information to the user when the determination result is not inconsistent, and stopping providing the search information to the user when the determination result is inconsistent.