CN110503464A - A kind of advertisement dispensing frequency control method based on distributed data base - Google Patents
A kind of advertisement dispensing frequency control method based on distributed data base Download PDFInfo
- Publication number
- CN110503464A CN110503464A CN201910740953.4A CN201910740953A CN110503464A CN 110503464 A CN110503464 A CN 110503464A CN 201910740953 A CN201910740953 A CN 201910740953A CN 110503464 A CN110503464 A CN 110503464A
- Authority
- CN
- China
- Prior art keywords
- frequency control
- data base
- distributed data
- launched
- deal
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 28
- 238000012544 monitoring process Methods 0.000 claims description 7
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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
- G06Q30/0251—Targeted advertisements
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Development Economics (AREA)
- Finance (AREA)
- Databases & Information Systems (AREA)
- Strategic Management (AREA)
- Accounting & Taxation (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- Computing Systems (AREA)
- Game Theory and Decision Science (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a kind of, and frequency control method is launched in the advertisement based on distributed data base, which is characterized in that is comprised the steps of: A, is launched server reception dispensing request；B, station number device_id and order information deal_id is parsed；C, server is launched to obtain launching historical information to distributed networks database query as major key using device_id+deal_id；D, using the corresponding rule_id of deal_id as major key, it maps to obtain period, period_unit, times by launching rule_map in historical information, the present invention is based on the advertisements of distributed data base to launch frequency control method when in face of complicated dropping apparatus, the relatively simple frequency control launched.
Description
Technical field
The present invention relates to technical field of network information, frequency control is launched in specifically a kind of advertisement based on distributed data base
Method processed.
Background technique
In the practical application of the prior art, although simple N+ dispensing improves user experience, throwing is also increased
The complexity put, advertiser can launch multiple and different N+ advertisements under logical stereotactic conditions (crowd, region etc.), i.e., same wide
It accuses under material there may be the playback version of multiple and different contents, the multiple identical advertisement of viewing will not be repeated by making user both,
The dispensing effect of advertisement will not be reduced.But this to launch with the N+ for orienting more advertisements, process complex redundancy is needed to identical item
The advertisement dropping apparatus of part is multiple, the setting up procedure that each advertisement is launched it is extremely complex (including a variety of stereotactic conditions selection,
The priority of various dimensions is arranged, N+ control setting, monitoring address setting etc.), it is unfavorable for managing and monitors.
Therefore, how when in face of complicated dropping apparatus, the relatively simple frequency control launched becomes existing
The technical issues of technology urgent need to resolve.
Summary of the invention
The purpose of the present invention is to provide a kind of, and frequency control method is launched in the advertisement based on distributed data base, to solve
The problems mentioned above in the background art.
To achieve the above object, the invention provides the following technical scheme:
A kind of advertisement dispensing frequency control method based on distributed data base comprising the steps of:
A, it launches server and receives dispensing request；
B, station number device_id and order information deal_id is parsed；
C, server is launched to obtain launching history letter to distributed networks database query as major key using device_id+deal_id
Breath；
D, using the corresponding rule_id of deal_id as major key, by launch rule_map in historical information map to obtain period,
period_unit,times；
E, current time stamp timestamp is calculated；
F, time_slot is calculated divided by period_unit in timestamp；
G, compare the corresponding counting of time_slot and times to judge currently launch whether have reached the frequency control upper limit；
H, the event in traversal queries result histroy_list；
I, the impressions of event of the statistics timestamp within the specified time of interval, judge whether current launch has reached frequency
The secondary control upper limit completes this process.
As further technical solution of the present invention: in the step B, if request is no to carry device_id, no
Carry out frequency control.
As further technical solution of the present invention: in the step C, if request carries deal_id, being walked
Rapid D；Otherwise step G is carried out.
As further technical solution of the present invention: the step C is specifically: the flow identified in air exercise, and output is detailed
Logic is handled to buffer area, and is sent to external journal queue's system.
As further technical solution of the present invention: in the step I, the impressions of event are needed in specific dimension
Lower statistics, the specific dimension are the dimension of deal_id, solution_id, creative_group_id composition.
As further technical solution of the present invention: further include the process that exposure monitoring request is launched in advertisement:
J, device_id, deal_id, solution_id, creative_ are precipitated according to the parametric solution that monitoring request carries
group_id；
K, complete exposure information is committed to distributed data base；
L, request is submitted in the UDF processing of distributed data base service side triggering deployment；
M, judge whether rule_info and its version changes；
If N, changed, the content update that exposure information is carried to rule_info, and empty rule_map and rule_list；
O, this exposure information is inserted into history_map, if to correspond to time_slot existing by timestamp, added up
times；
P, by the additional filling history_list of this exposure information.Complete this process.
As further technical solution of the present invention: in the step L, if exposure corresponding requests carry deal_id,
Then carry out step M；Otherwise step O is carried out.
Compared with prior art, the beneficial effects of the present invention are: the present invention is based on the advertisements of distributed data base to launch frequency
Secondary control method is when in face of complicated dropping apparatus, the relatively simple frequency control launched.
Detailed description of the invention
Fig. 1 is system overall flow architecture diagram.
Fig. 2 a certain user that illustrates records the access of a certain order.
Rule, which defines, in Fig. 2 at most shows the intention of same intention group 5 times in 2 days under the order.
Fig. 3 a certain user that illustrates records the access of a certain order.
Rule is defined and is at most shown 1 time in 2 hours to same dispensing under the order in Fig. 3.
Fig. 4 a certain user that illustrates records the access of a certain order.
Rule defines in Fig. 4 allows common show 5 times with another order within 1 week under the order.
Fig. 5 illustrate a certain user under the scene that flow does not carry deal_id recently several times access record.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
Embodiment 1: Fig. 1-5, a kind of advertisement dispensing frequency control method based on distributed data base are please referred to, comprising:
A launches server and receives dispensing request
B parses station number device_id and order information deal_id.If request is without carrying device_id, no
Carry out frequency control.
C is launched server and is obtained launching history to distributed networks database query as major key using device_id+deal_id
Information.If request carries deal_id, the example of query result Fig. 2,3,4, and carries out step S04；Otherwise show for Fig. 5
Example, and carry out step S08.
D maps to obtain using the corresponding rule_id of deal_id as major key by launching rule_map in historical information
period、period_unit、times。
E calculates current time stamp timestamp.
Time_slot is calculated divided by period_unit in timestamp by F.
G, compare time_slot it is corresponding counting and times come judge currently launch whether have reached the frequency control upper limit,
Complete this process.
Event in H, traversal queries result histroy_list.
I, statistics timestamp interval specified time in event specific dimension (deal_id, solution_id,
Creative_group_id the impressions under), judge whether current dispensing has reached the frequency control upper limit, complete this stream
Journey.
Embodiment 2: on the basis of embodiment 1: further include the process that exposure monitoring request is launched in advertisement:
J, device_id, deal_id, solution_id, creative_ are precipitated according to the parametric solution that monitoring request carries
group_id；
K, complete exposure information is committed to distributed data base；
L, request is submitted in the UDF processing of distributed data base service side triggering deployment.If exposure corresponding requests carry deal_
Id, then corresponding record is the example of Fig. 2,3,4, and carries out step S13；Otherwise it is Fig. 5 example, and carries out step S16.
Step S13, judges whether rule_info and its version changes；
M, judge whether rule_info and its version changes；
If N, changed, the content update that exposure information is carried to rule_info, and empty rule_map and rule_list；
O, this exposure information is inserted into history_map, if to correspond to time_slot existing by timestamp, added up
times；
P, by the additional filling history_list of this exposure information.Complete this process.
It is obvious to a person skilled in the art that invention is not limited to the details of the above exemplary embodiments, Er Qie
In the case where without departing substantially from spirit or essential attributes of the invention, the present invention can be realized in other specific forms.Therefore, no matter
From the point of view of which point, the present embodiments are to be considered as illustrative and not restrictive, and the scope of the present invention is by appended power
Benefit requires rather than above description limits, it is intended that all by what is fallen within the meaning and scope of the equivalent elements of the claims
Variation is included within the present invention.Any reference signs in the claims should not be construed as limiting the involved claims.
In addition, it should be understood that although this specification is described in terms of embodiments, but not each embodiment is only wrapped
Containing an independent technical solution, this description of the specification is merely for the sake of clarity, and those skilled in the art should
It considers the specification as a whole, the technical solutions in the various embodiments may also be suitably combined, forms those skilled in the art
The other embodiments being understood that.
Claims (7)
1. frequency control method is launched in a kind of advertisement based on distributed data base, which is characterized in that comprise the steps of:
A, it launches server and receives dispensing request；
B, station number device_id and order information deal_id is parsed；
C, server is launched to obtain launching history letter to distributed networks database query as major key using device_id+deal_id
Breath；
D, using the corresponding rule_id of deal_id as major key, by launch rule_map in historical information map to obtain period,
period_unit,times；
E, current time stamp timestamp is calculated；
F, time_slot is calculated divided by period_unit in timestamp；
G, compare the corresponding counting of time_slot and times to judge currently launch whether have reached the frequency control upper limit；
H, the event in traversal queries result histroy_list;
I, the impressions of event of the statistics timestamp within the specified time of interval, judge whether current launch has reached frequency
The secondary control upper limit completes this process.
2. frequency control method is launched in a kind of advertisement based on distributed data base according to claim 1, feature exists
In in the step B, if request is no to carry device_id, without frequency control.
3. frequency control method is launched in a kind of advertisement based on distributed data base according to claim 1, feature exists
In, in the step C, if request carry deal_id, carry out step D；Otherwise step G is carried out.
4. frequency control method is launched in a kind of advertisement based on distributed data base according to claim 1, feature exists
In the step C is specifically: the flow identified in air exercise exports processing logic in detail to buffer area, and is sent to external day
Will queue system.
5. frequency control method is launched in a kind of advertisement based on distributed data base according to claim 1, feature exists
In, in the step I, the impressions of event needs count under specific dimension, the specific dimension be deal_id,
The dimension of solution_id, creative_group_id composition.
6. frequency control method is launched in a kind of advertisement based on distributed data base according to claim 1, feature exists
In, further include advertisement launch exposure monitoring request process:
J, device_id, deal_id, solution_id, creative_ are precipitated according to the parametric solution that monitoring request carries
group_id；
K, complete exposure information is committed to distributed data base；
L, request is submitted in the UDF processing of distributed data base service side triggering deployment；
M, judge whether rule_info and its version changes；
If N, changed, the content update that exposure information is carried to rule_info, and empty rule_map and rule_list；
O, this exposure information is inserted into history_map, if to correspond to time_slot existing by timestamp, added up
times；
P, by the additional filling history_list of this exposure information, this process is completed.
7. frequency control method is launched in a kind of advertisement based on distributed data base according to claim 6, feature exists
In, in the step L, if exposure corresponding requests carry deal_id, carry out step M；Otherwise step O is carried out.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910740953.4A CN110503464B (en) | 2019-08-12 | 2019-08-12 | Advertisement putting frequency control method based on distributed database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910740953.4A CN110503464B (en) | 2019-08-12 | 2019-08-12 | Advertisement putting frequency control method based on distributed database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110503464A true CN110503464A (en) | 2019-11-26 |
| CN110503464B CN110503464B (en) | 2024-01-26 |
Family
ID=68586442
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910740953.4A Active CN110503464B (en) | 2019-08-12 | 2019-08-12 | Advertisement putting frequency control method based on distributed database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110503464B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2003242403A (en) * | 2002-02-14 | 2003-08-29 | Canon Inc | Advertisement distribution system, advertisement distribution server, advertisement distribution method, recording medium, and program |
| CN102708495A (en) * | 2012-01-06 | 2012-10-03 | 合一网络技术(北京)有限公司 | Method and device for controlling advertising frequency |
| CN102779308A (en) * | 2012-01-09 | 2012-11-14 | 合一网络技术(北京)有限公司 | Advertisement release method and system |
| CN105376592A (en) * | 2015-12-21 | 2016-03-02 | 合一网络技术(北京)有限公司 | Advertisement idea carousel method based on frequency control |
| CN105491454A (en) * | 2015-11-25 | 2016-04-13 | 合一网络技术(北京)有限公司 | Frequency control method and device in precise recommendation |
| CN106790572A (en) * | 2016-12-27 | 2017-05-31 | 广州华多网络科技有限公司 | The system and method that a kind of distributed information log is collected |
| CN107341690A (en) * | 2017-06-30 | 2017-11-10 | 上海精数信息科技有限公司 | Information-pushing method and device |
-
2019
- 2019-08-12 CN CN201910740953.4A patent/CN110503464B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2003242403A (en) * | 2002-02-14 | 2003-08-29 | Canon Inc | Advertisement distribution system, advertisement distribution server, advertisement distribution method, recording medium, and program |
| CN102708495A (en) * | 2012-01-06 | 2012-10-03 | 合一网络技术(北京)有限公司 | Method and device for controlling advertising frequency |
| CN102779308A (en) * | 2012-01-09 | 2012-11-14 | 合一网络技术(北京)有限公司 | Advertisement release method and system |
| CN105491454A (en) * | 2015-11-25 | 2016-04-13 | 合一网络技术(北京)有限公司 | Frequency control method and device in precise recommendation |
| CN105376592A (en) * | 2015-12-21 | 2016-03-02 | 合一网络技术(北京)有限公司 | Advertisement idea carousel method based on frequency control |
| CN106790572A (en) * | 2016-12-27 | 2017-05-31 | 广州华多网络科技有限公司 | The system and method that a kind of distributed information log is collected |
| CN107341690A (en) * | 2017-06-30 | 2017-11-10 | 上海精数信息科技有限公司 | Information-pushing method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110503464B (en) | 2024-01-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103617543B (en) | The recommendation method and apparatus of application program | |
| CN106600314B (en) | Advertisement pushing system | |
| US8965670B2 (en) | Method and system for automatically selecting and displaying traffic images | |
| US11663630B2 (en) | System and method for customizing audio advertisements | |
| US20020184097A1 (en) | Advertisement distributing device and charging device | |
| CN104537000B (en) | A kind of method and apparatus for pushed information | |
| CN104853230B (en) | A kind of hot video method for pushing and device | |
| US20110246201A1 (en) | System for providing audio messages on a mobile device | |
| CN110544134B (en) | Resource processing method and device and computer storage medium | |
| CN105872830A (en) | Interaction method and device for live channel | |
| CN110460881A (en) | Management method, device, computer equipment and the storage medium of attribute tags | |
| CN106530015A (en) | Information releasing control method and apparatus | |
| CN107404481B (en) | User information recognition methods and device | |
| CN108574706A (en) | Method and device for pushing media files | |
| CN108521583A (en) | A kind of a large amount of barrage information concurrent processing methods and cloud computing server based on cloud computing | |
| CN103747303A (en) | Advertisement putting method and device for additionally putting advertisements to target crowds | |
| JP2019509543A (en) | Media information presentation method, server, and storage medium | |
| CN116346794A (en) | Method, device and non-volatile computer-readable storage medium for receiving media data | |
| CN106447258A (en) | Searching method and system of courier information | |
| US11671669B2 (en) | System and method of tablet-based distribution of digital media content | |
| CN110268436B (en) | System for managing content playback | |
| JP2005078372A (en) | Content distribution device and method | |
| CN104602041A (en) | Content supply device and method | |
| CN110503464A (en) | A kind of advertisement dispensing frequency control method based on distributed data base | |
| Teklemariam et al. | What works in family planning interventions in sub-Saharan Africa: a scoping review |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |