CN104756144A - Database accumulating method - Google Patents
Database accumulating method Download PDFInfo
- 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
Links
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
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
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.
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)
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)
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 |
-
2012
- 2012-11-12 JP JP2012248792A patent/JP5497136B1/en active Active
-
2013
- 2013-09-05 WO PCT/JP2013/073926 patent/WO2014073260A1/en active Application Filing
- 2013-09-05 CN CN201380055589.9A patent/CN104756144A/en active Pending
- 2013-09-05 SG SG11201502829UA patent/SG11201502829UA/en unknown
-
2015
- 2015-04-30 PH PH12015500966A patent/PH12015500966A1/en unknown
- 2015-07-28 HK HK15107203.1A patent/HK1206845A1/en unknown
Patent Citations (7)
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 |