JP3471666B2 - Keyword search method over multiple tables - Google Patents

Description

Detailed Description of the Invention

[0001]

TECHNICAL FIELD The present invention relates to a method for searching the contents of a plurality of tables by keywords.

[0002]

2. Description of the Related Art A conventional keyword search method over a plurality of tables will be described below.

For example, when it is desired to know the price of "apple" recorded in one table, the value of the item field of the table is set to "apple" and the record in which the value of the item field is "apple" is searched. Will be done.
The SQL statement for this is, for example, SELECT * FROM TABLE1 WHERE NAME = "apple".

Assuming that each table records the price of each product variety of each year, in order to examine the price fluctuation of apples, in order to investigate the price fluctuation of apples, the table of the record shown above is used for the table in which the product variety of each product product over several years is fruit. The search procedure will be repeated.

[0005]

However, in the above-mentioned conventional keyword search method over a plurality of tables,
When the number of tables is enormous, it is troublesome to extract the table that includes the item for which you want to know the price fluctuation, so you have to search all the tables, so a lot of time is spent on the search. Was there.

[0006] Therefore, an object of the present invention is to provide a method for enabling the contents of a plurality of tables to be searched at high speed by keywords.

[0007]

According to a keyword search method for a plurality of tables according to the present invention, a plurality of first extraction tables each having a keyword field used for a keyword search of a plurality of search target tables as a keyword field. And a keyword pair having a name of each of the plurality of first extraction tables as a name field and the keyword field of the first extraction table as a keyword field. A second generation step of generating an extraction table name table in the recording medium, and a table list table having a name of each of the plurality of first extraction tables as a first name field and a record number as a record number field. Third generation generated on the recording medium And a first extraction table name-record number table having the table and the first name field of the table list table as the name field and the record number field of the table list table as the record number field in the recording medium. Refer to the keyword-to-first extraction table name table for the fourth generation step, the input step of inputting a keyword from the user through the input device, and the name of the first extraction table having the input keyword. And a record number of the table list table having the name of the retrieved first extraction table in the first name field in the first extraction table name vs. record number table. A second searching step for searching by reference; and the table A fifth generation step of generating a search result table consisting records retrieved record number of list table, a first display step of displaying on the output device the search result table,
A second display step of displaying the contents of the first extraction table of the name in the first name field of the record selected by the user via the input device of the search result table on the output device; It is characterized by having.

A keyword search method for a plurality of tables according to the present invention is the keyword search method for a plurality of tables described above, wherein the contents of the keyword fields of the plurality of first extraction tables are non-overlapping in a keyword field. Further comprising: a fifth generating step for generating in the recording medium; and a determining step of determining whether or not the keyword input in the input step is in the keyword field of the keyword table. If the determination result in step 1 is false, the steps from the first search step are not performed.

Further, a keyword search method for a plurality of tables according to the present invention is the method for a keyword search for a plurality of tables described above, wherein a plurality of second search fields each having a field that is not used for keyword search of each of the plurality of search target tables are provided. A sixth generation step of generating an extraction table on the recording medium, wherein the table list table and the search result table further have names of the plurality of second extraction tables as a second name field, In the second display step, in addition to the contents of the first extraction table of the name in the first name field, the contents of the second extraction table of the name in the second name field are displayed. And

Further, a keyword search method for a plurality of tables according to the present invention is the above keyword search method for a plurality of tables, wherein a plurality of keywords are input in the input step, and in the first search step,
It is characterized in that the names of the first extraction table of the records that are duplicated among the records retrieved corresponding to each of the plurality of keywords are used as the retrieval result.

Further, a keyword search method for a plurality of tables according to the present invention is the above keyword search method for a plurality of tables, wherein a plurality of keywords are input in the input step, and in the first search step,
It is characterized in that the name of the first extraction table of the record of the sum total of the records searched corresponding to each of the plurality of keywords is used as the search result.

Further, a keyword search method for a plurality of tables according to the present invention is the above keyword search method for a plurality of tables, wherein a keyword of a search target table corresponding to the extraction table is set in one of the keyword fields of the plurality of extraction tables. The method further comprises an additional step of adding a record having a content other than the content of the field.

A computer-readable recording medium according to the present invention is characterized in that a program for causing a computer to execute the above-described keyword search method across a plurality of tables is recorded.

[0014]

DETAILED DESCRIPTION OF THE INVENTION Embodiments of the present invention will be described in detail below with reference to the drawings.

FIG. 1 shows one of the tables to be searched.
An example configuration is shown. Each table to be searched is hereinafter referred to as a “search target table”. Referring to FIG.
Each record in the table consists of a NAME field and a PRICE field. FIG. 1 shows a price table of fruits in a predetermined year (for example, 1999), but the price table of fruits in other years and the price table of each year for other varieties such as vegetables are similar. It is configured and these are the targets of the search. The search target table is recorded in a recording medium such as a hard disk connected to the computer.

FIG. 2 shows a table group generated in the embodiment of the present invention. Referring to FIG. 2, the table group includes a table list table 1, a numerical value table 2, a character table 3, a keyword table 4, a keyword-to-character table name table 5, and a character table-to-record number table 6.
It is composed of The table group is recorded in a recording medium such as a hard disk connected to the computer.

The description of each table will be given below.

Each record in the table list table 1 is
It is composed of an ID field indicating a record number, a numeric table field storing the name of a numeric table, a character table field storing the name of a character table, and a table description field storing the description character of the search target table. It should be noted that an HTML table is generated as a result of the search based on the table list table 1, and the OnCkick event handler of any of the fields such as the ID field and the table description field of the HTML table includes each record of the table list table. A method for displaying the associated search target table is associated. Note that only the ID field and the table description field may be displayed in the HTML document. Further, the generated HTML table is composed of only the records narrowed down as a result of the search among all the records in the table list table 1. Or
The generated HTML table is the table list table 1
It consists of all records of, but only the records narrowed down as a result of the search are displayed specially.

The numerical table 2 is a table in which the price of each item stored in each search target table is stored, and each record is a BUN in which the identifier of each item in the search target table is stored. It consists of a field (BUN is the first letter of the "classification" in Roman letters) and a PRICE field that stores the price of each item. The numerical value table 2 is generated for each search target table.

The character table 3 is a table in which the names of the respective items stored in the respective retrieval target tables are stored, and each of these records is a BUN in which the identifier of each item in the retrieval target table is stored. It consists of a field and a NAME field that stores the name of each item. The BUN field of the numerical table 2 and the character table 3
The BUN field of 1 corresponds to 1: 1. Character table 3
Is generated for each search target table.

The keyword table 4 is a table in which the item names stored in at least one search target table among all the search target tables are stored.

Keyword-to-character table name table 5
Is a table that stores the name of the character table that stores the item name for each item name. Each record contains the NAME field that stores the item name and the item whose name is stored in the NAME field. It is composed of a table name field in which the name of the character table in which is stored. In the example of FIG. 2, there is only one record in which the value of the NAME field is "apple", but there may be other records. That is, the NAME field and the table name field have a one-to-many relationship.

Character table vs. record number table 6
Is the record number (I where the character table 3 is stored in the table list table 1 for each character table 3).
D) is stored in each table, and each record has a record number in which a character table field in which the name of the character table is stored and a character table having a name indicated by the character table field are stored in the table list table 1. It is composed of stored ID records.

Next, a method of generating each table will be described below.

The numerical value table 2 is generated by extracting the price field from each search target table. The character table 3 is generated by extracting the item field from each search target table. Also, numerical table 2
When the character table 3 is generated, the BUN of the numerical value table 2 and the value of the BUN field of the character table 3 for the same item are made the same.

The keyword table 4 is generated by adding the values of the NAME fields of all the character tables 3 without duplication.

Each record of the keyword-to-character table name table 5 is based on the character table 3 and is based on the character table 3.
It is generated by the value of the NAME field of each record included in and the name of the character table 3.

Each record in the table list table 1 is
When the numerical table 2 and the character table 3 are generated, their names are generated as the values of the numerical table field and the character table field. The ID field is, for example, an automatic serial number. The contents of the table description field are created based on the contents input to the computer by the user through an input device such as a keyboard, for example.

Character table vs. record number table 6
Is generated by extracting the ID field and the character table field of the table list table 1.

Next, a method of displaying a search target table including keywords will be described with reference to FIG.

First, H displayed by the user on the computer
A keyword is input to the computer on the screen of the TML document via an input device such as a keyboard (step S2).
01). The input position on the screen is, for example, a predetermined edit box on the HTML document.

Next, it is checked whether or not the input keyword is stored in the keyword table 4 (step S202). If it is stored, the process proceeds to step S203, and if it is not stored, the process ends.

Next, the name of the character table in which the input keyword is stored is searched by referring to the keyword-to-character table name table 5. The number of character tables is singular or plural (step S20).
3).

Next, the number of the record of the table list table 1 which stores the name of the retrieved character table is retrieved by referring to the character table-record number table 6 (step S204).

Next, among the records of the table list table 1, an HTML table including only records having the retrieved record number or an HTML table in which the record having the retrieved record number is specially displayed is generated (step S205). .

Next, the generated HTML table is displayed (step S206).

Next, the user selects and clicks the retrieved record in the HTML table (step S207).

Next, using the numeric table 2 whose name is stored in the numeric table field of the clicked record among the records in the HTML table and the character table 3 whose name is stored in the character table field of that record, , Which consists of records consisting of item names and prices, and which has the same contents as the corresponding search target table is displayed. At this time, only the record having the keyword input as the item name may be displayed, or all the records of the numerical value table 2 and the character table 3 may be displayed (step S208).

Next, the user clicks a predetermined position (such as the position of the return button) on the HTML document for redisplaying the HTML table (step S209).

From step S209 to step S206
Return to.

The above is the method of displaying the search target table including the keyword.

In the above embodiment, the item name is used as the keyword, but the contents of other fields may be used as the keyword. Also, although it has been stated that each table of the search target table has only the price field in addition to the item name field, the price field may be another field, and another field of the price field may be added. It may be done.

Further, the user holds a character string such as “variation”, “transition”, “xx year”, “fruit” in the character table 3 as the contents of the NAME field through the input device such as a keyboard. You may make it select these character strings as a keyword, when adding a record and inputting the keyword at the time of a search. At this time, the record corresponding to the added record in the character table 3 may not be present in the numerical value table 2. By doing so, it becomes possible to search for the target search target table using the character string that describes the search target table.

Further, a plurality of keywords at the time of retrieval may be set, and the logical product or logical sum of the character tables corresponding to the respective keywords may be taken in step S203, and the result may be used as the character table as the result of step S203. . That is, among the character tables searched for each keyword, only the character tables overlapping between the keywords may be used as the character table as the result of step S203, or the character table searched for each keyword may be used. All of the keywords may be used as the character table as the result of step S203.

Further, in order to add a record having a character string such as "variation", "transition", "XX year", and "fruit" as the contents of the NAME field to the character table 3, the keyword is searched at the time of retrieval. Instead of inputting, a sentence is input, the words extracted by decomposing the sentence are used as a plurality of keywords, and in step S203, the logical product or logical sum of the character tables corresponding to each keyword is taken, and the result is stepped. It may be a character table as a result of S203.

The method of generating each table and the method of displaying a search target table including a keyword according to the above embodiment (excluding the step of input by the user).
Can also be realized by the computer reading and executing the program from a recording medium such as a CD-ROM in which a program for causing the computer to execute the method is recorded.

At this time, the CPU of the computer is usually used.
The operating system temporarily transfers the program from the recording medium to the main memory, then reads the program from the main memory and executes the program.

The above program may be generated by a text format file in which an interpreter format instruction is described and an interpreter that reads this file and converts it into an execution instruction.

[0049]

As described above, according to the present invention,
Since the search target table can be narrowed down by the keyword, there is an effect that the search time can be shortened.

[Brief description of drawings]

FIG. 1 is a diagram showing a configuration example of a search target table according to an embodiment of the present invention.

FIG. 2 is a diagram showing a table group generated in the embodiment of the present invention.

FIG. 3 is a flowchart illustrating a method of displaying a search target table including a keyword according to an exemplary embodiment of the present invention.

[Explanation of symbols]

1 table list table 2 Numerical table 3-character table 4 keyword table 5 Keyword-to-character table name table 6-character table vs. record number table 101 search target table

─────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Makoto Yamaguchi 5-7-1 Shiba, Minato-ku, Tokyo Within NEC Corporation (56) Reference JP-A-4-304559 (JP, A) JP-A-8 -36514 (JP, A) JP 10-55373 (JP, A) JP 10-143538 (JP, A) (58) Fields investigated (Int.Cl. ⁷ , DB name) G06F 17/30 414 G06F 17/30 180 JISST file (JOIS)

Claims (7)

(57) [Claims] 1. A first generation step of generating, on a recording medium, a plurality of first extraction tables each having a keyword field used as a keyword field for keyword search of each of a plurality of search target tables, said plurality of Second generation of generating a keyword-to-first extraction table name table having the name of each of the first extraction tables as a name field and the keyword field of the first extraction table as a keyword field in the recording medium. And a third generation step of generating a table list table having a record number field as a record number field and a name of each of the plurality of first extraction tables as a first name field, and the table. Name the first name field of the list table As a field, a fourth generation step of generating a first extraction table name-record number table having the record number field of the table list table as a record number field in the recording medium, and from a user via an input device. An input step of inputting a keyword, a first search step of searching the name of the first extraction table having the input keyword with reference to the keyword vs. first extraction table name table, and a first searched Second search step of searching the record number of the table list table having the name of the extraction table in the first name field with reference to the first extraction table name-record number table, and the table list table Search result table consisting of the record with the searched record number of A fifth generation step of generating a search result table, a first display step of displaying the search result table on an output device, a first display step of the record selected by the user via the input device of the search result table. A second display step of displaying the content of the first extraction table of the name in the name field of the above on the output device. 2. The keyword search method for a plurality of tables according to claim 1, wherein a keyword table having contents of the keyword fields of the plurality of first extraction tables in a non-overlapping keyword field is generated in the recording medium. The method further includes a fifth generation step and a determination step of determining whether or not the keyword input in the input step is in the keyword field of the keyword table, and the determination result in the determination step is false. A keyword search method across a plurality of tables, wherein the steps from the first search step are not performed in some cases. 3. The keyword search method for a plurality of tables according to claim 1 or 2, wherein a plurality of second extraction tables each having a field that is not used for keyword search of each of the plurality of search target tables are recorded. A sixth generation step of generating the medium, wherein the table list table and the search result table further have the names of the plurality of second extraction tables as a second name field, and the second display In the step, in addition to the contents of the first extraction table of the name in the first name field, the contents of the second extraction table of the name in the second name field are displayed. Keyword search method. 4. The keyword search method for a plurality of tables according to claim 1, wherein a plurality of keywords are input in the input step, and a plurality of keywords are input in the first search step. A keyword search method across a plurality of tables, wherein the names of the first extraction tables of the records that are duplicated among the records searched corresponding to each other are used as the search results. 5. The keyword search method for a plurality of tables according to claim 1, wherein a plurality of keywords are input in the input step, and the plurality of keywords are input in the first search step. A keyword search method across a plurality of tables, wherein the name of the first extraction table of the total sum of the records searched corresponding to each is used as the search result. 6. The keyword search method for a plurality of tables according to claim 1, wherein a keyword of a search target table corresponding to the extraction table is included in the keyword field of any one of the plurality of extraction tables. A keyword search method across a plurality of tables, further comprising an additional step of adding a record having a content other than the content of the field. 7. A computer-readable recording medium on which is recorded a program for causing a computer to execute the keyword search method for a plurality of tables according to claim 1. Description: