WO2014073260A1 - Database accumulating method - Google Patents

Database accumulating method Download PDF

Info

Publication number
WO2014073260A1
WO2014073260A1 PCT/JP2013/073926 JP2013073926W WO2014073260A1 WO 2014073260 A1 WO2014073260 A1 WO 2014073260A1 JP 2013073926 W JP2013073926 W JP 2013073926W WO 2014073260 A1 WO2014073260 A1 WO 2014073260A1
Authority
WO
WIPO (PCT)
Prior art keywords
information
store
product
advertisement
customer
Prior art date
Application number
PCT/JP2013/073926
Other languages
French (fr)
Japanese (ja)
Inventor
有吾 辻
Original Assignee
株式会社Ｐａｌ
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 株式会社Ｐａｌ filed Critical 株式会社Ｐａｌ
Priority to CN201380055589.9A priority Critical patent/CN104756144A/en
Priority to SG11201502829UA priority patent/SG11201502829UA/en
Publication of WO2014073260A1 publication Critical patent/WO2014073260A1/en
Priority to PH12015500966A priority patent/PH12015500966A1/en
Priority to HK15107203.1A priority patent/HK1206845A1/en

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00—Commerce
    • G06Q30/06—Buying, selling or leasing transactions
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q20/00—Payment architectures, schemes or protocols
    • G06Q20/08—Payment architectures
    • G06Q20/20—Point-of-sale [POS] network systems
    • G06Q20/202—Interconnection or interaction of plural electronic cash registers [ECR] or to host computer, e.g. network details, transfer of information from host to ECR or from ECR to ECR
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q20/00—Payment architectures, schemes or protocols
    • G06Q20/08—Payment architectures
    • G06Q20/20—Point-of-sale [POS] network systems
    • G06Q20/203—Inventory monitoring
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00—Commerce
    • G06Q30/02—Marketing; Price estimation or determination; Fundraising
    • G06Q30/0241—Advertisements

Definitions

  • the present invention relates to a database storage method that can store customer information, product information, and store information in an open and non-limiting manner.
  • a store when a product is purchased at a store on a web page (hereinafter referred to as a store), the purchase procedure is performed and the product reaches the purchaser.
  • the product information and purchaser information are exchanged between the purchaser, the store, the warehouse, and the delivery company in this case. Note that payment companies that handle payment information are included, but are excluded here.
  • the product information and purchaser information described above are accumulated (accumulated) in the database as useful information for future product development.
  • the database may be independently constructed on the store side, and is constructed with a delivery point for product information and purchaser information.
  • a coupon with information such as a special sale about the product is issued from the store, this coupon is given to the customer, and how much of the customers who are given the coupon is guided to the coupon and visits the store is examined. It is known to measure the effect of coupons.
  • Information that stores can be obtained by this method includes customer information guided by coupons, coupon details, and information on the ratio of the number of customers visiting the number of coupons issued.
  • the customer information is additionally linked to the customer information and stored in the database, or the customer information is additionally linked to the coupon (for example, product information) information. Accumulate in the database.
  • product information in a store is associated (categorized), and when a product is purchased, another product information in the same category in the past purchase history of the product is extracted and displayed. It is known to carry out so-called interest-linked advertisements that lead to different products.
  • the information that can be obtained from the store is the trend information of interest mainly by browsing and displaying the purchase history of the customer and other product information.
  • the product information and other product information are additionally linked to the customer information and stored in the database, or the customer information is additionally linked to the product information and the database. To accumulate.
  • customer information and product information are linked and stored in a database simply by looking at information displayed at a store on the web (in this case, browsing a site specified by a URL). Will be.
  • On the store side based on such a database, data mining is performed so that a tendency to lead to profits can be searched and appropriate products can be presented.
  • the conventional two main data database storage methods can only store additional information that is a combination of information about the store and information about products handled at the store and customer information registered at the store. There is a problem that it is a selective and limited storage method that cannot store information other than the store or the product for the customer.
  • the problem to be solved is that the conventional database storage method can only store additional information that is a combination of the store information and information about the products handled at the store and the customer information registered at the store. The point and information other than the store or the product for the customer cannot be accumulated.
  • the present invention connects a plurality of store servers that store store customer information, purchase information, and product information on a website, and a plurality of advertisement servers that store advertisement information to collectively store information.
  • an aggregation server including an advertisement matching unit, a product shipment arrangement unit, a connection detection unit, and an information storage unit is provided between the plurality of store servers and the advertisement server.
  • the advertisement information of a plurality of stores provided from the advertisement server is stored, and the advertisement matching means
  • the advertising media or merchandise to be extracted from the advertising information and the advertising information of another store related to the customer is extracted and bundled with the product purchased by the merchandise shipping arrangement means
  • the advertising information in which the customer information and the purchase information can be linked to the packaging medium for packing the product is printed, and the tag for shipping the product is printed based on the customer information.
  • the advertising information is sent to the customer together with the product.
  • connection detection means After the arrival, when the customer connects to the store server of another store based on the advertisement information, this is detected by the connection detection means, and the information detected by linking to the customer information by the information storage means.
  • the most important feature is to store the purchase information when the product is stored and purchased at another store.
  • the present invention is not limited to the additional information combined with the store information, the information about the products handled at the store, and the customer information registered at the store.
  • information related to the customer's response to advertisement information of another store provided at the time of shipping can be newly accumulated, and purchase information of products purchased by the customer at the other store can also be accumulated.
  • this invention has the advantage that the information regarding the other goods in another store and another store can be accumulate
  • the database accumulated in the aggregation server by the accumulation method of the present invention is not only the purchase information of a certain store from the viewpoint of customer information, but also the purchaser who received the information of another store or the advertisement information from the advertisement information. Browsing history of other stores (advertising effect) and purchase information in other stores will continue to be accumulated permanently and almost automatically, and as a result, the database from the accumulated database will be used from a variety of detailed perspectives. There is an advantage that data mining can be performed.
  • FIG. 1 is a diagram showing an outline of the database storage method of the present invention.
  • FIG. 2 is a diagram showing a transition state of information in the database storage method of the present invention.
  • FIG. 3 is a diagram showing the operation status of the connection detecting means of the database storage method of the present invention.
  • the conventional database storage method can only store additional information in combination with a closed relationship via product information between a store and a customer, and selects information on the store or the product for the customer.
  • the database storage method according to the present invention includes a plurality of store servers 1, a plurality of advertisement servers 2, another store server 3, an aggregation server 4, and a personal computer (hereinafter referred to as a customer 5) as an internet-connectable environment used by a customer.
  • a customer a personal computer
  • the database storage method according to the present invention includes a plurality of store servers 1, a plurality of advertisement servers 2, another store server 3, an aggregation server 4, and a personal computer (hereinafter referred to as a customer 5) as an internet-connectable environment used by a customer.
  • the store server 1, the advertisement server 2, the separate store server 3, the aggregation server 4, and the customer 5 are general configurations that can be connected to the network as described above, the description is omitted.
  • the store server 1, the advertisement server 2, the separate store server 3, and the aggregation server 4 are assumed to have information described below on a hard disk as a storage device.
  • the store server 1 stores customer information 1A registered at the store and product information 1B handled at the store.
  • advertisement information 2A provided from the separate store server 3 is accumulated.
  • the separate store server 3 stores customer information 3A registered at the store and product information 3B handled at the store (for explanation, it is separated from the store server 1).
  • Customer information 1A (3A) is information in which, for example, a customer ID, a name, an address, and the like related to a customer are accumulated.
  • the product information 1B is information in which, for example, a product ID, a name, a genus, a price, and the like related to the product are accumulated.
  • the advertisement information 2A is information in which, for example, an advertisement ID, a store name, a URL, a product name, and the like related to a store and a product handled at the store are accumulated.
  • the advertisement information 2A in the advertisement server 2 means information provided from the separate store server 3 when there is a request for posting an advertisement from the separate store server 3.
  • the aggregation server 4 includes, as programs, product shipment arrangement means 4A, advertisement matching means 4B, connection detection means 4C, and information storage means 4D.
  • the product shipping arrangement means 4 ⁇ / b> A prints the advertising medium AD on which the advertising information 2 ⁇ / b> A included in the packaging medium P is posted.
  • the advertising information 2A is instructed to be printed on the packaging medium P for instructing or packing the product, and the packing tag T is instructed to be printed based on the customer information for shipping the product (provided by the store server 1).
  • the advertisement matching means 4B is one or both of the advertisement information 2A provided for posting an advertisement via the advertisement server 2 and the customer information 1A and the product information 1B received from the store server 2 for the instruction of shipping the product.
  • the advertisement information 2A that seems to be appropriate is extracted.
  • connection detection unit 4C detects that the customer 5 is connected to the different store server 3 as described later.
  • the information storage means 4D receives the customer information 5A, the purchase information 5B of the product sent by the customer, and the customer. If there is a product purchased at another store and the advertisement information 5C posted, the separate store purchase information 5D is mainly accumulated.
  • the purchase information 5A and the separate store purchase information 5D mean, for example, purchase date / time, purchased product, and purchased store, and in this example, these pieces of information are collectively referred to.
  • the information storage unit 4D also includes customer information 1A and product information 1B when the aggregation server 4 requests shipping of products, and advertisement information 2A when the aggregation server 4 requests posting of the advertisement information 2A. Accumulated.
  • FIG. 2 shows a situation in which various types of information are aggregated in the information storage unit 4D of the aggregation server 4.
  • the aggregation server 4 includes the advertisement information 2A provided from the advertisement server 2, customer information 1A and product information 1B instructed from the store server 1 at the time of shipment, and the customer 5 based on the information in the advertisement medium AD when the product arrives.
  • customer information 5A, purchase information 5B, advertisement information 5C, and when purchasing a product at another store another store purchase information 5D from the separate store server 3 is information. It is stored in the storage means 4D.
  • the customer information of the store server 1 (hereinafter, the separate store server 3 is replaced with the store server 1).
  • new advertisement information 2A is matched from the product information 1B by the advertisement matching means 4B, the advertising medium AD and the tag T are printed, and the product is packed in the packaging medium P and sent to the purchaser 5.
  • the advertisement medium AD generated from the advertisement information 2A and the connection detection method by the connection detection means 4C in the aggregation server 4 will be described.
  • the advertisement medium AD describes the contents of the advertisement / product to be guided to the different store server 3 and, for example, describes a QR code (registered trademark) in which a URL is embedded, transmits an e-mail including a URL link, and embeds the URL.
  • An automatic reading type sensor is provided or the URL itself is described.
  • the customer information 1A and the advertisement information 2A of the customer 5 to whom the products already stored in the information storage means 4D are shipped are bundled together and associated with the customer information 1A.
  • the buffered storage area is an encoded address.
  • the customer 5 When the customer 5 traces the URL to be guided by any of the above processes through the advertising medium AD, as shown in FIG. 3, the customer 5 is once connected to the connection detecting means 4C of the aggregation server 4, From here, the user is redirected to another store server 3.
  • the connection detection means 4C detects the connection of the customer 5 to the different store server 3, the information (that is, customer information 5A, purchase information 5B, advertisement information 5C) buffered separately is used as the customer information.
  • the data is normally stored in the information storage means 4D in association with 1A.

Landscapes

  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Engineering & Computer Science (AREA)
  • Strategic Management (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Game Theory and Decision Science (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Information Transfer Between Computers (AREA)
  • Cash Registers Or Receiving Machines (AREA)

Abstract

[Problem] To resolve, with respect to conventional database accumulating methods, the issue of being able to accumulate only information about a store and additional information that combines information about products carried by the store and customer information registered at the store, and the issue of not being able to accumulate information about the customer other than that pertaining to that store or those products. [Solution] The present invention provides an aggregation server (4) between store servers (1) and advertisement servers (2). The aggregation server (4) accumulates information provided from the store servers (1) pertaining to product shipments, and advertisement information (2A) provided from the advertisement servers (2), and the advertisement information (2A) provided from the advertisement servers (2) is delivered to the customer (5) together with the product. When the customer (5) connects to another store server (3) on the basis of the advertisement information (2A), the customer information (5A) at the time of the connection to the other store server (3), advertisement information (5C), and purchase information (5B) for the shipped product, are accumulated, and when a product is purchased at that other store, purchase information (5D) for that purchased product is accumulated.

Description

データベース蓄積方法Database storage method
　本発明は、開放的かつ非限定的に顧客情報や商品情報並びに店舗情報を集約的に蓄積することができるデータベース蓄積方法に関するものである。 The present invention relates to a database storage method that can store customer information, product information, and store information in an open and non-limiting manner.
　例えばウェブショッピングでは、ウェブページ上の店舗（以下、店舗という）で商品を購入すると、購入の手続が行われ、商品がその購入者に届く。この一連のサイクルの中では、商品に伴って該商品の情報と購入者の情報が、この場合、購入者、店舗、倉庫及び配送業者でやりとりされる。なお、決済情報を取り扱う決済会社も含まれるがここでは除くこととする。 For example, in web shopping, when a product is purchased at a store on a web page (hereinafter referred to as a store), the purchase procedure is performed and the product reaches the purchaser. In this series of cycles, the product information and purchaser information are exchanged between the purchaser, the store, the warehouse, and the delivery company in this case. Note that payment companies that handle payment information are included, but are excluded here.
　上記の例えば商品情報や購入者情報は、今後の商品展開上の有用な情報としてデータベースに蓄積される（蓄積されている）。データベースは、例えば店舗側で独自に構築する場合もある他、商品情報や購入者情報の受け渡しポイントで構築する。 The product information and purchaser information described above are accumulated (accumulated) in the database as useful information for future product development. For example, the database may be independently constructed on the store side, and is constructed with a delivery point for product information and purchaser information.
　従来、例えばある店舗が特売的意図の複数種のクーポンを発行してこれらクーポンを配布してこのクーポンの効果（クーポンによる購入者の動向）を調査して得た情報を蓄積する手法は、対象商品についての例えば特売等の情報が付与されたクーポンを店舗から発行し、このクーポンを顧客に渡し、クーポンを渡された顧客のうちどの程度そのクーポンに誘導されて店舗に来店するか、を調べるというクーポンの効果測定を行うことが知られている。 Conventionally, for example, a method of issuing a plurality of types of coupons intended for sale by a certain store, distributing these coupons, and accumulating information obtained by investigating the effect of this coupon (trends of buyers with coupons) For example, a coupon with information such as a special sale about the product is issued from the store, this coupon is given to the customer, and how much of the customers who are given the coupon is guided to the coupon and visits the store is examined. It is known to measure the effect of coupons.
　この手法で店舗が得られる情報としては、クーポンで誘導された顧客情報、クーポンの内容、及びクーポンの発行数に対する来店数の割合の情報、である。クーポン内容に対する顧客の動向を知るうえでは、顧客情報にそのクーポン情報を付加的に紐付けしてデータベースに蓄積する、あるいはクーポン（例えば商品の情報）情報に顧客情報を付加的に紐付けしてデータベースに蓄積する。 Information that stores can be obtained by this method includes customer information guided by coupons, coupon details, and information on the ratio of the number of customers visiting the number of coupons issued. In order to know the trend of the customer with respect to the coupon content, the customer information is additionally linked to the customer information and stored in the database, or the customer information is additionally linked to the coupon (for example, product information) information. Accumulate in the database.
　また、従来、例えば店舗における商品情報同士を関連付け（カテゴライズ）しておいて、ある商品を購入した際に、その商品の過去の購入履歴における同一カテゴリ中の別の商品情報を抽出して表示して別商品へ誘導する、いわゆる興味関心連動型の広告を行うことが知られている。 Conventionally, for example, product information in a store is associated (categorized), and when a product is purchased, another product information in the same category in the past purchase history of the product is extracted and displayed. It is known to carry out so-called interest-linked advertisements that lead to different products.
　この場合、店舗が得られる情報としては、主に顧客の購入履歴とその別の商品情報を閲覧表示することによる興味の傾向情報である。顧客の興味の傾向を知るうえでは、顧客情報にその商品情報と別の商品情報を付加的に紐付けしてデータベースに蓄積する、あるいは、商品情報に顧客情報を付加的に紐付けしてデータベースに蓄積する。 In this case, the information that can be obtained from the store is the trend information of interest mainly by browsing and displaying the purchase history of the customer and other product information. In order to know the trend of customer interest, the product information and other product information are additionally linked to the customer information and stored in the database, or the customer information is additionally linked to the product information and the database. To accumulate.
　以上のように、ウェブ上の店舗で表示された情報を見る（この場合ＵＲＬで指定されたサイトを閲覧することを意味する）だけで、顧客情報と商品情報とがデータベースに紐付けされて蓄積されることとなる。店舗側では、こうしたデータベースに基づいて、収益に繋がるよう傾向を探ったり適切な商品提示ができるようデータマイニングしている。 As described above, customer information and product information are linked and stored in a database simply by looking at information displayed at a store on the web (in this case, browsing a site specified by a URL). Will be. On the store side, based on such a database, data mining is performed so that a tendency to lead to profits can be searched and appropriate products can be presented.
　しかしながら、従来の主立った２つのデータデースの蓄積手法では、その店舗の情報及びその店舗で扱っている商品についての情報とその店舗で登録されている顧客情報との組み合わせ的な付加情報しか蓄積できないという閉鎖的な蓄積手法であるという問題があると共に、顧客に対するその店舗あるいはその商品以外の情報は蓄積できないという選択的かつ限定的な蓄積手法であるという問題があった。 However, the conventional two main data database storage methods can only store additional information that is a combination of information about the store and information about products handled at the store and customer information registered at the store. There is a problem that it is a selective and limited storage method that cannot store information other than the store or the product for the customer.
　解決しようとする問題点は、従来のデータベース蓄積方法は、その店舗の情報及びその店舗で扱っている商品についての情報とその店舗で登録されている顧客情報との組み合わせ的な付加情報しか蓄積できない点、及び顧客に対するその店舗あるいはその商品以外の情報は蓄積できない点である。 The problem to be solved is that the conventional database storage method can only store additional information that is a combination of the store information and information about the products handled at the store and the customer information registered at the store. The point and information other than the store or the product for the customer cannot be accumulated.
　本発明は、ウェブサイト上における店舗の顧客情報と購入情報と商品情報とを蓄積した複数の店舗サーバと、広告情報を蓄積した複数の広告サーバと、を接続して情報を集約的に蓄積するデータベース蓄積方法であって、前記複数の店舗サーバと前記広告サーバとの間に、広告マッチング手段と、商品発送手配手段と、接続検知手段と、情報蓄積手段とを備えた集約サーバを設け、この集約サーバに店舗サーバから提供された商品の発送に関する顧客情報と購入情報と商品情報とを蓄積する一方で、広告サーバから提供された複数の店舗の広告情報を蓄積すると共に、広告マッチング手段により前記広告情報から発送する商品及び顧客に関連する別店舗の広告情報を抽出し、商品発送手配手段により購入した商品に同梱する広告媒体又は商品を梱包する包装媒体に顧客情報及び購入情報を紐付けできる情報を付加した前記広告情報を、さらに顧客情報に基づいて商品発送のための荷札を、それぞれ印刷し、商品と共に顧客へ前記広告情報が到達した後、当該顧客が前記広告情報に基づいて別店舗の店舗サーバに接続した場合には接続検知手段によりこれを検知し、情報蓄積手段により当該顧客情報に紐付けして検知された情報を蓄積し、また、当該別店舗において商品を購入した場合にはその購入情報をさらに蓄積することを最も主要な特徴とする。 The present invention connects a plurality of store servers that store store customer information, purchase information, and product information on a website, and a plurality of advertisement servers that store advertisement information to collectively store information. In this database storage method, an aggregation server including an advertisement matching unit, a product shipment arrangement unit, a connection detection unit, and an information storage unit is provided between the plurality of store servers and the advertisement server. While accumulating customer information, purchase information, and product information related to the delivery of products provided from the store server to the aggregation server, the advertisement information of a plurality of stores provided from the advertisement server is stored, and the advertisement matching means The advertising media or merchandise to be extracted from the advertising information and the advertising information of another store related to the customer is extracted and bundled with the product purchased by the merchandise shipping arrangement means The advertising information in which the customer information and the purchase information can be linked to the packaging medium for packing the product is printed, and the tag for shipping the product is printed based on the customer information. The advertising information is sent to the customer together with the product. After the arrival, when the customer connects to the store server of another store based on the advertisement information, this is detected by the connection detection means, and the information detected by linking to the customer information by the information storage means The most important feature is to store the purchase information when the product is stored and purchased at another store.
　本発明は、その店舗の情報とその店舗で扱っている商品についての情報とその店舗で登録されている顧客情報との組み合わせ的な付加情報以外に、複数の店舗でのこれらの情報のみならず発送に際して提供される別店舗の広告情報に対する顧客の対応に係る情報を新たに蓄積することができ、また、その別店舗において顧客が購入した商品の購入情報も蓄積することができるという利点がある。また、本発明は、顧客に対するその店舗あるいはその商品以外に、別店舗及び別店舗における他の商品に関する情報も蓄積することができるという利点がある。 The present invention is not limited to the additional information combined with the store information, the information about the products handled at the store, and the customer information registered at the store. There is an advantage that information related to the customer's response to advertisement information of another store provided at the time of shipping can be newly accumulated, and purchase information of products purchased by the customer at the other store can also be accumulated. . Moreover, this invention has the advantage that the information regarding the other goods in another store and another store can be accumulate | stored besides the store or its goods with respect to a customer.
　すなわち、本発明の蓄積方法によって集約サーバにおいて蓄積されたデータベースは、顧客情報という観点からは、ある店舗の購入情報のみならず、広告情報から、別店舗の情報や、広告情報を受け取った購入者の別店舗への閲覧履歴（広告効果）や、別店舗における購入情報が永続的かつほぼ自動的に蓄積され続けることになり、結果として蓄積されたデータベースを用いたきめ細やかで様々な切り口からのデータマイニングが行えるという利点がある。 That is, the database accumulated in the aggregation server by the accumulation method of the present invention is not only the purchase information of a certain store from the viewpoint of customer information, but also the purchaser who received the information of another store or the advertisement information from the advertisement information. Browsing history of other stores (advertising effect) and purchase information in other stores will continue to be accumulated permanently and almost automatically, and as a result, the database from the accumulated database will be used from a variety of detailed perspectives. There is an advantage that data mining can be performed.
図１は本発明のデータベース蓄積方法の概略を示す図である。FIG. 1 is a diagram showing an outline of the database storage method of the present invention. 図２は本発明のデータベース蓄積方法の情報の遷移状況を示す図である。FIG. 2 is a diagram showing a transition state of information in the database storage method of the present invention. 図３は本発明のデータベース蓄積方法の接続検知手段の動作状況を示す図である。FIG. 3 is a diagram showing the operation status of the connection detecting means of the database storage method of the present invention.
　本発明は、従来のデータベース蓄積手法では店舗と顧客との間での商品情報を介した閉鎖的な関係の組み合わせ的な付加情報しか蓄積できない点、及び顧客に対するその店舗あるいはその商品の情報を選択的かつ限定的にしか蓄積できない点を、複数の店舗サーバと広告サーバとの間に、広告マッチング手段と、商品発送手配手段と、接続検知手段と、情報蓄積手段とを備えた集約サーバを設け、該集約サーバに店舗サーバから商品の発送に関する顧客情報と商品情報と共に広告サーバから提供された別店舗の広告情報を蓄積し、広告サーバから提供された別店舗の広告情報を商品と共に顧客へ発送し、当該顧客が広告情報に基づいてその広告情報の別店舗サーバに接続した際に別店舗サーバに接続した際の顧客情報と広告情報と発送した商品の購入情報を蓄積し、また、当該別店舗において商品を購入した場合にはその購入した商品の購入情報を蓄積することで解消した。 In the present invention, the conventional database storage method can only store additional information in combination with a closed relationship via product information between a store and a customer, and selects information on the store or the product for the customer. A central server with advertisement matching means, merchandise shipping arrangement means, connection detection means, and information storage means between a plurality of store servers and advertisement servers, which can be stored only in a limited manner. , Storing the advertisement information of another store provided from the advertisement server together with the customer information and the product information related to the shipment of the product from the store server in the aggregation server, and shipping the advertisement information of the different store provided from the advertisement server to the customer together with the product And when the customer connected to another store server of the advertisement information based on the advertisement information, the customer information and the advertisement information when connected to another store server were sent out Accumulating the purchase information goods, and if you made a purchase in the alternative shop has been solved by storing the purchase information of the goods to the purchase.
　以下に、本発明のデータベース蓄積方法の実施例を図１～図３を参照して説明する。本発明のデータベース蓄積方法は、複数の店舗サーバ１と、複数の広告サーバ２と、別店舗サーバ３と、集約サーバ４と、顧客が用いるインターネット接続可能な環境として例えばパーソナルコンピュータ（以下、顧客５と記す）とが、互いにネットワーク接続した状態で実施される。 Hereinafter, an embodiment of the database storage method of the present invention will be described with reference to FIGS. The database storage method according to the present invention includes a plurality of store servers 1, a plurality of advertisement servers 2, another store server 3, an aggregation server 4, and a personal computer (hereinafter referred to as a customer 5) as an internet-connectable environment used by a customer. Are implemented in a state where they are connected to each other via a network.
　店舗サーバ１、広告サーバ２、別店舗サーバ３、集約サーバ４、顧客５、の物理的かつ具体的ハードウェア構成は、上記のとおりネットワーク接続可能な一般的な構成であるので説明を割愛するが、店舗サーバ１、広告サーバ２、別店舗サーバ３、集約サーバ４には、記憶装置としてのハードディスクに次に説明する各情報を有しているものとする。 Although the physical and specific hardware configurations of the store server 1, the advertisement server 2, the separate store server 3, the aggregation server 4, and the customer 5 are general configurations that can be connected to the network as described above, the description is omitted. The store server 1, the advertisement server 2, the separate store server 3, and the aggregation server 4 are assumed to have information described below on a hard disk as a storage device.
　店舗サーバ１には、その店舗で登録された顧客情報１Ａと、その店舗で扱う商品情報１Ｂとが蓄積されている。広告サーバ２は、別店舗サーバ３から提供された広告情報２Ａが蓄積されている。別店舗サーバ３には、その店舗で登録された顧客情報３Ａと、その店舗で扱う商品情報３Ｂとが蓄積されている（説明上店舗サーバ１と分けている）。 The store server 1 stores customer information 1A registered at the store and product information 1B handled at the store. In the advertisement server 2, advertisement information 2A provided from the separate store server 3 is accumulated. The separate store server 3 stores customer information 3A registered at the store and product information 3B handled at the store (for explanation, it is separated from the store server 1).
　顧客情報１Ａ（３Ａ）は、顧客に関する例えば顧客ＩＤ、氏名、住所、等が蓄積されたものである。商品情報１Ｂは、商品に関する例えば商品ＩＤ、名前、属類、値段、等が蓄積されたものである。広告情報２Ａは、店舗と店舗で扱う商品に関する例えば広告ＩＤ、店舗名、ＵＲＬ、商品名、等が蓄積されたものである。 Customer information 1A (3A) is information in which, for example, a customer ID, a name, an address, and the like related to a customer are accumulated. The product information 1B is information in which, for example, a product ID, a name, a genus, a price, and the like related to the product are accumulated. The advertisement information 2A is information in which, for example, an advertisement ID, a store name, a URL, a product name, and the like related to a store and a product handled at the store are accumulated.
　この広告サーバ２における広告情報２Ａは、本例では別店舗サーバ３から広告を掲載する旨の依頼があった際に該別店舗サーバ３から提供されたものを意味する。 In this example, the advertisement information 2A in the advertisement server 2 means information provided from the separate store server 3 when there is a request for posting an advertisement from the separate store server 3.
　集約サーバ４は、プログラムとして、商品発送手配手段４Ａ、広告マッチング手段４Ｂ、接続検知手段４Ｃ、情報蓄積手段４Ｄを有している。商品発送手配手段４Ａは、集約サーバ４におけるハードウェアに、店舗サーバ１で購入した商品を発送する旨の指示を受けると、包装媒体Ｐに同梱する広告情報２Ａを掲載した広告媒体ＡＤを印刷指示する又は商品を梱包する包装媒体Ｐに広告情報２Ａを印刷指示し、また、商品を発送する（店舗サーバ１から提供される）顧客情報に基づいて荷札Ｔを印刷指示する。 The aggregation server 4 includes, as programs, product shipment arrangement means 4A, advertisement matching means 4B, connection detection means 4C, and information storage means 4D. Upon receiving an instruction to ship the product purchased at the store server 1 to the hardware in the aggregation server 4, the product shipping arrangement means 4 </ b> A prints the advertising medium AD on which the advertising information 2 </ b> A included in the packaging medium P is posted. The advertising information 2A is instructed to be printed on the packaging medium P for instructing or packing the product, and the packing tag T is instructed to be printed based on the customer information for shipping the product (provided by the store server 1).
　広告マッチング手段４Ｂは、広告サーバ２を介して広告の掲載のために提供されている広告情報２Ａと、店舗サーバ２から商品の発送の指示を受けた顧客情報１Ａ、商品情報１Ｂの一方又は両方に適切と思われる広告情報２Ａを抽出する。 The advertisement matching means 4B is one or both of the advertisement information 2A provided for posting an advertisement via the advertisement server 2 and the customer information 1A and the product information 1B received from the store server 2 for the instruction of shipping the product. The advertisement information 2A that seems to be appropriate is extracted.
　接続検知手段４Ｃは、本例では、後述するが、顧客５が別店舗サーバ３に接続したことを検知する。情報蓄積手段４Ｄは、顧客５から別店舗サーバ３に接続したことを前記接続検知手段４Ｃにより検知した際に、その顧客情報５Ａ、その顧客による発送された商品の購入情報５Ｂ、その顧客に対して掲載した広告情報５Ｃ、別店舗にて購入した商品がある場合はその別店舗購入情報５Ｄ、を主として蓄積する。 In this example, the connection detection unit 4C detects that the customer 5 is connected to the different store server 3 as described later. When the connection detecting means 4C detects that the customer 5 has connected to the different store server 3, the information storage means 4D receives the customer information 5A, the purchase information 5B of the product sent by the customer, and the customer. If there is a product purchased at another store and the advertisement information 5C posted, the separate store purchase information 5D is mainly accumulated.
　なお、購入情報５Ａ及び別店舗購入情報５Ｄは、例えば購入日時、購入商品、購入店舗、の情報を意味し、本例では、これらの情報を総称している。 The purchase information 5A and the separate store purchase information 5D mean, for example, purchase date / time, purchased product, and purchased store, and in this example, these pieces of information are collectively referred to.
　情報蓄積手段４Ｄは、後述するとおり、集約サーバ４に商品の発送を依頼した場合の顧客情報１Ａ、商品情報１Ｂ、及び集約サーバ４に広告情報２Ａの掲載を依頼した場合の広告情報２Ａも、蓄積している。 As will be described later, the information storage unit 4D also includes customer information 1A and product information 1B when the aggregation server 4 requests shipping of products, and advertisement information 2A when the aggregation server 4 requests posting of the advertisement information 2A. Accumulated.
　図２には、集約サーバ４の情報蓄積手段４Ｄに各種情報が集約される状況を示している。集約サーバ４には、広告サーバ２から提供される広告情報２Ａが、店舗サーバ１から発送時に指示される顧客情報１Ａと商品情報１Ｂが、商品到着時に顧客５が広告媒体ＡＤの情報に基づいて別店舗サーバ３に接続した際には顧客情報５Ａ、購入情報５Ｂ、広告情報５Ｃが、さらに、別店舗にて商品を購入した場合は該別店舗サーバ３から別店舗購入情報５Ｄが、各々情報蓄積手段４Ｄに蓄積されることとなる。 FIG. 2 shows a situation in which various types of information are aggregated in the information storage unit 4D of the aggregation server 4. The aggregation server 4 includes the advertisement information 2A provided from the advertisement server 2, customer information 1A and product information 1B instructed from the store server 1 at the time of shipment, and the customer 5 based on the information in the advertisement medium AD when the product arrives. When connected to another store server 3, customer information 5A, purchase information 5B, advertisement information 5C, and when purchasing a product at another store, another store purchase information 5D from the separate store server 3 is information. It is stored in the storage means 4D.
　また、別店舗購入情報５Ｄに基づいて集約サーバ４に対して新たな商品の発送指示が送られると、（説明上、以下、別店舗サーバ３を店舗サーバ１と置き換える）店舗サーバ１の顧客情報１Ａ、商品情報１Ｂから広告マッチング手段４Ｂにより新たな広告情報２Ａをマッチングして広告媒体ＡＤ、荷札Ｔを印刷して、商品を包装媒体Ｐに梱包して購入者５に送るサイクルになる。 In addition, when a new product shipping instruction is sent to the aggregation server 4 based on the separate store purchase information 5D, the customer information of the store server 1 (hereinafter, the separate store server 3 is replaced with the store server 1). 1A, new advertisement information 2A is matched from the product information 1B by the advertisement matching means 4B, the advertising medium AD and the tag T are printed, and the product is packed in the packaging medium P and sent to the purchaser 5.
　ここで、広告情報２Ａから生成する広告媒体ＡＤと、集約サーバ４における接続検知手段４Ｃによる接続検知手法と、について説明する。広告媒体ＡＤは、別店舗サーバ３へ誘導する広告・商品の内容を表記すると共に、例えばＵＲＬを埋め込んだＱＲコード（登録商標）を表記、ＵＲＬリンクを記載した電子メールを送信、ＵＲＬを埋め込んだ自動読み込み型のセンサを設ける、あるいはＵＲＬそのものを表記、するように構成している。 Here, the advertisement medium AD generated from the advertisement information 2A and the connection detection method by the connection detection means 4C in the aggregation server 4 will be described. The advertisement medium AD describes the contents of the advertisement / product to be guided to the different store server 3 and, for example, describes a QR code (registered trademark) in which a URL is embedded, transmits an e-mail including a URL link, and embeds the URL. An automatic reading type sensor is provided or the URL itself is described.
　そして、このＵＲＬには、情報蓄積手段４Ｄに既に蓄積されている商品が発送された当該顧客５の顧客情報１Ａと当該広告情報２Ａなどを一まとめにして、顧客情報１Ａに紐付けされて別途バッファされた記憶領域をコード化したアドレスとされている。 In this URL, the customer information 1A and the advertisement information 2A of the customer 5 to whom the products already stored in the information storage means 4D are shipped are bundled together and associated with the customer information 1A. The buffered storage area is an encoded address.
　広告媒体ＡＤを介して顧客５は、上記のうちのいずれかの経緯で誘導しようとするＵＲＬを辿ると、図３に示すように、一旦は集約サーバ４の接続検知手段４Ｃに接続され、こここから別店舗サーバ３にリダイレクトされる。そして、この接続検知手段４Ｃが、顧客５の別店舗サーバ３への接続を検知した際には、上記別途バッファした各情報（つまり顧客情報５Ａ、購入情報５Ｂ、広告情報５Ｃ）を当該顧客情報１Ａに紐付けして情報蓄積手段４Ｄに正規蓄積する。 When the customer 5 traces the URL to be guided by any of the above processes through the advertising medium AD, as shown in FIG. 3, the customer 5 is once connected to the connection detecting means 4C of the aggregation server 4, From here, the user is redirected to another store server 3. When the connection detection means 4C detects the connection of the customer 5 to the different store server 3, the information (that is, customer information 5A, purchase information 5B, advertisement information 5C) buffered separately is used as the customer information. The data is normally stored in the information storage means 4D in association with 1A.
　また、このときに、顧客５が別店舗にて商品を購入した場合、顧客情報５Ａ、購入情報５Ｂ、広告情報５Ｃに加えて、別店舗サーバ３より別店舗購入情報５Ｄが送られてこれが情報蓄積手段４Ｄに当該顧客情報１Ａに紐付けされて蓄積される。 At this time, when the customer 5 purchases a product at another store, in addition to the customer information 5A, the purchase information 5B, and the advertisement information 5C, another store purchase information 5D is sent from the other store server 3, and this is information. The customer information 1A is associated with and accumulated in the accumulation means 4D.
　１ 店舗サーバ
　　１Ａ　顧客情報
　　１Ｂ　商品情報
　２ 広告サーバ
　　２Ａ　広告情報
　３　別店舗サーバ
　　３Ａ　顧客情報
　　３Ｂ　商品情報
　４　集約サーバ
　　４Ａ　商品発送手配手段
　　４Ｂ　広告マッチング手段
　　４Ｃ　接続検知手段
　　４Ｄ　情報蓄積手段
　５　顧客
　　５Ａ　顧客情報
　　５Ｂ　購入情報
　　５Ｃ　広告情報
　　５Ｄ　別店舗購入情報 1 store server 1A customer information 1B product information 2 advertisement server 2A advertisement information 3 another store server 3A customer information 3B product information 4 aggregation server 4A product shipping arrangement means 4B advertisement matching means 4C connection detection means 4D information storage means 5 customer 5A customer information 5B Purchase information 5C Advertising information 5D Separate store purchase information

Claims (1)

  1. 　ウェブサイト上における店舗の顧客情報と購入情報と商品情報とを蓄積した複数の店舗サーバと、広告情報を蓄積した複数の広告サーバと、を接続して情報を集約的に蓄積するデータベース蓄積方法であって、前記複数の店舗サーバと前記広告サーバとの間に、広告マッチング手段と、商品発送手配手段と、接続検知手段と、情報蓄積手段とを備えた集約サーバを設け、この集約サーバに店舗サーバから提供された商品の発送に関する顧客情報と購入情報と商品情報とを蓄積する一方で、広告サーバから提供された複数の店舗の広告情報を蓄積すると共に、広告マッチング手段により前記広告情報から発送する商品及び顧客に関連する別店舗の広告情報を抽出し、商品発送手配手段により購入した商品に同梱する広告媒体又は商品を梱包する包装媒体に顧客情報及び購入情報を紐付けできる情報を付加した前記広告情報を、さらに顧客情報に基づいて商品発送のための荷札を、それぞれ印刷し、商品と共に顧客へ前記広告情報が到達した後、当該顧客が前記広告情報に基づいて別店舗の店舗サーバに接続した場合には接続検知手段によりこれを検知し、情報蓄積手段により当該顧客情報に紐付けして検知された情報を蓄積し、また、当該別店舗において商品を購入した場合にはその購入情報をさらに蓄積することを特徴とするデータベース蓄積方法。 A database storage method in which a plurality of store servers that store store customer information, purchase information, and product information on a website and a plurality of advertisement servers that store advertisement information are connected to store information collectively. An aggregation server including an advertisement matching unit, a product shipment arrangement unit, a connection detection unit, and an information storage unit is provided between the plurality of store servers and the advertisement server. While storing customer information, purchase information, and product information related to the shipment of products provided from the server, it accumulates advertisement information of a plurality of stores provided from the advertisement server and ships from the advertisement information by the advertisement matching means. The advertising information of another store related to the product to be purchased and the customer is extracted, and the advertising medium or product to be bundled with the product purchased by the product shipping arrangement means is packed. After the advertisement information with information that can be associated with customer information and purchase information is added to the packaging medium, and a tag for shipping the product based on the customer information, respectively, and after the advertisement information reaches the customer together with the product When the customer connects to a store server of another store based on the advertisement information, the connection detection unit detects this, and the information storage unit stores the detected information linked to the customer information, A database storage method characterized by further storing the purchase information when a product is purchased at the different store.
PCT/JP2013/073926 2012-11-12 2013-09-05 Database accumulating method WO2014073260A1 (en)

Priority Applications (4)

Application Number Priority Date Filing Date Title
CN201380055589.9A CN104756144A (en) 2012-11-12 2013-09-05 Database accumulating method
SG11201502829UA SG11201502829UA (en) 2012-11-12 2013-09-05 Database accumulating method
PH12015500966A PH12015500966A1 (en) 2012-11-12 2015-04-30 Database accumulating method
HK15107203.1A HK1206845A1 (en) 2012-11-12 2015-07-28 Database accumulating method

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
JP2012-248792 2012-11-12
JP2012248792A JP5497136B1 (en) 2012-11-12 2012-11-12 Database storage method

Publications (1)

Publication Number Publication Date
WO2014073260A1 true WO2014073260A1 (en) 2014-05-15

Family

ID=50684377

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/JP2013/073926 WO2014073260A1 (en) 2012-11-12 2013-09-05 Database accumulating method

Country Status (6)

Country Link
JP (1) JP5497136B1 (en)
CN (1) CN104756144A (en)
HK (1) HK1206845A1 (en)
PH (1) PH12015500966A1 (en)
SG (1) SG11201502829UA (en)
WO (1) WO2014073260A1 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2014196375A1 (en) * 2013-06-03 2014-12-11 独立行政法人情報通信研究機構 Translation device, learning device, translation method, and recording medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2005122311A (en) * 2003-10-14 2005-05-12 Nippon Telegraph & Telephone East Corp Advertisement presentation method, apparatus and program
JP2006107318A (en) * 2004-10-08 2006-04-20 Eye Medical System:Kk Sales management system
JP2010026869A (en) * 2008-07-22 2010-02-04 Yahoo Japan Corp System for delivering successful bid article

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
AU3329900A (en) * 1999-06-15 2001-01-02 Hiroaki Nagano Advertising system and method using electronic communication
JP2002083116A (en) * 2000-06-20 2002-03-22 Disparce Inc Customer information collecting method, customer information providing method, point imparting method, commodity information providing method and customer information collecting device using network
US7599851B2 (en) * 2000-09-05 2009-10-06 Renee Frengut Method for providing customized user interface and targeted marketing forum
CN101414372A (en) * 2007-10-19 2009-04-22 潘广和 Device and method for paying for internet advertisement information based on preservation

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2005122311A (en) * 2003-10-14 2005-05-12 Nippon Telegraph & Telephone East Corp Advertisement presentation method, apparatus and program
JP2006107318A (en) * 2004-10-08 2006-04-20 Eye Medical System:Kk Sales management system
JP2010026869A (en) * 2008-07-22 2010-02-04 Yahoo Japan Corp System for delivering successful bid article

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2014196375A1 (en) * 2013-06-03 2014-12-11 独立行政法人情報通信研究機構 Translation device, learning device, translation method, and recording medium

Also Published As

Publication number Publication date
JP5497136B1 (en) 2014-05-21
JP2014096115A (en) 2014-05-22
CN104756144A (en) 2015-07-01
HK1206845A1 (en) 2016-01-15
SG11201502829UA (en) 2015-05-28
PH12015500966A1 (en) 2015-07-27

Similar Documents

Publication Publication Date Title
JP5982310B2 (en) Sales promotion system, server device, sales promotion method, and program
JP6713731B2 (en) AR use advertisement providing system and AR use customer value-added information providing system
US20150242829A1 (en) System and method for managing a single point of sale of plurality of merchandise from plurality of retailer
WO2011163546A4 (en) System for purchasing commercial goods and services at a location remote therefrom
JP3865611B2 (en) Data collection method
JP6347034B2 (en) Transaction support system
WO2008114358A1 (en) Commodity information notifying system
JP2016133816A (en) Commodity demand prediction system
JP5571742B2 (en) Product sales management system and program thereof
JP5913235B2 (en) Product sales data processing apparatus and program
JP2011154611A (en) Server device, information providing method and information providing program
KR101477662B1 (en) Ordering goods information arranging method in management system of internet shopping mall
JP5497136B1 (en) Database storage method
JP2014118259A (en) Information processor and program
JP2014052678A (en) Information processing device and program
JP2013246813A (en) Sales data management server, sales data management system, sales data management program, and sales data management method
JP2010211687A (en) Customer management system
JP2011081525A (en) Commodity display system and commodity display device
JP6441038B2 (en) Promotional item evaluation apparatus, promotional item evaluation system and method
JP6203163B2 (en) Customer management apparatus, customer management system and method
JP2005108134A (en) Article or service information providing system
JP5958968B2 (en) Product sticker printing device
TWM541065U (en) Online shopping system integrating physical advertisement
JP2005235138A (en) Mail order selling device and mail order selling method
JP6456875B2 (en) Product seal

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 13853107

Country of ref document: EP

Kind code of ref document: A1

WWE Wipo information: entry into national phase

Ref document number: 12015500966

Country of ref document: PH

NENP Non-entry into the national phase

Ref country code: DE

WWE Wipo information: entry into national phase

Ref document number: IDP00201503581

Country of ref document: ID

122 Ep: pct application non-entry in european phase

Ref document number: 13853107

Country of ref document: EP

Kind code of ref document: A1