JP2006155043A - Information retrieval system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an information retrieval system capable of adequately displaying a data retrieval result by list so as to be easily understood, while permitting inconsistency in data among respective databases. <P>SOLUTION: The plurality of databases 1a, 1b, 1c are independently searched with a search condition being the value of the same component name, for example, so as to generate the search result which indicates each data retrieved from each database. Respective data indicated by the search result are connected for the components having the same component number, so as to generate a connection result which indicates each connected data. It is determined whether the value of an attribute coincides or not concerning the attribute which is common in the respective data indicated by the connection result. When the values of the attributes in the respective connected data are determined not to coincide mutually, the determination result is reflected on the connection result. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to an information retrieval system that retrieves data from a plurality of databases.

  When searching a plurality of databases, a difference in the expression format of search data in each database, data inconsistency between the databases, and the like become problems.

For this reason, for example, in Patent Document 1, a query sentence from a user is translated into a query sentence suitable for each database, each database is searched using the translated query sentence, and thereby an expression format of search data in each database Makes it possible to search freely even if it is different from the user's own expression format.
Japanese Patent No. 348805

  However, an effective technique for accurately handling data inconsistencies between databases has not yet been proposed.

  For example, at the design site for products and parts, there are many types of data such as CAD data, drawing data, experiment results, parts tables, and parts specifications, and these data are multiple databases with different purposes. It is stored and managed at. For this reason, in each database, data items (for example, attributes) are often common to each other and are not necessarily mutually exclusive.

  For example, the drawing data database manages data including items (attributes) such as part number, part name, and figure number, and the CAD data database includes items such as part number, CAD data, figure number, and part name. If data including (attributes) is managed, and data including items (attributes) such as part numbers and specifications is managed in the specification data database, at least the item of the part number is between each database. Common to each other.

  If these databases are searched individually, inconsistency of data between the databases does not matter.

  However, if these databases are searched at the same time, data inconsistency between the databases will be an adverse effect. For example, if the drawing data database and the CAD data database are searched at the same time to display a list of search data related to parts having the same part number, “part number, part name, and figure number” in the drawing data database By combining “part number, CAD data, figure number, and part name” in the CAD data database, “part number, part name, figure number, CAD data” can be displayed as a list as search data. At this time, if the figure number value in the drawing data database is different from the figure number value in the CAD data database, the figure number value is different among the databases only by displaying a list of the search data. However, it is not possible to know from each database whether multiple items have been retrieved as figure number values.

  Such inconsistency of data between databases is caused by an input error, a change not reflected due to a difference in registration time, and a difference in registration rules.

  For this reason, for example, in order to prevent such data inconsistency between the databases, it may be possible to introduce a system for detecting data inconsistency or strengthen the management system of each database. There is a problem that the cost increases.

  Therefore, the present invention has been made in view of the above-described conventional problems, and it is possible to display a list of data search results in an easy-to-understand and accurate manner while allowing data inconsistency between databases. It aims at providing a simple information retrieval system.

  In order to solve the above-mentioned problems, the present invention searches an information search system for searching for data from a plurality of databases, and searches each data corresponding to the search conditions from each database when a search condition and a join key are specified. Then, a search result indicating each data searched in each database is formed, and each data indicated by the search result is combined with those considered to be combined with each other by the combination key. Forming a combined result indicating each of the combined data, and determining whether or not the values of the items match for the items common to each of the combined data indicated by the combined result. A search apparatus that reflects the result of the combination and outputs the result of the combination reflecting the determination result, and instructs the search apparatus of the search condition and the combination key In response to this instruction, when a combination result reflecting the determination result is input from the search device, the combination result reflecting the determination result is displayed, and the items of the combined data indicated by the combination result In addition, a client device that instructs the search device to perform a search based on the value of the matching item and the value of the non-matching item is provided.

  Further, in the present invention, the search device forms a search result indicating each database search means for searching each database individually, and each data corresponding to the search condition searched by each database search means, The data indicated by the search result are combined with each other that are considered to be connected to each other by the connection key to form a connection result indicating the combined data, and the connection indicated by the connection result. For the items common to the respective data, whether or not the values of the items match is determined, and the determination result is reflected by the search result combining unit that reflects the determination result in the combination result, and the determination result by the search result combining unit A display data creation means for inputting a combined result reflecting the above, forming display data indicating the combined result, and outputting the display data to the client device; A reference availability unit for instructing a search device to perform a search based on a value of a matching item and a value of a non-matching item for each item of the combined data indicated by the combined result reflecting the determination result; The apparatus inputs display data from the display data creation means, displays the combined result reflecting the determination result indicated by the display data, and for each item of the combined data indicated by the combined result, A search based on the value of the matching item and the value of the non-matching item is instructed to the referability unit.

  Further, according to the present invention, the search result combining unit generates a search result master indicating the combined result reflecting the determination result, and generates a list of values of items determined not to match.

  According to the present invention, first, a search condition and a join key are instructed from the client device to the search device. In response to this, the search device searches each data corresponding to the search condition from each database, forms a search result indicating each data searched in each database, and each data indicated by this search result Are combined with each other that are considered to be combined with each other by a combination key to form a combined result indicating the combined data, and common to the combined data indicated by the combined result For the item, it is determined whether or not the item values match, the determination result is reflected in the combined result, and the combined result reflecting the determined result is output. Then, the client device displays the combined result reflecting the determination result, and performs a search based on the value of the matching item and the value of the non-matching item for each item of the combined data indicated by the combination result. Instruct the search device.

  For example, the drawing data database stores data including items (attributes) such as part number, part name, and figure number, and the CAD data database stores items (attributes) such as part number, CAD data, figure number, and part name. ) Is stored.

  When these databases are searched with the search condition of the same part name value (attribute value), the data including the part name value is searched for each database, and the search indicating the respective data searched in each database. A result is formed. Then, the data indicated by the search result are combined with each other including the same part number value to form a combined result indicating the combined data.

  For example, if the value of the same part name in the search condition is “Bis”, data including the part name “Bis” is searched for each database, and a search result is formed. If the value of the same part number of the combination key is “1”, the retrieved data are combined with each other including the part number “1”, and the part name “screw” and the part number “1” are combined. A join result is formed indicating that the data including are joined.

  At this time, if an item (attribute) common to the combined data is a figure number, it is determined whether or not the figure number value (attribute value) matches. If it is determined that the figure numbers of the combined data do not match each other, the determination result is reflected in the combined result.

  If the combined result reflecting the determination result is displayed on the client device side in this way, this is understood when the figure number values of the combined data do not match each other, and each figure value is determined by the user's judgment. It becomes possible to use it properly. For example, each value of the figure number can be selectively used.

  If it is not clear that the figure number values of the combined data do not match each other, whether the figure number values are different between the databases, or there are multiple figure number values from each database. It is impossible to know whether an object has been searched, and it is impossible to use each value of the figure number appropriately.

  In addition, according to the present invention, the search device includes a database search unit that searches each database, a search result combining unit that forms a search result and a combined result, and reflects the determination result in the combined result, and a combined result Display data creating means for forming display data indicating the output and outputting to the client device, and the value of the matching item and the item that does not match for each item of the combined data indicated by the combined result reflecting the determination result When a search based on the value of the client is instructed by the client apparatus, the client apparatus includes a reference availability means for instructing the search, and the client apparatus reflects the determination result indicated by the display data from the display data creation means For each item of the combined data indicated by the result of the combination, and the value of the matching item and not matching It has been instructed to see whether or not means a search based on the eye of the value.

  Further, according to the present invention, the search result combining unit generates a search result master indicating the combined result reflecting the determination result, and generates a list of values of items determined not to match. In this case, on the client device side, the value of the item determined to match may be displayed, or the list of each value of the item determined not to match may be displayed as a list, and the item determined to match by this display It is possible to discriminate each value of the item determined to be inconsistent with this value. In addition, using this list, it is possible to perform a search based on the values of items in the list.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings.

  FIG. 1 is a block diagram showing an embodiment of the information search system of the present invention. The information search system according to the present embodiment is used at a design site for products and parts, and includes a plurality of databases 1a, 1b, and 1c, a search server device 2 that searches each database 1a to 1c, and a user side. The client apparatus 3 is provided.

  Since each database 1a-1c, the search server apparatus 2, and the client apparatus 3 are mutually connected through the network 4, those installation locations are not restrict | limited. For example, it is also possible to install only the client device 3 at an overseas design base.

  In addition, here, three databases, ie, a drawing data database 1a, a 3D CAD data database 1b, and a specification data database 1c are illustrated, but even two databases are four or more databases. However, the information search system of this embodiment can be constructed.

  The drawing data database 1a normally stores drawing data in a disk device, and has a function of writing and reading drawing data to and from the disk device, and a function of retrieving drawing data from the disk device.

  The database 1a records and saves the attributes of the drawing data together with the image file in which the two-dimensional drawing image is recorded in the TIFF format. The attributes of the drawing data are parts information such as a unique identification number, an image file name, a part name, a part number, a figure number, a part type such as a gear and a screw, the number of gear teeth, and a gear diameter in the database 1a. .

  The 3D CAD data database 1b normally stores three-dimensional 3D CAD data in a disk device, has a function of writing and reading 3D CAD data to and from the disk device, and a function of retrieving 3D CAD data from the disk device. Yes.

  The database 1b records and saves the attributes of the 3D CAD data together with the 3D file in which the 3D 3D CAD data is recorded. The attributes of the 3D CAD data are component information such as a unique identification number in the database 1b, a 3D file name, a component name, a component number, a figure number, a component type such as a gear and a screw, the number of gear teeth, and a gear diameter. .

  The specification data database 1c normally stores specification data in a disk device, and has a function of writing and reading specification data to and from the disk device, and a function of retrieving specification data from the disk device. ing.

  Further, the database 1c records and saves the attribute of the specification data together with the specification file in which the specification image is recorded in the TIFF format. The attribute of the specification data is component information such as a unique identification number, a specification file name, a component name, a component number, a component type such as a gear and a screw, the number of gear teeth, and a gear diameter in the database 1c.

  In the chart P of FIG. 2, the attributes of the data recorded and stored for each of the databases 1a, 1b, and 1c are organized and shown.

  The search server device 2 is instructed by the client device 3 with a search condition and a join key, performs a search for each of the databases 1a to 1c in response to the search condition and the join key instruction, and displays a list of search results. Data is created and this display data is returned to the client device 3. In addition, when the client server 3 instructs the search server device 2 to specify the value of the attribute of the data, the search server device 2 searches the data including the attribute value from the databases 1 a to 1 c and returns this data to the client device 3.

  The search server device 2 includes a plurality of database search units 21a, 21b, and 21c, a search result combining unit 22, a display data creation unit 23, and a reference availability determination unit 24.

  Each database search unit 21a, 21b, 21c searches each database 1a, 1b, 1c individually. For example, when the client device 3 receives a component attribute value as a search condition, the value of this attribute is set. Are retrieved from the databases 1a, 1b, and 1cb, and the value of each attribute included in the data is output to the retrieval result combining unit 22 as a retrieval result for each data. .

  The search result combining unit 22 combines the search results searched by the databases 1a, 1b, and 1cb. For example, when the client device 3 indicates an attribute type as a combination key, the search results are combined. Are combined with those whose attribute values of the designated type match each other to create a search result master. In addition, the search result combining unit 22 determines whether or not the attribute values of the attributes common to the search results combined with the search result master match, and determines the attribute determined not to match. A list file for each value is created, and the search result master and list file are output to the display data creation unit 23.

  When the display data creation unit 23 receives the search result master and the list file, the display data creation unit 23 creates a list file indicating the search results by the database search units 21a to 21c based on the search result master and the list file. Is output to the client device 3.

  When the data attribute value is instructed from the client device 3, the referability determination unit 24 determines that data including the attribute value is to be retrieved from each of the databases 1 a to 1 c, and the list file is the client device 3. When instructed, the search result master is created again using the search results retrieved from the list file and the databases 1a, 1b, and 1cb.

  The client device 3 is a general PC terminal, and includes an input unit 31 such as a keyboard and a mouse, a display unit 32 such as a display monitor, a storage device 33 such as a disk device, a search for instructing to input search conditions and a combination key. A condition setting unit 34 and a search result selection unit 35 for inputting a search based on the search result master are provided.

  By the way, as apparent from the table of FIG. 2, in the case where a common attribute is used between the databases 1a, 1b, 1c, data inconsistency may occur between the databases 1a, 1b, 1c. . For example, since there is “part number” as a common attribute, each data including the value of “part number” is searched from each database 1a, 1b, 1c using the value of “part number” as a search condition. In addition, the values of other attributes included in these data, for example, the values of “drawing number” may not match each other. In this case, it is not possible to automatically determine which of the “diagram number” values that do not match each other should be adopted or used together.

  Therefore, in the present embodiment, the search results from the databases 1a, 1b, and 1c are displayed in an easy-to-understand and accurate list while avoiding such problems.

  Next, search processing by the information search system of the present embodiment will be described with reference to the flowchart of FIG.

  First, the client device 3 displays a Web browser input screen 41 on the display unit 32 for inputting search conditions, a combination key, and the like as shown in FIG. In this input screen 41, check fields 41a, 41b, 41c for indicating each database 1a, 1b, 1c as search targets, a combination key field 41d for entering the attribute type as a combination key, and an attribute A part type column 41e for entering a value as a search condition is displayed, and it is possible to input a database to be searched, a combination key, and a search condition.

  For example, when the input unit 31 is operated, a check mark is entered in each check field 41a, 41b, each database 1a, 1b is designated as a search target, and a part number (attribute) is entered in the join key field 41d. Is entered and instructed (step S101), and “gear” (attribute value) of the part name is entered in the part type column 41e as a search condition and instructed (step S102).

  It should be noted that the attribute value may be entered in each part specification column 41f to set the search condition in more detail. However, here, it is assumed that only the “gear” of the component name in the component type column 41e is entered and designated as the search condition.

  Thus, in the Web browser screen 41, check marks are entered in the check fields 41a and 41b, the part number is entered in the combination key field 41d, and the part name “gear” is entered in the part type field 41e. When the search effective button 42g is instructed by the operation of 31, the search condition setting unit 34 instructs the search server device 2 to search each database 1a, 1b as a search target, and to instruct the part number as a combination key. Further, “gear” of the part name is instructed as a search condition (step S103).

  In the search server device 2, when the databases 1a and 1b are instructed as search targets, the database search units 21a and 21b that search the databases 1a and 1b are started, and the database search units 21a and 21b are activated. The part name “gear” is designated as a search condition. Further, the part number is instructed to the search result combination unit 22 as a combination key.

  When the database search unit 21a is instructed to use the part name “gear” (attribute value) as a search condition, the database search unit 21a accesses the drawing data database 1a and stores data including the part name “gear” as the search condition. The search result A is generated by arranging the attribute values of the data including the part name “gear” as shown in FIG. 5, for example, and the search result A is output to the search result combining unit 22 (step S22). S104).

  In this search result A, the attribute values (part number value, part name value, and figure number value) of a plurality of data including the part name “gear” are arranged in the order of the part number.

  Further, when the “gear” (attribute value) of the part name is designated as a search condition, the database search unit 21b accesses the database 1b of 3D CAD data and includes “gear” of the part name as the search condition. The data is searched to generate a search result B in which the attribute values of the data including the part name “gear” as shown in FIG. 5 are arranged, for example, and the search result B is output to the search result combining unit 22 ( Step S104).

  This search result B is arranged in order of the part number in order of the part number in each attribute value (part number value, CAD data value, figure number value, and part name value) including “gear” of the part name. It is what.

  When the search result combining unit 22 receives the search results A and B, the search result combining unit 22 is instructed by using the part number (attribute) as the combination key as described above. A combined result C as shown in FIG. 5 is obtained by sharing the part name, CAD data, and figure number corresponding to the value (the same attribute value) (step S105).

  For example, the part name “gear 1”, CAD data “g1.prt”, and the figure number “S100” corresponding to the part number “A001” in each search result A and B are extracted from each search result A and B and shared. Turn into.

  In addition, the parts names “gear 2” and “gear 2a” corresponding to the part number “A002” in each of the search results A and B, the CAD data “g2.prt”, and the figure numbers “S200” and “S210” are searched. Extract from results A and B and share. However, since “Gear 2” and the figure number “S200” in the search result A are different from “Gear 2a” and the figure number “S210” in the search result B, they are called “Gear 2, Gear 2a” and “S200, S210”. List each value of the same attribute separated by ",".

  Further, since the part number “A003” in the search result B does not exist in the search result A, the CAD data “g1.prt” and the figure number “S100” corresponding to the part number “A003” are extracted from only the search result B. And ask.

  The search result combining unit 22 records “gear 2, gear 2a” and “S200, S210” that correspond to the same part number “A002” but did not match each other as shown in FIG. The respective list files D1 and D2 are created, and the respective file names “x0001.lst” and “x0002.lst” are set in the list files D1 and D2. List files are created for each attribute whose values do not match each other.

  Further, the search result combining unit 22 converts the combination result C as shown in FIG. 5 into a CSV file which is text file data, and creates a search result master E as shown in FIG. At this time, the file names “x0001.lst” and “x0002.lst” are entered in the search result master E instead of “gear 2, gear 2a” and “S200, S210” which did not match each other.

  The list files D1 and D2 and the search result master E created in this way are output from the search result combining unit 22 to the display data creating unit 23. Upon receiving the list files D1 and D2 and the search result master E, the display data creation unit 23 creates display data expressed in the HTML format using the search result master E (step S106).

  This display data shows a web browser input screen 42 as shown in FIG. 6, for example. Most of the values of each attribute in the search result master E are displayed as they are, and there are no attribute values, for example, a part number “ The part name corresponding to “A003” is left blank. The file names “x0001.lst” and “x0002.lst” are displayed by the respective operation buttons 42a and 42b. The display data creation unit 23 sets respective actions for calling and referring to the list files D1 and D2 with the file names “x0001.lst” and “x0002.lst” for the operation buttons 42a and 42b. .

  The display data created in this way is output from the display data creation unit 23 of the search server device 2 to the search result selection unit 35 of the client device 3. When the search result selection unit 35 receives the display data, the search result selection unit 35 displays the Web browser input screen 42 of FIG. 6 indicated by the display data on the display unit 32 (step S107).

  In this state, when the input unit 31 of the client device 3 is operated and, for example, CAD data “g1.prt” is instructed, the search result selection unit 35 refers to this instruction to the referability determination unit 24 of the search server device 2. (Step S108).

  When the CAD data “g1.prt” is instructed, the referability determination unit 24 determines that only a single attribute value, that is, “g1.prt” is instructed (“No” in step S109), and the client After confirming the access right to the database by the user of the apparatus 3, the database 1b is instructed to search for the CAD data “g1.prt”. The access right to the database by the user is confirmed by, for example, notifying the user identification number from the client apparatus 3 to the search server apparatus 2 and determining whether or not the access right is set for this identification number. The

  When instructed to search for the CAD data “g1.prt”, the database 1 b searches for 3D CAD data including the CAD data “g1.prt” and outputs the 3D CAD data to the client device 3. The client device 3 stores the 3D CAD data in the storage device 33, and displays a three-dimensional drawing indicated by the 3D CAD data on the display unit 32 (step S110). Thereafter, the process returns to step S101.

  Alternatively, when the figure number “S100” is instructed by the operation of the input unit 31 of the client device 3, this instruction is returned from the search result selection unit 35 to the reference availability determination unit 24 (step S108), and the attribute number is simply set. It is determined that one value has been designated (“No” in step S109), and after the access right to the database by the user of the client device 3 is confirmed, a search for the drawing number “S100” is designated to the drawing data database 1a. The drawing data including the drawing number “S100” is retrieved, and this drawing data is stored in the storage device 33 of the client device 3 and displayed on the display unit 32 (step S110). Thereafter, the process returns to step S101.

  In addition, after step S110, the instruction | indication whether the process by operation of the input part 31 of the client apparatus 3 is returned is confirmed, and when it is instruct | indicated not to return a process, it returns to step S107 and performs a process. When it is instructed to restore, the process may return to step S101.

  When the operation button 42a is instructed by the operation of the input unit 31 of the client device 3 with the Web browser input screen 42 of FIG. 6 displayed on the display unit 32, the search result selection unit 35 Is returned to the reference availability determination unit 24 of the search server device 2 (step S108).

  When the operation button 42a is instructed, the referability determination unit 24 calls and refers to the list file D2 with the file name “x0002.lst” in response to the instruction of the operation button 42a. Then, since “S200, S210” is registered in the list file D2, the reference availability determination unit 24 determines that each value that does not match the attribute is instructed (“Yes” in step S109). The number “S200” and the figure number “S210” are output to the search result combining unit 22. Then, the process returns to step S105.

  Upon receiving the figure number “S200” and the figure number “S210”, the search result combining unit 22 uses the figure number “S200” as a combination key and the part number corresponding to the figure number “S200” in each search result A and B. The part name is made common, and the part number and part name corresponding to the figure number “S210” in each search result A and B are made common using the figure number “S210” as a join key, and the join result J as shown in FIG. Is obtained (step S105).

  Then, the search result combining unit 22 has attribute values corresponding to the same drawing number “S200”, each value not matching each other does not exist, and corresponds to the same drawing number “S210”. Since there is no attribute value that does not match each other, a list file that records attribute values that do not match each other is not created, and the join result J shown in FIG. And a search result master K as shown in FIG. 7 is created (step S106).

  The search result master K is output from the search result combining unit 22 to the display data creating unit 23. The display data creation unit 23 creates display data expressed in the HTML format using the search result master K (step S106), and displays a Web browser input screen 43 as shown in FIG. 32 (step S107).

  In this state, for example, when the drawing number “S210” is instructed by the operation of the input unit 31 of the client device 3, the search result selection unit 35 returns this instruction to the reference availability determination unit 24 of the search server device 2 ( Step S108).

  When the figure number “S210” is instructed, the referability determination unit 24 determines that only a single attribute value, that is, “S210” is instructed (“No” in step S109), and the user of the client apparatus 3 After the access right to the database is confirmed, the search for the drawing number “S210” is instructed to the drawing data database 1a.

  When instructed to search for the drawing number “S210”, the database 1a searches for drawing data including the drawing number “S210” and outputs the drawing data to the client device 3. The client device 3 stores the drawing data in the storage device 33 and displays a two-dimensional drawing indicated by the drawing data, for example, a two-dimensional drawing Q as shown in FIG. 9 on the display unit 32 (step S110). Thereafter, the process returns to step S101.

  As described above, in this embodiment, for each of a plurality of databases, for example, the database is searched under the search condition of the same part name value, and a search result indicating each data searched in each database is formed. The data indicated by is combined with those containing the same part number value to form a combined result indicating the combined data, and the common attribute of the data indicated by the combined result It is determined whether or not the attribute values match. If it is determined that the attribute values of the combined data do not match each other, the determination result is reflected in the combined result.

  If the combined result reflecting this judgment result is displayed on the client device side, not only is the list displayed by combining the search results in each database, but also the attribute values common to the combined data match. When this is not done, this is known, and it is possible to use each attribute value appropriately at the discretion of the user. For example, each value of the attribute can be selectively used.

  In addition, each list file that records each attribute value that did not match each other is created, and each data searched in each database is combined with each other by a combination key called attribute value of each list file Since what is considered to be combined is obtained and a combined result is obtained, the same processing is repeated, and the processing process is simplified.

  In addition, the user can simultaneously search various databases at remote locations via the network using the client device, and can check the search results in a list form. .

  In addition, this invention is not limited to the said embodiment, It can deform | transform variously. For example, the present invention can be applied to an information search system used in another environment different from the design site for products and parts.

It is a block diagram which shows one Embodiment of the information search system of this invention. FIG. 2 is a chart in which attributes of data recorded and stored are organized for each database in the information search system of FIG. 1. It is a flowchart which shows the search process by the information search system of FIG. It is a figure which shows an example of the web browser input screen displayed on the client apparatus in the information search system of FIG. It is a figure which shows each data searched and produced by the information search system of FIG. It is a figure which shows the other example of the web browser input screen displayed on the client apparatus in the information search system of FIG. It is a figure which shows each other data searched and produced by the information search system of FIG. It is a figure which shows another example of the web browser input screen displayed on the client apparatus in the information search system of FIG. It is a figure which illustrates the two-dimensional drawing shown by the drawing data searched by the information search system of FIG.

Explanation of symbols

1a, 1b, 1c Database 2 Search server device 3 Client device 4 Network 21a, 21b, 21c Database search unit 22 Search result combination unit 23 Display data creation unit 24 Reference availability determination unit 31 Input unit 32 Display unit 33 Storage device 34 Search condition Setting part 35 Search result selection part

Claims (3)

In an information retrieval system that retrieves data from multiple databases,
When a search condition and a join key are instructed, each data corresponding to the search condition is searched from each database, and a search result indicating each data searched in each database is formed. Are combined with each other, which are considered to be combined with each other by the combination key, to form a combined result indicating the combined data, and for each of the combined data indicated by the combined result A search device that determines whether or not the values of items match for items common to each other, reflects the determination result in the combination result, and outputs a combination result that reflects the determination result;
When the search condition and the join key are instructed to the search device, and the join result reflecting the determination result is input from the search device in response to the instruction, the join result reflecting the determination result is displayed, An information search system comprising: a client device that instructs a search device to perform a search based on a value of a matching item and a value of a non-matching item for each item of the combined data indicated by a combination result. The search device
Each database search means for searching each database individually,
A search result indicating each data corresponding to the search condition searched by each database search means is formed, and each data indicated by the search result is considered to be combined with each other by the combination key. Combined to form a combined result indicating each combined data, and for the items common to each other of the combined data indicated by the combined result, determine whether or not the item values match Search result combining means for reflecting the determination result in the combination result;
Display data creation means for inputting the result of the combination reflecting the determination result by the search result combining means, forming display data indicating the result of the combination and outputting it to the client device;
For each item of the combined data indicated by the combined result reflecting the determination result, the reference availability means for instructing the search device to search based on the value of the matching item and the value of the non-matching item,
The client device inputs display data from the display data creation means, displays the combined result reflecting the determination result indicated by the display data, and for each item of the combined data indicated by the combined result 2. The information search system according to claim 1, wherein a search based on the value of the matching item and the value of the non-matching item is instructed to the referability means. The search result combining unit generates a search result master indicating a combined result reflecting the determination result, and generates a list of values of items determined not to match. Information retrieval system.

Images