CN109510859A - A kind of statistical method and device of the amount of reach of PUSH message - Google Patents
A kind of statistical method and device of the amount of reach of PUSH message Download PDFInfo
- Publication number
- CN109510859A CN109510859A CN201810982909.XA CN201810982909A CN109510859A CN 109510859 A CN109510859 A CN 109510859A CN 201810982909 A CN201810982909 A CN 201810982909A CN 109510859 A CN109510859 A CN 109510859A
- Authority
- CN
- China
- Prior art keywords
- message
- arrival
- record information
- pushed
- reach
- 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
- 238000007619 statistical method Methods 0.000 title claims abstract description 26
- 238000000034 method Methods 0.000 claims abstract description 22
- 238000004590 computer program Methods 0.000 claims description 15
- 238000012545 processing Methods 0.000 description 7
- 230000008901 benefit Effects 0.000 description 5
- 238000009825 accumulation Methods 0.000 description 4
- 238000004458 analytical method Methods 0.000 description 4
- 230000001186 cumulative effect Effects 0.000 description 4
- 230000000694 effects Effects 0.000 description 4
- 239000000284 extract Substances 0.000 description 4
- 238000007405 data analysis Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000006399 behavior Effects 0.000 description 1
- 230000019771 cognition Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/50—Network services
- H04L67/55—Push-based network services
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/14—Network analysis or design
- H04L41/142—Network analysis or design using statistical or mathematical methods
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Physics & Mathematics (AREA)
- Algebra (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Analysis (AREA)
- Mathematical Optimization (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Pure & Applied Mathematics (AREA)
- Telephonic Communication Services (AREA)
Abstract
The present invention provides a kind of statistical method of the amount of reach of PUSH message and devices.This method comprises: inquiring first database, each arrival record information for being pushed message reported at the appointed time section is obtained, wherein every arrival record information includes reporting time, message unique identity and arrival type；Acquired arrival record information is written line by line in a file；Duplicate removal and number of repetition statistical disposition are carried out to the arrival record information in the file, arrival record information and its corresponding number of repetition after obtaining duplicate removal；According to the message unique identity in the arrival record information after duplicate removal, by the arrival type reached in record information corresponding with each message unique identity, and amount of reach of the number of repetition of arrival record information as the arrival type for being pushed message corresponding with the message unique identity, it is stored in the second database.The present invention effectively increases the execution efficiency and Statistical Speed of program.
Description
Technical field
The present invention relates to Internet technical field, especially a kind of statistical method of the amount of reach of PUSH message, push disappear
Statistic device, computer storage medium and the calculating equipment of the amount of reach of breath.
Background technique
As the rapid development of development of Mobile Internet technology and electronic equipment are intelligentized universal, internet becomes current main
The information of stream propagates one of platform, meanwhile, message push also becomes one of the main means that information propagation is carried out by internet.
Message push usually propagates platform (such as application service platform with message push function) by information and it is expected to obtain by user
Information (such as instant communication information, Domestic News, marketing activity information) be pushed to user in form of a message, can be effective
It improves information and propagates the activity of the user on platform.
In message push service, every message all corresponds to an amount of reach.In order to grasp the effect of Push Service, together
When, analysis understands the hobby of user, further to formulate personalized push scheme, needs to count each period (for example, every
Hour in) amount of reach the case where.In the prior art, small by periodically (for example, per hour) source database being gone to inquire this
Shi Suoyou is pushed the arrival record information of message, and is written in a file.Then, the information in this document is read one by one,
Record in the information and staqtistical data base of reading is subjected to matching inquiry, if there is no the letters with reading in staqtistical data base
Corresponding message is ceased, then is put in storage the information of the message, if existing, carries out the accumulation operations that count is incremented.But when
Push Service is a large amount of in use, a broadcast message may be pushed to millions of a users, then the message has corresponded to millions of
Amount of reach, then, when being counted, need to carry out millions of time matching inquiries and accumulation operations, this will occupy a large amount of
Resource, seriously affect the execution efficiency of program and the performance of database.
Summary of the invention
In view of the above problems, it proposes on the present invention overcomes the above problem or at least be partially solved in order to provide one kind
State the statistical method of the amount of reach of the PUSH message of problem, the statistic device of the amount of reach of PUSH message, computer storage medium
And calculate equipment.
One side according to an embodiment of the present invention provides a kind of statistical method of the amount of reach of PUSH message, comprising:
The first database for being stored with the arrival record information for being pushed message that target terminal reports is inquired, is obtained
Take each arrival record information for being pushed message reported at the appointed time section, wherein every arrival records information and includes
On call time, message unique identity and reach type；
Acquired arrival record information is written line by line in a file；
Duplicate removal and number of repetition statistical disposition are carried out to the arrival record information in the file, the arrival after obtaining duplicate removal
Record information and its corresponding number of repetition；
It, will be corresponding with each message unique identity according to the message unique identity in the arrival record information after the duplicate removal
Arrival record information in arrival type and the arrival record information number of repetition as with the message unique identity pair
That answers is pushed the amount of reach of the arrival type of message, is stored in the second database.
Optionally, the first database for being stored with the arrival record information for being pushed message that target terminal reports is carried out
Inquiry obtains each arrival record information for being pushed message reported at the appointed time section, comprising:
Every the specified period to the first data for being stored with the arrival record information for being pushed message that target terminal reports
Library is inquired, and each arrival record information for being pushed message reported in upper a cycle is obtained.
Optionally, duplicate removal is carried out to the arrival record information in the file and number of repetition counts, comprising:
Duplicate removal is carried out to the arrival record information in the file using sort the and uniq-c order of Linux and is repeated secondary
Number statistics.
Optionally, the arrival type includes having received, have shown that or having clicked.
Optionally, the arrival record information for message that the target terminal reported be pushed is from the target terminal
What software tool pack SDK was generated extracts in log to being pushed getting ready for message.
Optionally, the message unique identity is message id.
According to another aspect of an embodiment of the present invention, a kind of statistic device of the amount of reach of PUSH message is additionally provided, is wrapped
It includes:
Enquiry module, suitable for the first data for being stored with the arrival record information for being pushed message that target terminal reports
Library is inquired, and obtains each arrival record information for being pushed message reported at the appointed time section, wherein every arrival
Record information includes reporting time, message unique identity and arrival type；
Writing module, suitable for acquired arrival record information is written line by line in a file；
Duplicate removal statistical module, suitable for carrying out duplicate removal and number of repetition Statistics Division to the arrival record information in the file
Reason, arrival record information and its corresponding number of repetition after obtaining duplicate removal；And
Preserving module, suitable for that will disappear with each according to the message unique identity in the arrival record information after the duplicate removal
Cease unique identification it is corresponding reach record information in arrival type and the arrival record information number of repetition as with this
The amount of reach of the corresponding arrival type for being pushed message of message unique identity is stored in the second database.
Optionally, the enquiry module is further adapted for:
Every the specified period to the first data for being stored with the arrival record information for being pushed message that target terminal reports
Library is inquired, and each arrival record information for being pushed message reported in upper a cycle is obtained.
Optionally, the duplicate removal statistical module is further adapted for:
Duplicate removal is carried out to the arrival record information in the file using sort the and uniq-c order of Linux and is repeated secondary
Number statistics.
Optionally, the arrival type includes having received, have shown that or having clicked.
Optionally, the arrival record information for message that the target terminal reported be pushed is from the target terminal
What software tool pack SDK was generated extracts in log to being pushed getting ready for message.
Optionally, the message unique identity is message id.
It is according to an embodiment of the present invention in another aspect, additionally provide a kind of computer storage medium, the computer storage
Media storage has computer program code, when the computer program code is run on the computing device, leads to the calculating
Equipment executes the statistical method according to the above amount of reach of described in any item PUSH messages.
Another aspect according to an embodiment of the present invention additionally provides a kind of calculating equipment, comprising:
Processor；And
It is stored with the memory of computer program code；
When the computer program code is run by the processor, the calculating equipment is caused to execute according to above
The statistical method of the amount of reach of described in any item PUSH messages.
The embodiment of the present invention propose technical solution, first to be stored be pushed message arrival record information first
Database (or being source database) is inquired, and each arrival for being pushed message reported within the period to be counted is obtained
Information is recorded, and acquired arrival record information is written line by line in a file, wherein every arrival record information includes upper
Call time, message unique identity and reach type.Then, duplicate removal and number of repetition are carried out to the arrival record information in this document
Statistical disposition, arrival record information and its corresponding number of repetition after obtaining duplicate removal.Finally, being recorded according to the arrival after duplicate removal
Message unique identity in information, by the arrival type reached in record information corresponding with each message unique identity, and
Number of repetition the arriving as the arrival type for being pushed message corresponding with the message unique identity of arrival record information
Up to amount, it is stored in the second database (or being staqtistical data base), completes the amount of reach statistics of PUSH message.By being entered
Before the operation of library, information is recorded to the arrival for being pushed message and carries out duplicate removal processing and number of repetition statistical disposition, after obtaining duplicate removal
Arrival record information and its corresponding number of repetition.Due to all corresponding message unique identity of every arrival record information and
A kind of arrival type, therefore, the number of repetition for reaching record information are that can be considered unique with the message in arrival record information
Identify the amount of reach of the corresponding arrival type for being pushed message.As a result, when carrying out in-stockroom operation, only need to be according to duplicate removal after
Arrival record information in message unique identity, by it is corresponding with each message unique identity reach record information in arrival
The number of repetition of type and arrival record information is stored in staqtistical data base, avoids and exists for each arrival record information
Matching inquiry is carried out in staqtistical data base and is accordingly carried out counting cumulative the step of updating operation according to query result, is greatlyd save
Data-analysis time, reduce the number of operations of database, to effectively improve the execution efficiency and statistics speed of program
Degree.
The above description is only an overview of the technical scheme of the present invention, in order to better understand the technical means of the present invention,
And it can be implemented in accordance with the contents of the specification, and in order to allow above and other objects of the present invention, feature and advantage can
It is clearer and more comprehensible, the followings are specific embodiments of the present invention.
According to the following detailed description of specific embodiments of the present invention in conjunction with the accompanying drawings, those skilled in the art will be brighter
The above and other objects, advantages and features of the present invention.
Detailed description of the invention
By reading the following detailed description of the preferred embodiment, various other advantages and benefits are common for this field
Technical staff will become clear.The drawings are only for the purpose of illustrating a preferred embodiment, and is not considered as to the present invention
Limitation.And throughout the drawings, the same reference numbers will be used to refer to the same parts.In the accompanying drawings:
Fig. 1 shows the flow chart of the statistical method of the amount of reach of PUSH message according to an embodiment of the invention；
Fig. 2 shows the flow charts of the statistical method of the amount of reach of PUSH message according to another embodiment of the present invention；With
And
Fig. 3 shows the structural schematic diagram of the statistic device of the amount of reach of PUSH message according to an embodiment of the invention.
Specific embodiment
Exemplary embodiments of the present disclosure are described in more detail below with reference to accompanying drawings.Although showing the disclosure in attached drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here
It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure
It is fully disclosed to those skilled in the art.
For the amount of reach of every message in push (push) service, currently used statistical method mainly includes walking as follows
It is rapid: firstly, inquiring all arrival for being pushed message in statistical time section from source database records information, and to be written one
In file；Then, one by one read this document in arrival record information, by the record in the information and staqtistical data base of reading into
Row matching inquiry, if Message Record corresponding with the information of reading is not present in staqtistical data base, by the arrival of the message
Information is put in storage and sets amount of reach as 1, if existing, the accumulation operations of count=count+1 are carried out to amount of reach.
But inventors have found that when Push Service is a large amount of in use, this carry out cumulative statistics side by matching inquiry
Method meets with the too low bottleneck of execution efficiency.For example, one broadcast message of fast video push is to 1,000,000 users, then the message pair
Answered 1,000,000 amount of reach, then, when being counted, it is necessary to this message carry out 1,000,000 times matching inquiry and
The accumulation operations of count=count+1 cause execution efficiency especially low, and Statistical Speed is very slow.
In order to solve the above technical problems, the embodiment of the present invention proposes a kind of statistical method of the amount of reach of PUSH message.Fig. 1
Show the flow chart of the statistical method of the amount of reach of PUSH message according to an embodiment of the invention.Referring to Fig. 1, this method can
To include the following steps S102 to step S108.
Step S102, to be stored with the first database of the arrival record information for being pushed message that target terminal reports into
Row inquiry obtains each arrival record information for being pushed message reported at the appointed time section, wherein every arrival record
Information includes reporting time, message unique identity and arrival type.
Acquired arrival record information is written in a file step S104 line by line.
Step S106 carries out duplicate removal and number of repetition statistical disposition to the arrival record information in this document, obtains duplicate removal
Arrival record information and its corresponding number of repetition afterwards.
Step S108 will uniquely be marked according to the message unique identity in the arrival record information after duplicate removal with each message
The number of repetition of the corresponding arrival type reached in record information and arrival record information is known as unique with the message
The amount of reach of the corresponding arrival type for being pushed message is identified, is stored in the second database.
The statistical method of the amount of reach for the PUSH message that the embodiment of the present invention proposes is right by before carrying out in-stockroom operation
The arrival record information for being pushed message carries out duplicate removal processing and number of repetition statistical disposition, and the arrival after obtaining duplicate removal records letter
Breath and its corresponding number of repetition.Due to every all corresponding message unique identity of arrival record information and a kind of arrival class
Type, therefore, the number of repetition for reaching record information are that can be considered corresponding with the message unique identity in arrival record information
It is pushed the amount of reach of the arrival type of message.As a result, when carrying out in-stockroom operation, it need to only be recorded according to the arrival after duplicate removal
Message unique identity in information by the arrival type reached in record information corresponding with each message unique identity and is somebody's turn to do
The number of repetition for reaching record information is stored in staqtistical data base, avoids and reaches record information in staqtistical data base for each
Middle progress matching inquiry simultaneously accordingly carries out counting cumulative the step of updating operation according to query result, and data analysis is greatly saved
Time, reduce the number of operations of database, to effectively improve the execution efficiency and Statistical Speed of program.
The first database (being referred to as source database) referred in above step S102 can be set in target terminal
On the push proxy server of the destination client of upper carrying or the data center of statistics side.Target terminal can be intelligent hand
The terminal devices such as machine, tablet computer, destination client can be APP (application program) client installed on the terminal device
Deng.
Optionally, the arrival record information for message that target terminal reported be pushed is from the software tool on target terminal
What packet (Software Development Kit, SDK) generated extracts in log to being pushed getting ready for message.It gets ready and refers to
By user's operation, view is caused to change, therefore, get record ready is not only the operation behavior of user, also record view variation
When service data information.In the embodiment of the present invention, event is got ready to be pushed message using SDK monitoring objective terminal side,
For example, destination client receive one be pushed message, the message that is pushed that receives is shown to terminal device operating system
Notification bar, user click receive be pushed message etc..When SDK is monitored to being pushed when getting event ready of message,
Generation gets that event is corresponding to get log ready ready with this, to record the arrival record information for being pushed message, and in turn by generation
It gets log ready and reports to preassigned server end or data center.
Be pushed at every message arrival record information in, including above call time, message unique identity and reach type.
Wherein, message unique identity can be message name, message id etc..
In one alternate embodiment, according to the difference of the operation for the type and user for being pushed message, it is pushed message
Arrival type may include having received, have shown that or having clicked.Specifically, received refer to destination client have received by
It PUSH message but does not show the message, is sent to APP client not using interior message or server end for example, receiving
Need message to be shown.It has shown that and refers to that being pushed message has shown that in the notification bar of operating system of target terminal equipment.
The message that is pushed for referring to that destination client receives has been clicked to be checked by user's click.
In one alternate embodiment, remember in step S102 to being stored with the arrival for being pushed message that target terminal reports
The first database of record information is inquired, and each arrival record letter for being pushed message reported at the appointed time section is obtained
Breath, can also be tangibly embodied as:
Every the specified period to the first data for being stored with the arrival record information for being pushed message that target terminal reports
Library is inquired, and each arrival record information for being pushed message reported in upper a cycle is obtained.Finger mentioned herein
Fixed cycle can be set according to actual count demand, such as be set as 1 hour, 2 hours etc..It is pushed away by periodically acquiring
The case where sending the arrival of message to record information to be counted, day part (for example, per hour in) amount of reach can be grasped, so as into
The analysis of one step understands the hobby of user, formulates personalized push scheme.
In actual operation, based on recording information data is reached the characteristics of, can carry out source database using hive tool
Building and inquiry, thus improve reach record information storage and search efficiency.Hive be it is a be implemented in Hadoop it
On Tool for Data Warehouse, externally provide HQL (class SQL) interface, bottom by MapReduce or Spark analysis be stored in
Large-scale dataset on HDFS.In addition, Hive can also analyze the data in other storage systems, such as HBase, RDB,
MongoDB etc..The optimal use occasion of Hive is the batch processing job of large data sets, for example, Web Log Analysis.
After getting each arrival record information for being pushed message reported at the appointed time section, step is executed
S104 acquired arrival record information is written line by line in a file, to subsequent processing.
List a plurality of arrival record information being written in file by way of example below:
In a plurality of arrival record information of above example, first is classified as and reports the time, wherein according to the time precision of statistics
The unit to call time in setting.In this example, the unit to call time by is set as hour, and specifically, 2018022211 indicate
2018-02-22 the 11st hour.Second is classified as arrival type, wherein received expression has received, and displayed expression has been opened up
Show, clicked expression has been clicked.Third column include message unique identity, are indicated in this example with messageId, sourceType
The source port of information is got in expression ready.
From above example as can be seen that the message for being for example 7274832258019387426 for messageId, has
The arrival of three identical received types records information, shows that the message is by 3 targets within 2018022211 periods
Terminal receives, that is, the amount of reach for having received type is 3.Arrival note simultaneously for the message, also with a clicked type
Information is recorded, shows that the message is clicked on 1 target terminal within 2018022211 periods, that is, has clicked the arrival of type
Amount is 1.
Based on above-mentioned cognition, the embodiment of the present invention in step s 106 to the arrival record information in file carry out duplicate removal and
Number of repetition statistical disposition, arrival record information and its corresponding number of repetition after obtaining duplicate removal.
In one alternate embodiment, letter is recorded to the arrival in this document using sort the and uniq-c order of Linux
Breath carries out duplicate removal and number of repetition statistics.Specifically, record information is reached to the multirow in file by sort order to arrange
Sequence makes to repeat capable be brought together.Then, it is removed by uniq-c order and repeats row and count number of repetition.
Still by taking a plurality of arrival above records information as an example, after carrying out duplicate removal and number of repetition statistical disposition, obtain
As a result as follows:
In result above, the first row in every a line is the number of repetition that the row reaches record information, it is, with this
Row reaches the corresponding message that is pushed of the messageId in record information and reaches the arrival type for recording information and being recorded in the row
Under amount of reach.
In above step S108, after obtaining the record information of the arrival after duplicate removal and its corresponding number of repetition, root
According to the message unique identity in the arrival record information after duplicate removal, arrival corresponding with each message unique identity is recorded into information
In arrival type and the arrival record information number of repetition be pushed message as corresponding with the message unique identity
The arrival type amount of reach, deposit the second database (being referred to as staqtistical data base) in.
It is still illustrated by taking above-mentioned a plurality of arrival record information as an example below.For example, for messageId:
7274832258019387426, it, will corresponding with messageId:7274832258019387426 according to the messageId
One reach record information in arrival type received (reception) and the arrival record information number of repetition 3 (as
The amount of reach for having received type for being pushed message corresponding with the messageId), and and messageId:
7274832258019387426 corresponding Article 2 reach arrival type clicked (click) in record information and this is arrived
Up to the number of repetition 1 of record information (as the amount of reach for having clicked type for being pushed message corresponding with the messageId)
It is associatedly stored in the second database.
In practical applications, the second database can use MySQL database.MySQL is most popular relational data
Base management system is saved the data in by linked database in different tables, to increase processing speed and management spirit
Activity.
A variety of implementations of the links of embodiment illustrated in fig. 1 are described above, specific embodiment will be passed through below
Come be discussed in detail PUSH message of the invention amount of reach statistical method realization process.Fig. 2 shows according to the present invention again
The flow chart of the statistical method of the amount of reach of the PUSH message of one embodiment.Referring to fig. 2, this method at least may include step
S202 to step S208.
Step S202 is pushed arriving for message to be stored with that target terminal reports by hive tool every the specified period
First database up to record information is inquired, and each arrival note for being pushed message reported in upper a cycle is obtained
Record information, wherein every arrival record information includes reporting time, message id and arrival type.
In the present embodiment, the specified period is set as 1 hour.Be pushed message arrival type include received, have shown that or
It has clicked.
Acquired arrival record information is written in a file step S204 line by line.
Step S206 carries out duplicate removal to the arrival record information in this document using sort the and uniq-c order of Linux
With number of repetition statistical disposition, arrival record information and its corresponding number of repetition after obtaining duplicate removal.
Step S208 will arrival corresponding with each message id according to the message id in the arrival record information after duplicate removal
The number of repetition of arrival type and arrival record information in record information disappears as be pushed corresponding with the message id
The amount of reach of the arrival type of breath is associatedly stored in MySQL database.
It should be noted that above-mentioned all optional embodiments can be any group by the way of combining in practical application
It closes, forms alternative embodiment of the invention, this is no longer going to repeat them.
Based on the same inventive concept, the embodiment of the invention also provides a kind of statistic device of the amount of reach of PUSH message,
For supporting the statistical method of the amount of reach of PUSH message provided by any one above-mentioned embodiment or combinations thereof.Fig. 3 is shown
The structural schematic diagram of the statistic device of the amount of reach of PUSH message according to an embodiment of the invention.Referring to Fig. 3, the device is extremely
It less may include: enquiry module 310, writing module 320, duplicate removal statistical module 330 and preserving module 340.
Now introduce the statistic device of the amount of reach of the PUSH message of the embodiment of the present invention each composition or device function with
And the connection relationship between each section:
Enquiry module 310, suitable for being stored with the first of the arrival record information for being pushed message that target terminal reports
Database is inquired, and obtains each arrival record information for being pushed message reported at the appointed time section, wherein every
Reaching record information includes reporting time, message unique identity and arrival type.
Writing module 320 is connect with enquiry module 310, suitable for a text is written in acquired arrival record information line by line
In part.
Duplicate removal statistical module 330 is connect with writing module 320, suitable for going to the arrival record information in this document
Weight and number of repetition statistical disposition, arrival record information and its corresponding number of repetition after obtaining duplicate removal.
Preserving module 340 is connect with duplicate removal statistical module 330, suitable for according to disappearing in the arrival record information after duplicate removal
Unique identification is ceased, the arrival type reached in record information corresponding with each message unique identity and the arrival are recorded
Amount of reach of the number of repetition of information as the arrival type for being pushed message corresponding with the message unique identity, deposit the
In two databases.
In one alternate embodiment, enquiry module 310 is further adapted for:
Every the specified period to the first data for being stored with the arrival record information for being pushed message that target terminal reports
Library is inquired, and each arrival record information for being pushed message reported in upper a cycle is obtained.
In one alternate embodiment, duplicate removal statistical module 330 is further adapted for:
Duplicate removal and number of repetition are carried out to the arrival record information in this document using sort the and uniq-c order of Linux
Statistics.
In one alternate embodiment, the arrival type for being pushed message may include having received, have shown that or having clicked.
In one alternate embodiment, the arrival record information that target terminal reported be pushed message can be from target
What software tool pack SDK in terminal was generated extracts in log to being pushed getting ready for message.
In one alternate embodiment, the message unique identity for being pushed message can be message id.
Based on the same inventive concept, the embodiment of the invention also provides a kind of computer storage mediums.Computer storage
Media storage has computer program code, when the computer program code is run on the computing device, calculating equipment is caused to be held
The statistical method of the amount of reach of row PUSH message according to any one above-mentioned embodiment or combinations thereof.
Based on the same inventive concept, the embodiment of the invention also provides a kind of calculating equipment.The calculating equipment may include:
Processor；And
It is stored with the memory of computer program code；
When the computer program code is run by processor, the calculating equipment is caused to execute according to any one above-mentioned reality
Apply the statistical method of the amount of reach of PUSH message described in example or combinations thereof.
According to the combination of any one above-mentioned alternative embodiment or multiple alternative embodiments, the embodiment of the present invention can reach
It is following the utility model has the advantages that
The statistical method and device of the amount of reach for the PUSH message that the embodiment of the present invention proposes are pushed to being stored with first
The first database (or being source database) of the arrival record information of message is inquired, and is obtained within the period to be counted
Each arrival record information for being pushed message of report, and acquired arrival record information is written line by line in a file,
In, every arrival record information includes reporting time, message unique identity and arrival type.Then, to the arrival in this document
It records information and carries out duplicate removal and number of repetition statistical disposition, the arrival after obtaining duplicate removal records information and its repeats accordingly secondary
Number.Finally, corresponding with each message unique identity will be arrived according to the message unique identity in the arrival record information after duplicate removal
Up to the number of repetition of the arrival type recorded in information and arrival record information as corresponding with the message unique identity
It is pushed the amount of reach of the arrival type of message, is stored in the second database (or being staqtistical data base), is completed push and disappears
The amount of reach of breath counts.By before carrying out in-stockroom operation, to the arrival for being pushed message record information carry out duplicate removal processing and
Number of repetition statistical disposition, arrival record information and its corresponding number of repetition after obtaining duplicate removal.Since every arrival records
The all corresponding message unique identity of information and a kind of arrival type, therefore, the number of repetition for reaching record information can be considered
The amount of reach of the arrival type for being pushed message corresponding with the message unique identity in arrival record information.Exist as a result,
, only need to be according to the message unique identity in the arrival record information after duplicate removal when carrying out in-stockroom operation, it will be unique with each message
The number of repetition deposit staqtistical data base of the corresponding arrival type reached in record information and arrival record information is identified,
It avoids and carries out matching inquiry in staqtistical data base for each arrival record information and accordingly carried out according to query result
Cumulative the step of updating operation is counted, the data-analysis time is greatly saved, reduces the number of operations of database, thus effectively
Ground improves the execution efficiency and Statistical Speed of program.
It is apparent to those skilled in the art that the specific work of the system of foregoing description, device and unit
Make process, can refer to corresponding processes in the foregoing method embodiment, for brevity, does not repeat separately herein.
In addition, each functional unit in each embodiment of the present invention can be physically independent, can also two or
More than two functional units integrate, and can be all integrated in a processing unit with all functional units.It is above-mentioned integrated
Functional unit both can take the form of hardware realization, can also be realized in the form of software or firmware.
Those of ordinary skill in the art will appreciate that: if the integrated functional unit is realized and is made in the form of software
It is independent product when selling or using, can store in a computer readable storage medium.Based on this understanding,
Technical solution of the present invention is substantially or all or part of the technical solution can be embodied in the form of software products,
The computer software product is stored in a storage medium comprising some instructions, with so that calculating equipment (such as
Personal computer, server or network equipment etc.) various embodiments of the present invention the method is executed when running described instruction
All or part of the steps.And storage medium above-mentioned includes: USB flash disk, mobile hard disk, read-only memory (ROM), random access memory
Device (RAM), the various media that can store program code such as magnetic or disk.
Alternatively, realizing that all or part of the steps of preceding method embodiment can be (all by the relevant hardware of program instruction
Such as personal computer, the calculating equipment of server or network equipment etc.) it completes, described program instruction can store in one
In computer-readable storage medium, when described program instruction is executed by the processor of calculating equipment, the calculating equipment is held
The all or part of the steps of row various embodiments of the present invention the method.
Finally, it should be noted that the above embodiments are only used to illustrate the technical solution of the present invention., rather than its limitations；To the greatest extent
Present invention has been described in detail with reference to the aforementioned embodiments for pipe, those skilled in the art should understand that: at this
Within the spirit and principle of invention, it is still possible to modify the technical solutions described in the foregoing embodiments or right
Some or all of the technical features are equivalently replaced；And these are modified or replaceed, and do not make corresponding technical solution de-
From protection scope of the present invention.
One side according to an embodiment of the present invention provides a kind of statistical method of the amount of reach of PUSH message of A1., packet
It includes:
The first database for being stored with the arrival record information for being pushed message that target terminal reports is inquired, is obtained
Take each arrival record information for being pushed message reported at the appointed time section, wherein every arrival records information and includes
On call time, message unique identity and reach type；
Acquired arrival record information is written line by line in a file；
Duplicate removal and number of repetition statistical disposition are carried out to the arrival record information in the file, the arrival after obtaining duplicate removal
Record information and its corresponding number of repetition；
It, will be corresponding with each message unique identity according to the message unique identity in the arrival record information after the duplicate removal
Arrival record information in arrival type and the arrival record information number of repetition as with the message unique identity pair
That answers is pushed the amount of reach of the arrival type of message, is stored in the second database.
A2. method according to a1, wherein believe the arrival record for being pushed message that target terminal reports is stored with
The first database of breath is inquired, and each arrival record information for being pushed message reported at the appointed time section is obtained,
Include:
Every the specified period to the first data for being stored with the arrival record information for being pushed message that target terminal reports
Library is inquired, and each arrival record information for being pushed message reported in upper a cycle is obtained.
A3. method according to a1 or a2, wherein duplicate removal and repetition are carried out to the arrival record information in the file
Number statistics, comprising:
Duplicate removal is carried out to the arrival record information in the file using sort the and uniq-c order of Linux and is repeated secondary
Number statistics.
A4. the method according to any one of A1-A3, wherein the arrival type is including having received, having had shown that or
It clicks.
A5. the method according to any one of A1-A4, wherein what the target terminal reported is pushed arriving for message
It is extracting to being pushed getting ready in log for message of being generated from the software tool pack SDK on the target terminal up to record information
's.
A6. the method according to any one of A1-A5, wherein the message unique identity is message id.
According to another aspect of an embodiment of the present invention, a kind of statistic device of the amount of reach of PUSH message of B7. is additionally provided,
Include:
Enquiry module, suitable for the first data for being stored with the arrival record information for being pushed message that target terminal reports
Library is inquired, and obtains each arrival record information for being pushed message reported at the appointed time section, wherein every arrival
Record information includes reporting time, message unique identity and arrival type；
Writing module, suitable for acquired arrival record information is written line by line in a file；
Duplicate removal statistical module, suitable for carrying out duplicate removal and number of repetition Statistics Division to the arrival record information in the file
Reason, arrival record information and its corresponding number of repetition after obtaining duplicate removal；And
Preserving module, suitable for that will disappear with each according to the message unique identity in the arrival record information after the duplicate removal
Cease unique identification it is corresponding reach record information in arrival type and the arrival record information number of repetition as with this
The amount of reach of the corresponding arrival type for being pushed message of message unique identity is stored in the second database.
B8. the device according to B7, wherein the enquiry module is further adapted for:
Every the specified period to the first data for being stored with the arrival record information for being pushed message that target terminal reports
Library is inquired, and each arrival record information for being pushed message reported in upper a cycle is obtained.
B9. the device according to B7 or B8, wherein the duplicate removal statistical module is further adapted for:
Duplicate removal is carried out to the arrival record information in the file using sort the and uniq-c order of Linux and is repeated secondary
Number statistics.
B10. the device according to any one of B7-B9, wherein the arrival type include received, have shown that or
It has clicked.
B11. the device according to any one of B7-B10, wherein what the target terminal reported is pushed message
Reaching record information is mentioning to being pushed getting ready in log for message of generating from the software tool pack SDK on the target terminal
It takes.
B12. the device according to any one of B7-B11, wherein the message unique identity is message id.
Another aspect according to an embodiment of the present invention additionally provides a kind of computer storage medium of C13., the computer
Storage medium is stored with computer program code, when the computer program code is run on the computing device, causes described
Calculate the statistical method that equipment executes the amount of reach of the PUSH message according to any one of A1-A6.
It is according to an embodiment of the present invention in another aspect, additionally providing a kind of calculating equipment of D14., comprising:
Processor；And
It is stored with the memory of computer program code；
When the computer program code is run by the processor, the calculating equipment is caused to execute according to A1-A6
Any one of described in PUSH message amount of reach statistical method.
Claims (10)
1. a kind of statistical method of the amount of reach of PUSH message, comprising:
The first database for being stored with the arrival record information for being pushed message that target terminal reports is inquired, is obtained
The each arrival record information for being pushed message reported in designated time period, wherein every arrival record information includes reporting
Time, message unique identity and arrival type；
Acquired arrival record information is written line by line in a file；
Duplicate removal and number of repetition statistical disposition are carried out to the arrival record information in the file, the arrival record after obtaining duplicate removal
Information and its corresponding number of repetition；
According to the message unique identity in the arrival record information after the duplicate removal, corresponding with each message unique identity will arrive
Up to the number of repetition of the arrival type recorded in information and arrival record information as corresponding with the message unique identity
It is pushed the amount of reach of the arrival type of message, is stored in the second database.
2. according to the method described in claim 1, wherein, being recorded to the arrival for being pushed message that target terminal reports is stored with
The first database of information is inquired, and each arrival record letter for being pushed message reported at the appointed time section is obtained
Breath, comprising:
Every the specified period to be stored with the first database of the arrival record information for being pushed message that target terminal reports into
Row inquiry obtains each arrival record information for being pushed message reported in upper a cycle.
3. method according to claim 1 or 2, wherein to the arrival record information progress duplicate removal in the file and again
Again number statistics, comprising:
Duplicate removal is carried out to the arrival record information in the file using sort the and uniq-c order of Linux and number of repetition is united
Meter.
4. method according to any one of claim 1-3, wherein the arrival type include received, have shown that or
It has clicked.
5. method according to any of claims 1-4, wherein what the target terminal reported is pushed arriving for message
It is extracting to being pushed getting ready in log for message of being generated from the software tool pack SDK on the target terminal up to record information
's.
6. method according to any one of claims 1-5, wherein the message unique identity is message id.
7. a kind of statistic device of the amount of reach of PUSH message, comprising:
Enquiry module, suitable for be stored with the first database of the arrival record information for being pushed message that target terminal reports into
Row inquiry obtains each arrival record information for being pushed message reported at the appointed time section, wherein every arrival record
Information includes reporting time, message unique identity and arrival type；
Writing module, suitable for acquired arrival record information is written line by line in a file；
Duplicate removal statistical module is obtained suitable for carrying out duplicate removal and number of repetition statistical disposition to the arrival record information in the file
Arrival record information and its corresponding number of repetition after to duplicate removal；And
Preserving module will be with each message only suitable for recording the message unique identity in information according to the arrival after the duplicate removal
One mark it is corresponding reach record information in arrival type and the arrival record information number of repetition as with the message
The amount of reach of the corresponding arrival type for being pushed message of unique identification is stored in the second database.
8. device according to claim 7, wherein the enquiry module is further adapted for:
Every the specified period to be stored with the first database of the arrival record information for being pushed message that target terminal reports into
Row inquiry obtains each arrival record information for being pushed message reported in upper a cycle.
9. a kind of computer storage medium, the computer storage medium is stored with computer program code, when the computer
When program code is run on the computing device, the calculating equipment is caused to execute according to claim 1 to 6
The statistical method of the amount of reach of PUSH message.
10. a kind of calculating equipment, comprising:
Processor；And
It is stored with the memory of computer program code；
When the computer program code is run by the processor, cause the calculating equipment execute according to claim 1-
The statistical method of the amount of reach of PUSH message described in any one of 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810982909.XA CN109510859A (en) | 2018-08-27 | 2018-08-27 | A kind of statistical method and device of the amount of reach of PUSH message |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810982909.XA CN109510859A (en) | 2018-08-27 | 2018-08-27 | A kind of statistical method and device of the amount of reach of PUSH message |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109510859A true CN109510859A (en) | 2019-03-22 |
Family
ID=65745638
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810982909.XA Pending CN109510859A (en) | 2018-08-27 | 2018-08-27 | A kind of statistical method and device of the amount of reach of PUSH message |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109510859A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110971690A (en) * | 2019-11-29 | 2020-04-07 | 支付宝实验室(新加坡)有限公司 | Push message processing method, device and equipment of IOS client |
| CN114253745A (en) * | 2021-12-16 | 2022-03-29 | 北京金堤科技有限公司 | Message deduplication processing method and device, storage medium and electronic equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150222583A1 (en) * | 2013-12-09 | 2015-08-06 | Tencent Technology (Shenzhen) Company Limited | Systems and Methods for Message Pushing |
| CN105681868A (en) * | 2015-04-28 | 2016-06-15 | 深圳Tcl数字技术有限公司 | Barrage content display method and terminal equipment |
| CN106033419A (en) * | 2015-03-10 | 2016-10-19 | 深圳市腾讯计算机系统有限公司 | An information real-time push method, device and system |
-
2018
- 2018-08-27 CN CN201810982909.XA patent/CN109510859A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150222583A1 (en) * | 2013-12-09 | 2015-08-06 | Tencent Technology (Shenzhen) Company Limited | Systems and Methods for Message Pushing |
| CN106033419A (en) * | 2015-03-10 | 2016-10-19 | 深圳市腾讯计算机系统有限公司 | An information real-time push method, device and system |
| CN105681868A (en) * | 2015-04-28 | 2016-06-15 | 深圳Tcl数字技术有限公司 | Barrage content display method and terminal equipment |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110971690A (en) * | 2019-11-29 | 2020-04-07 | 支付宝实验室(新加坡)有限公司 | Push message processing method, device and equipment of IOS client |
| CN110971690B (en) * | 2019-11-29 | 2022-10-04 | 支付宝实验室(新加坡)有限公司 | Push message processing method, device and equipment of IOS client |
| CN114253745A (en) * | 2021-12-16 | 2022-03-29 | 北京金堤科技有限公司 | Message deduplication processing method and device, storage medium and electronic equipment |
| CN114253745B (en) * | 2021-12-16 | 2023-06-20 | 北京金堤科技有限公司 | Message deduplication processing method and device, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108416620B (en) | Portrait data intelligent social advertisement putting platform based on big data | |
| US11120344B2 (en) | Suggesting follow-up queries based on a follow-up recommendation machine learning model | |
| US11461320B2 (en) | Determining a user-specific approach for disambiguation based on an interaction recommendation machine learning model | |
| US11775501B2 (en) | Trace and span sampling and analysis for instrumented software | |
| US20190034429A1 (en) | Translating a natural language request to a domain-specific language request using templates | |
| US10110687B2 (en) | Session based web usage reporter | |
| CN105608188A (en) | Data processing method and data processing device | |
| Bordin et al. | Dspbench: A suite of benchmark applications for distributed data stream processing systems | |
| US20190034498A1 (en) | Determining a presentation format for search results based on a presentation recommendation machine learning model | |
| US11170016B2 (en) | Navigating hierarchical components based on an expansion recommendation machine learning model | |
| CN111475509A (en) | Big data-based user portrait and multidimensional analysis system | |
| CN103838867A (en) | Log processing method and device | |
| CN104394118A (en) | User identity identification method and system | |
| CN109299164A (en) | A kind of data query method, computer readable storage medium and terminal device | |
| CN110675194A (en) | Funnel analysis method, device, equipment and readable medium | |
| US10009732B1 (en) | Mobile media communications system | |
| CN108073625A (en) | For the system and method for metadata information management | |
| CN111552885B (en) | System and method for realizing automatic real-time message pushing operation | |
| CN109033281B (en) | Intelligent pushing system of knowledge resource library | |
| US20190034500A1 (en) | Creating dashboards for viewing data in a data storage system based on natural language requests | |
| US9420422B1 (en) | Mobile media communications system | |
| CN111881221A (en) | Method, device and equipment for customer portrait in logistics service | |
| US20140337274A1 (en) | System and method for analyzing big data in a network environment | |
| CN108664492B (en) | Method and device for pushing content to user, electronic equipment and storage medium | |
| CN109510859A (en) | A kind of statistical method and device of the amount of reach of PUSH message |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190322 |
|
| RJ01 | Rejection of invention patent application after publication |