CN101355686A - Method and system for statistic of audience rating - Google Patents

Method and system for statistic of audience rating Download PDF

Info

Publication number
CN101355686A
CN101355686A CNA2008102227508A CN200810222750A CN101355686A CN 101355686 A CN101355686 A CN 101355686A CN A2008102227508 A CNA2008102227508 A CN A2008102227508A CN 200810222750 A CN200810222750 A CN 200810222750A CN 101355686 A CN101355686 A CN 101355686A
Authority
CN
China
Prior art keywords
viewing
analysis
mrow
top box
time
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
Application number
CNA2008102227508A
Other languages
Chinese (zh)
Other versions
CN101355686B (en
Inventor
柴剑平
韩光
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
BEIJING ZHONGCHUAN RUIZHI MARKET RESEARCH CO LTD
Original Assignee
ZHONGHUI SHIJI MEDIA DEVELOPMENT Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by ZHONGHUI SHIJI MEDIA DEVELOPMENT Co Ltd filed Critical ZHONGHUI SHIJI MEDIA DEVELOPMENT Co Ltd
Priority to CN2008102227508A priority Critical patent/CN101355686B/en
Publication of CN101355686A publication Critical patent/CN101355686A/en
Application granted granted Critical
Publication of CN101355686B publication Critical patent/CN101355686B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Two-Way Televisions, Distribution Of Moving Picture Or The Like (AREA)
  • Testing, Inspecting, Measuring Of Stereoscopic Televisions And Televisions (AREA)

Abstract

The invention provides a method for accounting audience rating and a system thereof. The method comprises: according to the channel ID, the analysis time period starting time(A), the analysis time period closing time(B), the continuous watching, the watching condition and the reaching condition in preset analysis conditions, each basic data in a watching information list is orderly searched so as to acquire all basic data meeting the conditions; according to the set-top box ID of the basic data and the user information analysis conditions in the preset analysis conditions, the user information data base is searched, so as to acquire the user information meeting the user information analysis conditions; according to the analysis index in the preset analysis conditions and the accounting formula corresponding to the analysis index, the user information is accounted, and the analysis index result is acquired. The invention can timely and accurately provide watching analysis, and the accuracy rate of the data is high, and the analytical cycle is short.

Description

Audience rating statistical method and system
Technical Field
The invention relates to audience rating condition investigation in the field of digital televisions, in particular to an audience rating statistical method and system of a digital television.
Background
With the rapid development of digital television technology in China, the viewing habits of people are changing silently, and the audience rating statistics for viewing situations is more and more important, however, the original audience rating statistics technology is directed to analog televisions, and therefore, the original audience rating statistics technology cannot be applied to the audience rating statistics of digital televisions.
To solve the above problem, many manufacturers and individuals are actively developing audience rating statistics system and method for digital tv, more prominently, the system and method for automatically collecting and counting audience rating data of digital tv system proposed in patent application No. 200610034523.3 is provided, which automatically collects audience rating data from the set-top box of the end user and transmits the collected audience rating data to the system server through the two-way priority tv network in real time, so that the system and method can count the audience rating data of digital tv programs, however, the prior art solution still has at least the following three disadvantages:
1. because the bidirectional characteristic of the IP network is utilized to transmit the audience rating data, a certain time delay exists during transmission, the accurate real-time transmission of the audience rating data cannot be ensured, and the audience rating is not accurately counted;
2. the audience rating data is transmitted to the system server in real time for audience rating statistics, so that the workload of the system server is overlarge, and inconvenience is brought to audience rating statistics;
3. the statistical method adopted by the system server has large workload, which causes great waste of system resources.
In order to retrieve data meeting the statistical requirement from the viewing information table returned by the set-top box in real time and calculate the viewing duration according to the data, the conventional statistical method often needs to repeatedly retrieve the viewing information table, which causes great waste of system resources.
Referring to fig. 1A to fig. 1D, since the basic data returned by the set-top box includes the set-top box ID, the start time a, the end time B, and the channel ID of each viewing record, there are four different time distribution situations for the basic data of the analysis time periods a to B that meet the statistical requirements, that is: 1. viewing starting time a and viewing ending time B are both outside the analysis time interval A-B required by statistics, namely, the user viewing time includes the analysis time interval, as shown in FIG. 1A; 2. viewing starting time a and viewing ending time B are both within analysis time periods A-B required by statistics, namely, user viewing time is contained in the analysis time periods, as shown in FIG. 1B; 3. the viewing start time a is within the analysis period, and the viewing end time b is outside the analysis period, as shown in fig. 1C; 4. the viewing start time a is outside the analysis period and the viewing end time b is within the analysis period, as shown in fig. 1D. At this time, in order to find a user who meets the analysis time period, conventionally, four judgment conditions are used to sequentially search and scan the basic table four times, and in order to calculate the viewing time period, different calculation formulas are used for different judgment conditions, that is, condition 1: a is more than A and B is more than B, and the watching time duration t is equal to B-A; condition 2: a is more than a and B is more than B, and the watching time duration t is B-a; condition 3: a is more than A and a is more than B and B is more than B, and the watching time duration t is equal to B-a; condition 4: a & A & B & B & B & A, and the watching time t is B-A. Therefore, the traditional statistical method is not only inefficient, but also wastes system resources.
Disclosure of Invention
In order to solve the problems pointed out in the prior art, the invention provides a method and a system for counting the audience rating of a digital television.
The invention discloses a method for counting audience rating, which comprises the following steps: according to a channel ID, an analysis time interval starting time A, an analysis time interval ending time B, a minimum viewing duration T and whether continuous viewing is carried out or not, determining that viewing conditions A & B & B & gt a and arrival conditions T are not less than T, and sequentially searching each piece of basic data in a viewing information table according to the viewing conditions and the arrival conditions to obtain all pieces of basic data meeting the conditions; searching a user information base according to the set-top box ID of the basic data and user information analysis conditions in preset analysis conditions to obtain user information meeting the user information analysis conditions; calculating the user information according to an analysis index in a preset analysis condition and a calculation formula corresponding to the analysis index to obtain an analysis index result; wherein each piece of basic data includes: the method comprises the following steps that (1) a set top box ID, a viewing time interval starting time a, a viewing time interval ending time b and a channel ID are set; and t is the effective viewing duration in the analysis time period or the sum of the effective viewing durations in the analysis time period.
The invention also discloses an audience rating statistical system, which comprises a statistical server, wherein the statistical server comprises: the retrieval unit is used for determining viewing conditions A & B & B & gt a and arrival conditions T & gtT according to the channel ID, the analysis time interval starting time A, the analysis time interval ending time B, the minimum viewing duration or the minimum viewing duration percentage T of preset analysis conditions and whether continuous viewing is performed, and sequentially retrieving each piece of basic data in the viewing information table according to the viewing conditions and the arrival conditions to obtain all pieces of basic data meeting the conditions; the searching unit is used for searching a user information base according to the set top box ID of the basic data and the user information analysis condition in the preset analysis condition to obtain the user information meeting the condition; the index calculation unit is used for calculating to obtain an analysis index result according to the user information and a calculation formula corresponding to the analysis index; each piece of basic data comprises a set top box ID, a viewing period starting time a, a viewing period ending time b and a channel ID; when T is the minimum watching duration, T is the effective watching duration in the analysis time period or the sum of the effective watching durations in the analysis time period; and when the T is the minimum viewing duration percentage, the T is the effective viewing duration in the analysis time period or the percentage of the sum of the effective viewing durations in the analysis time period and the duration of the analysis time period.
The invention has the beneficial effects that: the system and the method can provide accurate and timely audience rating condition analysis, have higher data accuracy and short analysis period, and can generate various graphic results as required for comparison.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the principles of the invention. In the drawings:
FIGS. 1A-1D are schematic diagrams illustrating the relationship between the start-stop period of user viewing and the analysis start-stop period of statistical requirements;
FIG. 2 is a flow chart of a statistical method of the present invention;
FIG. 3 is a flow chart of a method for basic data generation and return;
FIG. 4 is a flow chart of a method of retrieving an underlying data table;
FIG. 5 is a block diagram of a statistical system according to an embodiment of the present invention;
FIG. 6 is a diagram illustrating a system implementation of a statistics system according to an embodiment of the present invention;
FIG. 7 is a block diagram of a set-top box according to an embodiment of the present invention;
fig. 8 is a flowchart of a method for a set-top box to return viewing behavior records according to an embodiment of the present invention;
FIG. 9 is a block diagram of the components of a data center server according to an embodiment of the present invention;
fig. 10 is a flowchart of instruction interaction between a set-top box and a data center server according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are described in further detail below with reference to the embodiments and the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention.
The first embodiment is as follows:
referring to fig. 2, the audience rating statistical method of the embodiment of the present invention mainly includes the following steps:
201: according to a channel ID, an analysis time interval starting time A, an analysis time interval ending time B, a minimum viewing duration or a minimum viewing duration percentage T and whether continuous viewing is performed or not of preset analysis conditions, determining that viewing conditions A & B & B & gt a and arrival conditions T are more than or equal to T, and sequentially searching each piece of basic data in a viewing information table according to the viewing conditions and the arrival conditions to obtain all basic data meeting the conditions;
202: searching a user information base according to the set top box ID of the retrieved basic data and the user information analysis condition of the preset analysis condition to obtain the user information meeting the condition;
203: and analyzing and calculating the user information meeting the conditions according to analysis indexes in preset analysis conditions and a calculation formula corresponding to the analysis indexes to obtain an analysis index result.
In step 202, the step of searching the user information base according to the preset user information analysis condition of the analysis condition to obtain the user information meeting the condition may be performed before step 201, and the sequence is not limited in the present invention.
According to this embodiment, t is the sum of the effective viewing duration in the analysis period under the continuous viewing condition or the effective viewing duration in the analysis period under the discontinuous viewing condition. The continuous viewing condition means that the user continuously views the program within the specified analysis time period and reaches the minimum viewing time period (the time period for the user to view the program cannot be accumulated as the minimum viewing time period); the discontinuous viewing condition means that a user watches programs for more than a certain time but less than the specified viewing duration in the specified analysis time period, but in the specified analysis time period, the audience watches the programs for multiple times, and the sum of the durations of the multiple watching programs meets the viewing duration specified by the user.
According to other embodiments, T may be a percentage of the minimum viewing duration, and when T is the percentage of the minimum viewing duration, T is an effective viewing duration in the analysis period or a percentage of the sum of the effective viewing durations in the analysis period and the duration of the analysis period.
When T is the minimum watching duration in the preset analysis conditions and T is the effective watching duration of the user under the continuous watching conditions, then t = ( | A - b | + | a - B | - | a - A | - | b - B | ) 2 , Or t is the sum of the effective watching time length of the user under the condition of discontinuous watching <math> <mrow> <mi>t</mi> <mo>=</mo> <mfrac> <mrow> <munderover> <mi>&Sigma;</mi> <mrow> <mi>i</mi> <mo>=</mo> <mn>1</mn> </mrow> <mi>n</mi> </munderover> <mrow> <mo>(</mo> <mo>|</mo> <mi>A</mi> <mo>-</mo> <msub> <mi>b</mi> <mi>i</mi> </msub> <mo>|</mo> <mo>+</mo> <mo>|</mo> <msub> <mi>a</mi> <mi>i</mi> </msub> <mo>-</mo> <mi>B</mi> <mo>|</mo> <mo>-</mo> <mo>|</mo> <msub> <mi>a</mi> <mi>i</mi> </msub> <mo>-</mo> <mi>A</mi> <mo>|</mo> <mo>-</mo> <mo>|</mo> <msub> <mi>b</mi> <mi>i</mi> </msub> <mo>-</mo> <mi>B</mi> <mo>|</mo> <mo>)</mo> </mrow> </mrow> <mrow> <mn>2</mn> <mo>&times;</mo> <mi>n</mi> </mrow> </mfrac> <mo>,</mo> </mrow> </math> Wherein n is the number of times a certain user watches a certain channel program in the analysis time period.
When T is the minimum viewing duration percentage of the preset analysis condition, T is the effective viewing duration of the user or the percentage of the sum of the effective viewing durations of the user and the duration of the analysis time period, and:
when the t is the percentage of the effective viewing time length to the minimum viewing time length in the analysis time period:
<math> <mrow> <mi>t</mi> <mo>=</mo> <mfrac> <mrow> <mo>(</mo> <mo>|</mo> <mi>A</mi> <mo>-</mo> <mi>b</mi> <mo>|</mo> <mo>+</mo> <mo>|</mo> <mi>a</mi> <mo>-</mo> <mi>B</mi> <mo>|</mo> <mo>-</mo> <mo>|</mo> <mi>a</mi> <mo>-</mo> <mi>A</mi> <mo>|</mo> <mo>-</mo> <mo>|</mo> <mi>b</mi> <mo>-</mo> <mi>B</mi> <mo>|</mo> <mo>)</mo> </mrow> <mrow> <mn>2</mn> <mo>&times;</mo> <mrow> <mo>(</mo> <mi>B</mi> <mo>-</mo> <mi>A</mi> <mo>)</mo> </mrow> </mrow> </mfrac> <mo>&times;</mo> <mn>100</mn> <mo>%</mo> <mo>;</mo> </mrow> </math>
when the t is the percentage of the sum of the effective viewing duration and the minimum viewing duration in the analysis time period:
<math> <mrow> <mi>t</mi> <mo>=</mo> <mfrac> <mrow> <munderover> <mi>&Sigma;</mi> <mrow> <mi>i</mi> <mo>=</mo> <mn>1</mn> </mrow> <mi>n</mi> </munderover> <mrow> <mo>(</mo> <mo>|</mo> <mi>A</mi> <mo>-</mo> <msub> <mi>b</mi> <mi>i</mi> </msub> <mo>|</mo> <mo>+</mo> <mo>|</mo> <msub> <mi>a</mi> <mi>i</mi> </msub> <mo>-</mo> <mi>B</mi> <mo>|</mo> <mo>-</mo> <mo>|</mo> <msub> <mi>a</mi> <mi>i</mi> </msub> <mo>-</mo> <mi>A</mi> <mo>|</mo> <mo>-</mo> <mo>|</mo> <msub> <mi>b</mi> <mi>i</mi> </msub> <mo>-</mo> <mi>B</mi> <mo>|</mo> <mo>)</mo> </mrow> </mrow> <mrow> <mn>2</mn> <mo>&times;</mo> <mi>n</mi> <mo>&times;</mo> <mrow> <mo>(</mo> <mi>B</mi> <mo>-</mo> <mi>A</mi> <mo>)</mo> </mrow> </mrow> </mfrac> <mo>&times;</mo> <mn>100</mn> <mo>%</mo> <mo>,</mo> </mrow> </math> wherein n is the number of times a certain user watches a certain channel program in the analysis time period.
According to this embodiment, the basic data may be obtained in any practicable manner, such as manually obtained from the set-top box, automatically transmitted back from the set-top box through a bidirectional network in real time, or automatically transmitted back from the set-top box according to the transmission condition.
Fig. 3 is a flowchart illustrating a method for automatically returning a viewing behavior record according to a return condition by a set-top box, the method comprising the following steps:
301: collecting viewing behaviors and generating viewing behavior records;
302: judging whether the viewing behavior record meets a return condition, if so, sending the viewing behavior record (step 303), and continuing to the next step; if not, storing the viewing behavior record (step 304), and returning;
305: generating basic data according to the viewing behavior record, wherein the basic data comprises: channel ID, set-top box ID, viewing period starting time a and analysis period ending time b;
306: and storing the basic data to a viewing information table.
Wherein, the return condition is the maximum storage data amount required by the return of the viewing behavior record or the longest return time interval required by the return of the viewing behavior record.
Wherein the step of generating the basic data according to the viewing behavior record comprises:
checking and format conversion are carried out on the viewing behavior record;
and converting the converted viewing behavior records into basic data according to the classification of the channel ID, the set-top box ID, the viewing time interval starting time a and the viewing time interval ending time b.
According to this embodiment, it is also necessary to preset analysis conditions so as to filter the basic data and the user information according to the analysis conditions, extract users meeting the requirements, and calculate viewing data and count the viewing rate.
The analysis conditions comprise a channel ID, an analysis period starting time A, an analysis period ending time B, a minimum viewing duration or a minimum viewing duration percentage T, and whether continuous viewing is performed, and the analysis conditions, the viewing conditions and the arrival conditions are used for filtering basic data.
T may be set according to statistical requirements, and may be set to 1 minute, 3 minutes, or 5 minutes, for example.
Fig. 4 is a flowchart illustrating a method for retrieving basic data in a viewing information table according to preset analysis conditions, viewing conditions and arrival conditions, where in this embodiment, T is a minimum viewing duration, and as shown in fig. 4, the method for retrieving basic data in a viewing information table according to an embodiment of the present invention includes the following steps:
401: searching a first piece of basic data according to preset analysis conditions, wherein the analysis conditions at least comprise a channel ID, analysis time interval starting time A, analysis time interval ending time B, minimum watching duration T and whether continuous watching is carried out;
402: judging whether the channel ID in the basic data is equal to the channel ID in the analysis condition, if so, performing the next step, otherwise, searching the next piece of basic data (step 403);
404: judging whether the viewing time interval starting time a and the viewing time interval ending time B in the basic data meet viewing conditions of A & lt B & B & gt a, if so, performing the next step, otherwise, searching the next basic data (step 403);
405: calculating effective viewing time t according to whether continuous viewing is carried out or not;
406: judging whether the effective viewing duration meets the condition that the arrival time T is more than or equal to T, if so, performing the next step, otherwise, searching the next piece of basic data (step 403);
407: extracting the set-top box ID of the basic data and storing the set-top box ID;
408: and judging whether the last basic data is reached, if so, ending, otherwise, searching the next basic data (step 403).
According to the present embodiment, the order of the determination steps 402, 404, and 406 is not limited, and any method may be used as long as the basic data satisfying the analysis condition, the arrival condition, and the viewing condition is retrieved from the viewing information table according to the preset analysis condition.
According to the method for searching the viewing information table, only one viewing condition A < b is used&B > a includes four time distribution situations as shown in FIGS. 1A-1D, so that basic data meeting the viewing condition can be screened out by scanning the viewing information table onceTherefore, the data are further screened and counted conveniently, the counting efficiency is greatly improved, and the system resources are saved. And due to the adoption of formula t = ( | A - b | + | a - B | - | a - A | - | b - B | ) 2 The effective viewing time is calculated, and the statistical efficiency is improved while the system resources are saved.
In the embodiment shown in fig. 4, the minimum viewing duration T is preset, so when determining whether the reaching condition is satisfied, a calculation formula of the effective viewing duration T is selected according to whether continuous viewing is performed, and the effective viewing duration or the sum of the effective viewing durations is calculated according to the selected formula, so as to perform comparison and determination. According to other embodiments, the minimum viewing duration percentage T may be preset, and at this time, when determining whether the reaching condition is satisfied, the calculation formula is selected according to whether to continuously view, and then the percentage of the effective viewing duration or the sum of the effective viewing durations and the duration of the analysis period is calculated according to the selected formula, so as to perform comparison and determination. The specific calculation formula is already described in the foregoing, and is not described herein again.
In addition, the analysis conditions also include user information analysis conditions such as target people, regions and the like, and the analysis conditions are used for further filtering and screening the user information corresponding to the filtered basic data so as to calculate and count various analysis indexes according to the filtered and screened user information. The method comprises the following steps:
after the basic data meeting the conditions are obtained according to the method, the set top box IDs and the user information corresponding to the user information analysis conditions, including personnel information, target groups, regions and the like, are searched from the personnel information table, the region table and the watching information table (which are collectively called as a user information base) in the database according to the set top box IDs and the user information analysis conditions of the basic data, and then the data meeting the conditions are recorded.
According to this embodiment, searching for the eligible basic data according to the preset analysis condition and searching for the eligible user information according to the user information analysis condition in the preset analysis condition may be performed simultaneously or sequentially, and the present invention is not limited thereto.
Therefore, the user information can be further filtered and screened according to the user information analysis conditions such as target crowds, areas and the like in the preset analysis conditions, and the user information meeting the conditions is obtained.
In addition, in order to further improve the statistical efficiency, the embodiment of the present invention may also calculate the attribute weight in advance according to the attribute of the person attribute table in the database, and store the person attribute weight in the weight value table in the database, so as to be used when performing the index calculation.
At this time, a person attribute weight may be added when the analysis index is calculated according to the user information and a calculation formula corresponding to the analysis index, and the method includes:
searching a weight value table according to the user information extracted in the step to obtain a figure attribute weight value;
and calculating the analysis indexes according to the user information, the figure attribute weight and a calculation formula corresponding to the analysis indexes.
The analysis index is one of the preset analysis conditions, and is preset by a statistical staff according to the statistical requirement so as to select a calculation formula corresponding to the analysis index to calculate and count the index.
Here, it should be noted that the weighting is a core element in the process of viewing data processing. In the audience data processing, the purpose of weighting is to correct the deviation between the sample structure and the overall structure to obtain data that accurately reflects the overall audience situation.
For example, assume a city population of 10 million, with 48% male and 52% female; the number of sampled samples is 1000, the gender structure in the sample deviates from the overall gender structure, and the samples are respectively 420 men and 580 women, so that the male weight (the number of men in the sample represented in the overall) is different from the female weight, that is, the male weight is equal to the total number of men/the number of men in the sample is equal to 48000/420 and equal to 114.3; the female weight is 52000/580 89.6 in the total female population/sample. Assuming that 500 people, male 180 and female 320, watch a program in the sample, then: if the total number of people watching the program is equal to sample number of man watching people multiplied by weight value and sample number of woman watching people multiplied by woman weight value is equal to 180 multiplied by 114.3+320 multiplied by 89.6 is equal to 49246, the program rating is equal to 49264/100000 which is 49.3%, but not 500/300 which is 50%.
In the above example, the weighting variable is only one (gender), and in practice, the age, town and country, etc. may be used as the weighting value.
According to the method and the steps, after the user information meeting the preset analysis condition is extracted, various indexes can be calculated according to the analysis indexes and the calculation formulas corresponding to the analysis indexes.
In the field of digital tv, the analysis index is set and calculated according to the customer requirement or according to the operator requirement, the invention is not limited thereto, and only two examples are given to illustrate the application of the statistical method of the invention, and any analysis index calculation implemented according to the statistical method of the invention should be included in the protection scope of the invention.
In example one, the analysis index is arrival rate:
Figure A20081022275000161
wherein, the total number of the audience people who continuously meet the reaching condition can be obtained from the database according to the retrieval result, and the total number of the people who continuously watch the program in the appointed analysis time period is met, and the analysis condition is as follows: target population, region, date, analysis time period, channel selected by the user.
The total number of the audience people who do not continuously meet the arrival conditions can also be obtained from the database according to the search results, the total number of the audience people meets the conditions that the programs are watched in the appointed analysis time period, the sum of the program watching time meets the arrival conditions, and the analysis conditions are as follows: target population, region, date, time period, channel selected by the user.
The population is referred to as the population, i.e., the sample population.
Wherein, the category is calculated according to the index selected by the user, and the corresponding weight value can be taken out from the weight table.
Example two, the analysis index is audience rating:
Figure A20081022275000162
that is to say:
wherein, the total audience watching duration in the specific time interval meets the conditions as follows: target population, region, date, time period, channel selected by the user.
The weight is calculated according to the index selected by the user, and the corresponding weight value is taken out from the weight table.
Wherein, the total duration of the time period refers to the total duration of the specific time period of the general population.
According to the embodiment of the present invention, the statistical method is implemented by the statistical system of the embodiment of the present invention, and during the specific operation, the statistical personnel can operate according to the following steps:
setting analysis conditions and storing;
opening the analysis conditions and starting the analysis;
according to the information input in the analysis condition, the set information of target population, region, date, time period, channel, arrival condition, effective viewing condition, analysis index and the like is taken out from the analysis condition and stored in a temporary variable;
whether discontinuous time data need to be calculated, if so, deleting the arrival conditions in the temporary variables and carrying out the next step, otherwise, directly carrying out the next step;
connecting a database, and searching information meeting the analysis condition of the temporary variable from a region table, a channel information table, a personnel information table, a viewing information table and a weight value table;
storing the searched information in an intermediate variable;
according to the selected analysis index, using a corresponding calculation formula and the searched intermediate variable to start analysis;
and outputting an analysis result.
According to the method provided by the embodiment of the invention, the calculation and statistics of each index can be carried out on the viewing record returned by the set top box, so that the statistical efficiency is improved, the system resource is saved, and the waste and congestion of the system resource are avoided.
Example two:
fig. 5 is a block diagram of a digital television statistical system for implementing the statistical method according to the foregoing embodiment of the present invention, and as shown in fig. 5, the digital television statistical system according to the present invention includes a statistical server, where the statistical server includes:
the basic data importing unit 51 is configured to import basic data into the viewing information table in the database according to the statistical requirement, where the basic data also refers to viewing data of a user, and is generally collected by a set-top box and may be fed back to the digital television statistical system of the present invention through various ways. The statistical requirement may be a requirement of a statistical time period, for example, to count the audience rating of 6 months, the basic data importing unit 51 imports the basic data of the audience rating record of 6 months 1 to 6 months 30 in the data center server. In addition, the basic data may not have the ending time due to various possible reasons, and the basic data without the ending time may be processed according to a predetermined procedure, for example, if a default time is exceeded, the basic data is regarded as invalid processing.
The database 52 is configured to store broadcast data, family information, member information, set-top box information, weight information, advertisement prices, the basic data information, and the like in a table format, where the basic data information is stored in a viewing information table of the database, the weight information is pre-calculated according to the character attribute values and is stored in a weight table of the database, and the broadcast data, the family information, the member information, the set-top box information, the advertisement prices, and the like may be entered through the operation maintenance unit 57.
An analysis condition setting unit 53 for setting an analysis condition according to the statistical requirement. The analysis conditions include a channel ID, an analysis period start time a, an analysis period end time B, a minimum viewing duration or a minimum viewing duration percentage T, whether or not continuous viewing is performed, user information analysis conditions, analysis indexes, and the like.
A retrieving unit 54, configured to retrieve, according to a preset channel ID of an analysis condition, an analysis time period starting time a, an analysis time period ending time B, a minimum viewing duration or a minimum viewing duration percentage T, whether to continuously view, a viewing condition a & B & gta, and an arrival condition T ≧ T, each piece of basic data in the viewing information table in sequence, so as to obtain a set top box ID in all basic data that meet the condition;
the searching unit 55 is configured to search a user information base according to the set top box ID and a user information analysis condition in a preset analysis condition, so as to obtain user information meeting the condition;
the analysis index calculation unit 56 is configured to calculate an analysis index result according to the user information and a calculation formula corresponding to the analysis index;
each piece of basic data comprises a set top box ID, a viewing period starting time a, a viewing period ending time b and a channel ID; when T is the minimum watching duration, T is the sum of the effective watching duration under the continuous watching condition or the effective watching duration under the discontinuous watching condition; and when the T is the minimum viewing duration percentage, the T is the percentage of the sum of the effective viewing durations under the continuous viewing condition or the discontinuous viewing condition and the duration of the analysis time period.
The formula for t is already described above, and is not described herein again.
And the operation maintenance unit 57 is used for performing operations of adding, deleting and modifying data in the database 52.
According to this embodiment, the statistical system further comprises a set-top box and a data center server.
The following describes the composition of the audience rating statistical system of the digital television according to the embodiment of the present invention with reference to fig. 6, as shown in fig. 6, the audience rating statistical system of the digital television according to the present invention mainly includes a set-top box 61, a data center server 62 and a statistical server 63, where:
the statistical server 63 is configured to import the basic data stored in the data center server 62 into the viewing information table in the database as required, filter the basic data according to preset analysis conditions, arrival conditions, effective viewing conditions, and the like, filter the user information according to the preset analysis conditions, obtain the user information meeting the preset analysis conditions, calculate and count various indexes of the screened user information according to the analysis indexes and the calculation formulas corresponding to the analysis indexes, and generate the desired form of audience rating data for output. This part has already been explained in the foregoing and will not be described in detail here.
The set-top box 61 is used for recording and storing the screened effective original viewing data, and automatically initiates a connection request to the data center server 62 through the digital television bidirectional network when a return condition is reached, so as to return the original viewing data to the data center server 62.
According to an embodiment of the present invention, the set-top box 61 includes a viewing behavior collecting unit 71, a storing unit 72, a determining unit 73, and a viewing behavior record returning unit 74, as shown in fig. 7, where:
the viewing behavior collecting unit 71 is configured to collect viewing behavior data of a user, generate a viewing behavior record, and store the viewing behavior record in the storage unit 72, where the viewing behavior record includes: normal viewing record, null record, business mode record, standby record.
The records can be identified by adopting different ONID, TSID and SERVICEID combinations, state change information of the set top box at each moment is contained, and various viewing behaviors of a user are reflected. The change of the state of the set-top box comprises switching in/out of a current broadcast program, starting up/shutting down, entering/exiting data broadcasting, entering/exiting stock information, entering/exiting NVOD, entering/exiting games, entering/exiting e-mails and the like. The statistical server keeps the program list and the service mode number corresponding to the three field combination, if the combination of the three fields in the received data record is not defined in the table, the data is regarded as invalid data, and the calculation of the audience rating index is not carried out.
The normal watching record means that the user watches the same channel program for a certain time length continuously under the condition of watching the television program normally, so as to form a watching behavior once and generate the normal watching record. The time length as a threshold interval parameter may be set by the front end, such as a data center server, and stored in the set-top box.
The empty record means that the dwell time of each channel change in the continuous channel change of the user does not exceed the preset threshold interval, and the time is recorded as the empty record. The ONID of the empty record is 0x0000, the TSID is 0x0000, and the SERVICEID is 0x 0000.
The service mode record refers to a record reflecting viewing behavior generated when a user enters various functional services of the set-top box, wherein the functional services comprise EPG program guide, VOD/NVOD viewing, data broadcasting, games, stocks, e-mails and the like.
The above is only an example, and since the differences between local digital television network operators and set-top box manufacturers are very large, the business model records are not mentioned or need to be negotiated by all parties. Meanwhile, the service mode record can be correspondingly corrected along with the rapid development of the domestic digital television value-added service and the change of the investigation requirement. The scope of the present invention is not limited thereto, and any equivalent changes made in accordance with the spirit of the present invention should be included in the scope of the present invention.
The standby record is generated by the operation of closing the set-top box by remote control of a user, or the last approximate shutdown time is calculated by the information of recording the startup state by the system at intervals.
According to the above embodiment, the present invention subdivides viewing events by type, including, in addition to channel change information for switching in and switching out channels, a power-on/off record, a service mode record, satisfaction information, personnel information, and the like, and different types of events are represented by combinations of different original network IDs, transport stream IDs, and service IDs. The on-off, channel change, service mode and the like reflect the objective working state of the set top box, namely the audience rating condition of a user; and the information of satisfaction, personnel and the like can reflect who looks and how to evaluate. Therefore, the method can receive user feedback besides obtaining objective audience rating indexes, and obtain subjective evaluation of the user to provide extended applications such as personalized services.
The storage unit 72 is configured to store preset parameters and state parameters including the return conditions, and sequentially store each viewing behavior record according to the time sequence generated by the record. The storage unit 72 may be implemented by using a non-volatile memory, and reserve a sufficient storage space, and record a new viewing event, i.e. a viewing behavior record in the memory when the new viewing event is generated.
The preset parameters stored in the storage unit 72 of the set-top box 61 include: threshold interval, feedback condition, interval of updating shutdown time record, IP address and port number of data center server, time delay of reconnection after connection failure, etc., and the preset parameters can be expanded and modified according to requirements. Parameters such as threshold interval, feedback condition, interval for updating the shutdown time record, time delay for reconnection after connection failure and the like can be modified by the data center server or updated by the software of the set-top box; and the IP address and the port number of the data center server are preferably updated through the software upgrade of the set-top box due to the consideration of safety factors.
According to this embodiment, the threshold interval is used to effectively determine the viewing events, for example, a user often browses each channel during watching tv, each channel stays for a short time during browsing, and it should not be determined that the user watches the channels, and such data returned in real time is useless information, which wastes network resources and burdens the server. The set-top box presets the parameters of the threshold interval, and can flexibly define how long a user stays in a channel and record the time as an effective viewing record. By doing this at the set-top box end, useless data can be greatly reduced, storage space can be reduced, and network bandwidth can be saved. The parameters can be updated when the software of the set-top box is upgraded, and can also be updated by the data center server according to the communication protocol in the process of returning.
According to this embodiment, the backhaul conditions include a maximum amount of stored data that meets the backhaul requirement and a maximum backhaul time interval that meets the backhaul requirement. The set-top box according to the embodiment of the invention adopts a mode of firstly storing the viewing behavior record and then returning according to the returning condition because the statistics of the viewing rate does not need to be calculated in real time and the viewing information can be obtained within a certain time period according to the service requirement. The return condition can be flexibly controlled by setting parameters in software, and the return mechanism can be triggered when the recorded data amount is accumulated to a certain degree, or can be triggered when the last return time reaches a certain interval length. The parameters can be updated when the software of the set-top box is upgraded, and can also be updated by the data center server according to the communication protocol in the process of returning. In extreme cases, it is set that the same real-time feedback effect as the patent application in the background art can be achieved by returning every second or every record.
Compared with real-time backhaul, the advantages of the present invention using store-before-backhaul include: (1) the viewing information generated each time is only 16 bytes, the overhead caused by handshake information generated each time of returning, encapsulation of IP packets and the like is much larger than that, and the waste of network resources is caused when the server is continuously in the process of establishing and disconnecting the connection with each set top box under the condition of a large number of clients. Channel switching information generated by a large number of users in a short time under the conditions of starting or ending programs with high audience rating and the like can even cause overload paralysis of a server; under the condition of storing and returning, the time distribution of different users reaching the returning condition is more even, and the bandwidth utilization rate is higher. (2) Although the set-top box provides an IP network interface, the set-top box is still limited by the access mode of the IP network of the user home, real-time return needs to be online at any time, and the expense of the IP access network can be generated according to the local network deployment condition; the non-real-time mode can finish the return transmission with smaller bandwidth cost when the user surfs the internet, and the user does not need to be online at any time. (3) The scheme of the invention distinguishes effective data and invalid data during storage, and only returns the effective data, thus the defect can be improved.
The state parameters of the set-top box include: the number of the set-top box, the number of the intelligent card, the IP address of the set-top box, the amount of data which is not transmitted and the like.
The storage unit 72 of the set-top box 61 also stores the records in sequence according to the time sequence generated by the records, and if the storage area is full, the earliest data is cyclically covered. The system records a current latest written position pointer and a position pointer of last transmission end, and data between the current latest written position pointer and the position pointer of last transmission end is to-be-transmitted data which is transmitted back at this time. If the waiting data occupies the whole storage space, namely the current writing pointer is coincident with the last transmission end pointer, the newly written data still covers the oldest data, at this time, the oldest data record is discarded, and only the updated record is reserved. The last transmission end pointer moves backwards along with the current write pointer, meanwhile, the storage area full mark is set, and the data of the whole storage area is transmitted back next time.
According to other embodiments of the present invention, the set-top box 61 may further comprise a clock synchronization unit (not shown) for synchronizing with a clock in the digital television system to record the viewing event time at the time of the digital television system. According to DVB standard, the digital television transmission stream contains a time table TDT, the set-top box is synchronous with a system clock when working normally, 5 bytes of time information is extracted from the time table according to DVB standard, the time is an accurate time point for users to watch events, and the situation that network delay, congestion, packet loss, server busy and the like possibly caused by adopting the time of receiving the watching data by a statistical server as the watching time are avoided to generate error information and even lose information.
After the set-top box is started, synchronizing the set-top box with a system clock and recording the set-top box as a starting event; recording the channel switching-in time when a user performs channel switching and other operations, judging that the user does not switch out at a threshold interval, judging the channel switching event, recording the switching-in time, an original network ID, a transport stream ID and a service ID, and otherwise, not recording or recording as a null record; the user generates service mode record when using value added services such as NVOD, data broadcast, stock, etc., and different service applications are represented by the combination of the three IDs. When watching, the user can generate evaluation records of personnel and satisfaction degree by operating a set top box menu. The set-top box updates the power-off time value to the current time every a short period of time, so that the set-top box is powered on next time under the condition of sudden power-off such as power failure and the like, and the time is extracted and stored as the last power-off record. When a certain preset condition is reached, the set-top box transmits back all the stored viewing records through the network. And emptying the storage area after the transmission is finished. In the transmission process, the set-top box initiates connection to the server, reports the ID, the storage state and various parameters of the set-top box, and the server responds to the request of the set-top box to transmit data back or update the parameters. And disconnecting after the completion.
The determining unit 73 is configured to determine whether the viewing behavior record reaches the return condition, which has been described above and will not be described herein.
If the result of the judgment is yes, a request for establishing connection is initiated to the data center server 62 through the viewing behavior record returning unit, and the viewing behavior record is automatically returned to the data center server 62.
If the result of the judgment is negative, the set-top box 61 continues to collect the viewing behavior data, generates a viewing behavior record and stores the viewing behavior record in the storage unit 72.
The back transmission unit 74 is configured to send the viewing behavior record to the data center server 62 according to the judgment result of the judgment unit 73. The interaction flow between the set-top box 61 and the data center server 62 will be described in detail below.
Referring to fig. 8 again, the step of the set-top box automatically returning the viewing behavior record according to the returning condition includes:
801: collecting viewing behavior data, generating viewing behavior records and storing the viewing behavior records;
802: judging whether the longest time interval required by the return transmission is reached, if so, performing a step 803, otherwise, performing a step 804;
803: returning the viewing behavior record;
804: and judging whether the maximum storage data amount required by the backhaul is reached, if so, performing step 803, otherwise, performing step 801.
The data center server 62 is configured to receive the original viewing data uploaded by the set-top box 61, that is, the viewing behavior record, perform verification and format conversion, generate basic data, and prepare for storage.
According to the present embodiment, the data center server 62 includes a viewing behavior record receiving unit 91, a data format conversion and verification unit 92, a data center 93, and a set-top box parameter modification unit 94, as shown in fig. 9, where:
the viewing behavior record receiving unit 91 is configured to receive the viewing behavior record returned by the return unit 74 of the set-top box 61.
The data format conversion and verification unit 92 is configured to perform verification and format conversion on the viewing behavior record, generate basic data, and store the basic data in a data center, and specifically includes the following steps:
(1) checking message information including viewing behavior records returned by the set top box 61, and removing abnormal information (including messy codes, errors and the like);
(2) converting the message information into basic data according to keywords such as regions, channels and the like according to the requirements preset by the user;
(3) and storing the converted basic data in a data center in a file form for storage and waiting for warehousing.
The data center 93 is configured to store the basic data, which includes a channel ID, a set-top box ID, a viewing period start time a, and a viewing period end time b.
The set-top box parameter modifying unit 94 is configured to modify parameters of the set-top box, where the modified parameters include a threshold interval, a backhaul condition, an interval for updating a shutdown time record, a time delay for reconnection after a connection failure, and the like.
Referring again to fig. 10, the interaction process between the data center server 62 and the set-top box 61 includes the following steps:
the set-top box 61 automatically initiates a connection to the data center server 62 when the amount of stored data reaches the maximum amount of stored data or the preset maximum return time interval is reached from the last return time interval. When the set-top box 61 is connected to the data center server 62, a connection request instruction is sent (step 1001), where the connection request instruction includes information such as a self-id, an IP address, an operating parameter, and an amount of data that is not transmitted, where the self-id is a number that can uniquely identify the user, and may be an intelligent card number, an MAC address, or a factory number.
The data centre server 62 confirms the identity of the set-top box 61 and sends a corresponding instruction to respond according to the action to be performed.
The set-top box 61 receives the instruction sent by the data center server 62 (step 1002), and determines the type of the instruction (step 1003).
In most cases, the data center server 62 sends a data fetching instruction (2), the set-top box 61 starts sending the data fetching instruction (step 1004) to return after receiving the data fetching instruction, the data center server 62 sends a data receiving confirmation instruction after receiving the data fetching instruction, the set-top box 61 receives the confirmation instruction (step 1005), whether the data sending is successful is judged according to the content of the confirmation instruction (step 1006), if so, the set-top box 61 moves the data fetching pointer backwards by the number of bytes transmitted (step 1007), otherwise, the data is continuously sent to the data center server 62.
When the parameters of the set-top box 61 need to be modified, the data center server 62 sends a parameter setting instruction (4) after the connection is established, and the set-top box 61 receives the instruction, modifies the parameters (step 1008), and sends a setting confirmation instruction to the data center server 62 (step 1009). If the setting is successful, the instruction content is sent to be a successful parameter setting confirmation instruction, and the data center server 62 can send the data instruction after receiving the successful confirmation; if the setting is failed, a parameter setting confirmation instruction with the instruction content failed is returned, and the data center server 62 retransmits the parameter setting instruction after receiving the failure confirmation.
In order to meet the storage requirement of a large amount of data, the data center server in the embodiment of the invention can adopt a server cluster load balancing technology.
The invention defines a whole set of protocols and specifications for conducting audience rating surveys and some extended applications using digital television set-top boxes. At present, a plurality of set top boxes with IP network access functions are available on the market. The scheme of the invention can be completely realized by modifying the set-top box embedded software on the existing hardware platform without changing hardware, the storage capacity of the common set-top box product is reserved with certain margin, and if the storage space built in the set-top box is insufficient, the storage chip can be expanded.
The work flow is briefly described as follows: after the set-top box is started, synchronizing the set-top box with a system clock and recording the set-top box as a starting event; recording the channel switching-in time when a user performs channel switching and other operations, judging that the user does not switch out at a threshold interval, judging the channel switching event, recording the switching-in time, an original network ID, a transport stream ID and a service ID, and otherwise, not recording or recording as a null record; the user generates service mode record when using value added services such as NVOD, data broadcast, stock, etc., and different service applications are represented by the combination of the three IDs. When watching, the user can generate evaluation records of personnel and satisfaction degree by operating a set top box menu. The set-top box updates the power-off time value to the current time every a short period of time, so that the set-top box is powered on next time under the condition of sudden power-off such as power failure and the like, and the time is extracted and stored as the last power-off record. When a certain preset condition is reached, the set-top box transmits back all the stored viewing records through the network. And emptying the storage area after the transmission is finished.
In the transmission process, the set-top box initiates connection to the data center server, reports the ID, the storage state and various parameters of the set-top box, and the data center server responds to the requirement that the set-top box returns data or updates the parameters of the set-top box. And disconnecting after the completion. And the data center server performs checksum format conversion on the received data and prepares for storage. The statistical server imports basic data after verification and format conversion into the data center server according to statistical requirements, and converts the basic data into viewing data for storage according to broadcasting data, family information, member information, set top box information, advertisement price information and the like stored in a database. And the analysis platform of the statistical server performs index analysis on the audience rating data according to analysis conditions including analysis indexes, specific samples, broadcasting time, regions, channels and the like, and outputs an audience rating chart. Thus, the survey and statistics of the audience rating are completed.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.

Claims (17)

1. A method for rating statistics, the method comprising the steps of:
according to a channel ID, an analysis time interval starting time A, an analysis time interval ending time B, a minimum viewing duration T and whether continuous viewing is carried out or not, determining that viewing conditions A & B & B & gt a and arrival conditions T are not less than T, and sequentially searching each piece of basic data in a viewing information table according to the viewing conditions and the arrival conditions to obtain all pieces of basic data meeting the conditions;
searching a user information base according to the set-top box ID of the basic data and user information analysis conditions in preset analysis conditions to obtain user information meeting the user information analysis conditions;
calculating the user information according to an analysis index in a preset analysis condition and a calculation formula corresponding to the analysis index to obtain an analysis index result;
wherein each piece of basic data includes: the method comprises the following steps that (1) a set top box ID, a viewing time interval starting time a, a viewing time interval ending time b and a channel ID are set; and t is the effective viewing duration in the analysis time period or the sum of the effective viewing durations in the analysis time period.
2. The method of claim 1, wherein:
when the t is the effective view length in the analysis time period:
t = ( | A - b | + | a - B | - | a - A | - | b - B | ) 2 ;
when the t is the sum of the effective viewing duration in the analysis time period:
<math> <mrow> <mi>t</mi> <mo>=</mo> <mfrac> <mrow> <munderover> <mi>&Sigma;</mi> <mrow> <mi>i</mi> <mo>=</mo> <mn>1</mn> </mrow> <mi>n</mi> </munderover> <mrow> <mo>(</mo> <mo>|</mo> <mi>A</mi> <mo>-</mo> <msub> <mi>b</mi> <mi>i</mi> </msub> <mo>|</mo> <mo>+</mo> <mo>|</mo> <msub> <mi>a</mi> <mi>i</mi> </msub> <mo>-</mo> <mi>B</mi> <mo>|</mo> <mo>-</mo> <mo>|</mo> <msub> <mi>a</mi> <mi>i</mi> </msub> <mo>-</mo> <mi>A</mi> <mo>|</mo> <mo>-</mo> <mo>|</mo> <msub> <mi>b</mi> <mi>i</mi> </msub> <mo>-</mo> <mi>B</mi> <mo>|</mo> <mo>)</mo> </mrow> </mrow> <mrow> <mn>2</mn> <mo>&times;</mo> <mi>n</mi> </mrow> </mfrac> <mo>,</mo> </mrow> </math> wherein n is the number of times a user watches a channel program in the analysis time period.
3. The method of claim 1, wherein:
and if the T is the minimum viewing duration percentage, the T is the effective viewing duration in the analysis time period or the percentage of the sum of the effective viewing durations in the analysis time period and the duration of the analysis time period.
4. The method of claim 3, wherein:
when the t is the percentage of the effective viewing time length to the minimum viewing time length in the analysis time period:
<math> <mrow> <mi>t</mi> <mo>=</mo> <mfrac> <mrow> <mo>(</mo> <mo>|</mo> <mi>A</mi> <mo>-</mo> <mi>b</mi> <mo>|</mo> <mo>+</mo> <mo>|</mo> <mi>a</mi> <mo>-</mo> <mi>B</mi> <mo>|</mo> <mo>-</mo> <mo>|</mo> <mi>a</mi> <mo>-</mo> <mi>A</mi> <mo>|</mo> <mo>-</mo> <mo>|</mo> <mi>b</mi> <mo>-</mo> <mi>B</mi> <mo>|</mo> <mo>)</mo> </mrow> <mrow> <mn>2</mn> <mo>&times;</mo> <mrow> <mo>(</mo> <mi>B</mi> <mo>-</mo> <mi>A</mi> <mo>)</mo> </mrow> </mrow> </mfrac> <mo>&times;</mo> <mn>100</mn> <mo>%</mo> <mo>;</mo> </mrow> </math>
when the t is the percentage of the sum of the effective viewing duration and the minimum viewing duration in the analysis time period:
<math> <mrow> <mi>t</mi> <mo>=</mo> <mfrac> <mrow> <munderover> <mi>&Sigma;</mi> <mrow> <mi>i</mi> <mo>=</mo> <mn>1</mn> </mrow> <mi>n</mi> </munderover> <mrow> <mo>(</mo> <mo>|</mo> <mi>A</mi> <mo>-</mo> <msub> <mi>b</mi> <mi>i</mi> </msub> <mo>|</mo> <mo>+</mo> <mo>|</mo> <msub> <mi>a</mi> <mi>i</mi> </msub> <mo>-</mo> <mi>B</mi> <mo>|</mo> <mo>-</mo> <mo>|</mo> <msub> <mi>a</mi> <mi>i</mi> </msub> <mo>-</mo> <mi>A</mi> <mo>|</mo> <mo>-</mo> <mo>|</mo> <msub> <mi>b</mi> <mi>i</mi> </msub> <mo>-</mo> <mi>B</mi> <mo>|</mo> <mo>)</mo> </mrow> </mrow> <mrow> <mn>2</mn> <mo>&times;</mo> <mi>n</mi> <mo>&times;</mo> <mrow> <mo>(</mo> <mi>B</mi> <mo>-</mo> <mi>A</mi> <mo>)</mo> </mrow> </mrow> </mfrac> <mo>&times;</mo> <mn>100</mn> <mo>%</mo> <mo>,</mo> </mrow> </math> wherein n is the number of times a user watches a channel program in the analysis time period.
5. A method according to claim 1 or 3, wherein said step of retrieving basic data in a viewing information table comprises:
and judging whether the channel ID in the basic data is equal to the channel ID in the analysis condition, judging whether the viewing period starting time a and the viewing period ending time b in the basic data meet the viewing condition, judging whether t meets the reaching condition, if so, extracting the set-top box ID of the basic data, and storing the set-top box ID.
6. The method according to claim 1 or 3, wherein the step of searching a user information base according to the set-top box ID and a user information analysis condition of a preset analysis condition to obtain user information meeting the condition comprises:
searching a user information base according to the set top box ID and the user information analysis condition, finding user information which accords with the set top box ID condition and the user information analysis condition, and recording the data;
wherein the user information base includes: a personnel information table, a region table and a viewing information table; the user information analysis conditions include: target population and region.
7. The method according to claim 6, wherein the step of calculating the user information according to the analysis index in the preset analysis condition and the calculation formula corresponding to the analysis index to obtain the analysis index result comprises:
searching a weight value table according to the user information to obtain each weight value corresponding to the user information;
and calculating the analysis indexes according to the user information, the weight and a calculation formula corresponding to the analysis indexes.
8. The method of claim 7, wherein:
the analysis index is audience rating, and the calculation formula corresponding to the analysis index is an audience rating calculation formula:
Figure A2008102227500004C1
wherein,
Figure A2008102227500004C2
viewing time (minutes) i is obtained from the user information, weight i is obtained from a value table, and the total time of the analysis period and the total inferred population are preset.
9. The method according to claim 1 or 3, wherein the method further comprises a step of base data backhauling, which comprises:
generating a viewing behavior record;
judging whether the viewing behavior record meets a return condition, if so, sending the viewing behavior record, and continuing the next step; if not, storing the viewing behavior record, and returning;
generating and storing basic data according to the viewing behavior record, wherein the basic data comprises: channel ID, set-top box ID, start time, end time.
10. The method according to claim 9, wherein the backtransmission condition is a maximum amount of stored data required for the backtransmission of the viewing behavior record or a maximum backtransmission time interval required for the backtransmission of the viewing behavior record.
11. The method of claim 9, wherein the step of generating the base data from the viewing behavior record comprises:
checking and format conversion are carried out on the viewing behavior record;
and converting the converted viewing behavior records into basic data according to the classification of the channel ID, the set-top box ID, the start time and the end time.
12. An audience rating statistics system, the audience rating statistics system comprising a statistics server, the statistics server comprising:
the retrieval unit is used for determining viewing conditions A & B & B & gt a and arrival conditions T & gtT according to the channel ID, the analysis time interval starting time A, the analysis time interval ending time B, the minimum viewing duration or the minimum viewing duration percentage T of preset analysis conditions and whether continuous viewing is performed, and sequentially retrieving each piece of basic data in the viewing information table according to the viewing conditions and the arrival conditions to obtain all pieces of basic data meeting the conditions;
the searching unit is used for searching a user information base according to the set top box ID of the basic data and the user information analysis condition in the preset analysis condition to obtain the user information meeting the condition;
the index calculation unit is used for calculating to obtain an analysis index result according to the user information and a calculation formula corresponding to the analysis index;
each piece of basic data comprises a set top box ID, a viewing period starting time a, a viewing period ending time b and a channel ID; when T is the minimum watching duration, T is the effective watching duration in the analysis time period or the sum of the effective watching durations in the analysis time period; and when T is the minimum viewing duration percentage, T is the effective viewing duration in the analysis period or the percentage of the sum of the effective viewing durations in the analysis period and the duration of the analysis period.
13. The system according to claim 12, wherein the statistical server further comprises an analysis condition setting unit for setting an analysis condition according to a statistical requirement.
14. The system of claim 12, wherein the statistics server further comprises:
the basic data import unit is used for importing the basic data into a viewing information table in a database according to the statistical requirement;
the database is used for storing broadcasting data, family information, member information, set top box information, weight information, advertisement price and the basic data in a form of a table; and
and the operation maintenance unit is used for performing operations of adding, deleting and modifying on the data in the database.
15. The system of claim 12, further comprising:
the set top box is used for sending viewing behavior records to the data center server when the return conditions are met;
and the data center server is used for receiving the viewing behavior record and generating basic data.
16. The system of claim 15, wherein the set-top box comprises:
the viewing behavior acquisition unit is used for acquiring the viewing behavior of a user and generating a viewing behavior record, wherein the viewing behavior record comprises: normal viewing record, null record, business mode record and standby record;
the storage unit is used for storing the return conditions and sequentially storing all viewing behavior records according to the time sequence generated by the records;
the judging unit is used for judging whether the viewing behavior record reaches the return condition or not;
and the return unit is used for sending the viewing behavior record to the data center server according to the judgment result of the judgment unit.
17. The system of claim 15, wherein the data center server comprises:
the viewing behavior record receiving unit is used for receiving viewing behavior records automatically returned by the set top box;
the data format conversion and verification unit is used for verifying and format converting the viewing behavior record to generate basic data;
the data center is used for storing the basic data;
and the set-top box parameter modifying unit is used for modifying the parameters of the set-top box, wherein the parameters comprise return conditions.
CN2008102227508A 2008-09-24 2008-09-24 Method and system for statistic of audience rating Expired - Fee Related CN101355686B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN2008102227508A CN101355686B (en) 2008-09-24 2008-09-24 Method and system for statistic of audience rating

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2008102227508A CN101355686B (en) 2008-09-24 2008-09-24 Method and system for statistic of audience rating

Publications (2)

Publication Number Publication Date
CN101355686A true CN101355686A (en) 2009-01-28
CN101355686B CN101355686B (en) 2010-09-08

Family

ID=40308230

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2008102227508A Expired - Fee Related CN101355686B (en) 2008-09-24 2008-09-24 Method and system for statistic of audience rating

Country Status (1)

Country Link
CN (1) CN101355686B (en)

Cited By (38)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102186115A (en) * 2011-02-25 2011-09-14 深圳创维数字技术股份有限公司 Set top box based program display system and method
CN102340413A (en) * 2010-07-27 2012-02-01 上海未来宽带技术及应用工程研究中心有限公司 Method for controlling cable bridge terminal
WO2012016474A1 (en) * 2010-08-05 2012-02-09 中兴通讯股份有限公司 Method and system for implementing viewing audience survey for internet protocol television (iptv)
CN102427554A (en) * 2011-10-21 2012-04-25 李世平 Survey statistic method and system for real-time audience rating situation of television programs
CN102523497A (en) * 2011-12-29 2012-06-27 北京衡准科技有限公司 Method for predicting television program hot spot information based on monitoring of mass television program forenotices
WO2012130186A1 (en) * 2011-04-01 2012-10-04 尼尔森网联媒介数据服务有限公司 Method, system and apparatus for digital television data collection and human-computer interaction device
CN103546514A (en) * 2012-07-13 2014-01-29 阿里巴巴集团控股有限公司 Method and system for processing delay-transmitted log data
CN103731738A (en) * 2014-01-23 2014-04-16 哈尔滨理工大学 Video recommendation method and device based on user group behavioral analysis
CN104079961A (en) * 2014-05-21 2014-10-01 四川长虹电器股份有限公司 System and method used for counting audience ratings of TV programs on TV set
CN104301759A (en) * 2014-10-28 2015-01-21 北京国双科技有限公司 Television-watching time duration obtaining method and device
CN104320705A (en) * 2014-11-07 2015-01-28 北京国双科技有限公司 Method and device for monitoring network television ratings
CN104394469A (en) * 2014-11-19 2015-03-04 四川长虹电器股份有限公司 Method for automatically acquiring user watch time by set-top box
CN104394436A (en) * 2014-11-28 2015-03-04 北京国双科技有限公司 Audience rating monitoring method and device of network television live channel
CN104394433A (en) * 2014-11-27 2015-03-04 北京国双科技有限公司 Method and device for detecting play times of multimedia file in television channel
CN104410906A (en) * 2014-11-18 2015-03-11 北京国双科技有限公司 Detection method and detection device for video playing behavior
CN104469424A (en) * 2014-11-06 2015-03-25 北京国双科技有限公司 Statistical method and device for TV-watching duration of TV channels
CN104469432A (en) * 2014-12-31 2015-03-25 合一网络技术(北京)有限公司 User-based audience rating correcting method and device
CN104469494A (en) * 2014-12-03 2015-03-25 北京国双科技有限公司 Method and device for generating test data of network television
CN104486645A (en) * 2014-11-20 2015-04-01 小米科技有限责任公司 Method for determining program audience rating, playback equipment, server and device
CN104503288A (en) * 2014-08-14 2015-04-08 方正宽带网络服务有限公司 Method and device for remote controller configuration, and remote controller
CN104811810A (en) * 2015-03-23 2015-07-29 四川长虹电器股份有限公司 Real-time regional audience rating and audience share statistical system based on intelligent television and method thereof
CN104936023A (en) * 2015-06-11 2015-09-23 嘉兴市广播电视集团 Big data collecting and analyzing method and system of digital television user behavior
CN106101643A (en) * 2016-07-21 2016-11-09 王海燕 Internet of Things polyhouse-based agriculture growth monitoring system
CN106470348A (en) * 2015-08-14 2017-03-01 北京国双科技有限公司 Rating number statistical method and device
CN106612459A (en) * 2015-10-22 2017-05-03 北京国双科技有限公司 Method and device for calculating user viscosity based on Internet protocol television
CN107172469A (en) * 2017-06-15 2017-09-15 青岛海信电器股份有限公司 Broadcast TV channel switching method and television display device
CN108287870A (en) * 2017-12-27 2018-07-17 优地网络有限公司 Intelligent method for running and device
CN108335150A (en) * 2013-04-17 2018-07-27 尼尔森(美国)有限公司 Device and computer readable storage medium for monitoring media presentation
CN108574859A (en) * 2017-03-08 2018-09-25 北京国双科技有限公司 A kind of viewing behavior statistical method and device
CN109547821A (en) * 2019-01-16 2019-03-29 中央电视台 A kind of television station channel rating trend evaluation method and device
CN109698967A (en) * 2018-12-18 2019-04-30 中央电视台 A kind of TV station's communication effect appraisal procedure and device
CN109729427A (en) * 2017-10-31 2019-05-07 北京国双科技有限公司 The statistical method and device of rating duration
CN110019932A (en) * 2017-10-31 2019-07-16 北京国双科技有限公司 The method and device of data processing
CN110298711A (en) * 2019-07-12 2019-10-01 秒针信息技术有限公司 Advertisement arrival rate determines method, apparatus, storage medium and advertisement delivery method
CN111246294A (en) * 2020-01-06 2020-06-05 国家广播电视总局广播电视规划院 Method, device, equipment and storage medium for processing audience rating index data
CN111526394A (en) * 2020-04-10 2020-08-11 国家广播电视总局广播电视规划院 Method, device and equipment for processing audience behavior data and storage medium
CN112887764A (en) * 2021-01-19 2021-06-01 北京浩瀚深度信息技术股份有限公司 OTT video audience rating analysis method and equipment based on DPI and storage medium
CN113727192A (en) * 2020-06-19 2021-11-30 天翼智慧家庭科技有限公司 Method and system for collecting viewing behaviors

Cited By (61)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102340413A (en) * 2010-07-27 2012-02-01 上海未来宽带技术及应用工程研究中心有限公司 Method for controlling cable bridge terminal
CN102340413B (en) * 2010-07-27 2014-12-17 上海未来宽带技术股份有限公司 Method for controlling cable bridge terminal
WO2012016474A1 (en) * 2010-08-05 2012-02-09 中兴通讯股份有限公司 Method and system for implementing viewing audience survey for internet protocol television (iptv)
CN102377789A (en) * 2010-08-05 2012-03-14 中兴通讯股份有限公司 Method and system for implementing IPTV (Internet protocol television) audience investigation
CN102377789B (en) * 2010-08-05 2015-08-12 中兴通讯股份有限公司 Realize the method and system of IPTV television viewing audience investigation
CN102186115B (en) * 2011-02-25 2012-12-26 深圳创维数字技术股份有限公司 Set top box based program display system and method
CN102186115A (en) * 2011-02-25 2011-09-14 深圳创维数字技术股份有限公司 Set top box based program display system and method
WO2012130186A1 (en) * 2011-04-01 2012-10-04 尼尔森网联媒介数据服务有限公司 Method, system and apparatus for digital television data collection and human-computer interaction device
CN102740138A (en) * 2011-04-01 2012-10-17 尼尔森网联媒介数据服务有限公司 Digital television viewing data acquisition method, system, equipment and man-machine interaction apparatus thereof
CN102427554A (en) * 2011-10-21 2012-04-25 李世平 Survey statistic method and system for real-time audience rating situation of television programs
CN102523497A (en) * 2011-12-29 2012-06-27 北京衡准科技有限公司 Method for predicting television program hot spot information based on monitoring of mass television program forenotices
CN103546514A (en) * 2012-07-13 2014-01-29 阿里巴巴集团控股有限公司 Method and system for processing delay-transmitted log data
CN103546514B (en) * 2012-07-13 2016-12-21 阿里巴巴集团控股有限公司 A kind of method and system processing the daily record data postponing transmission
US12039557B2 (en) 2013-04-17 2024-07-16 The Nielsen Company (Us), Llc Methods and apparatus to monitor media presentations
US11687958B2 (en) 2013-04-17 2023-06-27 The Nielsen Company (Us), Llc Methods and apparatus to monitor media presentations
CN108335150B (en) * 2013-04-17 2022-03-29 尼尔森(美国)有限公司 Apparatus and computer-readable storage medium for monitoring media presentation
US11282097B2 (en) 2013-04-17 2022-03-22 The Nielsen Company (Us), Llc Methods and apparatus to monitor media presentations
CN108335150A (en) * 2013-04-17 2018-07-27 尼尔森(美国)有限公司 Device and computer readable storage medium for monitoring media presentation
CN103731738A (en) * 2014-01-23 2014-04-16 哈尔滨理工大学 Video recommendation method and device based on user group behavioral analysis
CN104079961A (en) * 2014-05-21 2014-10-01 四川长虹电器股份有限公司 System and method used for counting audience ratings of TV programs on TV set
CN104503288A (en) * 2014-08-14 2015-04-08 方正宽带网络服务有限公司 Method and device for remote controller configuration, and remote controller
CN104301759A (en) * 2014-10-28 2015-01-21 北京国双科技有限公司 Television-watching time duration obtaining method and device
CN104469424A (en) * 2014-11-06 2015-03-25 北京国双科技有限公司 Statistical method and device for TV-watching duration of TV channels
CN104320705B (en) * 2014-11-07 2018-04-06 北京国双科技有限公司 Web TV rating monitoring method and device
CN104320705A (en) * 2014-11-07 2015-01-28 北京国双科技有限公司 Method and device for monitoring network television ratings
CN104410906A (en) * 2014-11-18 2015-03-11 北京国双科技有限公司 Detection method and detection device for video playing behavior
CN104394469A (en) * 2014-11-19 2015-03-04 四川长虹电器股份有限公司 Method for automatically acquiring user watch time by set-top box
CN104486645A (en) * 2014-11-20 2015-04-01 小米科技有限责任公司 Method for determining program audience rating, playback equipment, server and device
CN104394433A (en) * 2014-11-27 2015-03-04 北京国双科技有限公司 Method and device for detecting play times of multimedia file in television channel
CN104394436B (en) * 2014-11-28 2018-06-26 北京国双科技有限公司 The monitoring method and device of the audience ratings of Internet TV live television channel
CN104394436A (en) * 2014-11-28 2015-03-04 北京国双科技有限公司 Audience rating monitoring method and device of network television live channel
CN104469494A (en) * 2014-12-03 2015-03-25 北京国双科技有限公司 Method and device for generating test data of network television
CN104469494B (en) * 2014-12-03 2018-05-15 北京国双科技有限公司 Test data generating method and device for Web TV
CN104469432A (en) * 2014-12-31 2015-03-25 合一网络技术(北京)有限公司 User-based audience rating correcting method and device
CN104811810B (en) * 2015-03-23 2018-12-07 四川长虹电器股份有限公司 Based on smart television real-time region audience ratings and rating share statistical system and method
CN104811810A (en) * 2015-03-23 2015-07-29 四川长虹电器股份有限公司 Real-time regional audience rating and audience share statistical system based on intelligent television and method thereof
CN104936023A (en) * 2015-06-11 2015-09-23 嘉兴市广播电视集团 Big data collecting and analyzing method and system of digital television user behavior
CN106470348A (en) * 2015-08-14 2017-03-01 北京国双科技有限公司 Rating number statistical method and device
CN106470348B (en) * 2015-08-14 2019-10-25 北京国双科技有限公司 Rating number statistical method and device
CN106612459A (en) * 2015-10-22 2017-05-03 北京国双科技有限公司 Method and device for calculating user viscosity based on Internet protocol television
CN106612459B (en) * 2015-10-22 2019-11-12 北京国双科技有限公司 Method, apparatus, storage medium and viscosity based on Web TV counting user viscosity count equipment
CN106101643A (en) * 2016-07-21 2016-11-09 王海燕 Internet of Things polyhouse-based agriculture growth monitoring system
CN106101643B (en) * 2016-07-21 2018-06-12 内蒙古中孚明丰农业科技有限公司 Compatible type Internet of Things polyhouse-based agriculture grows monitoring system
CN108574859B (en) * 2017-03-08 2020-10-27 北京国双科技有限公司 Viewing behavior statistical method and device
CN108574859A (en) * 2017-03-08 2018-09-25 北京国双科技有限公司 A kind of viewing behavior statistical method and device
CN107172469A (en) * 2017-06-15 2017-09-15 青岛海信电器股份有限公司 Broadcast TV channel switching method and television display device
CN110019932A (en) * 2017-10-31 2019-07-16 北京国双科技有限公司 The method and device of data processing
CN109729427A (en) * 2017-10-31 2019-05-07 北京国双科技有限公司 The statistical method and device of rating duration
CN108287870B (en) * 2017-12-27 2020-09-01 优地网络有限公司 Intelligent operation method and device
CN108287870A (en) * 2017-12-27 2018-07-17 优地网络有限公司 Intelligent method for running and device
CN109698967B (en) * 2018-12-18 2021-07-06 中央电视台 Method and device for evaluating propagation effect of television station
CN109698967A (en) * 2018-12-18 2019-04-30 中央电视台 A kind of TV station's communication effect appraisal procedure and device
CN109547821B (en) * 2019-01-16 2021-06-04 中央电视台 Television station channel viewing tendency evaluation method and device
CN109547821A (en) * 2019-01-16 2019-03-29 中央电视台 A kind of television station channel rating trend evaluation method and device
CN110298711A (en) * 2019-07-12 2019-10-01 秒针信息技术有限公司 Advertisement arrival rate determines method, apparatus, storage medium and advertisement delivery method
CN111246294A (en) * 2020-01-06 2020-06-05 国家广播电视总局广播电视规划院 Method, device, equipment and storage medium for processing audience rating index data
CN111526394A (en) * 2020-04-10 2020-08-11 国家广播电视总局广播电视规划院 Method, device and equipment for processing audience behavior data and storage medium
CN113727192A (en) * 2020-06-19 2021-11-30 天翼智慧家庭科技有限公司 Method and system for collecting viewing behaviors
CN113727192B (en) * 2020-06-19 2023-09-12 天翼数字生活科技有限公司 Method and system for collecting viewing behaviors
CN112887764A (en) * 2021-01-19 2021-06-01 北京浩瀚深度信息技术股份有限公司 OTT video audience rating analysis method and equipment based on DPI and storage medium
CN112887764B (en) * 2021-01-19 2022-11-08 北京浩瀚深度信息技术股份有限公司 OTT video audience rating analysis method and equipment based on DPI and storage medium

Also Published As

Publication number Publication date
CN101355686B (en) 2010-09-08

Similar Documents

Publication Publication Date Title
CN101355686A (en) Method and system for statistic of audience rating
JP3713043B2 (en) Viewing history recording method and viewing history usage method
CN101217618B (en) A real-time collection method of STB working status
CN103475910B (en) A kind of programs of set-top box for intelligent television end recommends method and system
CN103891298A (en) Method and system for collecting and managing tv viewership data
US20020133506A1 (en) Server delivering the degree of interest in broadcast programs and method thereof and computer program of the method
CN102088627A (en) Program data information updating system and data updating method
CN104584571A (en) Generating a sequence of audio fingerprints at a set top box
CN101639841A (en) Method and system for providing multimedia data searching and querying service
CN102244811A (en) System and method for recommending television channels
CN103891299A (en) Method and system for providing efficient and accurate estimates of tv viewership ratings
CN100544420C (en) A kind of network TV business prompting system and method
CN101222609A (en) Audience investigation system based on bidirectional digital television techniques
CN104394436A (en) Audience rating monitoring method and device of network television live channel
CN104394427B (en) A kind of set-top box obtains and pushes the method and system of micro- message
CN102769782A (en) Digital television audience rating returning method
CN1937539B (en) Device and method for automatically obtaining information relating to the audiences of programs transmitted by a communication network
CN103179440A (en) Value-added service time-shifted television system facing 3G users
CN102483750A (en) Metadata collecting device
CN101902342A (en) Method and device for acquiring billing and accounting data in telecommunications
CN114979690B (en) Live channel information control inspection method based on big data analysis
JP4168802B2 (en) Program information acquisition device
CN102739718A (en) Set top box quality data processing method and system thereof
CN102377789B (en) Realize the method and system of IPTV television viewing audience investigation
CN107404659B (en) Network video display methods and device

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
ASS Succession or assignment of patent right

Owner name: BEIJING ZHONGCHUAN RUIZHI MARKET RESEARCH CO., LTD

Free format text: FORMER OWNER: ZHONGHUI SHIJI MEDIA DEVELOPMENT CO., LTD.

Effective date: 20121205

C41 Transfer of patent application or patent right or utility model
COR Change of bibliographic data

Free format text: CORRECT: ADDRESS; FROM: 100029 CHAOYANG, BEIJING TO: 100176 DAXING, BEIJING

TR01 Transfer of patent right

Effective date of registration: 20121205

Address after: 100176, No. 3, block A, 3 middle Sheng Road, Beijing economic and Technological Development Zone, Beijing

Patentee after: Beijing Zhongchuan Ruizhi Market Research Co.,Ltd.

Address before: 100029 Beijing city Chaoyang District Yumin Road A Chinese international science and Technology Exhibition Center No. 12 block 601

Patentee before: Zhonghui Shiji Media Development Co., Ltd.

CF01 Termination of patent right due to non-payment of annual fee
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20100908

Termination date: 20170924