CN108235068B

CN108235068B - Television column playing statistical method and device

Info

Publication number: CN108235068B
Application number: CN201611200713.8A
Authority: CN
Inventors: 李越
Original assignee: Beijing Gridsum Technology Co Ltd
Current assignee: Beijing Gridsum Technology Co Ltd
Priority date: 2016-12-22
Filing date: 2016-12-22
Publication date: 2020-05-26
Anticipated expiration: 2036-12-22
Also published as: CN108235068A

Abstract

The invention provides a television column playing statistical method and device, which are used for acquiring column program information in a CMS system and expanding the column hierarchical information according to column hierarchical relationship, wherein the column hierarchical information comprises the affiliated relationship between each level of column and program; and acquiring program viewing information in the log of the C3, and counting to obtain program playing information corresponding to each program, wherein the program playing information comprises playing times. And then, matching the program playing information with the column hierarchy information according to the program ID to obtain column program playing information. And counting program playing information of all different program IDs contained in the target column in the column program playing information to obtain the playing information of the target column. The method is to count the program playing information corresponding to all different program IDs in the target column, and not to accumulate the program playing information corresponding to the hierarchical logic relationship of all the columns contained in the target column, so that the program playing information corresponding to the columns obtained through counting is more accurate.

Description

Television column playing statistical method and device

Technical Field

The invention relates to the technical field of computers, in particular to a method and a device for counting television column playing.

Background

With the rapid development of network technology, IPTV (Internet Protocol Television) service has entered into thousands of households, and IPTV is a system that uses broadband as a medium to transmit Television information and provides digital Television services to users through broadband Internet Protocol.

Providers of IPTV services typically use a CMS (Content Management System) System to manage tv program Content, where the columns are classified into several levels, such as a first-level column, a second-level column, and a third-level column, where the first-level column includes a plurality of second-level columns, and each second-level column may include a plurality of third-level columns, and so on. Thus a program may belong to different secondary categories under the same primary category, for example, the television program super flying man belongs to both the "cartoon" category and the "newest animation" category, both of which belong to the "kids" category.

The C3 log is currently commonly used to record the viewing information for video programs on demand. Each user generates a log of every tv program broadcast, which is stored in the C3 log, and the viewing information in the C3 log includes the program code. The C3 log is associated with the columns in the CMS system by the program code, so that the playing times of a program in the C3 log may match with a plurality of secondary columns in the CMS system, and the secondary columns belong to a primary column, so that when counting the playing times of the primary column, the playing times of all the secondary columns under the primary column are accumulated, resulting in an inaccurate result of the counting of the playing times of the primary column.

Disclosure of Invention

In view of the above, the present invention is proposed to provide a tv column playing statistical method and apparatus that overcomes or at least partially solves the above problems.

In a first aspect, the present application provides a method for statistical broadcasting of tv listings, including:

acquiring column program information, and expanding the column program information according to a column hierarchical relationship to obtain column hierarchical information, wherein the column hierarchical information comprises a program identity;

acquiring program viewing information, and counting program playing information corresponding to each program contained in the program viewing information;

matching the program playing information with the column hierarchy information according to the program identity identification to obtain column program playing information, wherein the column program playing information comprises program playing information under each column hierarchy corresponding to each program;

and according to the column program playing information, counting program playing information corresponding to all different program identification marks contained in the target column to obtain the playing information of the target column.

Optionally, the counting, according to the program playing information of the column, program playing information corresponding to all different program identifiers included in a target column to obtain the playing information of the target column includes:

searching all information items corresponding to the target column from the column program playing information;

for each program identification in the information items corresponding to the target column, all information items containing the program identification are searched from all information items corresponding to the target column, and all information items containing the program identification are numbered in a sequence increasing in sequence from the designated number;

and after all the information items corresponding to the target column are compiled, accumulating the program playing information in the information items with the specified serial numbers to obtain the playing information of the target column.

Optionally, the counting, according to the program playing information of the column, program playing information of all different program identifiers included in a target column to obtain the playing information of the target column includes:

numbering all information items corresponding to the target column, and judging whether any numbered information item contains a program identity mark contained in the information item to be numbered;

if the numbered information item does not contain the program identity, marking the information item to be numbered as a first preset number;

if the numbered information item contains the program identity mark, marking the information item to be numbered as a second preset number;

and accumulating the program playing information in the information items marked as the first preset numbers to obtain the playing information of the target column.

Optionally, the acquiring column program information and expanding the column program information according to the column hierarchy relationship to obtain column hierarchy information includes:

acquiring column program information in a content management system;

and expanding the column program information step by step according to the column hierarchical relationship to obtain column hierarchical information taking each column hierarchical relationship as an information item.

Optionally, matching the program playing information with the column hierarchy information according to the program identity identifier to obtain column program playing information, where the matching includes:

for any program identity, extracting all column level information items corresponding to the program identity from the column level information;

and establishing a corresponding relation between the information item of the column hierarchy and the program playing information to obtain the column program playing information corresponding to the program identity identification.

In a second aspect, the present application provides a tv column playing statistics apparatus, including:

the column hierarchy expansion module is used for acquiring column program information and expanding the column program information according to a column hierarchy relationship to obtain column hierarchy information, wherein the column hierarchy information comprises a program identity;

the program playing information counting module is used for acquiring program viewing information and counting program playing information corresponding to each program contained in the program viewing information;

the matching module is used for matching the program playing information with the column hierarchy information according to the program identity identification to obtain column program playing information, and the column program playing information comprises program playing information under each column hierarchy relationship corresponding to each program;

and the column playing information counting module is used for counting the program playing information corresponding to all different program identification marks contained in the target column according to the column program playing information to obtain the playing information of the target column.

Optionally, the column playing information statistics module includes:

the first searching submodule is used for searching all information items corresponding to the target column from the column program playing information;

the numbering submodule is used for searching all information items containing the program ID from all information items corresponding to the target column for each program identity in the information items corresponding to the target column, and numbering all the information items containing the program identity in a sequence increasing from the specified number;

and the first statistic submodule is used for accumulating the program playing information in the information items with the specified numbers to obtain the playing information of the target column after all the information items corresponding to the target column are compiled.

Optionally, the column playing information statistics module includes:

the second searching submodule is used for searching all information items corresponding to the target column from the column program playing information;

the judgment submodule is used for numbering all the information items corresponding to the target column and judging whether any numbered information item contains a program identity mark contained in the information item to be numbered or not;

the first numbering submodule is used for marking the information item to be numbered as a first preset number when the numbered information item does not contain the program identity;

the second numbering submodule is used for marking the information item to be numbered as a second preset number when the numbered information item contains the program identity;

and the second counting submodule is used for accumulating the program playing information in the information item marked as the first preset number to obtain the playing information of the target column.

Optionally, the column hierarchy expansion module comprises:

the column information acquisition submodule is used for acquiring column program information in the content management system;

and the hierarchy expansion submodule is used for expanding the column program information step by step according to the column hierarchy relationship to obtain column hierarchy information taking each column hierarchy relationship as an information item.

Optionally, the matching module includes:

the column information acquisition submodule is used for extracting all column level information items corresponding to the program identity mark from the column level information for any program identity mark;

and the corresponding relation establishing submodule is used for establishing the corresponding relation between the information item of the column hierarchy and the program playing information to obtain the column program playing information corresponding to the program identity identifier ID.

By means of the technical scheme, the television column playing statistical method provided by the invention obtains column program information in a CMS system, and obtains column level information according to the expansion of column level relations, wherein the column level information comprises the affiliated relations between various levels of columns and programs; and acquiring program viewing information in the log of the C3, and counting to obtain program playing information corresponding to each program, wherein the program playing information comprises playing times. And then, matching the program playing information with the column hierarchy information according to the program ID to obtain column program playing information. And counting program playing information of all different program IDs contained in the target column in the column program playing information to obtain the playing information of the target column. The method is to count the program playing information corresponding to all different program IDs in the target column, and not to accumulate the program playing information corresponding to the hierarchical logic relationship of all the columns contained in the target column, so that the program playing information corresponding to the columns obtained through counting is more accurate.

The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.

Drawings

Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:

FIG. 1 is a flow chart illustrating a statistical method for TV program broadcasting according to an embodiment of the present invention;

FIG. 2 is a schematic diagram illustrating an unexpanded column hierarchy logical relationship;

FIG. 3 is a flow chart illustrating a process of obtaining playback information for a target field according to an embodiment of the present invention;

FIG. 4 is a flow chart illustrating another embodiment of the present invention for obtaining playback information for a target listing;

FIG. 5 is a block diagram of a TV program playing statistics device according to an embodiment of the present invention;

FIG. 6 is a block diagram of a section playing information statistics module according to an embodiment of the present invention;

FIG. 7 is a block diagram of a hurdle play information statistics module according to an embodiment of the present invention;

fig. 8 is a block diagram of another tv column play statistics apparatus according to an embodiment of the present invention.

Detailed Description

Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

Referring to fig. 1, a flow chart of a tv column playing statistics method according to an embodiment of the present invention is shown, where the method is applied to a statistics system, and as shown in fig. 1, the method may include the following steps:

s110, acquiring column program information, and expanding the column program information according to a column hierarchical relationship to obtain column hierarchical information; the column level information includes a program ID (Identity).

The program ID in this specification is a program identification. The column hierarchy relationship is used for representing a relationship path between columns of different hierarchies corresponding to each program ID. Because each program ID may correspond to a plurality of different levels of columns, there may be a plurality of relationship paths between the columns of different levels corresponding to each program ID, that is, there may be a plurality of column level relationships corresponding to each program ID.

Column program information in a CMS (content management system) system is acquired, and the column program information is a mapping relation between television columns and television programs at all levels in the CMS system. And after acquiring the column program information, expanding according to the column hierarchical relationship to acquire column hierarchical information.

Referring to fig. 2, a schematic diagram of a hierarchical logical relationship of unexpanded columns is shown, as shown in fig. 2, column a is a first-level column, columns b1 and b2 are second-level columns, columns c1, c2 and c4 are third-level columns, and column c1 and c4 correspond to program 1, column c1 and c2 correspond to program 2, column c2 and b2 correspond to program 3, and column c2 and c4 correspond to program 4.

In a possible implementation manner of the present invention, the expanded column hierarchy logical relationship may be represented in a table manner, as shown in table 1:

TABLE 1

In the column hierarchy diagram shown in fig. 2, one program may correspond to multiple columns, and therefore, the column program information obtained after the column hierarchy expansion includes repeated program IDs.

And S120, acquiring program viewing information, and counting program playing information corresponding to each program contained in the program viewing information.

The program viewing information is obtained from the C3 log, and the playing data of all users is stored in the C3 log, so that it is necessary to perform grouping statistics on the playing data in the C3 log according to the program ID to obtain the program playing information corresponding to each program, for example, program 1/playing time 2 times.

The program playing information may be information such as playing times, effective playing times of the columns, contribution rate of the columns, and column occupation ratio.

Wherein, the effective playing times of the column is the column on-demand with (on-demand watching time length/program time length) more than or equal to 0.1; column contribution rate is the number of viewings of the selected column/the viewings of the corresponding column level; column ratio is the number of viewings/number of all on-demand viewings of the selected column.

S130, matching the program playing information with the column hierarchy information according to the program ID to obtain column program playing information.

The column program playing information comprises program playing information under each column hierarchical relationship corresponding to each program.

Matching the obtained program playing information with the expanded program hierarchy information according to the program ID, for example, matching the program hierarchy information shown in table 1 with the program playing information obtained in S120 according to the program ID, and obtaining the program playing information of the program as shown in table 2:

TABLE 2

Table 2 contains the broadcast information of each type of column hierarchical relationship corresponding to the tv program, for example, program 4 corresponds to two types of column hierarchical relationships, one is: column a → column b1 → column c2 → program 4; the other is column a → column b2 → column c4 → program 4, and therefore, table 2 contains program broadcast information of two programs 4 (i.e., the number of broadcasts in table 2).

And S140, according to the column program playing information, counting the program playing information corresponding to all different program IDs contained in the target column to obtain the playing information of the target column.

The target section is a section to be counted currently, and for example, any one of the sections may be set as the target section by the user.

As can be seen from the contents shown in table 2, the program 4 belongs to the second-level listings b1 and b2, respectively, but the listings b1 and b2 belong to the first-level listing a, so when the number of plays of the listing a is counted, the number of plays in table 2 cannot be directly accumulated. It is necessary to count the program broadcast information of all different program IDs included in the target column from the column program broadcast information obtained in table 2.

For example, counting the number of broadcast times of the program in the column a, the number of broadcast times of all different programs in the column a is found from table 2 and accumulated to obtain 7+5+3+2 as 17.

If the number of times of broadcast of the program in the column b1 is counted, and it is known from table 2 that the programs included in the column b1 are program 4, program 3, program 2, and program 1, the number of times of broadcast of the column b1 is 7+5+3+2, which is 17.

When the number of times of broadcast of the program in the section b2 is counted, and it is known from table 2 that the programs included in the section b2 are program 4, program 3, and program 1, the number of times of broadcast of the section b2 is 7+5+2, which is 14.

When the number of times of broadcast of the program included in the section c1 is counted, and as can be seen from table 2, the section c1 includes the program 2 and the program 1, the number of times of broadcast of the section c1 is 3+2 — 5.

As can be seen from table 2 when the number of times of broadcast of the program included in the section c2 is counted, and the section c2 includes the program 4, the program 3, and the program 2, the number of times of broadcast of the section c2 is 7+5+3, which is 15.

When the number of times of broadcast of the program included in the section c4 is counted, and as can be seen from table 2, the section c4 includes the program 1 and the program 4, the number of times of broadcast of the section c4 is 7+2 — 9.

The method for counting television column playing provided by this embodiment acquires column program information in a CMS system, and develops column hierarchy information according to column hierarchy relationship, where the column hierarchy information includes the affiliation relationship between each level of column and program; and acquiring program viewing information in the log of the C3, and counting to obtain program playing information corresponding to each program, wherein the program playing information comprises playing times. And then, matching the program playing information with the column hierarchy information according to the program ID to obtain column program playing information. And counting program playing information of all different program IDs contained in the target column in the column program playing information to obtain the playing information of the target column. The method is to count the program playing information corresponding to different program IDs in the target column, and not to accumulate the program playing information of all program IDs contained in the target column, so that the program playing information corresponding to the column obtained through counting is more accurate.

Referring to fig. 3, a flowchart of a process of obtaining play information of a target field according to an embodiment of the present invention is shown; in this embodiment, the information items corresponding to the same program ID are sequentially numbered in an increasing order from the designated number, and thus, the program IDs in the information items numbered as the designated number are different from each other, and therefore, it is sufficient to count the broadcast information in the information items corresponding to the designated number.

As shown in fig. 3, the process of obtaining the playing information of the target field includes the following steps:

and S141, searching all information items corresponding to the target column from the column program playing information.

The target column can be any one level column and can be set by the user according to the requirement of the user. All information items corresponding to the target column are relationship information between the columns of all the hierarchies corresponding to the target column and the program ID. For example, the target hurdles may be any one of the hurdles in any of the levels in the example shown in table 1, first-level hurdle a, second-level hurdles b1, b2, third-level hurdles c1, c2, c 4; alternatively, the target hurdles may be a combination of any number of hurdles in any level, for example, all secondary hurdles, tertiary hurdles c1 and c 4. For example, if the target column is column a, all the information items in table 2 are information items corresponding to column a.

In a possible implementation manner of the present invention, the information items corresponding to all the target columns may be found from the column program playing information table shown in table 2.

And S142, for each program ID in the information items corresponding to the target column, searching all the information items containing the program ID from all the information items corresponding to the target column, and numbering all the information items containing the program ID in a sequence increasing from the specified number.

For example, the target column is column a, the designated number is 1, and the same program IDs included in column a are sequentially numbered from the designated number in an increasing manner according to a preset step length to obtain an information table shown in table 3; the preset step size is 1.

TABLE 3

As can be seen from table 3, for any one program ID (for example, program 4), the information items in table 3 are numbered item by item from top to bottom, and all programs 4 in table 3 are numbered sequentially from "1"; similarly, the other program IDs in table 3 are numbered sequentially from "1". In this way, the program IDs corresponding to the information item numbered "1" are different from each other, and the information item numbered "1" includes all the program IDs included in the target column, so that it is only necessary to count the broadcast information included in the information item numbered "1" later.

For example, when the target column is column b1, the information item corresponding to column b1 is found from table 2, and numbered item by item, resulting in table 4:

TABLE 4

First-level column	Second grade column	Three-level column	Program ID	Statistical numbering	Number of times of playing
						Column a	Column b1	Column c2	Program 4	1	7
Column a	Column b1	Column c2	Program 3	1	5
						Column a	Column b1	Column c1	Program 2	1	3
Column a	Column b1	Column c2	Program 2	2	3
						Column a	Column b1	Column c1	Program 1	1	2

For example, the target column is b2, the information item corresponding to column b2 is found from table 2, and numbered item by item, resulting in table 5:

TABLE 5

And S143, after all the information items corresponding to the target column are compiled, accumulating the program playing information in the information items with the numbers being the specified numbers to obtain the playing information of the target column.

After all the information items of the column a shown in table 3 are numbered, the program IDs corresponding to the information items numbered as "1" are different from each other, so that it is only necessary to count the program playing information included in the information items numbered as "1";

when the number of times of playing of the program included in the column a is counted, the number of times of playing corresponding to the information item numbered "1" in table 3 is accumulated to obtain 7+5+3+2 as 17.

When the number of times of broadcast of the program included in the column b1 is counted, the number of times of broadcast corresponding to the information item numbered "1" in table 4 is added up to obtain 7+5+3+2 as 17.

When the number of times of broadcast of the program included in the column b2 is counted, the number of times of broadcast corresponding to the information item numbered "1" in table 5 is added, and 7+5+2 is obtained as 14.

In the process of obtaining the playing information of the target column provided by this embodiment, all information items corresponding to the target column are found from the column program playing information. Then, for any one of the found all information items, the information items of the program ID are sequentially numbered in an ascending order from the designated number. In this way, the program IDs corresponding to the information items numbered as the designated numbers are different from each other, and the program playing information corresponding to the information items numbered as the designated numbers is accumulated to obtain the playing information of the target column. By using the method, the playing information of all programs contained in the target column is obtained through statistics, and repeated statistics is avoided.

Referring to fig. 4, a flowchart of another embodiment of the present invention for obtaining the playing information of the target column is shown, in which in this embodiment, the program ID appearing for the first time is marked as a first preset number, and the program ID appearing for the second time is marked as a second preset number. The program IDs included in the information items marked with the first preset number are different from each other, and therefore, the playing information corresponding to the information items marked with the first preset number is counted.

As shown in fig. 4, the process of obtaining the playing information of the target field includes the following steps:

s144, all information items corresponding to the target column are searched from the column program playing information.

S145, numbering all information items corresponding to the target column, and judging whether any numbered information item contains a program ID contained in the information item to be numbered; if so, executing S147; if not, S146 is executed.

And S146, marking the information item to be numbered as a first preset number.

And S147, marking the information items to be numbered as second preset numbers.

The first preset number and the second preset number may be set by the user, or may be default numbers of the system.

For example, the target column is column a, the first preset number is "I", and the second preset number is "II", all information items including the target column are compiled in the manner shown in S145 to S147, and then table 6 is obtained:

TABLE 6

First-level column	Second grade column	Three-level column	Program ID	Statistical numbering	Number of times of playing
						Column a	Column b1	Column c2	Program 4	I	7
Column a	Column b2	Column c4	Program 4	II	7
						Column a	Column b1	Column c2	Program 3	I	5
Column a	Column b2	---------	Program 3	II	5
						Column a	Column b1	Column c1	Program 2	I	3
Column a	Column b1	Column c2	Program 2	II	3
						Column a	Column b1	Column c1	Program 1	I	2
Column a	Column b2	Column c4	Program 1	II	2

For example, if the target column is column b2, the first preset number is "I", and the second preset number is "II", all information items corresponding to column b2 are numbered according to S145 to S147, resulting in table 7:

TABLE 7

First-level column	Second grade column	Three-level column	Program ID	Statistical numbering	Number of times of playing
						Column a	Column b2	Column c4	Program 4	I	7
Column a	Column b2	---------	Program 3	I	5
						Column a	Column b2	Column c4	Program 1	I	2

And S148, accumulating the program playing information in the information item marked as the first preset number to obtain the playing information of the target column.

For example, when the number of times of playback corresponding to the column a is counted, the number of times of playback in the information item numbered "I" in table 6 is added up to obtain 7+5+3+2 as 17.

For example, when the number of times of playback corresponding to the column b2 is counted, the number of times of playback in the information item numbered "I" in table 7 is added up to obtain 7+5+2 — 14.

In the process of obtaining the broadcast information of the target column provided in this embodiment, all the information items corresponding to the target column are numbered, specifically, the information item corresponding to the program ID that appears for the first time may be marked as a first preset number, and the information item corresponding to the program ID that appears repeatedly may be marked as a second preset number. Then, the playing information corresponding to the information item marked as the first preset number is counted to obtain the playing information of the target column, and the method is simple to implement and does not repeatedly calculate the playing information of the same program.

Corresponding to the embodiment of the television column playing statistical method, the invention also provides an embodiment of a television column playing statistical device.

Referring to fig. 5, a block diagram of a tv column playing statistics apparatus according to an embodiment of the present invention is shown, where the apparatus is applied to a statistics system, and as shown in fig. 5, the apparatus includes: column hierarchy expansion module 510, program playing information statistics module 520, matching module 530 and column playing information statistics module 540.

The column hierarchy expansion module 510 is configured to obtain column program information, and expand the column program information according to a column hierarchy relationship to obtain column hierarchy information; the program level information includes a program ID.

Column program information in the CMS system is obtained, wherein the column program information is a mapping relation between television columns and television programs at all levels in the CMS system. And after acquiring the column program information, expanding according to the column hierarchical relationship to acquire column hierarchical information.

In a possible implementation manner of the present invention, the column hierarchy expansion module 510 includes: the column information acquisition submodule is used for acquiring column program information in the CMS system; and the hierarchy expansion submodule is used for expanding the column program information step by step according to the column hierarchy relationship to obtain column hierarchy information taking each column hierarchy relationship as an information item.

The program playing information counting module 520 is configured to obtain program viewing information and count program playing information corresponding to each program included in the program viewing information.

The program viewing information is obtained from the C3 log, and the playing data of all users is stored in the C3 log, so that it is necessary to perform grouping statistics on the playing data in the C3 log according to the program ID to obtain the program playing information corresponding to each program, for example, the program 1| playing times are 2 times.

The matching module 530 is configured to match the program playing information with the column hierarchy information according to the program ID, so as to obtain column program playing information.

The column program playing information obtained by matching the program playing information with the column hierarchy information, for example, may be represented by a table shown in table 2. The column program playing information includes program playing information of each column hierarchical relationship corresponding to each program.

In one possible implementation manner of the present invention, the matching module includes: the column information acquisition submodule is used for acquiring information items of all column levels corresponding to the program ID from the column level information for any program ID; and the corresponding relation establishing submodule is used for establishing the corresponding relation between the information item of the column level and the program playing information to obtain the column program playing information corresponding to the program ID.

The column playing information statistics module 540 is configured to, according to the column program playing information, count program playing information of all different program IDs included in the target column to obtain playing information of the target column.

As can be seen from the contents shown in table 2, the program 4 belongs to the second-level listings b1 and b2, respectively, but the listings b1 and b2 belong to the first-level listing a, so when the number of plays of the listing a is counted, the number of plays in table 2 cannot be directly accumulated. It is necessary to count the program playing information of all different program IDs included in the target program from the program playing information of the program in the program column obtained in table 2.

In the television column playing statistical device provided by this embodiment, a column hierarchy expansion module acquires column program information in a CMS system, and expands the column hierarchy information according to column hierarchy relationship to obtain column hierarchy information, where the column hierarchy information includes the relationship between each level of column and program; then, the program viewing information in the log of C3 is obtained by the program playing information statistics module, and program playing information corresponding to each program is obtained by statistics, where the program playing information includes the playing times. And matching the program playing information with the column hierarchy information by the matching module according to the program ID to obtain column program playing information. And finally, the column playing information counting module counts the program playing information of all different program IDs contained in the target column in the column program playing information to obtain the playing information of the target column. The device counts the program playing information corresponding to all different program IDs in the target column, and does not accumulate the program playing information corresponding to the hierarchical logic relationship of all the columns contained in the target column, so that the program playing information corresponding to the columns obtained through counting is more accurate.

Referring to fig. 6, a block diagram of a section playing information statistics module according to an embodiment of the present invention is shown, and as shown in fig. 6, the section playing information statistics module 540 includes: a first lookup submodule 541, a numbering submodule 542, and a first statistics submodule 543.

The first searching sub-module 541 is configured to search all information items corresponding to the target column from the column program playing information.

In a possible implementation manner of the present invention, the column program playing information is represented by a manner shown in table 2, so that all information items corresponding to the target column can be searched from table 2.

The numbering sub-module 542 is configured to, for each program ID in the information items corresponding to the target column, find all information items including the program ID from all information items corresponding to the target column, and number all information items including the program ID in an increasing order from a specified number.

And for any program ID in all the information items corresponding to the target column, all the information items containing the program ID are searched, numbering is carried out item by item, and numbering is carried out in a sequence increasing in sequence from the specified number. That is, the information items having the same program ID among all the information items corresponding to the target column are numbered in ascending order. After all the information corresponding to the target column is compiled, the program IDs corresponding to the information items numbered as the specified numbers are different from each other.

The designation number may be set by the user, and may be set to "1", for example.

The first statistics sub-module 543 is configured to, after all the information items corresponding to the target column are compiled, accumulate the program playing information in the information items with the specified serial numbers to obtain the playing information of the target column.

The program IDs of the information items corresponding to the designated numbers are different from each other, so that the program playing information of the information items corresponding to the designated numbers is accumulated to obtain the playing information of the target column.

The column playing information statistics module provided in this embodiment finds all information items corresponding to the target column from the column program playing information. Then, for any one of the found all information items, the information items of the program ID are sequentially numbered in an ascending order from the designated number. In this way, the program IDs corresponding to the information items numbered as the designated numbers are different from each other, and the program playing information corresponding to the information items numbered as the designated numbers is accumulated to obtain the playing information of the target column. By using the method, the playing information of all programs contained in the target column is obtained through statistics, and repeated statistics is avoided.

Referring to fig. 7, a block diagram of a section playing information statistics module according to another embodiment of the present invention is shown, and as shown in fig. 7, the section playing information statistics module 540 includes: a second lookup submodule 544, a decision submodule 545, a first numbering submodule 546, a second numbering submodule 547, and a second statistics submodule 548.

The second searching sub-module 544 is configured to search all information items corresponding to the target column from the column program playing information.

The determining sub-module 545 is configured to number all information items corresponding to the target column, and determine, for any information item to be numbered, whether the numbered information item includes a program ID included in the information item to be numbered.

The first numbering submodule 546, configured to mark the information item to be numbered as a first preset number when the numbered information item does not include the program ID.

The second numbering sub-module 547 is configured to mark the information item to be numbered as a second preset number when the numbered information item includes the program ID.

For example, the target column is column a, the first preset number is "I", and the second preset number is "II", all information items including the target column are numbered according to the numbering method of this embodiment, and then the results shown in table 6 are obtained.

The second statistics submodule 548 is configured to accumulate the program playing information in the information item marked as the first preset number to obtain the playing information of the target column.

The program IDs of the information items corresponding to the first preset numbers are different from each other, so that the program playing information corresponding to the first preset numbers is accumulated to obtain the playing information of the target column.

The statistics module for obtaining column playing information provided in this embodiment numbers all information items corresponding to the target column, and specifically, may mark an information item corresponding to a program ID that appears for the first time as a first preset number, and mark an information item corresponding to a program ID that appears repeatedly as a second preset number. Then, the playing information corresponding to the information item marked as the first preset number is counted to obtain the playing information of the target column, and the method is simple to implement and does not repeatedly calculate the playing information of the same program.

Referring to fig. 8, a block diagram of another tv column playing statistics apparatus according to an embodiment of the present invention is shown, the apparatus includes a processor 810 and a memory 820, where the column hierarchy expansion module, the program playing information statistics module, the matching module, and the column playing information statistics module are all stored in the memory as program units, and the processor executes the program units stored in the memory to implement corresponding functions.

The processor comprises a kernel, and the kernel calls the corresponding program unit from the memory. The kernel can be set to be one or more than one, and the program playing information corresponding to all different program IDs in the target column is counted by adjusting the kernel parameters, so that the counting result is more accurate.

The memory may include volatile memory in a computer readable medium, Random Access Memory (RAM) and/or nonvolatile memory such as Read Only Memory (ROM) or flash memory (flash RAM), and the memory includes at least one memory chip.

The invention provides a television column playing statistical method, which comprises the steps of obtaining column program information in a CMS system, and expanding to obtain column hierarchy information according to column hierarchy relation, wherein the column hierarchy information comprises the affiliated relation between each level of column and programs; and acquiring program viewing information in the log of the C3, and counting to obtain program playing information corresponding to each program, wherein the program playing information comprises playing times. And then, matching the program playing information with the column hierarchy information according to the program ID to obtain column program playing information. And counting program playing information of all different program IDs contained in the target column in the column program playing information to obtain the playing information of the target column. The method is to count the program playing information corresponding to all different program IDs in the target column, and not to accumulate the program playing information corresponding to the hierarchical logic relationship of all the columns contained in the target column, so that the program playing information corresponding to the columns obtained through counting is more accurate.

The present application further provides a computer program product adapted to perform program code for initializing the following method steps when executed on a data processing device:

acquiring column program information, and expanding the column program information according to a column hierarchical relationship to obtain column hierarchical information, wherein the column hierarchical information comprises a program ID;

matching the program playing information with the column hierarchy information according to the program ID to obtain column program playing information, wherein the column program playing information comprises program playing information under each column hierarchy corresponding to each program;

and according to the column program playing information, counting program playing information corresponding to all different program IDs contained in the target column to obtain the playing information of the target column.

As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.

The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.

The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). The memory is an example of a computer-readable medium.

Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.

The above are merely examples of the present application and are not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.

Claims

1. A statistical method for TV column playing is characterized by comprising the following steps:

acquiring column program information, and expanding the column program information according to a column hierarchical relationship to obtain column hierarchical information, wherein the column hierarchical information comprises program identification marks, and the program identification marks corresponding to the same program in different column hierarchical information are the same;

according to the column program playing information, counting program playing information corresponding to different program identification marks contained in a target column to obtain the playing information of the target column;

wherein, the program playing information corresponding to the program identification marks different from each other contained in the statistics target column includes: and searching all information items corresponding to the target column from the column program playing information, counting the program playing information in the information item corresponding to each program identification contained in the target column, and only counting the program playing information of any one information item in at least two information items when at least two information items contain the same program identification.

2. The method according to claim 1, wherein the obtaining the playing information of the target column by counting the program playing information corresponding to the program identifiers that are different from each other and are included in the target column according to the program playing information of the column comprises:

for each program identity in the information items corresponding to the target column, all the information items containing the program identity are searched from all the information items corresponding to the target column, and all the information items containing the program identity are numbered in a sequence increasing in sequence from the specified number;

3. The method according to claim 1, wherein the obtaining the playing information of the target column by counting the program playing information of the program identifiers that are different from each other and are included in the target column according to the column program playing information comprises:

4. The method according to any one of claims 1-3, wherein the acquiring column program information and expanding the column program information according to a column hierarchy relationship to obtain column hierarchy information comprises:

acquiring column program information in a content management system;

5. The method according to any one of claims 1 to 3, wherein said matching said program playing information with said program hierarchy information according to a program identifier to obtain program playing information comprises:

6. A tv column play statistics apparatus, comprising:

the column hierarchy expansion module is used for acquiring column program information and expanding the column program information according to a column hierarchy relationship to obtain column hierarchy information, wherein the column hierarchy information comprises program identification marks, and the program identification marks corresponding to the same program in different column hierarchy information are the same;

the column playing information counting module is used for counting program playing information corresponding to different program identification marks contained in a target column according to the column program playing information to obtain the playing information of the target column;

the column playing information counting module is specifically configured to, when counting program playing information corresponding to different program identifiers included in a target column,: and searching all information items corresponding to the target column from the column program playing information, counting the program playing information in the information item corresponding to each program identification contained in the target column, and only counting the program playing information of any one information item in at least two information items when at least two information items contain the same program identification.

7. The apparatus of claim 6, wherein the hurdle play information statistics module comprises:

the numbering submodule is used for searching all information items containing the program identity from all information items corresponding to the target column for each program identity in the information items corresponding to the target column, and numbering all the information items containing the program identity in a sequence increasing from the specified number;

8. The apparatus of claim 6, wherein the hurdle play information statistics module comprises:

9. The apparatus of any of claims 6-8, wherein the column level expansion module comprises:

10. The apparatus of any of claims 6-8, wherein the matching module comprises:

and the corresponding relation establishing submodule is used for establishing the corresponding relation between the information item of the column hierarchy and the program playing information to obtain the column program playing information corresponding to the program identity identification.