CN104756144A - Database accumulating method - Google Patents

Database accumulating method Download PDF

Info

Publication number
CN104756144A
CN104756144A CN201380055589.9A CN201380055589A CN104756144A CN 104756144 A CN104756144 A CN 104756144A CN 201380055589 A CN201380055589 A CN 201380055589A CN 104756144 A CN104756144 A CN 104756144A
Authority
CN
China
Prior art keywords
information
shop
commodity
server
advertising message
Prior art date
Legal status (The legal status 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 status listed.)
Pending
Application number
CN201380055589.9A
Other languages
Chinese (zh)
Inventor
辻有吾
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
P Co Ltd Al
Pal Co Ltd
Original Assignee
P Co Ltd Al
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 P Co Ltd Al filed Critical P Co Ltd Al
Publication of CN104756144A publication Critical patent/CN104756144A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Payment architectures, schemes or protocols
    • G06Q20/08Payment architectures
    • G06Q20/20Point-of-sale [POS] network systems
    • G06Q20/202Interconnection 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
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Payment architectures, schemes or protocols
    • G06Q20/08Payment architectures
    • G06Q20/20Point-of-sale [POS] network systems
    • G06Q20/203Inventory monitoring
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Commerce
    • G06Q30/02Marketing; Price estimation or determination; Fundraising
    • G06Q30/0241Advertisements

Abstract

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. 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
Technical field
The present invention relates to a kind of can open ground and the database storage method of centralized stores Customer Information, merchandise news and store information in non-limiting manner.
Background technology
Such as in shopping online, if buy commodity in the shop on webpage (hereinafter referred to as shop), then carry out purchase formality, this buyer delivered to by commodity.In this series of circulation, along with commodity, the information of these commodity and the information of buyer are accessed with buyer, shop, warehouse and dispensing dealer in this case.In addition, although also comprise the clearing houses of process settlement information, eliminating is set to herein.
Above-mentioned such as merchandise news or buyer's information as from now on commodity are expanded useful information be stored in a database (being stored).Database, except situation about such as building separately in shop, also builds in exchange place of merchandise news, buyer's information.
In the past, the multiple reward voucher that the distribution special selling of known such as certain shop is intended to also distributes these reward vouchers, the method that the information obtained this reward voucher effect of investigation (trend because of the buyer that reward voucher causes) stores, it is issued the reward voucher of the information such as such as special selling imparted about object commodity by shop, and give client by this reward voucher, carry out the effect measuring of reward voucher, namely investigation obtains having much degree to come shop by the induction of this reward voucher in the client of reward voucher.
As the information that shop in the method obtains, for being subject to Customer Information, the reward voucher content of reward voucher induction and carrying out the percent information of shop number relative to issuing preferential tickets quantity.After knowing the trend of client for reward voucher content, this coupon information additionally associated to Customer Information and stores in a database, or Customer Information additionally associated to reward voucher (such as merchandise news) information and stores in a database.
In addition, in the past, knownly carry out the advertisement of so-called interest matching type, namely, the merchandise news in shop is such as made to be associated with each other (classification), when have purchased certain commodity, other merchandise news that the past extracting these commodity is bought in history in same classification shows, thus induces to other commodity.
In this case, as the information that shop obtains, mainly client purchase history and by reading other merchandise news of display the interest trend information that obtains.After knowing the interest tendency of client, this merchandise news and other merchandise news additionally associated to Customer Information and stores in a database, or Customer Information additionally associated to merchandise news and stores in a database.
As mentioned above, by means of only the information (referring to the website of reading specified by URL in this situation) of viewing shop on net display, Customer Information and merchandise news is just made to be associated and to be stored in database.In side, shop, based on such database, for being associated with income and seeking tendency, or for suitable commodity can be pointed out to carry out data mining.
But, in the storage means of existing two databases mainly, there is the problem that described method is the storage means of closure, namely, described method only can store this shop information and about the information of the commodity at this shop operation and the associativity additional information of the Customer Information to register in this shop, also there is described method is optionally and the problem of determinate storage means simultaneously, that is, described method can not store the information except this shop or this commodity for client.
Summary of the invention
(1) technical matters that will solve
The problem solved is, existing database storage method only can store this shop information and about the information of the commodity at this shop operation and the problem of the additional information of the associativity of the Customer Information to register in this shop, and the problem of the information except this shop or this commodity for client can not be stored.
(2) technical scheme
The present invention is a kind of database storage method, connect the Customer Information in the shop stored on website, multiple shops server and the multiple Advertisement Servers storing advertising message of purchase information and merchandise news, centrality ground stores information, it is topmost is characterised in that, between described multiple shops server and described Advertisement Server, centralized servers is set, this centralized servers possesses advertising matches portion, commodity send preparing portion, connect test section and information storage part, the Customer Information relating to commodity transmission provided by shop server is provided in this centralized servers, purchase information and merchandise news, on the other hand, the advertising message in the multiple shops provided by Advertisement Server is provided, simultaneously, from described advertising message, the advertising message in other shop associated with the commodity sent and client is extracted by advertising matches portion, by commodity send preparing portion with the commodity bought with on the packaging medium of the advertising media of tying or bale packing commodity, printing is attached with the described advertising message of the information that can associate Customer Information and the information of purchase respectively, and based on Customer Information for commodity send goods label, after described advertising message arrives client place together with commodity, when this client to connect the shop server in other shop based on described advertising message, by connecting test section, this is detected, the information that the association of this Customer Information is detected is stored by information storage part, in addition, when have purchased commodity in this other shop, this purchase information of further storage.
(3) beneficial effect
Tool of the present invention has the following advantages: except this store information and about except the information of the commodity at this shop operation and the associativity additional information of the Customer Information registered in this shop, newly can also store the relevant information of client for the correspondence of following information, namely, not only there is the above-mentioned information in multiple shop, other advertisement demonstrating information provided when sending is be provided, further, the purchase information of the commodity that client buys in this other shop can also be stored.In addition, tool of the present invention has the following advantages: except for except this shop of client or this commodity, can also store the information of other commodity relating to other shop and other shop.
Namely, tool has the following advantages, namely, by the database that storage means of the present invention stores in centralized servers, based on the viewpoint of Customer Information, the not only purchase information in certain shop, and receive the information in other shop, the buyer of advertising message to the reading history (advertising results) in other shop, purchase information in other shop permanently and roughly automatically continue to store from advertising message, its result, can carry out employing stored database, extremely careful and data mining that is that cut from various entry.
Accompanying drawing explanation
Fig. 1 is the figure of the summary representing database storage method of the present invention.
Fig. 2 is the figure of the transition situation of the information representing database storage method of the present invention.
Fig. 3 is the figure of the running-active status of the connection test section representing database storage method of the present invention.
Embodiment
The present invention is directed in existing database storage method, only can store the problem by means of the associativity additional information of the closure relation of merchandise news between shop and client, and the problem that only can optionally and restrictively store for this shop of client or the information of these commodity, solve by the following technical solutions, namely, between multiple shops server and Advertisement Server, centralized servers is set, this centralized servers possesses advertising matches portion, commodity send preparing portion, connect test section and information storage part, the Customer Information relating to commodity transmission and merchandise news that are thered is provided by shop server are provided in this centralized servers, simultaneously, the advertising message in other shop provided by Advertisement Server is also provided, the advertising message in other shop provided by Advertisement Server is sent to client together with commodity, when this client to connect other shop server of this advertising message based on advertising message, to Customer Information during other shop server of connection, the goods purchase information of advertising message and transmission stores, in addition, when have purchased commodity in this other shop, store the purchase information of the commodity of this purchase.
Embodiment 1
Below, be described with reference to the embodiment of Fig. 1 ~ Fig. 3 to database storage method of the present invention.Database storage method of the present invention is multiple shops server 1, multiple Advertisement Server 2, other shop server 3, centralized servers 4, can implementing under the state that connects at network each other of the environment such as PC (hereinafter referred to as client 5) of connecting Internet of using as client.
Due to the physical property of shop server 1, Advertisement Server 2, other shop servers 3, centralized servers 4, client 5 and concrete hardware configuration is can the general structure that connects of network as mentioned above, description will be omitted, but be set to, in shop server 1, Advertisement Server 2, other shop servers 3, centralized servers 4, in as the hard disk of memory storage, to there is various information described below.
The Customer Information 1A that registers in this shop and the merchandise news 1B at this shop operation is stored in shop server 1.Advertisement Server 2 stores the advertising message 2A provided by other shop server 3.The Customer Information 3A registered in this shop and the merchandise news 3B (separating with shop server 1 in explanation) at this shop operation is stored in other shop server 3.
Customer Information 1A (3A) is the information storing the such as client ID, name, address etc. that relate to client.Merchandise news 1B is the information storing the such as commodity ID, name, classification, price etc. that relate to commodity.Advertising message 2A stores the information relating to shop and such as advertisement ID, shop name, URL, trade name etc. at the commodity of shop operation.
Advertising message 2A in this Advertisement Server 2 refers to when sending the request of the main idea wanting advertizing by other shop server 3 in this example, the information provided by this other shop server 3.
Centralized servers 4 has commodity as program and sends preparing portion 4A, advertising matches portion 4B, connects test section 4C and information storage part 4D.If commodity send the instruction that preparing portion 4A receives the main idea being sent in the commodity that shop server 1 is bought in the hardware of centralized servers 4, then instruction printing and packaging medium P are with the advertising media AD publishing advertising message 2A tied, or instruction print advertisements information 2A on the packaging medium P of bale packing commodity, in addition, based on (being provided by shop server 1) Customer Information instruction printing goods label T sending commodity.
Advertising matches portion 4B extracts the advertising message 2A provided in order to advertizing by Advertisement Server 2, and be considered to shop server 1 in receive commodity and send in the Customer Information 1A and merchandise news 1B indicated one or both sides and be considered to suitable advertising message 2A.
Connect test section 4C aftermentioned explanation in this example, it detects client 5 and connects other shop server 3.Information storage part 4D detected by described connection test section 4C connect other shop server 3 by client 5 time, information 5D is bought in the advertising message 5C main store this Customer Information 5A, the goods purchase information 5B sent because of this client, publishing to this client, this other shop when other shop have purchased commodity.
In addition, buy the information that information 5A and other shop purchase information 5D refers to such as buy the date, buy commodity, buy shop, be referred to as these information in this example.
Information storage part 4D is as aftermentioned explanation, and stores customer information 1A, merchandise news 1B when asking to send commodity to centralized servers 4, when asking centralized servers 4 also to store advertising message 2A when advertizing information 2A.
The situation that the information storage part 4D that various information concentrates on centralized servers 4 concentrates has been shown in Fig. 2.In centralized servers 4, the advertising message 2A provided by Advertisement Server 2, by the Customer Information 1A of shop server 1 instruction when sending and merchandise news 1B, when commodity arrive, client 5 connects other shop servers 3 based on the information of advertising media AD time Customer Information 5A, buy information 5B, advertising message 5C, also have other shops purchase information 5D from these other shop servers 3 when to have purchased commodity in other shops to be stored in respectively in information storage part 4D.
In addition, if buy information 5D based on other shops to indicate the transmission that centralized servers 4 sends new commodity, then become circulation as described below, namely, (in explanation, being exchanged by other shop servers 3 below with shop server 1) mates new advertising message 2A by advertising matches portion 4B according to Customer Information 1A, the merchandise news 1B of shop server 1, and print advertisements medium AD, goods label T, by commodity bale packing in packaging medium P, send to buyer 5.
Here, the advertising media AD generated by advertising message 2A and the connection detection method of being undertaken by connecting test section 4C in centralized servers 4 are described.Advertising media AD is configured to, record the content of the advertisement/commodity to the induction of other shop servers 3, simultaneously, the QR code (registered trademark) of such as record embedding URL, transmission record the Email of URL link, arrange the automatic reading out type sensor of embedding URL, or directly record URL.
Further, in this URL, together with the Customer Information 1A of this client 5 be sent out at the commodity of information storage part 4D storage is summarised in this advertising message 2A etc., and associate with Customer Information 1A, and then address is made in the storage area numeralization cushioned in addition.
If client 5 is by advertising media AD access, in above-mentioned, any one passes through for carrying out the URL induced, then as shown in Figure 3, connect for the time being, be redirected to other shop servers 3 thus with the connection test section 4C of centralized servers 4.Then, this connection test section 4C is when detecting that client 5 connects other shop servers 3, each information (i.e. Customer Information 5A, purchase information 5B, advertising message 5C) of above-mentioned other buffering is associated with this Customer Information 1A, is formally stored in information storage part 4D.
In addition, now, when client 5 have purchased commodity in other shops, not only Customer Information 5A, purchase information 5B, advertising message 5C, and sending other shops purchase information 5D by other shop servers 3, this other shop is bought information 5D and is associated with this Customer Information 1A and store in information storage part 4D.
Description of reference numerals
1-shop server
1A-Customer Information
1B-merchandise news
2-Advertisement Server
2A-advertising message
Other shop server of 3-
3A-Customer Information
3B-merchandise news
4-centralized servers
4A-commodity send preparing portion
4B-advertising matches portion
4C-connects test section
4D-information storage part
Client 5-
5A-Customer Information
5B-buys information
5C-advertising message
Information is bought in other shop of 5D-

Claims (1)

1. a database storage method, it connects the Customer Information in the shop stored on website, multiple shops server and the multiple Advertisement Servers storing advertising message of purchase information and merchandise news, centrality ground stores information, it is characterized in that, between described multiple shops server and described Advertisement Server, centralized servers is set, this centralized servers possesses advertising matches portion, commodity send preparing portion, connect test section and information storage part, the Customer Information relating to commodity transmission provided by shop server is provided in this centralized servers, purchase information and merchandise news, on the other hand, the advertising message in the multiple shops provided by Advertisement Server is provided, simultaneously, from described advertising message, the advertising message in other shop associated with the commodity sent and client is extracted by advertising matches portion, by commodity send preparing portion with the commodity bought with on the packaging medium of the advertising media of tying or bale packing commodity, printing is attached with the described advertising message of the information that can associate Customer Information and the information of purchase respectively, and based on Customer Information for commodity send goods label, after described advertising message arrives client place together with commodity, when this client to connect the shop server in other shop based on described advertising message, by connecting test section, this is detected, the information that the association of this Customer Information is detected is stored by information storage part, in addition, when have purchased commodity in this other shop, this purchase information of further storage.
CN201380055589.9A 2012-11-12 2013-09-05 Database accumulating method Pending CN104756144A (en)

Applications Claiming Priority (3)

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

Publications (1)

Publication Number Publication Date
CN104756144A true CN104756144A (en) 2015-07-01

Family

ID=50684377

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201380055589.9A Pending CN104756144A (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)

Families Citing this family (1)

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

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20010054014A1 (en) * 2000-06-20 2001-12-20 Hajime Noda Client information collecting method, client information providing method, point assigning method, merchandise information providing method, and merchandise information collection apparatus using network
US20020046099A1 (en) * 2000-09-05 2002-04-18 Renee Frengut Method for providing customized user interface and targeted marketing forum
CN1357126A (en) * 1999-06-15 2002-07-03 永野宏明 Advertising system and method using electronic communication
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
CN101414372A (en) * 2007-10-19 2009-04-22 潘广和 Device and method for paying for internet advertisement information based on preservation
JP2010026869A (en) * 2008-07-22 2010-02-04 Yahoo Japan Corp System for delivering successful bid article

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1357126A (en) * 1999-06-15 2002-07-03 永野宏明 Advertising system and method using electronic communication
US20010054014A1 (en) * 2000-06-20 2001-12-20 Hajime Noda Client information collecting method, client information providing method, point assigning method, merchandise information providing method, and merchandise information collection apparatus using network
US20020046099A1 (en) * 2000-09-05 2002-04-18 Renee Frengut Method for providing customized user interface and targeted marketing forum
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
CN101414372A (en) * 2007-10-19 2009-04-22 潘广和 Device and method for paying for internet advertisement information based on preservation
JP2010026869A (en) * 2008-07-22 2010-02-04 Yahoo Japan Corp System for delivering successful bid article

Also Published As

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

Similar Documents

Publication Publication Date Title
US20090228360A1 (en) Email advertisement system and method for online retail
WO2001039023A2 (en) Method and facility for capturing behavioral and profile data during a customer visit to a web site
US20150242829A1 (en) System and method for managing a single point of sale of plurality of merchandise from plurality of retailer
Rabinovich et al. Unlimited shelf space in Internet supply chains: Treasure trove or wasteland?
WO2011163546A4 (en) System for purchasing commercial goods and services at a location remote therefrom
CN103246982A (en) Method and system for commodity release
JP3865611B2 (en) Data collection method
JP2006227817A (en) Advertisement effect measurement system, advertisement effect measurement method and program
CA2880014C (en) Transaction support system
CN103257890A (en) Order system template and structure
JP2011154611A (en) Server device, information providing method and information providing program
JP4480388B2 (en) Distribution management system and method, and distribution information recording medium
CN104756144A (en) Database accumulating method
KR20140022308A (en) Real time goods management system using qr code
KR20030036537A (en) Method and system for deciding price of product on the basis of valid date of product
JP2011108064A (en) Sales promotion information generation system
US20230222570A1 (en) Systems and methods for increasing the migration and accessibility of data
Sciarra et al. Geographical indications: why traceability systems matter and how they add to brand value
Boruhan et al. What is wrong with private shopping sites?–evidence from turkey
KR20150059203A (en) Method and system for real time providing goods information online
JP6203163B2 (en) Customer management apparatus, customer management system and method
JP2013229066A (en) Output control method, output control device, and computer program
TWM541065U (en) Online shopping system integrating physical advertisement
JP2010211687A (en) Customer management system
Savolainen Customer Returns in E-commerce: Jyväs-Caravan Oy

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
REG Reference to a national code

Ref country code: HK

Ref legal event code: DE

Ref document number: 1206845

Country of ref document: HK

RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20150701

REG Reference to a national code

Ref country code: HK

Ref legal event code: WD

Ref document number: 1206845

Country of ref document: HK