JP2002269105A - Device for searching and recording merchandise database, and method for searching merchandise database and recording retrieval result - Google Patents

Abstract

PROBLEM TO BE SOLVED: To retrieve a merchandise database composed of a plurality of merchandise groups with one system and to record the results of the retrieval. SOLUTION: A merchandise database 11 composed of a table in which merchandise attributes are recorded for each of a plurality of merchandise groups is prepared, A retrieval image displaying part 12 allows a user to select a merchandise group and displays a retrieval image corresponding to the merchandise group, and a retrieval performing part 13 performs retrieval on the basis of a retrieval condition inputted in the retrieval image. A retrieval result displaying part 14 displays retrieval results, and a retrieval result temporary recording part 15 temporarily records a merchandise group with respect to a retrieval result selected by the user and a main key of the table. A retrieval result recording part 16 permanently records the temporarily recorded retrieval result.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a product database search / recording apparatus for searching product databases and recording search results and a method for searching product databases and recording search results. In particular, there are a plurality of product groups having different attributes. The present invention relates to a product database search and recording device, a product database search, and a method of recording search results.

[0002]

2. Description of the Related Art Conventionally, in a system in which the attribute of a product is converted into a database and searched, a single type of product such as a book can be searched, and an inquiry for an estimate of a product selected from the searched products can be made. It has become.

[0003] Further, a person who provides a system that can search for a product by using such a database and inquire about a quotation is a person who sells a product. It can be said that such a system is provided.

[0004] Further, in such a system, the merchandise seller may disclose irresponsible remarks regarding the publication of the raw opinion of the merchandise purchaser, and may disclose the article manufacturer (maker). Afraid of the pressure from the public) and has declined to publish.

[0005]

However, for example, when considering the case of constructing an apartment,
Condominiums are equipped with products from a number of product groups with different attributes, such as toilets, baths, kitchens, fittings, carpets, flooring, lighting fixtures, and outlets, and use a system that can search for a single type of product. Therefore, it is necessary to operate the system for each product group, and when comparing quotations, requests for quotations are made by the number of sellers.

[0006] On the other hand, when there are a plurality of dealers for one article, and each of them accepts a request for quotation, discounts are made among the sellers, which may be profitable for a product purchaser. There will be disadvantages for the manufacturer. As a result, the product manufacturer operates a product search system by converting the product into a database, and pressures merchants accepting requests for quotation to stop providing the system.
It is also disadvantageous for product buyers.

[0007] Further, in order to obtain a reputation of a product, a product purchaser needs to obtain information from a system other than a product search system. However, product manufacturers tend to publish only good points of their products. It is necessary to seek information sources other than the manufacturer of the product, but even with the widespread use of the Internet, finding information sources is not easy, and finding reliable information sources is not easy. Absent.

In the construction of condominiums and buildings, it is necessary to determine at the planning stage which product to use and in what specification, and to obtain approval from the construction client. A catalog about the product is ordered from the seller, and only the necessary parts of the catalog are cut out to create presentation materials. Paper waste is occurring.

[0009]

The present invention has the following configuration.

According to the first aspect of the present invention, a product database comprising tables storing product attributes for each product group having different attributes is prepared in the product database search / recording apparatus. Provide a search screen for each group.
For this purpose, a search execution unit and a search result display unit are prepared. In addition, a search result temporary recording unit for temporarily storing the search result and a search result recording unit for permanently storing the search result are prepared. As a result, a plurality of product groups can be searched by one system, and even if the product groups are different, search results can be recorded in one system, which is convenient for the user.

According to a second aspect of the present invention, there is provided a product database search and recording device capable of temporarily storing search results permanently recorded by a search result recording unit. As a result, it is possible to easily use the result of the past search without performing a new search operation.

According to the third aspect of the present invention, there is provided a product database search / recording apparatus capable of adding a comment when a search result recorded in a search result temporary recording unit is recorded in a product result recording unit. This allows the user to grasp in a short time how the results retrieved in the past can be used.

According to a fourth aspect of the present invention, there is provided a product database search / recording device capable of writing a comment on a product obtained as a search result and reading the written comment. This allows the user to provide a reputation for the product and to know the reputation.

According to a fifth aspect of the present invention, there is provided a product database search / recording apparatus which displays written comments on an administrator screen and allows the administrator to select whether or not to post.
As a result, it is possible to avoid slander without reason for writing the product by writing irresponsible comments, and it is possible to avoid pressure exerted by the manufacturer of the product.

According to the sixth aspect of the present invention, when displaying a search result of a product, first, an outline is displayed to a user.
Provided is a product database search and recording device that provides detailed information on a product specified by a user. As a result, it is possible to display search results that are easy for the user to see.

According to a seventh aspect of the present invention, there is provided a merchandise database search / recording apparatus which records the number of times detailed information on merchandise is provided for each merchandise. As a result, it is possible to obtain information on which product is receiving attention, and to provide that information to the user. According to an eighth aspect of the present invention, there is provided a product database search / recording device that records a table primary key and a table name when recording a product search result from a plurality of tables.

According to the ninth aspect of the present invention, the range of the value of the primary key is determined for each table so that the range does not overlap between a plurality of tables, and the result of retrieval of a product from the plurality of tables is recorded. In this case, a merchandise database search and recording device that records only the value of the primary key is provided.

According to the tenth aspect of the present invention, a table is prepared which indicates the correspondence between the value of the primary key and the primary key of which table. Provided is a product database search / recording device that records only a key value. According to the eighth, ninth, or tenth aspect of the present invention, search results of a plurality of product groups can be recorded.

According to the eleventh aspect of the present invention, a product is associated with its retailer, and an estimate is requested to the retailer of the product based on the search result recorded in the search result temporary recording section. The present invention provides a product database search and recording device that allows the user to view the product. As a result, estimation for a plurality of types of commodities becomes possible with one system.

According to a twelfth aspect of the present invention, there is provided a product database search / recording apparatus which makes a one-to-one correspondence between a product and a store of the product. As a result, it is possible to prevent a plurality of dealers from responding to one product, thereby causing a price reduction competition.

According to a thirteenth aspect of the present invention, there is provided a merchandise database search and recording device capable of transmitting and receiving search results recorded in a search result temporary recording section by electronic mail. As a result, it becomes possible for a plurality of persons to share the search result of the product, and it becomes possible to work together.

According to a fourteenth aspect of the present invention, there is provided a merchandise database search / recording apparatus including a clickable map creating unit for associating a part of a plan view with a merchandise search result. Thus, for example, in the construction of a condominium or a building, it is easy to determine which part of the product should be used in which part at the planning stage, and to prepare a presentation material for obtaining approval from the construction client.

According to a fifteenth aspect of the present invention, there is provided a method for searching a product database for storing product attributes for each product group and recording a search result, wherein a step of displaying a search screen for each product group and a step of performing a search are provided. A method of searching a product database and recording a search result, comprising a search result display step, a temporary recording step for temporarily recording the search result, and a permanent recording step for permanently recording the search result. As a result, a search for a plurality of product groups can be performed by one system, and even if the product groups are different, search results can be recorded in one system, and user convenience can be achieved.

According to a sixteenth aspect of the present invention, there is provided a method for searching a product database and recording the search results, which can temporarily store the search results recorded in the permanent recording step. As a result, it is possible to easily use the results of the past search without performing a new search operation.

According to a seventeenth aspect of the present invention, there is provided a method of searching a commodity database to which a comment can be added when a search result is permanently recorded in a permanent recording step, and a method of recording the search result. This allows the user to grasp in a short time how the results retrieved in the past can be used.

According to an eighteenth aspect of the present invention, there is provided a method of searching a product database and recording a search result, comprising a step of adding a comment to a search result and a step of reading the added comment. As a result, the reputation of the product can be provided and the reputation can be known.

According to a nineteenth aspect of the present invention, there is provided a method of searching a product database and recording a search result, comprising a step of displaying a written comment on an administrator screen and a step of selecting whether or not to post the comment. This allows
It is possible to avoid slander without reason for writing the product by writing irresponsible comments, and to avoid pressure from the manufacturer of the product.

In the twentieth aspect of the present invention, in the step of displaying the search result, a summary of the product is first displayed, and a search of a product database for providing detailed information on the product selected by the user and recording of the search result are performed. Provide a way. As a result, it is possible to display search results that are easy for the user to see.

According to a twenty-first aspect of the present invention, there is provided a method of searching a product database and recording a search result, comprising a step of recording the number of times detailed information on a product is provided. As a result, it is possible to obtain information on which product is receiving attention, and to provide that information to the user.

According to the invention of claim 22, a method is provided for searching a product database for recording the primary key of a table and the name of the table when recording the search results of the products from a plurality of tables and recording the search results. .

According to the twenty-third aspect of the present invention, the range of the value of the primary key is determined for each table so that the range does not overlap between a plurality of tables, and the result of retrieval of a product from the plurality of tables is recorded. The present invention provides a method of searching a product database that records only the value of a primary key and recording a search result.

In the invention of claim 24, a table is prepared which indicates the correspondence between the value of the primary key and the primary key of which table. A method of searching a product database that records only key values and recording a search result is provided.

According to the invention of claim 22, claim 23, or claim 24, it becomes possible to record the search results of a plurality of product groups.

According to the twenty-fifth aspect of the present invention, the merchandise and its retailer are associated with each other, and from the search result recorded in the search result temporary recording section, an estimate is requested to the merchandise retailer, To provide a method of searching a product database and recording a search result so that a user can view the product database. As a result, estimation for a plurality of types of commodities becomes possible with one system.

According to a twenty-sixth aspect of the present invention, there is provided a method of searching a product database and recording a search result in a one-to-one correspondence between a product and a store of the product. As a result, it is possible to prevent a plurality of dealers from responding to one product, thereby causing a price reduction competition.

According to a twenty-seventh aspect of the present invention, there is provided a method for searching a product database and recording the search results, which can transmit and receive the search results recorded in the search result temporary recording section by electronic mail. As a result, it becomes possible for a plurality of persons to share the search result of the product, and it becomes possible to work together.

According to a twenty-eighth aspect of the present invention, there is provided a method of searching a product database for creating a clickable map that associates a part of a plan view with a search result of a product, and a method of recording the search result. Thus, for example, in the construction of a condominium or a building, it is easy to determine which part of the product should be used in which part at the planning stage, and to prepare a presentation material for obtaining approval from the construction client.

[0038]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Embodiment 1

FIG. 1 shows the configuration of a product database search and recording device 10 according to an embodiment of the present invention. A product database 11, a search screen display unit 12, a search execution unit 13, a search result display unit 14, and a search result temporary storage unit 15, a search result recording unit 16; The product database search and recording device 10 having such a configuration can be configured by the computer 20, the communication network 28, and the user terminal 27 shown in FIG.

The computer 20 comprises a CPU 21, a memory 22,
It comprises a hard disk 23, an input device 24, an output device 25, and a communication interface 26. Hard disk 23
Stores a product database 11 and a program to be executed by a computer. The program is loaded into the memory 22 as needed, and is executed by the CPU 21. The programs stored in the hard disk 23 implement a search screen display unit 12, a search execution unit 13, a search result display unit 14, a search result temporary recording unit 15, and a search result recording unit 16.
In a program for realizing the search result temporary recording unit 15 and the search result recording unit 16, the search result is stored in the memory 2.
2 and the hard disk 23.

The input device 24 and the output device 25 are computers 20
Are used to perform maintenance of the computer 20, display an administrator screen described later, and perform operations on the screen. The communication interface is connected to a communication network 28,
The communication with the user terminal 27 is performed. Product Database 11
Is a table that stores the attributes of the products for each product group having different attributes. The product group is a group of products having the same set of attributes, for example, a product group such as a bath, a toilet, a kitchen, and a fitting. FIG. 3 shows an example of the product database, and a table 31
Is a table storing the attributes of products of a product group of a bath, a table 32 of a toilet, a table 33 of a kitchen, and a table 34 of a fitting. Some attributes are common between the product groups, but the sets of attributes are different as a whole. Note that the column of the product ID is the primary key of each table, and in the same table, the values of the columns of the product ID in the two rows are not the same.

The search screen display section 12 displays a search screen corresponding to a product group on the user terminal 27. As an example of the search screen display unit 12, first, the search screen display unit 12 may display the screen of FIG. 4 on the user terminal 27. A list of product group names is displayed on the screen of FIG. 4, and the user selects one of them. For example, if you select a toilet,
The search screen display unit 12 displays a toilet search screen, and the user terminal displays a toilet search screen, an example of which is shown in FIG.

In FIG. 5, a circular portion or a square portion is a portion that the user inputs as a search condition.
The values of the columns can be selected by a circular portion or a square portion corresponding to columns other than the column of the product ID and the image file of No. 2. For example, a circular portion is a portion for selecting any one of them, and one of a washing method and a non-water washing method is selected. The square portion is a portion called a check box, and is a portion from which a plurality can be selected. For example, in FIG. 5, a Western style, a Japanese style, and a urinal are arranged on the right side of the toilet shape, and the user can arbitrarily select zero, one, or a plurality of desired toilet shapes among these.

The reason why the columns of the product ID and the image file are excluded is that the product ID is usually determined by the creator of the product database and does not usually have any meaning for the user. This is because there is no effective method for specifying a search condition for a file in the current state of the art. The product ID is meaningful for the user,
If there is a method of specifying a search condition for an image file, it may be possible to specify a search condition for a column of a product ID and an image file.

In FIG. 5, the search condition is input by a circular portion or a square portion. However, an embodiment in which the user inputs by a character string is also possible. The search execution unit 13 issues a search formula for a table corresponding to a product group from the search conditions input on the search screen displayed by the search screen display unit 12. For example, if the table 32 is named toilet, SELECT
* FROM Toilet WHERE (Washing method = 'Washing') AND (Toilet shape = 'Western style' OR Toilet shape = 'Japanese style') AND ... For each row of the table, the column values are circular or square. Creates an atomic condition that is equal to the value selected by, creates an expression in which the atomic conditions for the same column are connected by OR, and encloses the whole in parentheses. A WHERE part having conditions obtained by connecting the expressions thus formed with AND is created. If the user enters a condition using a character string, an atomic condition is generated in which the column name is equal to the input character string, or the input character string is regarded as a regular expression and the regular expression is matched. Will be.

FIG. 6 is a flowchart showing the operation of the search screen display unit 12 and the search execution unit 13. Step 6
In FIG. 1, the screen shown in FIG. 4 is displayed to urge the user to select a product group. In step 62, a search screen of the product group selected by the screen of FIG. 4 is displayed,
In step 63, a query sentence for searching the table of the product group from the data input to the search screen is issued. The search result display unit 14 displays on the user terminal 27 a search result based on the search sentence issued by the search execution unit 13.

For example, as shown in FIG. 7, it is conceivable to display the values of the columns of the rows of the table of FIG. 3 obtained by executing the search formula. However, as described above, the merchandise ID is not normally displayed to the user because it has no meaning, and the content of the image file is displayed for the image file. Further, although the product ID is not displayed, the correspondence between the search result displayed on the computer 20 or the user terminal 27 and the product ID is managed in order to record the search result.
As an example, the search result display unit 14 instructs the computer 20 or the user terminal 27 to store the correspondence between the ID of the sub-window on which the search result is displayed and the product ID.

In FIG. 7, a column 71 is a column indicating a check box 75, and a search result of the selected check box is temporarily recorded as described later. Column 72 is
In the columns of the row of the search result, the values of the columns excluding the image file and the product ID are shown. Besides this, it is also conceivable to display the attribute of another table associated with the product ID.
For example, it is conceivable that a table indicating the correspondence between the product ID and the manufacturer name of the product is separately prepared, and the manufacturer name of the product obtained by the search is displayed. The column 73 displays the contents of the image file. Column 74 is a scroll bar.

FIG. 8 is a flowchart for explaining the operation of the search result display section 14. In step 81, the result of the search executed by the search execution unit 13 is obtained. In step 82, an image file name of each search result is obtained to obtain an image. In step 83, 8
The search result is displayed on the user terminal 27 together with the image obtained in step 2.

The search result temporary recording section 15 temporarily records the search result selected by the user from the search results displayed on the search result display section. Temporarily recording means that it is only necessary to record the information at least while the user performs some operation on the search result.
For this reason, the search results are usually managed in the memory 22.

FIG. 9 shows an example of a search result recorded by the search result temporary recording unit 15, and is a table in which search results selected from the search results displayed on the search result display unit 14 are added. . The table of FIG. 9 stores a product group name and a product ID.
And the product ID of the search result whose check box 75 is selected from the user terminal 27 is added.

The search result recording section 16 is a section for permanently storing the search results temporarily recorded by the search result temporary recording section 15. Permanently means that the communication between the user terminal 27 and the computer 20 is disconnected or that the computer 20
Means that the recorded contents are not erased even when the power supply of the hard disk 23 is turned off.
To record.

FIG. 10 shows an example of a search result recorded by the search result recording section 16, and shows a table including three columns of a record ID, a product group name, and a product ID. The record ID is a unique number assigned by the search result recording unit 16 when the temporarily recorded search result is permanently recorded. For example, the last recorded ID is stored in a certain area of the hard disk 23, and when the search result is recorded in the search result recording unit 16, the record ID is read from the certain area and 1 is added. It is conceivable that the value is written in the certain area and used as the record ID.

<Embodiment 2>

In addition to the above embodiment, the user terminal 27
In some embodiments, the search result recorded in the search result recording unit 16 is temporarily detected by detecting the operation of the search operation. User terminal 2
The operation 7 means that the user selects a specific search result from the content of the search result recorded in the search result recording unit 16 displayed on the screen on the user terminal 27, and selects the selected search result. This is to issue a command to the computer 20 to temporarily record the result.

FIG. 12 shows an example of a screen displayed on the user terminal 27 when a search result selected by the user from the search results recorded in the search result recording section 16 is temporarily recorded. . In this example, the toilet is shown above and a unit bath is shown below it. From the display form of the scroll bar on the right part of the screen, it can be seen that the displayed content is a part of the whole. The user can select the search results to be recorded in the search result temporary recording unit 15 by clicking the check boxes indicated by 121 and 122 with the mouse.

FIG. 11 shows a flowchart of an operation for temporarily recording the search result permanently recorded in the search result recording section 16. In step 111, the product group name and the product I that make up the search result permanently recorded
Read D into memory. In step 112, the table of FIG. 3 corresponding to the product group name is read, and the row in which the primary key is the product ID read in step 111 is read into the memory. In step 113, the value of the column of the image file in the line read in step 112 is obtained, and the content of the image file is read.
Get the product image.

At step 114, the user terminal 27
To the column values of the row obtained in step 112 and step 1
13 is displayed, and the search result temporary recording unit 15 is displayed.
Prompts the user to select a search result to be recorded in. For example, a display with a check box is performed as shown in FIG. In step 115, a product group name and a product ID of the search result selected by the user are obtained. For example, FIG.
The table as shown in FIG. 13 that associates the window ID of the sub-window displaying the check boxes 121 and 122 with the product group name and the product ID is stored in the memory 2.
2, the product group name and the product ID can be obtained from the window ID of the sub-window of the selected check box. In step 116, the merchandise group name and the merchandise ID obtained in step 115 are temporarily recorded so that the search result temporary recording unit 15 can handle the temporarily recorded search results.

<Embodiment 3>

Further, in the above embodiment, there is also an embodiment in which a function of adding a comment is added when the temporarily recorded search result is permanently recorded by the search result recording unit 16. To add a comment is to attach a sentence describing the relation to the search result because the temporarily recorded search result is recorded with an intention of some kind of relation. The comment is input by the user from the user terminal 27 and added to the search result, and the added comment is stored in the search result recording unit 16.
Is permanently recorded when records the search results.

FIG. 14 shows an example in which the comment added to the search result is recorded. The table storing the record ID and the comment added when the search result is permanently recorded. Has become. Thereby, the record ID
It is expressed that the search result of “10” relates to Room 303 of Yurakucho Heights 1-8-1 Yurakucho, Chiyoda-ku, Tokyo.

<Embodiment 4>

In the first or second embodiment, there is also an embodiment in which a comment on a product can be written and the comment can be read. A comment on a product is a user's impression of the product. By reading the impression of the product, the user can know the reputation of the product and use it as reference information for product selection. Can be.

In this embodiment, an example is considered in which a table storing comments on products is prepared for each of the tables corresponding to the product groups in FIG. 3, and FIG. Shows an example of a table in which is stored.

The table shown in FIG. 15 stores comments on products stored in any of the product grouping tables shown in FIG. 3. To determine which product is a comment, see the value in the column of the product ID. Thus, it can be determined. For this embodiment, a button for writing a comment on the product and a comment written on the product are displayed on the screen displaying the search results shown in FIGS. 7 and 12 for each product. Add a button to

When the button for writing a comment is pressed,
A program for writing a comment of the computer 20 starts, and a sub-window for writing a comment is displayed on the user terminal 27. When the program senses that the user has finished writing the comment and, for example, pressed the button to write the comment, the product I is displayed in the table of FIG.
A comment is added together with D, time, and the user name of the user terminal 27.

When a button for displaying a comment is pressed, a program for reading the comment of the calculator 20 is started, and the program displays a button for displaying a comment on which product ID of which product group. Is determined, a product ID is retrieved from a table storing comments corresponding to the product group, comments of the target product are collected, and displayed on the user terminal 27.

FIG. 16 is a flowchart for explaining the operation of a program for reading a comment in more detail. The searched product is displayed with the comment display button,
Window of the subwindow that constitutes the display button
FIG. 13 shows the correspondence between wID, product group name, and product ID.
Is managed by the computer 20 as follows. In step 161, the window ID of the sub window whose comment display button is pressed is obtained. Step 162
In, the product group name and the product ID are obtained from the WindowID. In step 163, the table storing the comment corresponding to the product group name is stored in step 1
Search by the product ID obtained in 62. In step 164, the obtained comment is displayed on the user terminal 27. For example, it is conceivable to display a sub window for displaying comments.

<Embodiment 5>

As a modified embodiment of the fourth embodiment,
When a comment on a product is written, the comment is not unconditionally stored in the table of FIG. 15 but stored in a temporary comment storage table, and the comment stored in the temporary comment storage table is displayed on the administrator screen. In some embodiments, the administrator can select display on the user terminal 27 for each comment. The administrator is a managing entity of the product database search device, and the comment temporary storage table is a table for storing comments prepared separately from comments displayed on the user terminal 27. Comments can be read only by the administrator. The administrator screen is a screen for displaying the comments stored in the comment temporary storage table and performing an operation of moving to the table in FIG. 15 so that the comment selected by the administrator can be displayed on the user terminal 27. That is.

FIG. 17 shows an example of the manager screen, in which the comments stored in the comment temporary storage table are displayed. Check box 17 in the column labeled Post
1 and 172, and when this check box is selected by the administrator, the comment of the selected line moves to the table of FIG. 15 where the comment displayed on the user terminal 27 is stored. When the administrator selects the checkboxes 173 and 174 in the column of “delete”, the comment of the selected line is deleted from the comment temporary storage table, and FIG.
Will not move to the table.

FIG. 18 shows the operation of a program operating on the computer 20 for operating a comment from the display of the administrator screen. In step 181, the comment stored in the comment temporary storage table is displayed on the manager screen. In step 182, the comment selected by the posting check box is moved to a table in which comments displayed to the user corresponding to the product group are stored. In step 183, the comment selected by the delete check box is deleted from the comment temporary storage table.

<Embodiment 6>

The merchandise database search and recording device according to the first or second embodiment includes a search result temporary record display unit and a search result record display unit, and the search result display unit, the search result temporary record display unit, and the search result In some embodiments, the record display unit first displays an outline of a product on the user terminal 27, and displays detailed information of the selected search result product by an operation from the user terminal.

The search result temporary recording and display section displays the temporarily recorded search results on the user terminal 27, and displays detailed information of the displayed product by the operation of the user. Provide operating means. For example, together with the display of the product information, a button for displaying detailed information of the product is displayed.

The search result record display section displays the permanently recorded search result on the user terminal 27, and
An operation unit for displaying detailed information of a displayed product by a user's operation is provided. For example, together with the display of the product information, a button for displaying detailed information of the product is displayed.

Further, instead of the button for displaying the detailed information of the product, the detailed information of the product may be displayed by clicking the image of the product with the mouse. Detailed product information includes the product search screen,
This is information that is not displayed on the screen that displays product search results. Such information is stored in a table for storing detailed information corresponding to the table of each product group in FIG. 3, and the table for storing the detailed information is searched by the product ID to obtain detailed information. And can be displayed on the user terminal 27.

<Embodiment 7>

In this embodiment, the number of times detailed information of a product is displayed on the user terminal 27 is recorded for each product in the product database search and recording device of the sixth embodiment. As shown in an example in FIG. 19, the number of times of display is determined by the search result display unit 14, the search result temporary record display unit, and the search result record display unit from the user terminal 27 to the detailed information of the product. The number of times the display is requested can be counted by recording the number of times for each product ID in a table corresponding to the product group in a table corresponding to the product group.

The higher the number of times the detailed information of a product is displayed, the higher the interest in the product. Therefore, when the search result temporary display unit and the search result record display unit display the search result, the record is displayed. It is also conceivable to display the degree of interest in the product to the user by giving some kind of mark according to the number of times the product has been made.

<Embodiment 8>

In the above embodiment, it is assumed that the search result is recorded by recording the product group name and the product ID, but another embodiment is also possible. That is, the range of possible values of the product ID, which is the primary key, is determined in advance for each product group table so that the ranges do not overlap each other, and when the product ID is given, the product ID is It is determined to which range the product belongs and the product ID of the product in the product group table is determined. As a result, when recording the search result, if only the product ID is recorded, the product is uniquely determined.

For example, a merchandise ID ranging from 0000 to 0099 is assigned to a bus, and a product ID ranging from 0100 to 099 is assigned to a toilet.
9 for the product ID, 1000 for the kitchen, 2999 for the kitchen, 700 for the fittings.
Commodity IDs in the range from 0 to 8999 are allocated so that those ranges do not overlap. When the search result is recorded temporarily or permanently, only the product ID is recorded, and when obtaining the attribute of the product from the product ID, it is determined in which range the product ID is. Thus, it is determined which product group table belongs to, and the product group table obtained by the determination is searched.

<Embodiment 9>

Further, a table showing the correspondence between the product ID and the table is prepared, and when the product ID is given, the table name of the product group in which the product ID appears In some embodiments, the search result is temporarily or permanently recorded by recording the product ID.

The table indicating the correspondence between the product ID and the table ID is a table including two columns, one column storing the product ID, and the other column storing the product ID. This is a table that stores the table names of the stored product groups. An example of this is shown in FIG. For example, a product ID of 0001 means that it appears in a table of a product group named bus.

By preparing such a table, when a product ID is given, the name of the product group can be known by searching the table, and the product information can be obtained from the name and the product ID. Can be obtained.

<Embodiment 10>

In the merchandise database search and recording apparatus of the second embodiment, information for associating merchandise with its dealer is stored in the merchandise database, and an estimate request creation screen display section, an estimate request section, an estimate reception recording section, Some embodiments include an estimation result display unit.

The information for associating a product with its store is as follows:
This information indicates which store sells the product, and is stored in, for example, a table as shown in FIG. FIG.
, The merchandise group has a merchandise ID of 0001
It is expressed that the product is sold at the store A. The address column stores an address to which a quote request is sent when the quote request unit requests a quote.

The estimate request creation screen display section displays an estimate request screen for requesting an estimate from the temporarily recorded search results on the user terminal. Specifically, as shown in FIG. 22, by displaying a screen having a column for inputting the number of products of the search result recorded in the search result temporary recording unit 15, the user can determine the number of each product. Display a screen that allows you to enter whether you need them.

The estimate request unit uses the temporarily recorded search results, the number of products input on the screen displayed by the estimate request creation screen display unit, and information for associating the products with the stores. Then, for each product, a request for a quote is sent to the retailer of the product.

The operation of the estimating request unit is as follows. For one or more products entered on the screen displayed by the estimate request creation screen display unit, the address of the store of the product is obtained using information that associates the product with the store. Then, to the address, the number of the quote request, the information for specifying the product and the number of the products, and the information for reference of the quote such as the name of the user who made the quote request are transmitted. In addition, record that an estimate has been requested. The quote request number is a number that is uniquely assigned to the quote request. When the quote request number is specified, it is a number that allows you to know which product the quote request was made for. is there.

The information for specifying the product is information for uniquely specifying the product, and usually uses the name of the manufacturer of the product and the product number of the manufacturer. Although the table shown in FIG. 3 does not seem to store the maker name or the product number of the product, another table storing detailed information of the product is stored in each table corresponding to the product group. The table may be prepared, the manufacturer name and the product number may be stored in the table, and the table and the table corresponding to the product group may be associated by the product ID.

Sending information means sending information to a designated address. For example, the address http: // trade. k. co
m / cgi-bin / trade. The cgi has a quote number of 1234, a manufacturer name of HOHO, and a product number of GJ3498-
B, if the number is 3, http: // trade. k.
com / cgi-bin / trade. cgi? reqno =
1234 & producedby = HOHO & item
no = GJ3498-B & count = 3 HTT
Send P request. An embodiment in which an electronic mail is sent to a mail address in a predetermined format is also conceivable.

Recording that a quote has been requested means recording in a table in order to associate the quote request number with the product for which the quote was sent. An example of the record is shown in FIG. 23, and includes columns of an estimate number, a display number, a product group, a product ID, the number, and an estimate result. The quote number is a number that gives the same number to the search result that requested the quote, and a different number is assigned to another quote request. When the number is specified, it is possible to know which product has been requested for an estimate. The display number indicates the display order when the product information is displayed on the estimate request creation screen. The product group and product ID uniquely identify the product. The number is the number of products input on the estimate request creation screen. The quote result is a quote price for a quote request. If a response to the estimated price has not been received yet, a special value of NULL indicating a null value is set in the estimated result.

The estimate receiving and recording unit receives the estimate request number and the estimate price from the dealer, and records the estimate result in a table that records that the estimate has been requested.

The estimation result display unit displays on the user terminal 27 the contents of a table for recording that the estimation has been requested. FIG. 24 shows an example of the display of the estimation result display section. The value of the column of the estimation result in the table that records that the estimate was requested is NULL
If it is L, it means that there is no reply to the quote, so that the indication during the quote request is displayed.

In this embodiment, an embodiment is also conceivable in which information for associating a product with its store is associated with one store with one product. By associating one store with one product, it is possible to prevent a discount competition for the product.

<Embodiment 11>

In the tenth embodiment, there is also an embodiment in which the search results recorded in the search temporary recording section are sent out by e-mail, and the search results sent by e-mail are temporarily recorded. For example, the content of the table of the product group name and the product ID temporarily recorded as a search result is made into a structured document, transmitted, and the side receiving the mail analyzes the structure of the structured document. It is conceivable to temporarily record the product group name and the product ID.

For such an embodiment, the computer 20
A step in which a program running on the user terminal collects the temporarily recorded search results into a structured document;
The step of transmitting the structured document to the specified e-mail address from step 7 will be executed. When a structured document is received, a step of analyzing its structure, a step of extracting a product group name and a product ID, and a step of temporarily recording the same are performed.
Alternatively, an embodiment in which transmission and reception are performed in a so-called CSV file format is also conceivable.

<Embodiment 12>

The twelfth embodiment is an embodiment in which the product database search and recording device of the eleventh embodiment is provided with a plan view display unit and a clickable map creation unit.

The plan view display unit displays a drawing of a building on the user terminal 27.

The clickable map creator detects the coordinates of a position specified on the drawing displayed on the plan view display unit, and detects a part of the plan view in the vicinity thereof.
A hyperlink to the selected search result among the temporarily recorded search results is provided. Note that the search result in the search result temporary recording unit may be the search result transmitted by mail in the eleventh embodiment.

The position designated on the drawing displayed on the plan view display unit is a coordinate position on the drawing. For example, the user clicks the mouse on the drawing displayed on the user terminal 27. Is performed to perform the specification. The vicinity is a position portion on a plan view including a designated coordinate position and having a certain extent, such as a rectangular area having two points as vertices designated by the user, or a position designated by the user. The region is a region surrounded by a line on the included plan view. A hyperlink is created by associating a specific location with an image file or document file so that clicking on a specific location in the floor plan displays the content of the image file or the content of the document file. is there.

FIG. 25 shows an example in which hyperlinks are provided in a plan view. <IMAGE SRC = "7th-floor. ×××” US
EMAP = "# 7thFloor"> is the 7th-floor. ×
Xx, and the hyperlink information is 7thFloor
It represents that. <MAPNAME = "7thFlo"
or "> to </ MAP> represents the content of the hyperlink information of 7thFloor, for example, 15, 11, 165,
Clicking on the area indicated by the coordinate position 143, F
B0001.XXX means that the contents of the image file are associated so as to be displayed. FIG. 26 shows the operation of the program for generating the hyperlink information whose example is shown in FIG.

In step 261, a coordinate position on the plan view specified by a user operation such as clicking a mouse button is obtained. In step 262, a neighborhood is determined. For example, it is conceivable to obtain the coordinates of the vertices of a square of a predetermined size centered on the specified position. Further, as another embodiment, it is conceivable to obtain the coordinates of the vertices of a rectangular area included in an area surrounded by a line on the plan view and including a position designated by the user. In step 263, the merchandise group and merchandise ID of the merchandise selected from the temporarily recorded search results are obtained, and the image file name is obtained. Step 2
In 64, <AREA SHAPE = RECT COORDS = "…" HREF = "
.. ">. The image file name determined in step 263 is specified by HREF =.

<Thirteenth Embodiment>

The present embodiment is a method for searching a product database in which a table for storing product attributes is stored for each product group having different attributes and recording the search results, wherein the computer comprises: a search screen display step; A search step, a search result display step, a temporary recording step, and a permanent recording step are executed.

A product group is a group of products having the same set of attributes, for example, a product group such as a bath, a toilet, a kitchen, and a fitting. The table that stores the attributes of the products for each product group having different attributes is a table of a database that stores, for each group of products having different attribute sets, the attributes of those products.

FIG. 3 is an example showing a plurality of tables for storing product attributes for each product group having different attributes. The table 31 is a bath, the table 32 is a toilet, the table 33 is a kitchen, and the table 34 is a fitting. It is a table that stores the attributes of the products of the product group. Some attributes are common between the product groups, but the sets of attributes are different as a whole. Note that, in the table shown in FIG. 3, the column of the product ID is the primary key of each table, and in the same table, the values of the columns of the product ID in the two rows are not the same.

FIG. 2 shows the configuration of a computer according to this embodiment, which comprises a CPU 21, a memory 22, a hard disk 23, an input device 24, an output device 25, and a communication interface 26. The hard disk 23 stores the product database 11 and stores a program to be executed by a computer. The program is loaded into the memory 22 as needed and executed by the CPU 21. The configuration data of the screen displayed on the user terminal 27 is also stored.

The input device 24 and the output device 25 are computers 20
Are used to perform maintenance of the computer 20, display an administrator screen described later, and perform operations on the screen.

The communication interface is connected to the communication network 28 and communicates with the user terminal 27. User terminal 2
7 is operated by a user to operate a program stored in the hard disk 23 of the computer 20 connected via the communication network 28, and causes the computer 20 to execute the following steps.

[0117] The search screen display step is a step of displaying a search screen for each table on the user terminal 27 with respect to a table for storing product attributes for each product. As an example of the search screen display step, first, the screen of FIG. 4 is displayed on the user terminal 27. A list of product group names is displayed on the screen of FIG. 4, and the user selects one of them. For example, when a toilet is selected, the computer 20 displays a toilet search screen, and the user terminal displays a toilet search screen, an example of which is shown in FIG.

In FIG. 5, a circular portion or a square portion is a portion to be input by the user as a search condition.
The values of the columns can be selected by a circular portion or a square portion corresponding to columns other than the column of the product ID and the image file of No. 2. For example, a circular portion is a portion for selecting any one of them, and one of a washing method and a non-water washing method is selected. The square portion is a portion called a check box, and is a portion from which a plurality can be selected. For example, in FIG. 5, a Western style, a Japanese style, and a urinal are arranged on the right side of the toilet shape, and the user can arbitrarily select zero, one, or a plurality of desired toilet shapes among these.

The reason why the columns of the product ID and the image file are excluded is that the product ID is usually determined by the creator of the product database and does not usually have a meaning to the user. This is because there is no effective method for specifying a search condition for a file in the current state of the art. The product ID is meaningful for the user,
If there is a method of specifying a search condition for an image file, it may be possible to specify a search condition for a column of a product ID and an image file.

In FIG. 5, the search condition is input by a circular portion or a square portion. However, an embodiment in which the user inputs by a character string is also possible. The search step is a step of issuing a search formula for a table corresponding to a product group from search conditions input on the search screen displayed by executing the search screen display step. For example, if the table 32 is named toilet, SELECT * FROM toilet WHERE
(Washing method = 'Washing') AND (Toilet shape = 'Western style')
OR Toilet shape = 'sum expression' AND For each column of the table, create an atomic condition that the value of the column is equal to the value selected by the circular portion or the square portion. Generates an expression with parentheses surrounding the entire connection with OR. A WHERE unit having conditions obtained by connecting the expressions obtained in this way with AND is created. If the user enters a condition using a character string, an atomic condition is generated in which the column name is equal to the input character string, or the input character string is regarded as a regular expression and the regular expression is matched. Will be.

The search result display step is to display, on the user terminal 27, the search result of the product obtained by the search formula issued in the search step. For example, as shown in FIG. 7, it is conceivable to display the values of the columns of the rows of the table of FIG. 3 obtained by executing the search formula. However, as described above, the merchandise ID is not normally displayed to the user because it has no meaning, and the content of the image file is displayed for the image file. Further, although the product ID is not displayed, the correspondence between the search result displayed on the computer 20 or the user terminal 27 and the product ID is managed in order to record the search result. That is, the correspondence between the ID of the sub-window in which the search result displayed in FIG. 7 is displayed and the product ID is stored in the computer 20 or the user terminal 27.

In FIG. 7, a column 71 is a column indicating a check box 75, and a search result of the selected check box is temporarily recorded in a temporary recording step as described later. Column 72 shows the values of the columns of the row of the search result except the image file and the product ID. Besides this, it is also conceivable to display the attribute of another table associated with the product ID. For example, it is conceivable that a table indicating the correspondence between the product ID and the manufacturer name of the product is separately prepared, and the manufacturer name of the product obtained by the search is displayed. The column 73 displays the contents of the image file. Column 74 is a scroll bar.

FIG. 8 is a flowchart for explaining the operation of the computer 20 when executing the search result display step. In step 81, the result of the search issued in the search step is obtained. In step 82, an image file name of each search result is obtained to obtain an image. In step 83, the search result is displayed on the user terminal 27 together with the image obtained in 82.

[0124] The temporary recording step is a step of temporarily recording the search result selected by the user from the search results displayed in the search result display step. Temporarily recording means that it is only necessary to record the information at least while the user performs some operation on the search result. For this reason, the search result is usually stored in the memory 22 and recorded.

FIG. 9 shows an example of search results recorded in the temporary recording step, and is a table in which search results selected from the search results displayed in the search result display step are added. The table in FIG. 9 stores a product group name and a product ID. By executing the search result display step, the table name on which the search result is displayed and the check box 75 are displayed from the user terminal 27. The product ID of the selected search result is added.

The permanent recording step is a step of permanently recording the search result temporarily recorded in the temporary recording step. Permanently means that the recorded contents are not erased even when the communication between the user terminal 27 and the computer 20 is cut off or when the power of the computer 20 is cut off. Is recorded on the hard disk 23.

FIG. 10 shows an example of a search result recorded in the permanent recording step, and shows a table including three columns of a record ID, a product group name, and a product ID. Record I
D is a unique number assigned when the search result temporarily recorded in the temporary recording step is recorded in the permanent recording step. For example, the last recorded ID is stored in a certain area of the hard disk 23, and when the search result is recorded in the search result recording unit 16, the record ID is read from the certain area and 1 is added. It is conceivable that the value is written in the certain area and used as the record ID.

<Embodiment 14>

In addition to the embodiment of the thirteenth embodiment, there is also an embodiment in which the search result recorded by the permanent recording step is temporarily recorded.

FIG. 12 shows an example of a screen displayed on the user terminal 27 when the search result selected by the user from the search results recorded in the permanent recording step is temporarily recorded. I have. The toilet is shown above and the unit bath is shown below. From the display form of the scroll bar on the right part of the screen, it can be seen that the displayed content is a part of the whole. The user can select and temporarily record the search results recorded by the permanent recording step by clicking on the check boxes shown as 121 and 122 with the mouse.

FIG. 11 is a flowchart showing the operation of the computer 20 when the search result recorded in the permanent recording step is temporarily recorded by the selection from the user terminal 27. In step 111, the merchandise group name and the merchandise ID constituting the search result recorded in the permanent recording step are read into the memory. In step 112, the table of FIG. 3 corresponding to the product group name is read, and the primary key is the product ID read in step 111.
Reads the line marked with into memory. In step 113, the value of the column of the image file in the row read in step 112 is obtained, and the content of the image file is read to obtain an image of the product.

At step 114, the user terminal 27
To the column values of the row obtained in step 112 and step 1
The image obtained in step 13 is displayed, and the user is prompted to select a search result to be temporarily recorded. For example, a display with a check box is performed as shown in FIG. Step 11
At 5, the product group name and product ID of the search result selected by the user are obtained. For example, the W of the subwindow in which the check boxes 121 and 122 in FIG.
A table as shown in FIG. 13 for associating the windowID with the merchandise group name and the merchandise ID is prepared in the memory 22, and the W of the selected check box subwindow is displayed.
It is conceivable to obtain the product group name and the product ID from the windowID. In step 116, the product group name and the product ID obtained in step 115 are added to a table to which the product group name and the product ID are added in the temporary recording step.

<Embodiment 15>

In the above embodiment, a comment is added when the search result recorded in the temporary recording step is permanently recorded in the permanent recording step. To add a comment is to attach a sentence describing the relation to the search result because the temporarily recorded search result is selected for a certain relation. The comment is input by the user from the user terminal 27 and added to the search result, and the added comment is permanently recorded when the search result is recorded in the permanent recording step.

FIG. 14 shows an example in which a comment added to a search result is recorded, and a table for storing a record ID added when the search result is recorded in the permanent recording step and the added comment. It has become. Thereby, it is expressed that the search result with the record ID of 10 is related to Room 303, Yurakucho Heights 1-8-1 Yurakucho, Chiyoda-ku, Tokyo.

<Embodiment 16>

In the thirteenth embodiment or the fourteenth embodiment, there is also an embodiment in which a user can write a comment on a product and read the comment. A comment about a product is a user's impression of the product. By reading the impression of the product, the user can know the reputation of the product,
It can be used as reference information for product selection. In this embodiment, an example is considered in which a table storing comments on products is prepared for each of the tables corresponding to the product groups in FIG. 3, and FIG. 15 stores such comments. An example of a table is shown.

The table of FIG. 15 stores comments on products stored in the table corresponding to the product group of FIG. 3, and indicates which product the comment is for.
The determination can be made by looking at the value in the column of the product ID.

For this embodiment, a button for writing a comment for a product and a product are written for each product on a screen displaying search results shown in FIGS. 7 and 12. Add a button to display comments. When the comment writing button is pressed, a program for writing a comment of the computer 20 is activated, and a sub-window for writing a comment is displayed on the user terminal 27. When the program senses that the user has finished writing the comment and, for example, pressed the button to write the comment, the product I is displayed in the table of FIG.
A comment is added together with D, time, and the user name of the user terminal 27.

When the button for displaying the comment is pressed, a program for reading the comment of the computer 20 is started, and it is determined whether the button for displaying the comment on which product ID of which product group is pressed. ,
The product ID is retrieved from the table storing the comments corresponding to the product groups, the comments of the target product are collected, and displayed on the user terminal 27.

FIG. 16 is a flowchart for explaining the operation of the program for reading comments in more detail. In the search result, the searched product is displayed together with the comment display button, and the window ID, the product group name, and the product I of the sub-window constituting the display button are displayed.
It is assumed that the correspondence of D is managed by the computer 20 as shown in FIG. In step 161, the window ID of the sub window whose comment display button is pressed is obtained. In step 162, a product group name and a product ID are obtained from the WindowID. In step 163, the table storing the comment corresponding to the product group name is searched by the product ID obtained in step 162. In step 164, the obtained comment is displayed on the user terminal 27. For example, it is conceivable to display a sub window for displaying comments.

<Embodiment 17>

As a modification of the sixteenth embodiment, there is an embodiment in which the computer 20 executes a comment manager screen display step and a comment selection step. In this embodiment, when a comment on a product is written by the user, the comment is not stored unconditionally in the table of FIG. 15 but is stored in the comment temporary storage table and stored in the comment temporary storage table. In some embodiments, the comment is displayed on an administrator screen, and the administrator can select display on the user terminal 27 for each comment.

The comment manager screen display step is a step of displaying the contents of a comment temporary storage table for storing comments written by the user on the manager screen for the manager. The comment selecting step is a step in which a comment selected by the administrator from the comments displayed in the comment manager screen displaying step can be displayed on the user terminal 27.

The manager is the managing entity of the product database search device, and the comment temporary storage table is a table for storing comments prepared separately from comments displayed to the user. Comments stored in the table can only be read by the administrator. What is the administrator screen?
This is a screen for displaying a comment stored in the comment temporary storage table and performing an operation of moving the selected comment to a table in which comments displayed on the user terminal 27 are stored.

FIG. 17 shows an example of the manager screen, in which the comments stored in the comment temporary storage table are displayed. Check box 17 in the column labeled Post
1, 172. When this check box is selected by the administrator, the comment in the selected line is moved to a table in which the comment to be displayed to the user is stored. When the administrator selects the check boxes 173 and 174 in the column of “delete”, the comment of the selected line is deleted from the comment temporary storage table, and the comment displayed on the user terminal 27 is stored in the table. Stop moving.

FIG. 18 shows the operation of the computer 20 for operating a comment from the display of the administrator screen. In step 181, the comment stored in the comment temporary storage table is displayed on the manager screen. Step 182
In, the comment selected by the posting check box is moved to a table in which the comment displayed to the user corresponding to the product group is stored. In step 183, the comment selected by the delete check box is deleted from the comment temporary storage table.

<Embodiment 18>

As a modified embodiment of the thirteenth embodiment or the fourteenth embodiment, the computer 20 executes a search result recording and displaying step. There is also an embodiment characterized in that the information is displayed on the user terminal 27 and detailed information of the product of the selected search result is displayed by an operation from the user terminal.

In the search result recording and displaying step, the temporarily or permanently recorded search results are displayed on the user terminal 27, and detailed information of the displayed product is displayed by the operation of the user. Step. For example,
Along with displaying product information, a button is displayed to show detailed product information. Further, instead of a button for displaying detailed information of a product, detailed information of the product may be displayed by clicking a mouse on an image of the product.

The detailed information of a product is information that is not displayed on a product search screen and a screen displaying a product search result. Such information is stored in a table for storing detailed information corresponding to the table of each product group in FIG. 3, and the table for storing the detailed information is searched by the product ID to obtain detailed information. And can be displayed on the user terminal 27.

<Embodiment 19>

In this embodiment, the computer 20 executes a display count recording step of recording the number of times detailed information of a product is displayed on the user terminal 27 for each product in the product database search / recording apparatus of the eighteenth embodiment. As shown in FIG. 19, the number of times the display of detailed information of a product is requested from the screen displayed on the user terminal 27 in the search result recording and displaying step is, as shown in an example in FIG. Is recorded in a table in which the number of times is recorded for each product ID in a table corresponding to. The more often you see detailed product information,
Since it can be said that the interest in the product is high, when the search result temporary record display unit and the search result record display unit display the search results, by marking some items that are displayed many times, Alternatively, the degree of interest in the product may be displayed.

<Embodiment 20>

In the above embodiment of the method of searching the product database and recording the search result, the search result is recorded as
Although it has been assumed that this is performed by recording the product group name and the product ID, other embodiments are possible. That is, the range of possible values of the product ID, which is the primary key, is determined in advance for each product group table, and the ranges are prevented from overlapping each other.
When D is given, it is determined which range the product ID belongs to, thereby determining which product group table is the product ID of the product in the table. This allows
When recording the search result, if only the product ID is recorded, the product is uniquely determined.

For example, a merchandise ID ranging from 0000 to 0099 is assigned to a bus, and a merchandise ID ranging from 0100 to 099 is assigned to a toilet.
9 for the product ID, 1000 for the kitchen, 2999 for the kitchen, 700 for the fittings.
Commodity IDs in the range from 0 to 8999 are allocated so that those ranges do not overlap. When the search result is recorded, only the product ID is recorded, and when the attribute of the product is obtained from the product ID, it is determined in which range the product ID is located. It is determined whether or not it belongs to the group table, and the product group table obtained by the determination is searched.

<Embodiment 21>

Further, a table showing the correspondence between the product ID and the table is prepared, and when the product ID is given, the table name of the product group in which the product ID appears is provided. In some embodiments, the search result is recorded by recording the product ID. The table indicating the correspondence between the table and the product ID is a table including two columns, one storing the product ID and the other storing the product ID. This is the table that stores the table name of the group. An example of this is shown in FIG. For example, the product ID is 000
1 means that it appears in the table of the product group named bus.

By preparing such a table, when a product ID is given, the name of the product group can be known by searching the table, and information on the product can be obtained from the name and the product ID. Can be obtained.

<Embodiment 22>

In the fourteenth embodiment, information for associating a product with its retailer is stored in the product database, and an estimate request screen display step, an estimate request step, an estimate reception recording step, and an estimate result display step are performed. In some embodiments, the computer 20 executes. The information for associating a product with its store is information indicating at which store the product is sold, and is stored in, for example, a table as shown in FIG. FIG. 21 shows that a product whose product group has a bus product ID of 0001 is sold at A store. The address column stores an address to which a quote request is sent when requesting a quote in the quote request step.

In the estimate request screen display step, a screen for requesting an estimate from a temporarily recorded search result is displayed on the user terminal. Specifically, as shown in FIG. 22, by displaying a screen having a column for inputting the number of products in the temporarily recorded search results, how many products each user needs is displayed. Display a screen that allows you to enter The quote request step is performed for each product using the temporarily recorded search results, the number of products input on the screen displayed by the quote request screen display step, and information for associating the product with the store. Then, a request for a quote is sent to the merchandise dealer.

The operation of the computer 20 in the estimation requesting step is as follows. For one or more products input on the screen displayed in the estimate request screen display step, the address of the store of the product is obtained using the information that associates the product with the store. Then, to the address, the number of the quote request, the information for specifying the product and the number of the products, and the information for reference of the quote such as the name of the user who made the quote request are transmitted. In addition, record that an estimate has been requested.

The quote request number is a number uniquely assigned to the quote request. When the quote request number is specified, it is possible to know which product the quote request was made. It is a number that can be.

The information for specifying the product is information for uniquely specifying the product, and usually uses the manufacturer name of the product and the product number of the manufacturer. Although the table shown in FIG. 3 does not seem to store the maker name or the product number of the product, a table storing detailed information of the product is prepared in each table corresponding to the product group. In this case, the manufacturer name and the product number are stored in the table, and the table and the table corresponding to the product group may be associated by the product ID.

Transmitting the information means transmitting the information to the designated address. For example, the address http: // trade. k. co
m / cgi-bin / trade. The cgi has a quote number of 1234, a manufacturer name of HOHO, and a product number of GJ3498-
B, if the number is 3, http: // trade. k.
com / cgi-bin / trade. cgi? reqno =
1234 & producedby = HOHO & item
no = GJ3498-B & count = 3 HTT
Send P request. An embodiment in which an electronic mail is sent to a mail address in a predetermined format is also conceivable.

To record the fact that the quote has been requested means to record in a table in order to associate the quote request number with the product for which the quote was sent. An example of the record is shown in FIG. 23, and includes columns of an estimate number, a display number, a product group, a product ID, the number, and an estimate result. The quote number is a number that gives the same number to the search result that requested the quote, and a different number is assigned to another quote request. When the number is specified, it is possible to know which product has been requested for an estimate. The display number indicates the display order when the product information is displayed on the estimate request creation screen. The product group and product ID uniquely identify the product. The number is the number of products input on the estimate request creation screen. The quote result is a quote price for a quote request. If a response to the estimated price has not been received yet, a special value of NULL indicating a null value is set in the estimated result.

The estimate receiving and recording step is a step of receiving an estimate request number and an estimate price from a store, and recording the estimate result in a table that records that the estimate has been requested.

In the estimation result display step, the contents of the table for recording that the estimation has been requested are displayed on the user terminal 27. FIG. 24 is an example of a screen displayed by executing the estimation result display step. If the value of the column of the estimation result of the table that records the request for the quotation is NULL, it means that there is no response to the quotation, and the indication of requesting the quotation is displayed.

In this embodiment, an embodiment in which information for associating a product with its store is associated with one store for one product is also conceivable. By associating one store with one product, it is possible to prevent a discount competition for the product.

<Embodiment 23>

In the twenty-second embodiment, a temporarily recorded mail sending step of sending a temporarily recorded search result by e-mail and a mail receiving step of temporarily recording the search result sent by e-mail are performed by a computer. In some embodiments, 20 is performed. For example, the contents of the table of the product group name and the product ID of the search result temporarily recorded are made into a structured document, transmitted, and the side receiving the mail analyzes the structure of the structured document. It is conceivable to add a product group name and a product ID to a table in which search results are temporarily stored.

For such an embodiment, the computer 20
Executes the steps of combining the temporarily recorded search results into a structured document and sending the structured document to a specified mail address from the user terminal 27. When a structured document is received, a step of analyzing its structure, a step of extracting a product group name and a product ID, and a step of temporarily adding it are performed. Alternatively, an embodiment in which transmission and reception are performed in a so-called CSV file format is also conceivable.

<Embodiment 24>

The twenty-fourth embodiment is an embodiment in which a plan view displaying step and a linking step are executed by the computer 20 in addition to the operation of the computer 20 in the twenty-third embodiment. In the plan view display step, the drawing of the building is displayed on the user terminal 27. The link step is to detect the coordinates of the position specified on the drawing displayed on the plan view display unit, and, for a part of the plan view in the vicinity thereof, among the search results temporarily recorded, And setting a hyperlink to the selected search result.

Note that the temporarily recorded search result may be the search result transmitted by mail in the eleventh embodiment. The position designated on the drawing displayed in the plan view display step is a coordinate position on the drawing, for example, when the user performs a mouse click operation on the drawing displayed on the user terminal 27. Is specified.

The neighborhood is a position portion on a plan view including a designated coordinate position and having a certain extent, such as a rectangular area having two vertices designated by the user or a user designated by a user. The area is a region surrounded by a line on the plan view including the position indicated by the arrow. A hyperlink is created by associating a specific location with an image file or document file so that clicking on a specific location in the floor plan displays the content of the image file or the content of the document file. is there.

FIG. 25 shows an example in which hyperlinks are provided in a plan view. <IMAGE SRC = "7th-floor. ×××” US
EMAP = "# 7thFloor"> is the 7th-floor. ×
Xx, and the hyperlink information is 7thFloor
It represents that. From <MAP NAME = "7thFloor"> to </ MA
The part of P> represents the content of the hyperlink information of 7thFloor. For example, if you click on the area indicated by the coordinate position of 15, 11, 165, 143, the contents of the image file FB0001.XXX will be displayed It means that they are associated.

FIG. 26 shows the operation of the computer 20 for generating hyperlink information whose example is shown in FIG. In step 261, a coordinate position on a plan view specified by a user operation such as clicking a mouse button is obtained. In step 262, a neighborhood is determined. For example, it is conceivable to obtain the coordinates of the vertices of a square of a predetermined size centered on the specified position. Further, as another embodiment, it is conceivable to obtain the coordinates of the vertices of a rectangular area included in an area surrounded by a line on the plan view and including a position designated by the user. In step 263, the merchandise group and merchandise ID of the merchandise selected from the temporarily recorded search results are obtained, and the image file name is obtained. Step 26
4. In <AREA SHAPE = RECT COORDS = "…" HREF = "...
… "> Is output. HREF =
This is the image file name obtained in step 263.

[0180]

As described above in detail, according to the present invention, it is possible to search for a product in a plurality of product groups and record the search results with one system. In addition, there are temporary records and permanent records in the search result records, treat the search results as temporary records, make a permanent record to use the search results at a later date, This makes it possible to handle a temporary record again as a temporary record.

When performing permanent recording, a comment is added, so that the contents of the recording can be easily known. Since the user can write a comment on the product and read the written comment, the user can know the reputation of the product and can refer to the selection of the product.

Also, by specifying whether or not the user can see the written comment, it is possible to prevent harmful comments such as slander of the product from spreading to the users. Can be. When the search result is displayed, by displaying the summary information of the product and the detailed information on the product selected by the user, the search result that is easy for the user to understand can be displayed.

Further, by recording the number of times detailed information of a product is displayed, it is possible to provide a clue for the user to know the reputation of the product. By associating the product with the retailer's information, customers can request quotes for temporary records of search results,
You can know the result of the quotation.

Further, by associating one store with one product, competition for discounts can be prevented, and pressure from the manufacturer of the product can be prevented. By sending a temporary record of search results to others by e-mail, the contents of the search results can be shared with others. In addition, it becomes possible to request some work based on the search result. Displaying the plan view on the user screen and linking the area of the plan view with the temporarily recorded search result facilitates the creation of the presentation material.

[Brief description of the drawings]

FIG. 1 is a configuration diagram of a product database search and recording device.

FIG. 2 is a configuration diagram of a computer.

FIG. 3 is an example of a table constituting a product database.

FIG. 4 is an example of a screen for selecting a product group.

FIG. 5 is an example of a screen for inputting search conditions for a product.

FIG. 6 is a flowchart illustrating an operation of searching for a product from the display of a search screen.

FIG. 7 is an example of a screen displaying a search result.

FIG. 8 is a flowchart for explaining a screen display operation for displaying search results.

FIG. 9 is a diagram showing an example of a table for temporarily storing search results.

FIG. 10 is a diagram illustrating an example of a table for permanently storing search results.

FIG. 11 is a flowchart illustrating an operation for temporarily recording search results that are permanently recorded.

FIG. 12 is a diagram illustrating an example of displaying search results permanently recorded on a screen.

FIG. 13 is an example of a table for managing a correspondence between a sub-window displaying a search result and a product search result when the search result is displayed on a screen.

FIG. 14 is an example diagram of a table storing comments added to a permanent record.

FIG. 15 is a diagram illustrating an example of a table storing comments attached to products.

FIG. 16 is a flowchart illustrating an operation of displaying a comment attached to a product.

FIG. 17 is a view showing an example of a comment displayed on the manager screen.

FIG. 18 is a flowchart illustrating an operation of performing comment processing by an operation from an administrator screen.

FIG. 19 is a diagram showing an example of a table for recording detailed information of a product.

FIG. 20 is a diagram illustrating an example of a table storing correspondence between a product ID and a product group to which the product ID belongs;

FIG. 21 is a diagram illustrating an example of a table storing a correspondence between a product and a store;

FIG. 22 is an example of an estimate request screen.

FIG. 23 is an example of a table for recording that an estimate has been requested;

FIG. 24 is an example of a screen displaying an estimation result.

FIG. 25 is a diagram illustrating an example of a description in which a hyperlink is provided in a plan view.

FIG. 26 is a flowchart illustrating an operation of setting a hyperlink on a plan view.

[Explanation of symbols]

 Reference Signs List 10 product database search recording device 11 product database 12 search screen display unit 13 search execution unit 14 search result display unit 15 search result temporary recording unit 16 search result recording unit

Claims (28)

[Claims] 1. A product database having a table for storing product attributes for each product group having different attributes, a search screen display unit for displaying a search screen corresponding to a product group on a user terminal, and the search screen. A search execution unit that searches a table corresponding to a product group corresponding to the search screen according to the value input to the search screen; and a search result display unit that displays a search result obtained by execution of the search execution unit on the user terminal. A search result temporary recording unit for temporarily recording a search result selected by an operation of the user terminal among the search results displayed by the search result display unit, and a search result temporarily recorded in the search result temporary recording unit. A product database search and recording device comprising: a search result recording unit that permanently records a search result. 2. The temporary storage of the search result by temporarily recording a search result selected by an operation of the user terminal from the search result permanently recorded by the search result recording unit. 2. The merchandise database search and recording device according to claim 1, wherein the merchandise database can be handled as a search result recorded by the section. 3. The search result recording unit can add a comment when the search result recorded in the search result temporary recording unit is permanently recorded by the search result recording unit. The merchandise database search and recording device according to claim 1 or 2. 4. A comment is written on a search result displayed by the search result display unit, a search result recorded in the search result temporary recording unit, and a product of the search result recorded in the search result recording unit. 3. The merchandise database search and recording device according to claim 1 or 2, wherein the comment can be read. 5. The administrator can display the written comment on an administrator screen, and display the comment on the user terminal according to the availability of the posting selected by the administrator for each comment. 5. The merchandise database search and recording device according to claim 4, further comprising a comment display unit. 6. A search result temporary display unit for displaying a search result recorded in the search result temporary storage unit on the user terminal, and displaying the search result recorded in the search result storage unit on the user terminal. A search result record display unit for displaying the search result, the search result display unit, the search result temporary record display unit, and the search result record display unit first display an outline of a product on the user terminal, 3. The merchandise database search and recording device according to claim 1, wherein detailed information of the merchandise of the search result selected by an operation from a user terminal is displayed on the user terminal. 7. The merchandise database search and recording apparatus according to claim 6, wherein the number of times detailed information of the merchandise is displayed on the user terminal is recorded. 8. The method according to claim 1, wherein when the search result is temporarily and permanently recorded, a primary key and a table name of the table for each product group are recorded. A product database search and recording device according to item 1. 9. The primary key value range is determined so as not to overlap with each other for each of the product group tables. 3. The apparatus according to claim 1, wherein a primary key of a table for each group is recorded. 10. The product database stores a table in which a primary key of a product-specific table and a table name of a product are recorded in order to record a correspondence relationship between which primary key value is the primary key of which table. 3. The product database search record according to claim 1, wherein when the search result is temporarily and permanently recorded, a primary key of the table for each product group is recorded. apparatus. 11. The product database also stores information for associating a product with a store of the product, and a quote request creation screen for creating a quote request for the product from the temporarily recorded search results. An estimate request creation screen display unit to be displayed on the user terminal; and an input product estimate information displayed on the estimate request creation screen and associated with the item by information stored in the item database. An estimate requesting section for summarizing by store and sending out an estimate request for each store, an estimate receiving and recording section for receiving and recording an estimate result from the store, and an estimate result display for displaying the estimate result on the user terminal 3. The merchandise database search and recording device according to claim 2, comprising: 12. The merchandise according to claim 11, wherein the information stored in the merchandise database for associating the merchandise with a store of the merchandise corresponds to one merchandise and one store. Database search recorder. 13. The product database according to claim 10, wherein the search result temporarily recorded is transmitted by e-mail, and the search result sent by e-mail can be temporarily recorded. Search recording device. 14. A plan view display unit for holding a plan view and displaying the plan view on the user terminal, and temporarily storing the plan view at a position designated on the plan view displayed on the user terminal. 14. The product database search and recording device according to claim 13, further comprising a clickable map creation unit that can link to a search result selected by an operation of the user terminal among the recorded search results. 15. A method for searching a product database in which a table for storing product attributes is stored for each product group having different attributes and recording a search result, wherein the computer operates the product in accordance with an operation from a user terminal A search screen display step of displaying another search screen on the user terminal, a search step of searching a table corresponding to a product group corresponding to the search screen, and a search result display of displaying search results on the user terminal A temporary recording step of temporarily recording a search result selected from the search results by an operation from the user terminal, and a permanent recording step of permanently recording the search result recorded by the temporary recording step. How to search the product database and record the search results. 16. The method according to claim 1, further comprising: temporarily recording a search result selected by operation of said user terminal from search results permanently recorded in said permanent recording step; 16. The method according to claim 15, wherein the search result can be handled as a selection result recorded in the product database. 17. The method according to claim 15, wherein in the execution of the permanent recording step, the computer executes a comment adding step of adding a comment. 18. The computer according to claim 15, wherein the computer executes a product comment adding step of adding a comment to the product of the search result and recording the comment, and a product comment reading step of reading a comment added to the search result. Search method of 16 product databases and recording of search results. 19. The computer according to claim 19, wherein the computer displays the written comment on an administrator screen, and writes the comment to the user terminal in accordance with the administrator's selection of whether to post the comment. 19. The method for searching a product database and recording a search result according to claim 18, further comprising a comment selecting step for enabling display. 20. The computer executes a search result recording and displaying step of displaying the search result recorded in the temporary recording step and the permanent recording step on the user terminal, wherein the computer displays the search result and the search result. In the record display step, first, an outline of a product is displayed on the user terminal, and detailed information of the product of the search result selected by an operation from the user terminal is displayed on the user terminal. 17. The method for searching a product database and recording a search result according to claim 15 or claim 16. 21. The method according to claim 20, wherein the computer executes a display count recording step of recording the number of times the detailed information of the product is displayed on the user terminal. 22. The computer according to claim 15, wherein when the search result is temporarily and permanently recorded, the computer records a primary key and a table name of the table for each product group. 17. A method for searching a product database according to claim 16 and recording a search result. 23. The range of the value of the primary key is determined so as not to overlap with each other for each of the tables for each of the product groups, and when the search results are temporarily and permanently recorded, the computer is used. 17. The method according to claim 15, wherein a primary key of a table for each product group is recorded. 24. The product database, wherein a table in which a primary key of a product-specific table and a name of a product-specific table are recorded in order to record a correspondence relationship between a primary key value and a table of the primary key. To store search results temporarily,
17. The method according to claim 15, wherein the computer records a primary key of a table for each product group when the data is permanently recorded. . 25. An estimate request wherein the computer stores information relating a product to a store of the product, and wherein the computer creates an estimate request from the search result temporarily recorded. An estimate request screen display step of displaying a screen on the user terminal; and a display of the estimate request screen, the input estimate information of the item being associated with the item by the information stored in the item database. An estimate requesting step of summarizing by store and sending an estimate request by the store; an estimate receiving and recording step of receiving and recording an estimate result from the store; and an estimate result of displaying the estimate result on the user terminal. 17. The method of claim 15 or claim 16 for executing a display step. 26. The merchandise according to claim 25, wherein the information stored in the merchandise database for associating a merchandise with a store of the merchandise corresponds to one merchandise and one store. How to search the database and record search results. 27. A temporary recording mail sending step in which the computer sends the temporarily recorded search result by mail, and the search result sent in the temporary recording mail sending step is recorded by the temporary recording step. 17. The method according to claim 15, further comprising: executing a mail content capturing step of capturing as a searched result. 28. A computer comprising: a computer for storing a plan view and displaying the plan view on the user terminal, wherein the computer displays the plan view, and at a position designated on the plan view displayed on the user terminal, Linking a link to a search result selected by an operation of the user terminal from among the temporarily recorded search results.