JP2014096115A - Database accumulation method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To solve the problem in which: in the conventional database accumulation methods, only additional information, such as the combination of information on a shop and products sold by the shop and information on customers registered with the shop, can be accumulated or information other than on shops and products, with respect to customers, cannot be accumulated.SOLUTION: In the invention, an aggregation server 4 between a shop server 1 and an advertisement server 2 is included; information on the shipment of products provided by the shop server 1 and advertisement information 2A provided by the advertisement server 2 are accumulated in the aggregation server 4; the advertisement information 2A provided by the advertisement server 2 is shipped to a customer 5, together with a product(s); and when the customer 5 is connected to a server 3 of another shop according to the advertisement information 2A, customer information 5A, advertisement information 5C and purchase information 5B on the shipped product(s) at the time of the connection are accumulated. Also, when a product(s) is purchased at the other shop, purchase information 5D on the purchased product(s) is accumulated.

Description

  The present invention relates to a database storage method capable of intensively storing 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), a 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.

  For example, 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 obtained from a store by this method includes customer information guided by a coupon, the contents of the coupon, 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 from which the store is obtained 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 Advertisement media or products that are extracted from the advertisement information and the advertising information of another store related to the customer, and are bundled with the products purchased by the product dispatch arrangement means The advertisement information with information that can be associated with customer information and purchase information added to the packaging medium to be packed is printed, and a tag for shipping the product is printed based on the customer information. The advertisement information reaches the customer together with the product. After that, when the customer connects to a store server at another store based on the advertisement information, the connection detection means detects this, and the information storage means stores the detected information linked to the customer information. In addition, when the product is purchased at the different store, the most important feature is that the purchase information is further accumulated.

  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 When the customer connects to another store server of the advertisement information based on the advertisement information, the customer information and the advertisement information sent to the other store server are sent The purchase information stored in, also in the case of a purchase in the alternative shop it has been solved by storing the purchase information of the goods to the purchase.

  Embodiments of the database storage method according to the present invention will be described below 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).

  The customer information 1A (3A) is information in which, for example, a customer ID, a name, an address, etc. relating to the 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 a request for posting an advertisement is received 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 4 </ b> C detects that the customer 5 is connected to the different store server 3, which will be 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 5 </ b> A and the separate store purchase information 5 </ b> D mean, for example, purchase date and time, purchased product, and purchased store, and in this example, these 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

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. When a product shipping instruction is sent to the aggregation server , the aggregation server provides the customer information and the product information from the store server in a cycle of matching the advertisement information by the advertisement matching means and sending the product to the purchaser. Stores customer information, purchase information, and product information related to the delivery of the purchased products, while storing the advertisement information of a plurality of stores provided by the advertisement server Both the product to be shipped from the advertisement information by the advertisement matching means and the advertisement information of another store related to the customer are extracted, and the advertisement medium bundled with the product purchased by the product dispatch arrangement means or the packaging medium to pack the product The advertisement information to which information that can be associated with information and purchase information is further printed, and a tag for shipping the product is printed based on the customer information. After the advertisement information reaches the customer together with the product, the customer When connected to the store server of another store based on the advertisement information, this is detected by the connection detecting means , and the advertisement information provided from the advertisement server is instructed by the information storage means from the store server at the time of shipment. Customer information, product information, customer information, purchase information, and advertising information when the customer connects to another store server based on the advertising information when the product arrives , The most important feature to be accumulated and correlated the purchase information of the store server of said another to the customer information when you purchase the product at its different store.

Claims (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 advertisement 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 associate customer information and purchase information with the packaging medium is printed, and a tag for shipping the product is printed based on the customer information, and 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.

Images