JP2001319138A - Method and system for displaying advertisement information - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an advertisement information display system which easily extracts advertisement information on the price, etc., of a target article and advertisement information such as store information from stores in an area that a consumer desires and displays them to the consumer in an easy-to-see state. SOLUTION: The store information and advertisement information are sent from a store terminal device 5 of each store and stored in an area DB 41, a store DB 42, and an advertisement DB 43 on a DB server 3. When display request information including area information is sent from a consumer terminal device 4 to a WWW/CGI (34) on an advertisement server 2 of the advertisement information display system 1, a display information generation part 30 is actuated, a parameter analyzing process part 35 analyzes parameters included in the display request information, and a DB retrieving process part 36 extracts data corresponding to the parameters from the respective databases on the DB server 3. The extracted data are sent from a display data generation part 37 to the consumer terminal device 4 and advertisement information limited to the area is displayed.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an advertisement information display method and an advertisement information display system. The present invention relates to an advertisement information display method and an advertisement information display system for displaying a price.

[0002]

2. Description of the Related Art In a computer network, for example, the Internet, consumers can use a computer to access W
By accessing the homepage of a store provided on a WWW server on the WW (World Wide Web) using a WWW browser (hereinafter referred to as a browser as appropriate), it is possible to keep the products and prices of stores in all regions while staying there. You can know. There are cases where it is desired to compare such products and prices of stores on the WWW with products and prices of other stores on the WWW. As a method for a consumer to search for information on products and prices provided by stores on the Internet WWW, (1) a general search site performs a search using a product name or the like as a keyword, and the consumer uses the search result to perform a search. Can directly refer to each store's homepage to collect advertising information for products, (2)
Upload information such as store name, product name, price, etc. manually registered by each store to a server such as an electronic shopping mall provided by a third party, and consumers access the homepage of this electronic shopping mall, etc. A method of collecting advertisement information of a product by referring to data displayed here has been mainstream.

[0003]

However, in a general search site, a search is performed using a product name or the like as a keyword, and a consumer directly refers to a homepage of each store based on the search result, and obtains advertisement information of the product. In the collecting method, there is a problem that even if a product name or a region is input as a keyword, there are many search omissions and noises, and it is troublesome to just find a handling store. In addition, the user accesses a homepage of an electronic shopping mall or the like provided by a third party in which information such as a store name, a product name, and a price is registered, and collects advertisement information of the product by referring to data displayed here. The method can be said to be such a hassle-free operation, but the sales situation of stores located in an area that can be easily accessed from home when consumers want to check the product directly or purchase it directly at the store Sometimes you just want to know. In this case, searching for a store that sells the desired product at the lowest price in a predetermined area requires accessing the homepage of each store and confirming its location, etc. There was a problem that it could not be discovered without spending a lot of time and complicated work.

[0004] The present invention solves the above-mentioned problems, and easily extracts price information such as the price of a target product and advertisement information such as store information from stores in an area desired by a consumer. It is an object of the present invention to provide advertisement display information and an advertisement information display system that are displayed to consumers in an easy-to-understand manner.

[0005]

In order to achieve this object, a method for displaying advertisement information according to the present invention comprises the steps of: receiving a display request information including area designation information from a consumer terminal; A store database that stores store information that is information on stores associated with region information that is information for specifying a region based on the region designation information included in the display request information received in the receiving step. And a display step of displaying, on the terminal of the consumer, advertising information including the store of the predetermined condition extracted by the extracting step. For this reason, by specifying the area by the consumer, advertising information such as the price of the product and advertising information such as store information can be displayed on the consumer's terminal only for stores in the area desired by the consumer, Consumers can easily and quickly obtain noise-free information about commodities in a desired area.

Further, in the advertisement information display method of the present invention, in the receiving step, the designation information of the area of the display request information includes:
The selection of an arbitrary area and the designation of the distance from the selected area, and the center of the area is selected by selecting an arbitrary area from an area database in which the position coordinates of each area are stored in advance by the extraction step. Is determined, and based on the distance specified from the selected area, the area whose center exists within a predetermined distance from the center of the selected area is specified. Then, stores existing in the specified area are extracted from the store database. For this reason, the consumer can display the advertising information on the consumer's terminal not only in one area but also in a peripheral area to which the consumer can go, so that the consumer easily and quickly desires. Noise-free information on products in a plurality of areas can be obtained.

Further, according to the advertisement information display method of the present invention, in the receiving step, the designation information of the area included in the display request information received is specified based on the postal code. For this reason, the area can be designated using the postal code system, so that areas without omission or duplication can be managed, and each store can easily register the area of its own store just by inputting the postal code. . Further, if the consumer can directly specify the area by inputting the postal code in addition to directly inputting the postal code, the area can be further easily specified by specifying the postal code corresponding to the address.

Further, in the advertisement information display method of the present invention, the display request information includes the product designation information including the product classification, and the advertisement information including the price of the product associated with the store information in the extracting step is stored in advance. The store is extracted from the advertisement database obtained based on the specified information of the product. Therefore, it is possible to specify and extract a product category desired by the consumer, and display advertisement information with less noise to the consumer.

Further, in the advertisement information display method of the present invention, the display step displays the products and the stores side by side in ascending order of the prices of the products. For this reason, the consumer can easily find a target product with a low price.

[0010] In the advertisement information display method of the present invention, the display step displays the stores in an order based on the area where the store exists. Therefore, the consumer can search for a store from a nearby area.

The advertisement information display method according to the present invention uses the extraction result displayed on the consumer's terminal in the display step to determine the store specified by the consumer's memo pad entry request information as the area information and the advertisement. The information is stored in a memo pad database, which is storage means, together with information selected from the information. Therefore, it is possible to select and store only those items that the consumer thinks are necessary among the extracted stores and products by an easy operation.

Further, the advertisement information display system of the present invention comprises:
A receiving unit that receives display request information including the area designation information from the consumer terminal, and a store database in which store information that is information about a store associated with the region information that is information for specifying the region is stored in advance. Extracting means for extracting a store having predetermined conditions from a store database based on the area designation information included in the display request information received by the receiving means, and advertising information including the store having predetermined conditions extracted by the extracting means. Display means for displaying on a consumer terminal. For this reason, by specifying the area by the consumer, advertising information such as the price of the product and advertising information such as store information can be displayed on the consumer's terminal only for stores in the area desired by the consumer, Consumers can easily and quickly obtain noise-free information about commodities in a desired area.

Further, the advertisement information display system of the present invention comprises:
An area database in which the position coordinates of each area to be specified are stored in advance, and the receiving means includes, as area specification information,
Upon receiving display request information including selection of an arbitrary area and designation of a distance from the selected area, the extraction means determines, from the area database, position coordinates to be the center based on the selection of the arbitrary area. In addition, an area having the center within a predetermined distance from the center of the specified area is specified, and a store existing in the specified area is extracted from the store database. For this reason, consumers are not limited to one area,
Since the advertisement information can be displayed on the consumer's terminal only in the peripheral area where the consumer can go, the consumer can easily and quickly obtain noise-free information on the products in the desired plurality of areas. Can be.

[0014] Further, the advertisement information display system of the present invention comprises:
The designation information of the area included in the display request information received by the receiving means is designated based on the postal code. For this reason, the area can be designated using the postal code system, so that areas without omission or duplication can be managed, and each store can easily register the area of its own store just by inputting the postal code. . In addition, in addition to directly inputting the postal code or inputting the address, the consumer can specify the area by the corresponding postal code, so that the area can be specified more easily.

[0015] Further, the advertisement information display system of the present invention comprises:
The display request information includes product designation information including a product category, and the extracting means extracts a store from an advertisement database in which advertisement information associated with the store information is stored in advance, based on the product designation. Therefore, it is possible to specify and extract a product category desired by the consumer, and display advertisement information with less noise to the consumer.

Further, the advertisement information display system of the present invention comprises:
The display means displays the price of the product and the store in ascending order of the price of the product. For this reason, the consumer can easily find a target product with a low price.

Further, the advertisement information display system of the present invention comprises:
The display means displays the stores in an order based on the area where the stores are located. Therefore, the consumer can search for a store from a nearby area.

Then, the advertisement information display system of the present invention, based on the extraction result displayed on the consumer terminal by the display means, displays the store specified by the memo pad entry request information of the consumer as area information and advertisement information. And a memo pad database storing means for storing the memo pad database as a storage means together with information selected from the above. Therefore, it is possible to select and store only those items that the consumer thinks are necessary among the extracted stores and products by an easy operation.

[0019]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, an advertisement information display method and an advertisement information display system according to the present invention will be described using an advertisement information display system 1 as a preferred embodiment with reference to the accompanying drawings.

First, the configuration of the advertisement information display system 1 will be outlined with reference to the drawings. FIG. 1 is a diagram schematically illustrating a hardware configuration of the advertisement information display system 1. As shown in FIG. 1, the advertisement information display system 1 includes an advertisement server 2 and a DB (database) server 3
The consumer information device 1 and the shop terminal device 5 are connected to the advertisement information display system 1. Here, the consumer terminal device 4 and the store terminal device 5 are connected one by one, for example, but a large number of consumer terminal devices 4 and the store terminal device 5 can be connected.

The advertisement information display system 1 and the consumer terminal device 4 need only be communicably connected as a communication network by any method, whether wired or wireless.
LAN (Local Area Network) or WAN (Wide Area Network)
It does not matter. In the advertisement information display system 1 of the present embodiment, the advertisement information display system 1 is connected to the Internet (Internet) 6 via a modem 7 by an Internet provider (not shown) using an analog public line. Of course, a digital line may be used to connect to the Internet provider via the DSU, and the method is not limited. Similarly, the consumer terminal device 4 is connected to the Internet 6 by an Internet provider via a modem 8 using an analog public line.

In the present embodiment, the store terminal device 5 is also connected to the provider of the Internet 6 via the modem 9. However, the store terminal device 5 is not limited to the Internet, but may be connected by any method, wired or wireless. All right,
It may be directly connected by a public line. Furthermore, even if the advertisement information display system 1 and the store terminal device 5 are not necessarily connected online, the server management of information from the store on a digital recording medium such as an FD (flexible disk) or an analog recording medium such as a facsimile device is performed. It is also possible to send the information to the advertisement information display system 1 and input the information to the advertisement information display system 1 by using the input device 10 including a keyboard and a scanner or the FDD (flexible disk drive) 15.

The consumer terminal device 4 is a terminal device used by consumers for searching and displaying advertisement information, such as a personal computer or a mobile phone equipped with an i-mode (registered trademark) and capable of displaying a screen. Mobile communication body,
It is realized by various kinds of hardware that can use a WWW browser, such as a game machine and a television having an STP (Set Top Box). That is, the consumer terminal device 4
Is the interface between the system and the consumer.
Here, the WWW browser is software capable of browsing the WWW, and examples thereof include Internet Explorer (registered trademark) and Netscape Navigator (registered trademark).

[0024] The shop terminal device 5 stores shop information from each shop,
It is used to register advertisement information and the like in the advertisement information display system 1. For example, it is realized by hardware that can use a WWW browser, such as a personal computer and a mobile phone. That is, the store terminal device 5 is an interface between the system and the store.

The advertisement server 2 can be specifically constituted by an information processing device such as a personal computer or a workstation. In the present embodiment, the CPU (Cent
ral Processing Unit) 13, RA
M (Ramdom Access Memory) 1
2. ROM (Read Only Memory) 14
, A FDD 15 and a HDD (Hard Disk Dr).
ive) 17, a CD-ROM drive 16, a display device 11 such as a CRT display, an input device 10 such as a keyboard, a mouse, a scanner, etc., a modem 7, etc.
8 are connected.

The DB server 3 is a server provided to store a large-capacity database and, like the advertisement server 2, can be constituted by an information processing device such as a personal computer and a workstation. In this embodiment,
A well-known workstation including a CPU 20, a RAM 19, and a ROM 21 is provided.
3. The CD-ROM drive 22 is connected via the interface 24. Here, the HDD 23 includes a plurality of drives, and is configured to be capable of storing a large capacity.
Of course, the storage medium is not limited to HD,
Magneto-optical storage media such as DR and MO and various storage media can be used, and can be appropriately selected in consideration of the capacity, the speed of R / W, and the like. The DB server 3 is connected to the advertisement server 2 via the interface 24. Although the advertisement information display system 1 of the present embodiment is configured using two workstations, the advertisement server 2 and the DB server 3, it is not always necessary to use separate workstations.
It may be constituted by one or three or more information processing devices such as workstations.

FIG. 2 is a diagram showing an outline of a functional configuration of the advertisement information display system 1. The advertisement server 2 functionally includes a display information creation unit 30, a memo pad processing unit 31, a store registration processing unit 32, an advertisement registration processing unit 33, a WWW / CGI (C
ommon GatewayInterface) 34
Is provided. These functions are stored in the form of a program in the HDD 17 of the advertisement server 2 or the like, and are stored in the CPU 1.
3 to perform its function (see FIG. 1).

WWW / CGI (34) is a function for exchanging information between a WWW server and a program.
A specific program is started from a WWW browser of a terminal device via a WWW server in response to a request from the terminal device, and the execution result is displayed on a WWW browser of the terminal device or the like. Display request information from the user, store information from each store, and advertisement information, and reads out programs such as the display information creation unit 30 and the memo pad processing unit 31 from the HDD 17 and activates them based on the display request information. The processing is executed and displayed on the display of the consumer terminal 4, the programs of the store registration processing unit 32 and the advertisement registration processing unit 33 are read from the HDD 17, and these are activated to execute the store registration processing and the advertisement registration processing. .
For this reason, consumers and each store can communicate interactively with the advertisement information display system 1 using the display of the consumer terminal device 4 or the store terminal device 5 and the keyboard and mouse (see FIG. 1). .

The DB server 3 stores an area DB (Data B)
base 41, store DB (DataBase) 42, advertisement DB (Data Base) 43, memo pad DB (Da
(Ta Base) 44. These D
B is stored in the HDD 23 (see FIG. 1).

The area DB 41 stores information for defining a district. Here, FIG. 6 is a diagram conceptually showing the configuration of the area DB 41. As shown in FIG.
Includes a district ID 61, a prefecture 62, a municipal county 63, a municipal county (2) 64, a town / village 65, an X coordinate 66, and a Y coordinate 67.
The association is stored for each district ID 61. Area D
The area information stored in B41 is managed for each district, and a district ID 61 unique to the district is assigned to each district. District I
D61 is a seven-digit number corresponding to the postal code here. In principle, the area indicated by the postal code and the area I
The area indicated by D61 matches. In addition, the prefecture 62 to which the district ID 61 belongs, the municipal county 63, the municipal county (2) 64,
The towns and villages 65 are stored in correspondence with the district IDs 61.

The position of the district ID 61 is defined by the X coordinate 66 and the Y coordinate 67 of the center of the area in the area. The center can be obtained, for example, by centering on the intersection of diagonal lines of a quadrangle including the area, or by centering on a position corresponding to the center of gravity of the area of the area. The position of the center obtained in this manner may be specified by longitude and latitude, or the X coordinate 66 and the Y coordinate 67 may be determined by a unique coordinate system. Here, an original coordinate system is determined for ease of processing. In this manner, each district is divided in a form corresponding to the area of the postal code, and a district ID unique to each divided area and the X coordinate 66 and the Y coordinate 67 of the center are obtained, and the area DB 41 Is stored and prepared in advance.

The store DB 42 stores information for defining a store. Here, FIG. 8 is a diagram conceptually showing the configuration of the store DB 42. As shown in FIG.
2, store ID 71, district ID 72, postal code 73,
Store name 74, address 1 (75), address 2 (76), telephone number 77, store image data 78, E-mail (7
9) The HP-URL (80) is stored in association with each store ID 71. The store ID 71 is “00000
A unique number assigned to each store, such as "01", is used to identify each store. The district ID 72 is “4
560001 "and the area ID 61 of the area DB 41.
(See FIG. 6). The postal code 73 is
District ID as described above, such as "456-0001"
Although it is basically the same as 72, the postal code 73 assigned to a post office box or a specific company that does not correspond to a certain area does not necessarily have the same number as the district ID 72, and is integrated with any district ID. Is also good. The store name 74 displays the business name of each store, such as “A furniture store”. The address 1 (75) stores a street, an address, a number, a number, and the like, such as "1-7-5". Address 2 (76)
The building name and the like are stored like "A department store". The telephone number 77 stores a telephone number for inquiry of a store, such as “123-456-7890”. Although not shown, the store map image data 78 is stored in, for example, an image format such as a jpeg format, and is stored so as to be displayed for consumers visiting the store. E-Mail
(79) stores an e-mail address that can be contacted with the sales manager of the store, such as "xxx @ xxx ...". HP-URL (Home Page-Unifo
The rm Resource Locator (80) stores the address of the homepage on the WWW established by the store in DNS (Domain Name System).
m), the protocol, server name,
The URL consisting of the file name is, for example, "http://www.xxx
@ xxx.xxx ".

The advertisement DB 43 stores information for defining advertisements related to merchandise provided by stores. Here, FIG. 7 is a diagram conceptually showing the configuration of the advertisement DB 43. As shown in FIG. 7, the advertisement DB 43 includes
Store ID 81, major category 82, middle category 83, small category 84,
A product name 85, a maker name 86, a selling price 87, a list price 88, and a photographic image 89 are stored in association with each product. The store ID 81 is the same as the store ID 71 of the store DB 42 (see FIG. 8), and is used to specify the store. The major category 82 indicates the largest category to which the product belongs, for example, “living”, “office”, “fashionable”,
They are classified according to the position of commodities in consumer life such as "clothing". The next middle category 83 is a sub-category classified in the large category 82, such as “life”, and is classified into items such as “furniture” and “repair”.
The sub-class 83 is a sub-class which is further subdivided into, for example, “furniture” classified by the middle class 83, and is classified into, for example, items such as “learning desk”, “tance”, and “chair”. The product name 85 is a product subdivided into a large category 82, a middle category 83, and a small category 84. For example, in the case of a mass production product, a product number of a manufacturer such as "A-1" is used. In the case of a handmade product, the product is specified using a name such as "5-stage closet" that can specify the product. An example may be given in a pull-down menu, but registration with any other name is free. Manufacturer name 86
Stores the name of the maker that manufactured the product, for example, "Maker A". The selling price 87 stores the selling price desired by the store, for example, “9000 (yen)”.
Price 88 is when the product has a price,
It is stored as "10000 (yen)". However, there are products such as handmade products and open prices, so the price is not necessarily required.

The memo pad DB 44 selects advertisement information that the consumer wants to keep information from among the displayed advertisement information, and temporarily stores the selected advertisement information. This is when the consumer specifies the advertisement information search condition on the browser, and on the screen where the search result is displayed (see FIG. 9), the consumer wants to save the search result. Is used to select and store the data. Details will be described later. The postal code dictionary 45 stores postal codes and their corresponding addresses. FIG. 12 is a diagram conceptually showing the configuration of the postal code dictionary 45. As shown in FIG. 12, the postal code dictionary 45 is table data in which an address corresponding to each postal code is stored. Therefore, it is possible to search for and extract an address corresponding to the postal code as a keyword, or to search for and extract a postal code corresponding to the address using the address as a keyword. It is also possible to search for a postal code from a part of an address or an address from a part of a postal code. Therefore, for example, a postal code of “456-0000” is extracted from an address of “Atsuta-ku, Nagoya City”, or a constellation of “Atsuta-ku, Nagoya City” is derived from a postal code of “456-0000”. Address can be extracted. In the case where a plurality of addresses correspond to one postal code, all of the plurality of addresses are extracted and displayed in a pull-down menu on the screen.

Next, each function in the advertisement server 2 will be described. The store registration processing unit 32 determines that each store is a store terminal device 5
Is registered by the WWW / CGI (34) of the advertisement server 2 in response to a request from the store terminal device 5, and stores the store information input from the screen of the store terminal device 5 into the store DB 42 of the DB server 3. Register with.

The advertisement registration processing section 33 is activated by the WWW / CGI (34) of the advertisement server 2 in response to a request from the store terminal device 5 when each store registers advertisement information.
The advertisement information input from the screen of the store terminal device 5 is registered in the advertisement DB 43 of the DB server 3.

[0037] The display information creating section 30 is provided for the consumer terminal device 4.
In response to the display request information from, the display information that can be referred to from the consumer terminal device 4 by the WWW browser is created. The display information creation unit 30 includes a parameter analysis processing unit 35, a DB search processing unit 36, and a display data creation unit 37.

The parameter analysis processing section 35 analyzes information received from the consumer terminal device 4 and extracts parameters included in the information. The DB search processing unit 36 determines whether the received information is display request information or memo pad entry request information based on the parameters extracted by the parameter analysis processing unit 35.
41, necessary data is searched from the store DB 42 and the advertisement DB 43 to extract area information, store information, and advertisement information.
The display data creation unit 37 creates display data that can be displayed as a WWW page based on the data extracted by the DB search processing unit 36 and the memo pad processing unit 31.

When the advertisement information to be temporarily recorded is selected from the advertisement information listed on the consumer terminal device 4, the memo pad processing section 31 sends the consumer ID and the product advertisement from the display data creation section 37. The ID and the store ID are stored in the memo pad DB 44, and then the contents are passed to the display data creation unit 30. The display data creation unit 30 creates display data in which product data is rearranged in store order and product category order. As a method for the consumer to delete unnecessary items from the displayed notepad display data, when the consumer marks unnecessary items from the notepad display data, the memo pad processing unit 31 After deleting the product advertisement ID from the DB 44, the content is passed to the display data creation unit 30.

Next, the processing procedure of the advertisement information display system 1 configured as described above will be described. First, a procedure when each store registers store information in the advertisement information display system 1 will be described. Here, FIG. 3 is a flowchart showing the flow of processing at the time of registering store information. First, the store in which store information is to be registered activates the WWW browser of the store terminal device 5 and, while viewing a display device (not shown) such as a CRT display, uses a keyboard or mouse to provide an input device (not shown). ), A predetermined URL as an address on the Internet 6 (see FIG. 2) of a page for registering store information of the advertisement information display system 1
Enter When the store terminal device 5 is connected to the advertisement information display system 1 in this manner, the WW on the advertisement server 2
The store information processing unit 32 on the advertisement server 2 is activated by the W / CGI (34) (step (step is abbreviated as S in the following description and figures) 1). When the store information registration processing unit 32 is activated, a page necessary for registering the store information is read, and the page is displayed on a display device (not shown) of the store terminal device 5.

Here, FIG. 10 is a screen configuration diagram of a store information registration screen for inputting store information on the browser of the store terminal device 5. As shown in FIG. 10, the store information registration screen includes store information 90 and branch information 94. The store information 90 includes a store name 91, a zip code 92, an address 93, and E
-Mail (98) and HP-URL99. The store name 91 is used to enter the business name of the store. For example, if the store is “aa furniture store”, “aa furniture store” is input to the store name. Next, if the postal code 92 is the postal code of a store, for example, 456-0002, "4
56 "and" 0002 "are input. Then, an address is input to the address 93. In this case, the postal code 456-00
02, the corresponding address may be searched for and extracted from the postal code dictionary 45, and the address may be displayed on the screen. If a plurality of addresses are applicable, select the address from the pull-down menu. Is also good. Of course, characters may be input. Conversely, when the address is entered, the postal code corresponding to this address is searched from the postal code dictionary 45.
You may make it extract and display it on a screen automatically. Also, E-Mail (98) is, for example, “xxxx @ x
xxxx.xxx ", and the HP-URL 99 is" ht
tp: //www.xxx.xxxx.xxx ". Further, in FIG. 10, a telephone number, a store map, and the like are also input.

Here, if there is a branch that sells a common product, necessary data is input to the branch information 94. The input method is the same as that for the store information 90, and the store name 95, postal code 96, and address 97 are input. If there are two branches, enter the store name, zip code and address in the same manner. Of course, when there are three or more branches, the input button for adding a branch may be further displayed and operated by operating the add button. After completing the above input,
The store information is registered by operating the register button (S2).
When the shop information is transmitted from the shop terminal device 5, the WWW / CGI (34) of the advertisement server 2 stores the shop information in the shop DB of the DB server 3 (S3). With the above procedure, the storage of the store information in the store DB 42 is completed (end), and the store information is stored in a configuration as shown in FIG.

Next, a procedure when each store registers advertisement information in the advertisement information display system 1 will be described. Here, FIG. 4 is a flowchart showing a flow of processing at the time of registering advertisement information. First, the store in which the advertisement information is to be registered starts the WWW browser of the store terminal device 5, and stores the CR.
While watching a display device (not shown) such as a T display, an input device (not shown) equipped with a keyboard and a mouse is used to input an Internet 6 (see FIG. 2) of a page for registering advertisement information of the advertisement information display system 1. ) Input a predetermined URL as the above address. Note that the link may be made by operating a button of “advertisement information registration” shown in FIG. In this way, the store terminal device 5
Is connected to the advertisement information display system 1, the WWW / CGI (34) on the advertisement server 2 activates the advertisement registration processing unit 33 on the advertisement server 2 (S11). When the advertisement registration processing unit 33 is activated, a page necessary for registering the advertisement information is read, and the page is displayed on a display device (not shown) of the shop terminal device 5.

Here, FIG. 11 is a screen configuration diagram of an advertisement information registration screen for inputting store information on the browser of the store terminal device 5. As shown in FIG. 11, the advertisement information registration screen includes a shop name 100, a zip code 101, an address 102, and advertisement information 103. Store name 100 is already store D
B42 (see FIG. 2), if the store name 100 is input on the screen of the store terminal device 5 and transmitted to the advertisement server 2, the postal code or address that is already stored at present is stored in the postal code 101 or the postal code. It may be displayed at the address 102.

The product advertisement information 103 includes a classification designation 104 and a product description 117. The classification designation includes a large classification 105, a middle classification 106, and a small classification 107. Here, the classification is determined in advance, and the large classification 10
When 5 is selected from the pull-down menu, the middle category 10
Reference numeral 6 denotes a pull-down menu in which options according to the selected large category 105 are displayed. Then, for the small category 107, similarly, options according to the middle category 106 are displayed by a pull-down menu. Then, when the classification designation is completed and transmitted to the advertisement server 2 in this way, the already registered product details 117 corresponding to this classification are displayed. The registered product details 117 include a product photographic image 108, a product name 109, a maker name 110, a selling price 111, and a regular price 11.
2, advertisement start date 113, advertisement end date 114, branch advertisement 1
15, remarks 116 and other items. The product photographic image 108 is input, for example, at a designated position in a jpeg format or the like. The product name 109, the manufacturer name 110, the selling price 111, the list price 112, the advertisement start date 113, and the advertisement end date 114 are input by character input.

The branch advertisement 115 is input in the store D
Display the branch name or branch ID read from B,
The handling of the product may be indicated by checking the check box of each branch. The remarks 116 may include the features of the product and the sales points. When the necessary items are completed in this way, the registration button 118 is operated to register the advertisement information (S12). When the advertisement information is transmitted from the shop terminal device 5, the WWW / CGI (3
4) is performed by the advertisement registration processing unit 33 on the advertisement server 2
The advertisement information is stored in the advertisement DB of the DB server 3 (S1).
3). With the above procedure, the storage of the advertisement information in the advertisement DB 43 is completed (end), and the advertisement information is stored in a configuration as shown in FIG.

Next, the flow of an advertisement information search process performed in the consumer terminal device 4 or the advertisement server 2 will be described. FIG. 5 is a flowchart showing a flow of processing at the time of searching for advertisement information. In this flowchart, S20-
The process in S23 is a process in the consumer terminal device 4, and the processes in S24 to S29 are processes in the advertisement server 2. It is assumed that the area information, the store information, and the advertisement information are already stored in the area DB 41, the store DB 42, and the advertisement DB 43 of the DB server 3 as described above.
First, a consumer who wants to search for advertisement information activates a WWW browser of the consumer terminal device 4 and looks at a display device (not shown) such as a CRT display while input device (not shown) having a keyboard and a mouse. Is omitted), a predetermined URL is input as an address on the Internet 6 (see FIG. 2) of a page for advertisement information search of the advertisement information display system 1. When the consumer terminal device 5 is connected to the advertisement information display system 1 in this manner, the advertisement server 2
The display information creation unit 30 on the advertisement server 2 is activated by the above WWW / CGI (34) (S20). When the display information creation unit 30 is activated, a page necessary for searching for advertisement information is read, and the page is displayed on a display device (not shown) of the consumer terminal device 4.

Here, FIG. 9 is a screen configuration diagram of an advertisement information search screen in which a search result is displayed by designating a product advertisement search condition on the browser of the consumer terminal device 4. As shown in FIG. 9, the advertisement information search screen includes a search center 120, a search area radius 123, a product specification 124, and a search start button 1
29, and a search result 130.

Here, the conditions for the store search area are set (S21). In the procedure for setting the conditions for the store search area, first, the search center 120 is set. The search center 120 is
It is composed of a zip code 121 and an address 122. The postal code 121 is input, for example, as “456-0002”. The postal code 121 input here is regarded as the district ID 61 (see FIG. 6) of the area DB 41 in principle.
When the postal code 121 is input, an address corresponding to the input postal code 121 is searched and extracted by the postal code dictionary 45 (see FIG. 2), and the prefecture 122
Towns and villages are displayed. If there are multiple corresponding towns and villages, they are displayed in a pull-down menu. Here, since it is sufficient that the postal code can be specified, it is not necessary to select the displayed towns and villages if a plurality of displayed towns and villages can be confirmed.

If the postal code 121 is unknown, the prefecture, city, county, and town of the address 122 are entered. Here, for example, when "Aichi Prefecture" is input as a prefecture, selectable municipalities are displayed in a pull-down menu, and for example, "Nagoya City" is selected and input as the municipalities. When a city / county / county is further input, a selectable city / county / county (2) is displayed in a pull-down menu, and for example, “Atsuta-ku” is selected and input as the city / county / country (2).
When the municipal county (2) is further input, selectable towns and villages are displayed in a pull-down menu, and for example, “Kanayama-cho” is selected and input as a town and village therefrom. Of course, character input is also possible, but by selecting in this way, input becomes easy and there is no input of an address that does not exist. As described above, by inputting the address, the corresponding postal code is extracted by the postal code dictionary 45 (see FIG. 2 and is automatically displayed in the postal code 121 column. Since the postal code is not displayed in the field of the postal code 121, it can be understood that the input is incorrect.When the postal code 121 is specified in this way, the district ID having the same numeral as the postal code 121 is provided. The district is determined to be the search center, so the search center is
It can be entered from either the zip code 121 or the address 122.

Subsequently, a search area radius 123 centered on the search center is input. Here, the radius is selected and input from a pull-down menu such as "30 km". This completes the setting of the conditions for the store limited area (S21).

Next, the procedure for setting the advertisement information search condition (S2)
Perform 2). The advertisement information search condition setting is performed by selecting from the large category 125, the middle category 126, the small category 127, and the product name 128 in the product specification 124 column of the advertisement information search screen shown in FIG. First, when the pull-down menu of the large category 125 is opened, the items “living”, “office”, “fashion”, “clothing” and the like of the large category 125 are displayed. From these, the target category, for example, “living” Select ".
After selecting "living", when the pull-down menu of the middle category 126 is opened, items "furniture", "repair", etc. of the middle category 126 corresponding to "living" of the large category 125 are displayed. Select "Furniture". After selecting “furniture”, when the pull-down menu of the small category 127 is opened, the items of the small category 127 corresponding to the “furniture” of the middle category 126, such as “learning desk”, “tance”, and “chair”, are displayed. Then, for example, "Cance" is selected.

In the setting of the advertisement information search condition, the product designation can be ended in any state of selection of only the large category 125, selection of the middle category 126, or selection of the small category 127. In this case, for example, if only the large category 125 is selected, all the products belonging to the large category 125 are extracted by search. Therefore, if it is not known which category the target product belongs to, a search is once performed in the large category 125, and if at least one target product can be found from the search results, the middle class 12 to which the product belongs
The search may be narrowed down again to 6 or the small category 127.

If you want to narrow down the products in more detail, you can search for products such as "Children's three-stage closet", "Character three-stage closet", "Katsura four-stage closet", "Five-stage closet", and "Hino five-stage closet". The name is selected from the product names 128. In this way, the large classification 125, the middle classification 126, and the small classification 12
7. When the product name 128 is selected or characters are input, the procedure for setting the advertisement search condition (S22) ends.

As described above, the condition setting of the advertisement search area (S
21) After the procedure of the advertisement information search condition setting (S22) is completed, when the search start button 129 on the advertisement information search screen is operated, the input content is determined, and the WW of the advertisement server 2 is determined.
The display request information is transferred to the W / CGI (34) (S2)
3).

WWW / CGI (34) of advertisement server 2
Is displayed by the display information creating unit 3 based on the transferred display request information.
0 is activated, and the procedure of the store extraction process (S24) that satisfies the condition of the advertisement search area is executed. The activated display information creating unit 30 causes the parameter analysis processing unit 35 to analyze the received display request information. Parameter analysis processing unit 35
Extracts a region ID for specifying a display target, a search area radius, a product category, and a product from the display request information as parameters for the search. Next, the parameters extracted by the parameter analysis processing unit 35 are output to the DB search processing unit 36. The DB search processing unit 36 recognizes information from the consumer terminal device 4 as display request information, and Referring to the store DB 42 and the advertisement DB 43, the photograph 133, the product name 134, the sales price 135, the list price 136, the store name 137, the TEL 138 of the search result 130 on the advertisement information search screen are referred to.
The information to be displayed in the address 139 and the remarks 140 is searched.

Specifically, first, from the postal code 121 included in the display request information (see FIG. 9), the area D having the same number is obtained.
The area ID 61 of B41 is read, and the X coordinate 66 and the Y coordinate 67 stored in association with the corresponding area ID are stored.
Is extracted (see FIG. 6). Next, the number of distances in a search range is read from the search area radius 123 of the display request information (see FIG. 9), and the search area radius 123 is set as a radius around the previously extracted X coordinate 66 and Y coordinate 67. The area of the range is calculated, and a district ID having the X coordinate 66 and the Y coordinate 67 existing in the range is extracted. Next, a store ID having the district ID thus extracted is extracted from the store DB 42 (see FIG. 8). Thus, the procedure of the limited store extraction process (S24) is performed.

When the procedure of the store extraction process (S24) that satisfies the condition of the advertisement search area is completed, an advertisement information search process (S25) that satisfies the advertisement information search condition is performed from the extracted stores. The advertisement information search process that satisfies the advertisement information search condition is a product specified by the consumer on the advertisement information search screen from the stores having the store ID extracted in the store extraction process (S24) that satisfies the advertisement search area condition. The commodity specified based on the large classification 125, the middle classification 126, the small classification 127, and the commodity name 128 (see FIG. 9) is extracted from the advertisement DB 43 (see FIG. 7) (S25).

Next, the maker name 86, sale price 87, and fixed price 88, which are the advertisement information extracted by the advertisement information search process (S25), are arranged in ascending order using the sale price 87 as a key. That is, the extracted advertisement information is rearranged in ascending order of the selling price (S26).

Next, the display data creation unit 37 (see FIG. 2) extracts the store name 74, address 1 (75), address 2 (76), and telephone number 77 from the store DB 42 into the data thus arranged. Then, the display information is added to the previously extracted list, and display information is created based on the search result (S27).

The advertisement server 2 transfers the created display information to the consumer terminal device 4 using a WWW browser (S28). As shown in FIG. 9, the transferred data includes a photograph 133 and a product name 13 as a search result 130.
4. Sales price 135, list price 136, store name 137, TEL
138, address 139, and remarks 140 are displayed (S2
9), end the processing (end).

Next, the processing of the memo pad processing section 31 (see FIG. 2) will be described. As shown in FIG. 9, a memo pad check column 132 is provided at the head of each column of the displayed search result. If the consumer thinks that it is necessary to record the information in the column provided with the memo pad check column 132, he / she clicks the memo pad check column 132 to add a check mark and operates the memo pad entry button 131 Then, the item checked is transferred to the advertisement server 2 as memo pad entry request information. The transferred advertisement server 2 has WWW /
The display information creation unit 30 is started by the CGI (34),
The parameters are analyzed by the parameter analysis processing unit 35 and output to the DB search processing unit 36. The DB search processing unit 36 determines the parameter output by the parameter analysis processing unit 35, and determines whether the data is search request information.
It is determined whether it is memo pad entry request information, and if it is memo pad entry request information, the display data creation unit 37
Before creating the display data, the memo pad processing unit 31 is activated.

When the memo pad processing section 31 is activated, the data obtained by analyzing the parameters by the parameter analysis processing section 35 is received from the display data creating section 37, and the consumer refers to the display data and writes the data in the memo pad. Is assigned to the selected product, and the advertisement D is used as information using the store ID and the product ID of the product to which the product ID is assigned as a key.
From B, detailed product data information on the corresponding product is obtained. Then, it has a function of temporarily storing the acquired advertisement information and deleting data as necessary.

The advertisement information display system 1 according to the embodiment of the present invention has the above-described configuration and operation.
The following effects are obtained. That is, by specifying the area by the consumer, the advertisement information such as the price of the product and the advertisement information such as the shop information can be displayed on the consumer terminal device 4 only for the stores in the area desired by the consumer, This has the effect that the consumer can easily and quickly obtain noise-free information about the product in the desired area.

Further, when the consumer specifies not only one specified area but also a desired distance from the specified area, the advertisement information is limited to the area that the consumer can go to. 4, the information can be obtained easily and quickly in a short time without noise regarding the products in a plurality of desired areas.

Further, since the area can be designated using the postal code system, the area without omission or duplication can be managed, and each store can easily register the area of its own store just by inputting the postal code. Can be. In addition, the consumer can directly input the postal code or, if the user inputs the address, specify the area by the corresponding postal code, so that the area can be specified more easily. Furthermore, the postal code dictionary 4
5, the corresponding address is extracted from the postal code, or the corresponding postal code is extracted from the address, thereby facilitating the input and reducing input errors. .

In addition, since the advertisement information can be displayed by specifying the product category desired by the consumer, the advertisement information with little noise can be displayed to the consumer. In particular,
Product categories of the target category can be displayed by selecting a major category, a middle category, a small category and a product category hierarchically, and by selecting this, the advertisement information is displayed in a wide range or a narrow range desired by consumers. There is an effect that can be.

Further, since the advertisement information can be displayed in the order of the lowest price, there is an effect that the consumer can easily find the target product with the lowest price.

Further, if the advertisement information is displayed in an order based on the area where the store exists, there is an effect that the consumer can easily search for the store from a nearby area.

Since the memo pad is provided, it is possible to select and store only the items that the consumer needs from the extracted stores and products by an easy operation.

As described above, the present invention has been described based on one embodiment. However, the present invention is not limited to the above-described embodiment, and various improvements and modifications can be made without departing from the gist of the present invention. Can be easily inferred.

For example, in the present embodiment, the area information is
Area IDs are assigned using postal codes and areas are managed in units of areas corresponding to postal codes.
Do not rely on postal codes, but administrative divisions, such as "prefectures"
The management may be performed in units such as “city”, “city”, and the like. In this case, I
It is necessary to add D, but by managing in this way, the position coordinates of the area can be easily and accurately obtained by referring to a commercially available map or the like.

In addition to the postal code, the area information may be given as area information using the area code or the area number of the public line. In this case, for example, “123-4
If the telephone number is 56-7890, "123"
Alternatively, using the number "123456" as a key,
D may be given.

Further, instead of using the postal code, address, and telephone number, using a direct coordinate system, for example, latitude and longitude,
Position coordinates may be given to each store, and this may be managed as area information. Further, on the map, the area may be divided into a matrix at every second of meridians / latitudes, for example, and the area information may be managed depending on which of these divisions the store belongs to. According to the postal code, administrative division, and area code, the area of the managed area has a difference in size. When the area of the area is large, a distant store is included in the same area. was there. However, by managing the area information based on the position coordinates of the store as described above, it is possible to manage the store so that the store can be displayed based on an accurate distance from the position of the consumer. This location information is
GPS (Global Positioning Sy)
(stem) or the like.

The information may be transferred by a WWW browser. For example, a file is transferred from each store to an advertisement server by FTP (File Transfer Protocol).
col) or by SSL encryption.

Further, the advertisement information may be extracted not only from the area and the selling price but also from the address, the manufacturer name and the like.
In addition, various items other than those exemplified above can be provided in the advertisement information. In FIG. 2, the area DB
41, store DB42, advertisement DB43, notepad DB44,
Although each storage medium of the postal code dictionary 45 is shown as an independent configuration for convenience of explanation, it is needless to say that the storage medium may be stored in one HD or the like, and the classification of stored data may be changed as appropriate.

[0077]

As is clear from the above description, the advertisement display information and the advertisement information display system of the present invention provide price information such as the price of a target product from stores in an area desired by the consumer. There is an effect that advertisement information such as shop information can be easily extracted and displayed in a manner that is easy for consumers to understand.

[Brief description of the drawings]

FIG. 1 is a diagram showing an outline of a hardware configuration of an advertisement information display system 1. FIG.

FIG. 2 is a diagram showing an outline of a functional configuration of the advertisement information display system 1.

FIG. 3 is a flowchart showing the flow of processing when registering shop information.

FIG. 4 is a slow chart showing a flow of processing when registering advertisement information.

FIG. 5 is a flowchart showing a flow of a process at the time of searching for advertisement information.

FIG. 6 is a diagram conceptually showing a configuration of an area DB 41.

FIG. 7 is a diagram conceptually showing a configuration of an advertisement DB 43.

FIG. 8 is a diagram conceptually showing a configuration of a store DB.

FIG. 9 is a screen configuration diagram of a screen on which a search result is displayed by specifying a product advertisement search condition on a browser of the consumer terminal device 4;

FIG. 10 is a screen configuration diagram of a store information registration screen for inputting store information on a browser of the store terminal device 5;

11 is a screen configuration diagram of an advertisement information registration screen for inputting advertisement information on a browser of the shop terminal device 5. FIG.

FIG. 12 is a diagram conceptually showing a configuration of a postal code dictionary 45.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Advertisement information display system 2 Advertisement server 3 DB (database) server 4 Consumer terminal device 5 Store terminal device 30 Display information creation unit 31 Notepad processing unit 32 Store registration processing unit 33 Advertisement registration processing unit 34 WWW / CGI 35 Parameter analysis Processing unit 36 DB search processing unit 37 Display data creation unit 41 Area DB 42 Store DB 43 Advertisement DB 44 Notepad DB 45 Postal code dictionary

──────────────────────────────────────────────────続 き Continued on the front page (51) Int.Cl. ⁷ Identification symbol FI Theme court ゛ (Reference) G06F 17/30 380 G06F 17/30 380E (72) Inventor Masaaki Mizuno 2-9-19-1 Tachibana, Naka-ku, Nagoya-shi No. Nagoya Television Broadcasting Corporation F term (reference) 5B049 AA01 BB11 BB49 EE05 GG02 5B075 ND20 NR12 PQ02 PQ46 PQ80 QP05

Claims (14)

[Claims] 1. A receiving step in which a computer receives display request information including area designation information from a consumer terminal, and based on the area designation information included in the display request information received in the receiving step. An extraction step of extracting a store having predetermined conditions from a store database in which store information that is information on the store associated with the region information that is the information specifying the region is extracted. Displaying the advertisement information including the store of the predetermined condition on the terminal of the consumer. 2. The receiving step includes selecting an arbitrary region and specifying a distance from the selected region in the designation information of the region in the display request information. From the region database in which the position coordinates of the region are stored in advance, the position coordinates at the center of the arbitrary region are determined based on the selection of the arbitrary region, and the selection is performed based on the designation of the distance from the selected region. The advertisement information display according to claim 1, wherein an area where the center exists within a predetermined distance from the center of the specified area is specified, and a store existing in the specified area is extracted from the store database. Method. 3. The advertisement information display method according to claim 1, wherein in the receiving step, the designation information of the area of the display request information is designated based on a postal code. . 4. The display request information includes product designation information including a product category, and the extracting step includes an advertisement database in which advertisement information including a price of a product associated with the store information is stored in advance. 4. The advertisement information display method according to claim 1, wherein a store is extracted based on the product designation information. 5. The advertisement information display method according to claim 4, wherein the displaying step displays the price of the product and the store in ascending order of the price of the product. 6. The advertisement information display method according to claim 1, wherein in the displaying step, the stores are displayed in an order based on an area where the stores exist. 7. A store specified by the consumer's notepad entry request information is selected from area information, advertisement information, and the like, from the extraction result displayed on the consumer's terminal in the display step. 7. The advertisement information display method according to claim 1, further comprising a memo pad database storing step of storing the information together with the information in a memo pad database serving as a storage unit. 8. A receiving means for receiving display request information including area designation information from a consumer terminal, and store information relating to a store associated with area information which is information for specifying an area is stored in advance. Based on the specified area information included in the display request information received by the receiving means, extracting means for extracting a store having predetermined conditions from the store database; and Display means for displaying advertisement information including a store on the consumer terminal. 9. An area database in which position coordinates of each designated area are stored in advance, wherein the receiving means selects an arbitrary area as a designation information of the area and a distance from the selected area. Receiving the display request information including the designation of, The extraction means, from the area database, determines the center position coordinates based on the selection of the arbitrary area,
9. The method according to claim 8, further comprising: identifying a region having the center within a predetermined distance from the center of the designated region, and extracting a store located in the specified region from the store database. Advertising information display system. 10. The advertisement according to claim 8, wherein the receiving unit specifies the area designation information included in the received display request information based on a postal code. Information display system. 11. The display request information includes product designation information including a product category, and the extraction means specifies the product from an advertisement database in which advertisement information associated with the store information is stored in advance. The advertisement information display system according to any one of claims 8 to 10, wherein a store is extracted on the basis of (i). 12. The advertisement information display system according to claim 11, wherein said display means displays the price of the product and the store in ascending order of the price of the product. 13. The advertisement information display system according to claim 8, wherein the display unit displays the stores in an order based on an area where the store exists. 14. A store specified by the memo pad entry request information of the consumer from information of the extraction displayed on a consumer terminal by the display means, information selected from area information, advertisement information, and the like. 14. A memo pad database storing means for storing in a memo pad database as a storage means.
The advertisement information display system according to any one of the above.