JP3558032B2 - Integrated search method and apparatus, and storage medium storing integrated search program - Google Patents

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to an integrated search method and apparatus, and a storage medium storing an integrated search program. In particular, the present invention relates to a plurality of logically independent tables of a database using a plurality of query statements having different structures. The present invention relates to an integrated search method and apparatus for acquiring two search results and a storage medium storing an integrated search program.
[0002]
[Prior art]
The conventional database integrated search method employs a method in which items are identified over a plurality of table boundaries using an item correspondence table prepared in advance, or a plurality of tables are joined according to records. By combining a plurality of tables by these methods to create one large table and performing a search on it, an integrated search is realized.
[0003]
UNION in the database query language SQL is an operator that integrates search results obtained from a plurality of queries. Normally, when performing a search on a plurality of tables, it is necessary to make an inquiry to each table and use the obtained results to organize the results. However, as shown in FIG. By using the UNION from the list B], the user can obtain a unified search result.
[0004]
On the other hand, there is also a demand for performing a search on a plurality of tables that are logically independently constructed and obtaining an integrated search result. Therefore, there is a method of identifying synonymous data items included in each table and integrating their columns, and a method of integrating search item data related to the same record included in each table.
[0005]
As such an integrated search technology, there is Japanese Patent Application Laid-Open No. 5-89320 "Information search device". FIG. 13 shows a search based on item identification using an item correspondence table. In this method, as shown in FIG. 13, an item correspondence table having the same name and the same meaning is automatically and interactively created in advance, and the corresponding items are identified and identified, so that the table exists over a plurality of tables. Merge columns. In other words, queries with the same structure for each information source
[SELECT name, age]
And integrate the results.
[0006]
Japanese Unexamined Patent Application Publication No. 11-175552 "Computer-readable recording medium recording a database search device and a database search program", as shown in FIG. ), And the data of the same record number (record number: 1)
[SELECT name, age, height, weight]
To integrate. In the condition search, a condition search [WHERE age <30, weight <70] is performed on the information after integration. This results in results not available from separate tables
[Record number: 1, Name: Aiyou, Age: 20, Height: 170, Weight: 60]
Search for.
[0007]
[Problems to be solved by the invention]
However, the above conventional method has the following problems.
[0008]
For example, suppose that the inquiry shown in FIG. 16 is performed on a plurality of tables shown in FIG. 15 to derive the search results shown in FIG. In each table shown in FIG. 15 (diagnosis, appendicitis treatment, appendicitis patient), information on the patient is registered. The inquiry sentence ((1) to (3)) shown in FIG. 16 is created in response to a request to “search for information on appendicitis patients”.
[0009]
Normally, when a plurality of search results are integrated using a UNION operator, the number of search items specified in each query statement, the order, and the data type of each item need to match. However, since the number of items in each inquiry sentence shown in FIG. 16 does not match, integration by UNION cannot be performed.
[0010]
Further, in the above-mentioned JP-A-5-83320 and JP-A-11-175552, search conditions for a specific table are not considered. That is, since the search condition for a specific table cannot be specified, the meaning of the items or the table itself may be lost due to the integration of the tables. Therefore, the search condition (“WHERE result = appendicitis” of (1)) for the specific table to which the inquiry shown in FIG. 16 is specified becomes invalid. As shown in FIG. 18, when only the integration of the data items is performed, data that does not satisfy the inquiry content is included in the search result. If search conditions are specified for all tables as well as search items, data that satisfies the contents of the query will be omitted from the search results. In any case, the search results shown in FIG. 17 cannot be obtained. That is, when only the merging of the data items of (1) is performed on the item correspondence table shown in FIG. 18 ([SELECT name, age, gender]), [diagnosis. Patient name, appendicitis treatment. Patient name, appendicitis patient. [Name] is changed to [Name] and [Appendicitis treatment. Age, appendicitis patient. "Age" to "age" and "Appendicitis patient. Gender] is integrated into “gender”, respectively, and becomes a search target. As can be seen from the search result of (1), patients (normal) other than "appendicitis" are also searched from the item of "diagnosis" in the item correspondence table.
[0011]
Next, when the search conditions ([SELECT name, age, gender], [WHERE result = appendicitis]) are applied to all tables, the information of the table "Appendicitis treatment" and "Appendicitis patients" is not retrieved. appear.
[0012]
Further, in Japanese Patent Application No. 5-83320, the correspondence definition is static, so that the table to be searched is changed, the name of a search item that can be input by the user as a search request is changed, or Even when the table is the same, it is necessary to modify the correspondence definition each time the usage scene is changed. It is impossible to define every correspondence in advance. Also, as the definition increases, the possibility that the search result includes unnecessary information increases.
[0013]
In a relational database, there is a concept called a view, and a data search operation can be interpreted as creating a table having a new meaning from a base table (also called a table). The view defines the operation and the table as a virtual object having no substance. Since the view is the result of a search operation, in order to perform a search on a plurality of tables having different data structures (also called schemas) and obtain integrated search results, a query statement for each table is required. Must be adjusted. In order to make adjustments, it is necessary to be familiar with the structure of the table and the query method.
[0014]
The present invention has been made in view of the above points, and is directed to a plurality of tables that are logically independently constructed. The number and order of search items, the data type of each item, and a plurality of different search conditions are different. An object of the present invention is to provide an integrated search method and apparatus capable of searching by a query sentence and a storage medium storing an integrated search program.
[0015]
A further object of the present invention is to store an integrated search method and apparatus and an integrated search program capable of flexibly coping with a change of a search function such as a search item name that can be input as an information source or a search request, and a search use scene. It is to provide a storage medium.
[0016]
[Means for Solving the Problems]
FIG. 1 is a diagram for explaining the principle of the present invention.
[0017]
The present invention (claim 1) provides a plurality of logically independently constructed databases.Search targetIn an integrated search method for searching a table using a plurality of query sentences having different structures and obtaining one search result,
In the query sentence input means,From the userInput,Accepts multiple inquiries (step 1),
In the search item obtaining means,Extract all search items from the query (step 2)
In the item identification determination means,A synonym dictionary that defines synonyms for data item names,Refer to based on the extracted search items, extract items that have the same data item name as synonyms, identify them as identical, and present them to the user.(Step 3),
In the output table creation means,Identification identified by the userResultAccording toCreate an output table that defines the search items extracted from the query statement as data items and store them in the database.(Step 4),
Data items of the output table created by the output table creation means in the query sentence correction meansInquiries according toCorrect the order of the search items and add an insert instruction to insert the search results into the output table.(Step 5),
In the inquiry execution means,Using the modified query,Search the table to be searched(Step 6),
In the search result output means,The searched result is output to the user (step 7).
[0018]
The present invention (claim 2) creates a synonym dictionary as a dictionary that manages only the vocabulary of registered words without managing the correspondence between data items in the table to be searched.
[0019]
The present invention (claim 3)In the inquiry execution means,When searching the table to be searched, the search result is derived in one table format.
[0020]
FIG. 2 is a diagram illustrating the principle of the present invention.
[0021]
The present invention (Claim 4) provides a plurality of logically independently constructed databases.Search targetAn integrated search device for searching a table using a plurality of query sentences having different structures and obtaining one search result,
Defined synonyms for data item namesA synonym dictionary 180,
A query sentence input unit 110 for receiving a plurality of query sentences from a user;
Search item obtaining means 120 for extracting all search items from the query sentence;
Synonym dictionary 180, Refer to based on the extracted search items, extract the results of identification as items having the same data item name as synonyms, and present them to the userItem identification determination means 130,
Identification identified by the userResultAccording toOutput table that defines search items extracted from query statements as data itemsCreateAnd store it in the databaseOutput table creation means 140,
Data items in the created output tableInquiries according toCorrect the order of the search items and add an insert instruction to insert the search results into the output tableQuery sentence correcting means 150;
Using the modified query,Search the table to be searchedInquiry execution means 160;
A search result output unit 170 for outputting a search result to a user;,Having.
[0022]
According to the present invention (claim 5), the synonym dictionary 180 manages only the registered vocabulary without managing the correspondence in the table to be searched.To be.
According to the present invention (claim 6), in the inquiry execution means 160,When searching the table to be searched,Deriving search results in one table format.
[0023]
According to the present invention (claim 7), in the query sentence correcting unit 150, a query sentence having the same number of search items, the order, and the data type of each item is made into one query sentence using the operator UNION. including.
[0024]
The present invention (claim 8) relates to a plurality of logically independently constructed databases.Search targetA storage medium storing an integrated search program for searching a table using a plurality of query sentences having different structures and obtaining one search result,
On the computer,
Query sentence input that accepts multiple query sentences from the userStepsWhen,
Search item acquisition to extract all search items from query textStepsWhen,
A synonym dictionary that defines synonyms for data item names,Refer to based on the extracted search items, extract items with the same data item names as synonyms, identify them as identical, and present them to the user.Search item identificationStepsWhen,
Identification identified by the userResultAccording toCreate an output table that defines the search items extracted from the query statement as data items and store them in the databaseCreate output tableStepsWhen,
Data items in the created output tableInquiries according toCorrect the order of the search items and add an insert instruction to insert the search results into the output tableInquiry sentence correctionSteps and
Using the modified query,Search the table to be searchedInquiry executionSteps and
Search result output to output search results to the userAnd a storage medium storing a program for executing the steps.
[0025]
The present invention (claim 9) creates a synonym dictionary as a dictionary that manages only the vocabulary of registered words without managing the correspondence between data items in the table to be searched.StepsMoreRun.
[0026]
The present invention (claim 10) implements an inquiryStepsAtWhen searching the table to be searched,Deriving search results in one table format.
[0027]
According to the present invention (claim 11), an inquiry sentence is corrected.StepsIn the above, for a query sentence in which the number, order, and data type of each item are the same, one query sentence is created using the operator UNION.StepsIs executed.
[0028]
As described above, the present invention prepares a synonym dictionary and, when a plurality of query sentences having different structures are received, converts each result into one by converting the query sentence so as to obtain one search result. Integration into a table enables easy retrieval of integrated search results.
[0029]
BEST MODE FOR CARRYING OUT THE INVENTION
FIG. 3 is a functional block diagram illustrating an outline of the present invention.
[0030]
The integrated search device 100 shown in the figure includes a query sentence input unit 110, a search item acquisition unit 120, a search item identification determination unit 130, an output table creation unit 140, a query sentence correction unit 150, a query execution unit 160, a search result. It comprises an output unit 170, a data item name meaning management dictionary 180, and a table 190.
[0031]
The data item name meaning management dictionary 180 manages data item names semantically using a synonym dictionary in which synonyms are set for each registered word. Hereinafter, the data item name meaning management dictionary 180 is referred to as a synonym dictionary.
[0032]
The query sentence input unit 110 receives from the user 10 a plurality of query sentences having different numbers of search items, data types of the respective items, and search conditions.
[0033]
The search item obtaining unit 120 extracts all search items from each inquiry sentence.
[0034]
The search item identification determination unit 130 determines the identity of each search item extracted by the search item acquisition unit 120 with reference to the synonym dictionary 180. Items whose item names are defined as synonyms in the dictionary are regarded as identical. However, even if the item names are synonymous, in practice, in order to prevent items having information with different meanings from being identified with each other, all combinations of items that can be identified with each other are presented to the user and output as It is also possible to select a required combination. As a result, a combination of identifications of identified search items is derived, and a data item name of an output table is determined by a user selecting an identification combination.
[0035]
The output table creating unit 140 generates a command sentence for creating an output table based on the result of the identification by the search item identification determining unit 130, and generates an output sentence having all data items extracted from the query sentence. Create a table. The form of the table may be a view table (virtual table, data entity) in the database in addition to the base table.IsWithout itMakingDefinition only).
[0036]
The query sentence correcting unit 150 adds an insert command to each input query sentence so as to insert the search result into the output table, and corrects the order of the search items of the query sentence. Further, in consideration of improvement in search efficiency, a query sentence having the same number, order, and data type of each search item can be made into one query sentence using the operator UNION.
[0037]
The inquiry execution unit 160 executes an inquiry to be corrected for each search target table, and sequentially inserts search results into a table for output. After inserting all the results, completely duplicated rows can be deleted.
[0038]
The search result output unit 170 outputs the output table in which the results of all the corrected inquiries are inserted to the user as search results based on a plurality of query sentences.
[0039]
The table 190 is a search target table that is constructed logically independently.
[0040]
Next, the operation of the present invention will be described.
[0041]
FIG. 4 is a flowchart for explaining the operation of the present invention.
[0042]
Step 101) The synonym dictionary 180 is set as a precondition for performing the processing after step 102. The synonym dictionary 180 defines synonyms of data item names, and does not define the correspondence between items. A plurality of data items determined as synonyms by this dictionary are candidates for identification. In addition, the user 10 can designate an item name registered in the dictionary or a synonym thereof as a search item. If a table to be searched is added and the table contains unregistered data items, or if the user 10 adds an item name that can be specified as a search item, the table is added to the synonym dictionary 180. Register the item name and synonym newly. As the synonym dictionary 180, a dictionary set by the administrator of the search system or a commercially available thesaurus dictionary can be used.
[0043]
Step 102) The query input unit 110 receives a plurality of query from the user.
[0044]
Step 103) The search item acquisition unit 120 extracts all search items from each inquiry sentence.
[0045]
Step 104) The search item identification determination unit 130 refers to the synonym dictionary, confirms synonyms for all search items, and regards search items whose item names are synonyms to be the same.
[0046]
Step 105) The output table creation unit 140 creates a table having all search items as data items in consideration of the result of identification.
[0047]
Step 106) The query sentence correcting section 150 corrects the order of the search items on the premise of output (or corrects the structure of each search command sentence to be the same using NULL), and returns the search result. To be inserted into the output table. Step 107) The query execution unit 160 executes each of the corrected search statements for each information source.
[0048]
Step 108) The search result output unit 170 outputs the output table into which the results of all the corrected inquiries have been inserted as search results based on a plurality of query sentences.
[0049]
As described above, a search using a plurality of query sentences having different numbers of search items, data types of the respective items, and search conditions can be realized.
[0050]
【Example】
Hereinafter, embodiments of the present invention will be described with reference to the drawings.
[0051]
In the following embodiment, based on the flowchart shown in FIG.ToAn example in which a search is performed on the three information sources shown (diagnosis, appendicitis treatment, and appendicitis patients) will be described.
[0052]
FIG. 5 shows an example of a synonym dictionary according to an embodiment of the present invention. In the figure, * indicates a backward match, for example, the patient's name is included in “* Name”.
[0053]
In the following, a description will be given of the inquiry sentence input processing after step 102.
[0054]
As a query sentence input process (step 102), a plurality of query sentences are received from the user. In the example, it is assumed that three inquiry sentences shown in FIG. 16 are input for the purpose of searching for “appendicitis patient” from the three information sources shown in FIG. When each inquiry is performed individually, search results (1) to (3) shown in FIG. 6 are obtained.
[0055]
Next, as search item acquisition processing (step 103), all search items are identified from each inquiry sentence. In the example, the following six items are identified as search items from three query sentences.
[Diagnosis. Patient name, appendicitis treatment. Patient name, appendicitis treatment. Age, appendicitis patient. Name, patient with appendicitis. Gender, appendicitis patient. age]
Next, as a search item identification determination process (step 104), a combination of search items that can be identified is identified by referring to the synonym dictionary 180. When referring to the synonym dictionary 180 shown in FIG. 5, it is possible to collect up to three items at a minimum.
[0056]
[Patient name, patient name, name is “name”, age is “age”, and gender is “gender”]
The data items of the table output as the search result differ depending on the combination of the search items to be identified. Therefore, all combinations are output as candidates, so that an optimal combination can be selected according to a user's request. FIG. 7 shows all combinations of search items to be identified. In the figure, it means that items with the same number are identified with each other. All the combinations of the search items shown in FIG. 7 acquired in this way are presented to the user, and the user is made to select.
[0057]
Next, as an output table creation process (step 105), data items are defined in accordance with a combination of search items identified by the user and identified, and a framework of a table to be output as a search result is created. This may be any means that creates a table (including virtual ones) according to the combination of search items to be identified. Here, an example in which a table is actually created in a database will be described. FIG. 8 is a diagram for explaining the creation of a search result output table according to one embodiment of the present invention. In the case where the search items are grouped into three items ((6) in FIG. Here is an example of a table creation command statement (when selected).
[0058]
As for the data type of each data item in the output table, the data type in the search target table 190 is applied as it is. For data items that have been identified, a data type that can absorb all the data types of each search item before identification is applied. For example, when a search item of a character type of 20 characters and a search item of a character type of 15 characters are identified, the data item in the output table is a character type of 20 characters.
[0059]
Next, as an inquiry sentence correction process (step 106), an insertion instruction is added to each input inquiry sentence so as to insert a search result into an output table, and the order of search items is corrected. FIG. 9 shows each of the modified inquiry sentences. FIG. 10 shows a query sentence for obtaining a result in the form of a virtual table, a view table.
[0060]
Next, as a query execution process (step 107), each query is performed on the search target table 190 using a query sentence into which the command shown in FIG. 9 is inserted. As a result, the output table is as shown in FIG. In order to improve search efficiency, at the stage of query execution, query sentences having the same number, order, and data type of each search item are combined into one query sentence using the UNION operator, and the search is performed. I do.
[0061]
Also, after inserting the full search, completely duplicated rows can be deleted.
[0062]
Finally, as a search result output process (step 108), an output table (FIG. 17) is output to the user as a search result.
[0063]
With the above processing, the present invention enables the following.
[0064]
Conventionally, a search that obtains a single table as a result from a plurality of query sentences having different structures cannot be realized, but in the present invention, first, a table for outputting a search result is created, and a plurality of query results are sequentially inserted therein. By performing a search using multiple query statements with different numbers of search items, data types of each item, and search conditions, the search results are always output as a single table. It is possible to reduce the burden on establishing the result.
[0065]
Conventionally, when changing the table to be searched, it is necessary to add the item name and define the correspondence with the already registered items. However, in the present invention, when the table to be searched is changed, In addition, the setting relating to the data item name management only requires additional registration having the same meaning as an unsupported data item name, so that it is possible to flexibly cope with a change in the table to be searched.
[0066]
Conventionally, an item correspondence table is prepared in advance, and only static integration according to the defined correspondence is performed. When a user request is changed, the item correspondence table needs to be changed accordingly. However, in the present invention, all search items are identified from a plurality of query sentences, and all combinations of items that can be identified by referring to a synonym dictionary are output and can be selected, so that they can be used at any time. It is possible to realize the integration of search results requested by the user. For example, in the above embodiment, it is assumed that the age of the information source “appendicitis treatment” refers to the age at the time of treatment, and the age of “appendicitis patient” refers to the current age. In this case, these data items should not be identified. In the present invention, a search result as shown in FIG. 11 can be obtained by selecting a combination that does not identify them when selecting combinations of item identification. In the conventional search method using the item correspondence table, in order to make such a change, the correspondence table must be corrected.
[0067]
In the above embodiment, the description has been given based on the flowchart shown in FIG. 4. However, the flowchart is constructed as a program, and a disk device connected to a computer used as an integrated search device, a floppy disk, a CD-ROM The present invention can be easily realized by storing it in a portable storage medium such as the above and installing it when implementing the present invention.
[0068]
It should be noted that the present invention is not limited to the embodiments described above, and various modifications and applications are possible within the scope of the claims.
[0069]
【The invention's effect】
As described above, according to the present invention, it is possible to satisfy a request of a user who does not know the structure of a table or the like by performing a search using a plurality of query sentences having different structures as automatically generated.
[0070]
In addition, the search function can flexibly respond to changes in information sources, search item names that can be input as search requests, search use scenes, and the like.
[Brief description of the drawings]
FIG. 1 is a diagram for explaining the principle of the present invention.
FIG. 2 is a principle configuration diagram of the present invention.
FIG. 3 is a functional block diagram illustrating an outline of the present invention.
FIG. 4 is a flowchart for explaining the operation of the present invention.
FIG. 5 is an example of a synonym dictionary according to an embodiment of the present invention.
FIG. 6 is a diagram showing a result of executing each inquiry according to the embodiment of the present invention.
FIG. 7 is an example of a combination of identifying data items according to an embodiment of the present invention.
FIG. 8 is a diagram for explaining creation of a table for outputting search results according to one embodiment of the present invention.
FIG. 9 is an example of performing a search and inserting a result into an output table according to an embodiment of the present invention.
FIG. 10 is an example of a query sentence for obtaining a search result as a view table according to an embodiment of the present invention.
FIG. 11 shows a search result obtained by changing a combination of data items being identified in one embodiment of the present invention.
FIG. 12 is a diagram for explaining union query combination and unified search by UNION.
FIG. 13 is a diagram for explaining a search based on item identification using an item correspondence table.
FIG. 14 is a diagram illustrating a search by data integration according to a record number.
FIG. 15 is an example of a search target information source.
FIG. 16 is an example of a query sentence having a different structure.
FIG. 17 shows a target search result.
FIG. 18 is a diagram for explaining a problem that a condition cannot be specified for a specific table.
[Explanation of symbols]
10 Users
100 Integrated search device
110 Query sentence input means, Query sentence input unit
120 search item acquisition means, search item acquisition unit
130 search item identification determination means, search item identification determination unit
140 output table creation means, output table creation section
150 Inquiry sentence correcting means, Inquiry sentence correcting unit
160 inquiry execution means, inquiry execution section
170 Search result output means, search result output unit
180 Synonym dictionary (data item name meaning management dictionary)
190 Table to be searched

Claims (11)

In an integrated search method for searching a plurality of search target tables logically independent of a database using a plurality of query statements having different structures and obtaining one search result,
In the query sentence input means, a plurality of query sentences input by the user are received,
In a search item obtaining means, extract all search items from the inquiry sentence,
In the item identification determining means, a synonym dictionary defining synonyms of the data item names is referred to based on the extracted search items, and items in which the data item names are synonyms are regarded as being the same and are regarded as being identical. Extract the result, present it to the user,
In the output table creation means, according to the result of the identification selected by the user, create a table for output defining the search items extracted from the query sentence as data items, and store it in the database,
In the query sentence correcting means, the order of the search items of the query sentence is corrected in accordance with the data items of the output table created by the output table creating means, and the search result is stored in the output table. Add an insert instruction to insert,
In the query execution means, using the corrected query sentence, search the table of the search target,
An integrated search method, wherein the search result output means outputs the searched result to the user. The integrated search method according to claim 1, wherein the synonym dictionary is created as a dictionary that manages only the registered vocabulary without managing the correspondence in the table to be searched. In the inquiry performing means, when searching the table to be searched,
2. The integrated search method according to claim 1, wherein the search results are derived in one table format. An integrated search device for searching a plurality of search target tables logically independent of a database using a plurality of query statements having different structures and acquiring one search result,
A synonym dictionary that defines synonyms for data item names ,
A query sentence input means for receiving a plurality of query sentences from a user,
Search item obtaining means for extracting all search items from the query sentence,
The synonym dictionary is referred to based on the extracted search item, and items whose data item names are synonyms are extracted as the same item, and a result of identification is extracted, and an item identification determination to be presented to the user is performed. Means,
According to the identification result selected by the user, an output table creating means for creating an output table defining search items extracted from the query sentence as data items , and storing the table in a database ,
Query sentence correcting means for correcting the order of the search items of the query sentence in accordance with the data items of the created output table, and adding an insert command for inserting a search result into the output table. When,
Inquiry executing means for performing a search of the table to be searched using the corrected query,
Integrated search apparatus characterized by comprising: a search result output means for outputting the results retrieved to the user, the. The synonym dictionary,
The search correspondence relationship in table subject without administration integrated search apparatus to that claim 4, wherein the dictionary management only vocabulary after the registration. The inquiry execution means,
The integrated search device according to claim 4, wherein when searching the table to be searched , the search result is derived in one table format. The inquiry sentence correcting means,
5. The integrated retrieval apparatus according to claim 4, further comprising means for using the operator UNION to form a single query sentence for a query sentence having the same number, order, and data type of each search item. A storage medium storing an integrated search program for searching a plurality of search target tables constructed independently of a database using a plurality of query statements having different structures and obtaining one search result. hand,
On the computer,
A query sentence input step for receiving a plurality of query sentences from a user;
A search item acquisition step of extracting all search items from the inquiry sentence,
A synonym dictionary that defines synonyms of data item names is referred to based on the extracted search items, and items in which data item names are synonyms are extracted as the same item, and a result of identification is extracted. A search item identification determination step to be presented to the user,
According to the result of the identification selected by the user, an output table creating step of creating an output table defining search items extracted from the query sentence as data items, and storing the table in a database ;
Inquiry sentence correcting step of correcting the order of the search items of the inquiry sentence according to the data items of the created output table and adding an insert instruction for inserting a search result into the output table. When,
A query execution step of performing a search of the table to be searched using the corrected query sentence ,
A storage medium storing an integrated search program, wherein a program for executing a search result output step of outputting a searched result to the user is stored . 9. The integrated search program according to claim 8, further comprising the step of creating the synonym dictionary as a dictionary that manages only the vocabulary of registered words without managing the correspondence between data items in the table to be searched. The storage medium in which it was stored. The inquiry execution step includes:
9. The storage medium storing the integrated search program according to claim 8, wherein a search result is derived in one table format when searching the table to be searched . The query sentence correcting step includes:
9. A storage medium storing an integrated search program according to claim 8, wherein a step of using the operator UNION to make a single query sentence is performed for a query sentence having the same number, order, and data type of each search item. .

Images