JP5874997B2 - SEARCH SYSTEM, SEARCH METHOD, AND PROGRAM - Google Patents

Description

  The present invention relates to a search system for searching data in a database, and further relates to a search method and a search program.

  In a business computer system used in a company, it may be required to add a search function to support data input. For example, in order to input a 7-digit zip code, a function is required to display on the terminal a list of zip codes that match the three digits simply by typing the first three digits of the zip code that the operator wants to input. There is a case. In addition to such a search function, if the operator selects a postal code to be input from the list, a function is also required in which a 7-digit postal code is input without typing the remaining four digits. May be.

  The search function as described above has various needs depending on the user company and the operator. For example, in order to input the above-described zip code, the operator simply types a part of the “address” corresponding to the zip code that the operator wants to input, and a list of zip codes that match the part of the address is displayed on the terminal. Sometimes functionality is required. In addition, for example, in order to input the above-described postal code, the operator only needs to type a part of the “reading kana” of the address corresponding to the postal code that the operator wants to input, and the postal code in which a part of the reading kana of the address matches There is a case where a function for displaying a list of the above is displayed on the terminal.

Conventionally, in order to respond to various needs of the search function, it has been necessary to individually develop programs according to individual needs.
For this reason, there is a possibility that the development cost increases as the number of search items increases.

JP-A-9-305611

  Therefore, an object of the present invention is to provide a search system, a search method, and a program that can respond to various search needs at low cost.

In order to solve the above problem, a search system according to one aspect of the present invention is a search system that can access a data table stored in a storage device, and accepts a search request including a search key and search target information. Means, and each record of the virtual table includes a first field including, as search items , data of a plurality of fields included in each record of the data table, and at least one included in each record of the data table The virtual table includes a second field including data of one field as a display item, and a third field including data of at least one field included in each record of the data table as a return value. Storage means for storing virtual table definition information to be defined in association with search target information The first field included in the plurality of records in the virtual table defined according to the virtual table definition information associated with the search target information received by the receiving unit using the search key received by the receiving unit A search means for performing a search for the data of the second field and a second field data included in at least one record extracted as a result of the search, and a plurality of records are extracted as a result of the search Output means for further outputting the data of the third field included in the one record when the data relating to one record is selected from the data relating to the plurality of records outputted. It has.

According to one aspect of the present invention , data in a plurality of fields of a data table is included in the first field of the virtual table according to the virtual table definition information associated with the search target information received by the receiving unit. By defining a virtual table and performing a search on this virtual table, it is possible to cope with various search needs by changing the definition of the virtual table. Therefore, it is possible to respond to various search needs at a low cost.

1 is a block diagram schematically showing a search system according to an embodiment of the present invention. In a 1st Example, it is a figure which shows the data structural example of the data table stored in the memory | storage device. It is a figure which shows the example of the information which defined the virtual table in a 1st Example. In a 1st Example, it is a figure which shows the example of a virtual table. In a 1st Example, it is a figure which shows the example of a search result. In a 2nd Example, it is a figure which shows the data structural example of the data table stored in the memory | storage device. In a 2nd Example, it is a figure which shows the example of the information which defined the virtual table. In a 2nd Example, it is a figure which shows the example of a virtual table. In a 2nd Example, it is a figure which shows the example of a search result.

  Hereinafter, a search system according to an embodiment of the present invention will be described in detail with reference to the drawings.

<1. Configuration of search system>
FIG. 1 is a block diagram schematically showing a search system according to an embodiment of the present invention. The search system shown in FIG. 1 includes an application server 20 connected to the client terminal 10 and a database server 30 connected to the application server 20. The client terminal 10, the application server 20, and the database server 30 are all computer devices including a CPU, a memory, a storage device, and the like.

  Although the search system is illustrated here as including a plurality of computer devices, the functions of these computer devices may be incorporated into one computer device.

  The client terminal 10 includes an input device 11, a search request unit 12, a search result receiving unit 16, and a display device 17. The input device 11 includes a keyboard and a mouse for inputting search conditions (search key W, search target x1). The search request unit 12 has a function of creating a search request including a search condition input by the input device 11 and transmitting the search request to the application server 20. The search result receiving unit 16 has a function of receiving a search result from the application server 20. The display device 17 includes a display device that displays input data such as search conditions input by the input device 11 and search result data received by the search result receiving unit 16.

  The application server 20 includes a search request receiving unit 22, a search request unit 23, a search result receiving unit 25, and a search result output unit 26. The search request receiving unit 22 has a function of receiving a search request from the client terminal 10. The search request unit 23 creates a search request including the search condition (search key W, virtual table definition information X) based on the search request received by the search request receiving unit 22, and the created search request is stored in the database server. 30. The search result receiving unit 25 has a function of receiving search results from the database server 30. The search result output unit 26 has a function of outputting at least a part of the search results (output table Z) received by the search result receiving unit 25 to the client terminal 10.

  The database server 30 includes a search request receiving unit 33, a search unit 34, and a search result output unit 35. The search request receiving unit 33 has a function of receiving a search request from the application server 20. The search unit 34 has a function of executing a search of the virtual table Y using the search key W based on the search request received by the search request receiving unit 33 and creating a search result (output table Z). The search result output unit 35 has a function of outputting the search result created by the search unit 34 to the application server 20.

  The virtual table Y is a table defined according to the definition information X. The data of the virtual table Y is not stored as real data as it is, but as the real data, various data tables 41 to 43 are stored in the storage device 40 connected to the database server 30. The virtual table Y looks at the data in the data tables 41 to 43 (existing tables) according to the definition information X. It can be said that the definition information X defines how to read the data tables 41 to 43.

<2. Operation of the search system>
First, as shown in FIG. 1, the client terminal 10 transmits a search request including a search condition (search key W, search target x1) input by the input device 11 to the application server 20, and the application server 20 Is accepted (S1).

  Next, the application server 20 creates a search request including a search condition (search key W, virtual table definition information X) based on the search request received from the client terminal 10, and uses the created search request as a database server. 30 (S2). The definition information X of the virtual table is stored in the storage device of the application server 20 in association with the search target x1.

  Next, the database server 30 searches the virtual table Y using the search key W based on the search request received from the application server 20, and creates a search result (output table Z) (S3). The virtual table Y is defined according to the definition information X.

Although a specific example of the definition information X will be described later, the definition information X may define two fields (Y1, Y2) in the virtual table Y. Then, the database server 30 executes a search in one of the fields (Y1) and creates an output table Z using the second field (Y2) included in the record extracted as a result of the search. Also good.
The definition information X may define at least three fields (Y1, Y2, Y3,...) In the virtual table Y. Then, the database server 30 executes a search in one of the fields (Y1), and uses the remaining fields (Y2, Y3,...) Included in the record extracted as a result of the search to search the output table Z. You may create it.

Next, the database server 30 outputs the created search result (output table Z) to the application server 20 (S4).
Next, the application server 20 outputs at least a part of the search result (output table Z) received from the database server 30 to the client terminal 10 (S5). In addition, after a part of the output table Z is output to the client terminal 10, when a new search key W is input at the client terminal 10, the above-described processing of S <b> 1 to S <b> 5 is repeated.

If each record of the output table Z has at least two fields (Z2, Z3), the application server 20 may output data of one field (Z2) included in each record to the client terminal 10. . Then, when one record of the output table Z is selected in the client terminal 10 and the selected information is sent to the application server 20, the application server 20 selects another field ( The data of Z3) may be output to the client terminal 10.
When each record of the output table Z has at least two fields (Z2, Z4), the application server 20 outputs data of at least two fields (Z2, Z4) included in each record to the client terminal 10. May be.

<3. First Example>
Next, the first embodiment will be described with reference to FIGS. The first embodiment relates to a search function used for input support for an operator to input a 7-digit postal code. In the first embodiment, a part of a zip code, a part of an address corresponding to the zip code, or a part of an address reading pseudonym is output by the operator, and a list of the corresponding zip codes is output. It is.

<3-1. Data Table 41>
FIG. 2 is a diagram illustrating a data configuration example of a data table stored in the storage device 40 in the first embodiment. In the first embodiment, a data table 41 stored in the storage device 40 is used.

  The data table 41 shown in FIG. 2 is a postal code data table, and stores one postal code data per record. Each record of the data table 41 stores a field a for storing the “first three digits” of the postal code, a field b for storing the “last four digits” of the postal code, and an “address” corresponding to the postal code. And a field d for storing the “reading kana” of the address corresponding to the postal code.

  In the first embodiment, the search system is configured so that a search using “address” or the like as a search key can be performed using the above-described data table 41 in order to obtain “zip code” as a search target. .

<3-2. Virtual table definition information X>
FIG. 3 is a diagram illustrating an example of information defining a virtual table in the first embodiment. The definition information X of the virtual table is stored in the storage device of the application server 20, and is sent to the database server 30 by the search request unit 23 together with the search request. As shown in FIG. 3, when the search target x1 is “zip code”, the “search item” field of each record of the virtual table Y contains the “first three digits” of the zip code of the data table 41. The data of the field a, the “last 4 digits” field b of the postal code, the “address” field c corresponding to the postal code, and the “reading kana” field d of the address corresponding to the postal code are included. A virtual table Y is defined.

  In the definition information X, the virtual table Y is defined such that the “display item” field of each record of the virtual table Y includes the data of the fields a, b, and c of the data table 41. The virtual table Y is defined so that the “return value” field of the virtual table Y includes the data of the fields a and b of the data table 41. The virtual table Y is defined so that the “information” field of the virtual table Y includes a character string “address”.

<3-3. Virtual table Y>
FIG. 4 is a diagram illustrating an example of a virtual table in the first embodiment. Each record of the virtual table Y corresponds to each record of the data table 41 shown in FIG. Each record of the virtual table Y is in accordance with the definition information X of the virtual table shown in FIG. 3, the “search item” field Y1, the “display item” field Y2, the “return value” field Y3, and the “information” "Field Y4".

  The “search item” field Y1 includes the “first three digits” of the zip code in the data table 41, the “last four digits” of the zip code, the “address” corresponding to the zip code, and the address corresponding to the zip code. Are included as character string data delimited by a delimiter such as a hyphen or space.

In the “display item” field Y2, the “first three digits” of the zip code in the data table 41, the “last four digits” of the zip code, and the “address” corresponding to the zip code are hyphenated or spaces, etc. It is included as character string data separated by the delimiter.
The “return value” field Y3 includes the “first three digits” of the zip code in the data table 41 and the “last four digits” of the zip code.
The “information” field Y4 includes a character string “address”.

<3-4. Output table Z>
FIG. 5 is a diagram illustrating an example of a search result in the first embodiment.
FIG. 5A shows an example of the output table Z. The output table Z shown in FIG. 5A shows a result of the search unit 34 searching the field Y1 of the “search item” of the virtual table Y with the search key W as “Sapporo Jujo”.

  As shown in FIG. 5A, in the output table Z, in the virtual table Y shown in FIG. 4, all records in which two search keys W “Sapporo” and “Jujo” are included in the “search item” field Y1. (Second and twelfth records) are extracted. Each record of the output table Z includes a “display item” field Z2 corresponding to the field Y2 of the virtual table Y, a “return value” field Z3 corresponding to the field Y3 of the virtual table Y, and a field Y4 of the virtual table Y. And an “information” field Z4 corresponding to. The output table Z may not include the “search item” field corresponding to the field Y1 of the virtual table Y. The output table Z is output from the search result output unit 35 to the application server 20.

<3-5. Search screen>
FIGS. 5B and 5C show a part of the search screen output to the display device 17 of the client terminal 10. As shown in the screen 171 of FIG. 5B, when the operator inputs “Sapporo Jujo” as the search key W in the input field displayed on the right side of the display position of the search target x1 “zip code”, the address “ A list of postal codes and addresses including the character strings “Sapporo” and “Jujo” is displayed.

  Specifically, the information of the search key W “Sapporo Jujo” input using the input device 11 and the information of the search target x1 (zip code) determined by the client terminal 10 from the input position on the screen are the application. It is sent to the server 20 (S1). Then, the information of the search key W and the information of the definition information X associated with the search target x1 are sent from the application server 20 to the database server 30 (S2). Furthermore, the virtual server Y is searched using the search key W in the database server 30 (S3). The output table Z created in the database server 30 is output to the application server 20 (S4), and the data in the “display item” field Z2 included in each record of the output table Z is sent from the application server 20 to the client terminal 10. (S5) and displayed on the screen 171.

At the same time, if the data (address) in the field Z4 of the “information” of the output table Z is displayed on the screen 171, the operator can narrow down the search result by inputting “address” in the input field. Understandable.
Even if nothing is input in the input field of the screen 171, the “no search key” search is performed according to the above-described S 1 to S 5 just by moving the cursor to the input field, and the “information” field Z 4 is displayed. Data may be displayed.

  The operator can use the mouse pointer 111 to select a postal code to be input from the data in the field “Z2” of the “display item” displayed on the screen 171. As shown in FIG. 5B, when “001-0010 Hokkaido Kita-ku Kitajojo Nishi” is selected with the mouse pointer 111, the screen transitions to a screen 172 shown in FIG. On the screen 172, the data of the “return value” field Z 3 included in the record selected in FIG. 5B (that is, “0010010”) is displayed in the postal code input field.

Specifically, information indicating that “001-0010 Hokkaido Kita-ku Kitajojo Nishi” has been selected with the mouse pointer 111 is sent to the application server 20. Then, among the corresponding records of the output table Z existing in the application server 20, the data of the “return value” field Z 3 is sent to the client terminal 10 and displayed on the screen 172.
As described above, the zip code is retrieved and output to the display device 17 of the client terminal 10.

<4. Second Embodiment>
Next, a second embodiment will be described with reference to FIGS. The second embodiment relates to a search function used for input support for an operator to input a person in charge code of a company. In the second embodiment, a part of the person-in-charge code, part of the person-in-charge name, or part of the department name of the person-in-charge is simply typed by the operator, and a list of relevant person-in-charge codes is output Is.

<4-1. Data Table 42, 43>
FIG. 6 is a diagram illustrating a data configuration example of a data table stored in the storage device 40 in the second embodiment. In the second embodiment, two data tables 42 and 43 stored in the storage device 40 are used.

  A first data table 42 shown in FIG. 6A is a data table for a person in charge, and stores data for one person in charge per record. Each record of the first data table 42 includes a field a for storing “company code”, a field b for storing “person in charge code”, a field c for storing “person in charge name”, and a “department code”. Field d for storing.

  A second data table 43 shown in FIG. 6B is a company department data table, and stores data of one department per record. Each record of the second data table 43 has a field e for storing “company code”, a field f for storing “department code”, and a field g for storing “department name”.

  In the second embodiment, the above-described two data tables 42 and 43 can be used to perform a search using “department name” or the like as a search key in order to obtain a “person in charge code” as a search target. Configure the search system.

<4-2. Virtual table definition information X>
FIG. 7 is a diagram illustrating an example of information defining a virtual table in the second embodiment. The definition information X of the virtual table is stored in the storage device of the application server 20, and is sent to the database server 30 by the search request unit 23 together with the search request. As shown in FIG. 7, when the search target x 1 is “person in charge code”, the “search item” field of each record in the virtual table Y contains “person in charge code” in the first data table 42. The virtual table Y is defined so that the data in the field b and the field c of the “person in charge name” and the data in the field g of the “department name” in the second data table 43 are included.

  Furthermore, the following rules are defined when combining the first data table 42 and the second data table 43. That is, the “department code” (field f) included in one of the records of the second data table 43 is added to the data of “department code” (field d) included in one record of the first data table 42. When the data match, the record of the second data table 43 is associated with the record of the first data table 42.

  In the definition information X, the virtual table Y is defined such that the “display item” field of each record of the virtual table Y includes the data of the fields b and c of the first data table 42. The virtual table Y is defined so that the “return value” field of the virtual table Y includes the data of the field b of the first data table 42. Further, the virtual table Y is defined so that the “information” field of the virtual table Y includes a character string “person in charge CD, person in charge name, department name”.

<4-3. Virtual table Y>
FIG. 8 is a diagram illustrating an example of a virtual table in the second embodiment. Each record of the virtual table Y corresponds to each record of the first data table 42 shown in FIG. Each record of the virtual table Y is in accordance with the definition information X of the virtual table shown in FIG. 7, the “search item” field Y 1, the “display item” field Y 2, the “return value” field Y 3, and the “information” "Field Y4".

  In the “search item” field Y1, the “person in charge code” and “person in charge name” of the first data table 42 and the “department name” in the second data table 43 are separated from each other by a delimiter such as a space. It is included as character string data separated by.

  For example, since the department code “001” is stored in the first record (TAN344 Toshiaki Ichijo) of the first data table 42, the first record in which the department code “001” is stored in the second data table 43 is stored. Associated with one record (marketing group). As a result, the “search item” field Y1 of the first record of the virtual table Y includes the character string “TAN344 Toshiaki Ichijo Marketing Group”. Even in the second record and below, the data of each record of the first data table 42 and the second data table 43 that are associated by matching the department code is included.

The “display item” field Y2 includes “person in charge code” and “person in charge name” of the first data table 42 as character string data separated from each other by a delimiter such as a space.
The “return value” field Y3 includes the “person in charge code” of the first data table 42.
The “information” field Y4 includes a character string “person in charge CD, person in charge name, department name”.

<4-4. Output table Z>
FIG. 9 is a diagram illustrating an example of search results in the second embodiment.
FIG. 9A shows an example of the output table Z. The output table Z shown in FIG. 9A shows a result of the search unit 34 searching the field Y1 of the “search item” of the virtual table Y with the search key W as “marketing”.

  As shown in FIG. 9A, in the output table Z, all records (first and first) in which the search key W “marketing” is included in the field Y1 of “search item” in the virtual table Y shown in FIG. 2, 3rd and 7th records) are extracted. Each record of the output table Z includes a “display item” field Z2 corresponding to the field Y2 of the virtual table Y, a “return value” field Z3 corresponding to the field Y3 of the virtual table Y, and a field Y4 of the virtual table Y. And an “information” field Z4 corresponding to. The output table Z may not include the “search item” field corresponding to the field Y1 of the virtual table Y. The output table Z is output from the search result output unit 35 to the application server 20.

<4-5. Search screen>
FIGS. 9B and 9C show a part of the search screen output to the display device 17 of the client terminal 10. As shown in the screen 171 of FIG. 9B, when the operator inputs “marketing” as the search key W in the input field displayed on the right side of the display position of the search target x1 “person in charge code”, the department name is displayed. A list of “person in charge code” and “person in charge name” including the character string “marketing” is displayed.

  Specifically, the information of the search key W “marketing” input using the input device 11 and the information of the search target x1 (person in charge code) determined by the client terminal 10 from the input position on the screen are the application. It is sent to the server 20 (S1). Then, the information of the search key W and the information of the definition information X associated with the search target x1 are sent from the application server 20 to the database server 30 (S2). Furthermore, the virtual server Y is searched using the search key W in the database server 30 (S3). The output table Z created in the database server 30 is output to the application server 20 (S4), and the data in the “display item” field Z2 included in each record of the output table Z is sent from the application server 20 to the client terminal 10. (S5) and displayed on the screen 171.

At the same time, if the data (in charge code, name of the person in charge, department name) in the “information” field Z4 of the output table Z is displayed on the screen 171, the operator can enter the “in charge code, name of the person in charge”. You can understand that search results can be narrowed down by entering any of the “department names” into the input field.
Even if nothing is input in the input field of the screen 171, the “no search key” search is performed according to the above-described S 1 to S 5 just by moving the cursor to the input field, and the “information” field Z 4 is displayed. Data may be displayed.

  The operator can select the name of the person in charge to input from the data in the field “Z2” of “Display Item” displayed on the screen 171 with the mouse pointer 111. As shown in FIG. 9B, when “TAN349 Yuki Mimura” is selected with the mouse pointer 111, the screen changes to a screen 172 shown in FIG. 9C. On the screen 172, in the input field of “person in charge code”, the data in the “return value” field Z3 included in the record selected in FIG. 9B (that is, the person in charge code of “TAN349 Yuki Mimura”) Is displayed.

Specifically, information indicating that “TAN349 Yuki Mimura” has been selected with the mouse pointer 111 is sent to the application server 20. Then, among the corresponding records of the output table Z existing in the application server 20, the data of the “return value” field Z 3 is sent to the client terminal 10 and displayed on the screen 172.
As described above, the person-in-charge code is retrieved and output to the display device 17 of the client terminal 10.

<5. Effects according to the embodiment>
According to the present embodiment, the virtual table Y is defined so that one field Y1 (search item) of the virtual table Y includes data such as a plurality of fields b and c of the data table. Therefore, if one field Y1 of the virtual table Y is searched, a plurality of fields b, c, etc. of the data table can be searched. If it is desired to increase or decrease the fields b, c, etc. to be searched in the data table, it is only necessary to change the definition of one field Y1 of the virtual table Y in the definition information X.

  Further, according to the present embodiment, in the virtual table Y, the second field Y2 (display item) is defined separately from the one field Y1, and the second field is extracted from the record extracted as the search result. Data of Y2 (data of field Z2 of output table Z) is output. In this way, display items for search results can be set separately from the search items. When it is desired to change such a “display item”, it is only necessary to change the definition information X in the same manner.

  Further, according to the present embodiment, in the virtual table Y, the third field Y3 (return value) is defined separately from the one field Y1 and the second field Y2. When a specific record is selected from a plurality of records in which the data of the second field Y2 is displayed as a search result, the data of the third field Y3 of the record (the field Z3 of the output table Z) Data) is further output. Thus, a return value can be set separately from the search item and the display item. When it is desired to change such a “return value”, it is only necessary to change the definition information X in the same manner.

  Therefore, according to the present embodiment, it is possible to easily cope with various needs of users.

DESCRIPTION OF SYMBOLS 10 ... Client terminal, 11 ... Input device, 12 ... Search request part, 16 ... Search result receiving part, 17 ... Display apparatus, 20 ... Application server, 22 ... Search request reception part, 23 ... Search request part, 25 ... Search result Receiving unit, 26 ... search result output unit, 30 ... database server, 33 ... search request receiving unit, 34 ... search unit, 35 ... search result output unit, 40 ... storage device, 41, 42, 43 ... data table, 111 ... Mouse pointer, 171, 172 ... screen, W ... search key, x1 ... search target, X ... definition information, Y ... virtual table, Z ... output table, Z2 ... display item, Z3 ... return value, Z4 ... information

Claims (5)

A search system capable of accessing a data table stored in a storage device,
Receiving means for receiving a search request including a search key and search target information;
Each record of the virtual table includes a first field including data of a plurality of fields included in each record of the data table as a search item, and at least one field included in each record of the data table. A virtual that defines the virtual table to include a second field that includes data as a display item, and a third field that includes at least one field of data included in each record of the data table as a return value. Storage means for storing table definition information in association with search target information;
The first field included in the plurality of records in the virtual table defined in accordance with the virtual table definition information associated with the search target information received by the receiving unit using the search key received by the receiving unit. A search means for performing a search for data;
Output the data of the second field included in at least one record extracted as a result of the search, and extract a plurality of records as a result of the search, and output data related to the plurality of records Output means for further outputting the data of the third field included in the one record when data relating to one record is selected from
A search system comprising: Each record of the virtual table further includes a fourth field including data representing information on a search key to be input to narrow down the search results;
When the accepting means accepts a search request that does not include a search key, the output means outputs the fourth field data to the display device used for inputting the search key. Display information represented by field data,
Claim 1 Symbol placement search system. A search system capable of accessing a first data table and a second data table stored in a storage device,
Receiving means for receiving a search request including a search key and search target information;
Each record of the virtual table includes at least one field data included in each record of the first data table and a record of the second data table associated with each record of the first data table A first field including at least one field data included in the search item, and at least one field data included in each record of the first or second data table as display items. The virtual table is defined to include a second field including a third field including, as a return value, data of at least one field included in each record of the first or second data table. Storage means for storing virtual table definition information in association with search target information;
The first field included in the plurality of records in the virtual table defined in accordance with the virtual table definition information associated with the search target information received by the receiving unit using the search key received by the receiving unit. A search means for performing a search for data;
Output the data of the second field included in at least one record extracted as a result of the search, and extract a plurality of records as a result of the search, and output data related to the plurality of records Output means for further outputting the data of the third field included in the one record when data relating to one record is selected from
A search system comprising: A search method for performing a search in a search system accessible to a data table stored in a storage device,
Receiving a search request including a search key and search target information (a);
Each record of the virtual table includes a first field including data of a plurality of fields included in each record of the data table as a search item, and at least one field included in each record of the data table. A virtual that defines the virtual table to include a second field that includes data as a display item, and a third field that includes at least one field of data included in each record of the data table as a return value. (B) acquiring virtual table definition information associated with the search target information received in step (a) from storage means for storing the table definition information in association with the search target information;
Using the search key received in step (a), search for data of the first field included in the plurality of records in the virtual table defined according to the virtual table definition information acquired in step (b). Performing step (c);
Outputting the data of the second field contained in at least one record extracted as a result of the search;
When a plurality of records are extracted as a result of the search and data related to one record is selected from the data related to the plurality of records output in step (d), the data is included in the one record. Outputting the third field data further (e);
A search method comprising: A search program for performing a search in a search system accessible to a data table stored in a storage device,
Receiving a search request including a search key and search target information (a);
Each record of the virtual table includes a first field including data of a plurality of fields included in each record of the data table as a search item, and at least one field included in each record of the data table. A virtual that defines the virtual table to include a second field that includes data as a display item, and a third field that includes at least one field of data included in each record of the data table as a return value. (B) acquiring virtual table definition information associated with the search target information received in step (a) from storage means for storing the table definition information in association with the search target information;
Using the search key received in step (a), search for data of the first field included in the plurality of records in the virtual table defined according to the virtual table definition information acquired in step (b). Performing step (c);
Outputting the data of the second field contained in at least one record extracted as a result of the search;
When a plurality of records are extracted as a result of the search and data related to one record is selected from the data related to the plurality of records output in step (d), the data is included in the one record. Outputting the third field data further (e);
Search program that causes a computer to execute.

Images