CN105898540B - A kind of data processing method and device of programme information - Google Patents
A kind of data processing method and device of programme information Download PDFInfo
- Publication number
- CN105898540B CN105898540B CN201610377174.9A CN201610377174A CN105898540B CN 105898540 B CN105898540 B CN 105898540B CN 201610377174 A CN201610377174 A CN 201610377174A CN 105898540 B CN105898540 B CN 105898540B
- Authority
- CN
- China
- Prior art keywords
- program
- user
- information
- log
- essential information
- 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.)
- Expired - Fee Related
Links
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04N—PICTORIAL COMMUNICATION, e.g. TELEVISION
- H04N21/00—Selective content distribution, e.g. interactive television or video on demand [VOD]
- H04N21/40—Client devices specifically adapted for the reception of or interaction with content, e.g. set-top-box [STB]; Operations thereof
- H04N21/43—Processing of content or additional data, e.g. demultiplexing additional data from a digital video stream; Elementary client operations, e.g. monitoring of home network or synchronising decoder's clock; Client middleware
- H04N21/435—Processing of additional data, e.g. decrypting of additional data, reconstructing software from modules extracted from the transport stream
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04N—PICTORIAL COMMUNICATION, e.g. TELEVISION
- H04N21/00—Selective content distribution, e.g. interactive television or video on demand [VOD]
- H04N21/40—Client devices specifically adapted for the reception of or interaction with content, e.g. set-top-box [STB]; Operations thereof
- H04N21/43—Processing of content or additional data, e.g. demultiplexing additional data from a digital video stream; Elementary client operations, e.g. monitoring of home network or synchronising decoder's clock; Client middleware
- H04N21/442—Monitoring of processes or resources, e.g. detecting the failure of a recording device, monitoring the downstream bandwidth, the number of times a movie has been viewed, the storage space available from the internal hard disk
- H04N21/44204—Monitoring of content usage, e.g. the number of times a movie has been viewed, copied or the amount which has been watched
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04N—PICTORIAL COMMUNICATION, e.g. TELEVISION
- H04N21/00—Selective content distribution, e.g. interactive television or video on demand [VOD]
- H04N21/40—Client devices specifically adapted for the reception of or interaction with content, e.g. set-top-box [STB]; Operations thereof
- H04N21/43—Processing of content or additional data, e.g. demultiplexing additional data from a digital video stream; Elementary client operations, e.g. monitoring of home network or synchronising decoder's clock; Client middleware
- H04N21/442—Monitoring of processes or resources, e.g. detecting the failure of a recording device, monitoring the downstream bandwidth, the number of times a movie has been viewed, the storage space available from the internal hard disk
- H04N21/44213—Monitoring of end-user related data
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04N—PICTORIAL COMMUNICATION, e.g. TELEVISION
- H04N21/00—Selective content distribution, e.g. interactive television or video on demand [VOD]
- H04N21/40—Client devices specifically adapted for the reception of or interaction with content, e.g. set-top-box [STB]; Operations thereof
- H04N21/45—Management operations performed by the client for facilitating the reception of or the interaction with the content or administrating data related to the end-user or to the client device itself, e.g. learning user preferences for recommending movies, resolving scheduling conflicts
- H04N21/4508—Management of client data or end-user data
- H04N21/4532—Management of client data or end-user data involving end-user characteristics, e.g. viewer profile, preferences
Abstract
The invention discloses a kind of data processing method of programme information and devices, generate the tables of data for analyzing program-related information for broadcasting log according to program.The described method includes: obtaining program broadcasts log；Log, which is broadcasted, according to the program generates listing, advertisement table and person chart；The essential information of the listing includes that channel, program broadcasting time, programm name and program where program click number；Log, which is broadcasted, according to the program generates user's table；The essential information of user's table includes user's browsing pages information, user broadcasting video information, user's answering information, user's lottery information, user's sharing information.After the program is analyzed by the program broadcast log to each channel program and extracts relevant information, all kinds of tables of data that can be used for subsequent analysis are generated, working efficiency is improved.
Description
Technical field
The present invention relates to data processing field, in particular to the data processing method and device of a kind of programme information.
Background technique
With the development of science and technology and the raising of living standards of the people, the program for watching each channel have become people's work
Make, study, social and irreplaceable amusement and recreation important way.In the playing process of each channel program, it can give birth to automatically
Log, and increasing with various programs and channel are broadcasted at a large amount of program, the program of generation broadcasts the data content of log
Also more and more, available many relevant informations in log are broadcasted from a large amount of program, for example the program of user preferences is assorted
, the regional distribution of user preferences program, the advertisement type of user's concern and what program launch the effect of advertisement most
OK etc., but lack the method that a kind of pair of program broadcasts log progress statistics and analysis and obtain relevant information at present.
Summary of the invention
The present invention provides the data processing method and device of a kind of programme information, is broadcasted by the program to each channel program
After log is analyzed and extracts relevant information, all kinds of tables of data that can be used for subsequent analysis are generated, improve work effect
Rate.
According to a first aspect of the embodiments of the present invention, a kind of data processing method of programme information is provided, comprising:
It obtains program and broadcasts log；
Log, which is broadcasted, according to the program generates listing, advertisement table and person chart；The essential information of the listing
Number is clicked including channel, program broadcasting time, programm name and program where program；The essential information of the advertisement table includes
The time that advertiser, ad click number and advertisement are clicked every time；The essential information of the person chart includes position locating for user
It sets, the programm name that user is watched using equipment, user's gender, User ID and user；
Log, which is broadcasted, according to the program generates user's table；The essential information of user's table includes user's browsing pages letter
Breath, user play video information, user's answering information, user's lottery information, user's sharing information.
In one embodiment, described that log generation listing, advertisement table and person chart, packet are broadcasted according to the program
It includes:
The program that will acquire broadcasts log and copies as two parts, and broadcasts in log from first part of program of duplication
Extract the essential information of listing, advertisement table and person chart；
Relevant database is written into the essential information of the listing, the advertisement table and the person chart；
It is described that log generation user's table is broadcasted according to the program；Include:
The essential information that simultaneously counting user table is extracted in log is broadcasted from second part of program of duplication；
Memory type database is written into the essential information of user's table.
In one embodiment, the essential information by the listing, the advertisement table and the person chart is write
Enter relevant database, comprising:
Every essential information of the listing of extraction, the advertisement table and the person chart is generated respectively and is somebody's turn to do
The corresponding data of essential information are inserted into sentence；
Whether the data insertion sentence that detection generates reaches preset threshold；
When the quantity of the data insertion sentence of generation reaches preset threshold, data insertion sentence is executed in batches, by each item
Essential information is inserted into respectively in tables of data corresponding in relevant database.
In one embodiment, memory type database is written in the essential information by user's table, comprising:
The essential information of user's table of extraction is generated into data statistics sentence corresponding with the essential information；
It executes data statistics sentence and the statistical result after execution is inserted into number corresponding in memory type database
According in table；
Execute the backup operation of the memory type database.
In one embodiment, the program broadcasts log program broadcast day corresponding for each program of each channel
Will, the quantity of the listing are equal to channel number multiplied by number of programs.
According to a second aspect of the embodiments of the present invention, a kind of data processing equipment of programme information is also provided, comprising:
Module is obtained, broadcasts log for obtaining program；
First tables of data generation module generates listing, advertisement table and personnel for broadcasting log according to the program
Table；The essential information of the listing includes that channel, program broadcasting time, programm name and program where program click number；
The essential information of the advertisement table includes the time that advertiser, ad click number and advertisement are clicked every time；The person chart
Essential information include programm name that user present position, user are watched using equipment, user's gender, User ID and user；
Second tables of data generation module generates user's table for broadcasting log according to the program；The base of user's table
This information includes user's browsing pages information, user broadcasting video information, user's answering information, user's lottery information, Yong Hufen
Enjoy information.
In one embodiment, the first tables of data generation module includes:
First extracting sub-module, the program for will acquire broadcast log and copy as two parts, and from the first of duplication
Part program broadcasts the essential information that listing, advertisement table and person chart are extracted in log；
First write-in submodule, for writing the essential information of the listing, the advertisement table and the person chart
Enter relevant database；
The second tables of data generation module includes:
Second extracting sub-module is extracted and counting user table for broadcasting from second part of the duplication program in log
Essential information；
Second write-in submodule, for memory type database to be written in the essential information of user's table.
In one embodiment, the first write-in submodule includes:
Be inserted into sentence generation unit, the listing, the advertisement table and the person chart for that will extract it is every
Essential information generates data insertion sentence corresponding with this essential information respectively；
Detection unit, for detecting whether the data generated insertion sentence reaches preset threshold；
First execution unit executes in batches number when the quantity for the data insertion sentence in generation reaches preset threshold
According to insertion sentence, each essential information is inserted into respectively in tables of data corresponding in relevant database.
In one embodiment, the second write-in submodule includes:
Sentence generation unit is counted, the essential information of user's table for that will extract generates corresponding with the essential information
Data statistics sentence；
Second execution unit, for executing data statistics sentence and the statistical result after execution being inserted into memory type data
In library in corresponding tables of data；
Backup units, for executing the backup operation of the memory type database.
In one embodiment, the program broadcasts log program broadcast day corresponding for each program of each channel
Will, the quantity of the listing are equal to channel number multiplied by number of programs.
Technical solution provided in an embodiment of the present invention can produce following the utility model has the advantages that obtaining program broadcasts log；According to institute
It states program and broadcasts log generation listing, advertisement table and person chart；The essential information of the listing includes frequency where program
Road, program broadcasting time, programm name and program click number；The essential information of the advertisement table includes advertiser, advertisement point
Hit number and time that advertisement is clicked every time；The essential information of the person chart includes that user present position, user's use are set
The programm name that standby, user's gender, User ID and user watch；Log, which is broadcasted, according to the program generates user's table；The use
The essential information of family table includes user's browsing pages information, user's broadcasting video information, user's answering information, user's prize drawing letter
Breath, user's sharing information.The program by program to each channel program broadcast log analyzed and extract relevant information it
Afterwards, all kinds of tables of data that can be used for subsequent analysis are generated, working efficiency is improved.
Other features and advantages of the present invention will be illustrated in the following description, also, partly becomes from specification
It obtains it is clear that understand through the implementation of the invention.The objectives and other advantages of the invention can be by written explanation
Specifically noted structure is achieved and obtained in book, claims and attached drawing.
Below by drawings and examples, technical scheme of the present invention will be described in further detail.
Detailed description of the invention
Attached drawing is used to provide further understanding of the present invention, and constitutes part of specification, with reality of the invention
It applies example to be used to explain the present invention together, not be construed as limiting the invention.
In the accompanying drawings:
Fig. 1 is a kind of present invention process of the data processing method of programme information shown according to an exemplary embodiment
Figure.
Fig. 2 is the process of the data processing method of the present invention another programme information shown according to an exemplary embodiment
Figure.
Fig. 3 is step S202 in the data processing method of present invention programme information shown according to an exemplary embodiment
Flow chart.
Fig. 4 is step S302 in the data processing method of present invention programme information shown according to an exemplary embodiment
Flow chart.
Fig. 5 is a kind of present invention block diagram of the data processing equipment of programme information shown according to an exemplary embodiment.
Fig. 6 is the frame of the data processing equipment of the present invention another programme information shown according to an exemplary embodiment
Figure.
Fig. 7 is the first write-in in the data processing equipment of present invention programme information shown according to an exemplary embodiment
The block diagram of module 622.
Fig. 8 is the second write-in in the data processing equipment of present invention programme information shown according to an exemplary embodiment
The block diagram of module 632.
Specific embodiment
Hereinafter, preferred embodiments of the present invention will be described with reference to the accompanying drawings, it should be understood that preferred reality described herein
Apply example only for the purpose of illustrating and explaining the present invention and is not intended to limit the present invention.
The embodiment of the present disclosure provides a kind of data processing method of programme information, for passing through the section to each channel program
After mesh broadcast log is analyzed and extracts relevant information, all kinds of tables of data that can be used for subsequent analysis are generated, are improved
Working efficiency.As shown in Figure 1, the method comprising the steps of S10-S30:
In step slo, it obtains program and broadcasts log；Wherein, the program broadcasts log as each program institute of each channel
Corresponding program broadcasts log, that is, program broadcasts log and channel number and number of programs has relationship, program broadcasts log
Quantity should be equal to channel number multiplied by number of programs.When program broadcasts, the relevant information that program broadcasts will be recorded in institute
It states program to broadcast in log, and the program on the day of broadcasts after finishing, so that it may which the program for obtaining the same day broadcasts log.
In step S20, log is broadcasted according to the program and generates listing, advertisement table and person chart；The program
The essential information of table includes that channel, program broadcasting time, programm name and program where program click number；It is intelligible, institute
The essential information for stating listing is not limited to according to analysis to need that other content is added for the above content；One
In a embodiment, the program broadcasts log program corresponding for each program of each channel and broadcasts log, the program
The quantity of table is equal to channel number multiplied by number of programs.The essential information of the advertisement table includes advertiser, ad click number and wide
Accuse the time being clicked every time；The essential information of the person chart includes user present position, user using equipment, Yong Huxing
Not, the programm name that User ID and user watch；Intelligible, the essential information of the advertisement table and the person chart is simultaneously unlimited
Due to for the above content, according to analysis can also need that other content is added.
In step s 30, log is broadcasted according to the program and generates user's table；The essential information of user's table includes using
Family browsing pages information, user play video information, user's answering information, user's lottery information, user's sharing information.It is appreciated that
, the essential information of user's table is not limited to according to analysis to need that other content is added for the above content.
In one embodiment, as shown in Fig. 2, the step S20 includes:
Step S201, the program that will acquire broadcasts log and copies as two parts, and from first part of program of duplication
Broadcast the essential information that listing, advertisement table and person chart are extracted in log；That is, due to listing, advertisement table and people
Relevant database will be written in member's table, and memory type database will be written in user's table, due to two databases write-in data
Data source is required to a program and broadcasts log, it is therefore desirable to and the program that first will acquire broadcasts log and copies as two parts,
And a copy of it is used to extract the essential information of listing, advertisement table and person chart；The essential information of the listing includes
Channel, program broadcasting time, programm name and program click number where program；It is intelligible, the basic letter of the listing
Breath is not limited to according to analysis to need that other content is added for the above content；In one embodiment, the section
Mesh broadcasts log program corresponding for each program of each channel and broadcasts log, and the quantity of the listing is equal to channel number
Multiplied by number of programs.The essential information of the advertisement table includes the time that advertiser, ad click number and advertisement are clicked every time；
The essential information of the person chart includes that user present position, user are watched using equipment, user's gender, User ID and user
Programm name；Intelligible, the essential information of the advertisement table and the person chart is not limited to as the above content, can be with
According to analysis need that other content is added.
Step S202, relationship type number is written into the essential information of the listing, the advertisement table and the person chart
According to library.
In one embodiment, as shown in figure 3, the step S202 includes:
Step S2021, by every essential information of the listing of extraction, the advertisement table and the person chart point
It Sheng Cheng not data insertion sentence corresponding with this essential information；That is, dividing first after reading a program and broadcasting log
It analyses this program and broadcasts the content of each field of log, and detect the difference of target data table structure, when target matrix is relationship
When the associated data table of type database, is broadcasted in log from every program and extract and generate and the essential information of corresponding tables of data
Corresponding several datas are inserted into sentence.
Step S2022, whether the data insertion sentence that detection generates reaches preset threshold；That is, detection generate and not
Whether the data insertion sentence of execution reaches preset threshold, when the data insertion sentence for generating and being not carried out reaches preset threshold
When, data insertion sentence is executed in batches in step S2023, and data are inserted into corresponding tables of data.Wherein, the default threshold
Value, which can according to need, to be set.
Step S2023, when the quantity of the data insertion sentence of generation reaches preset threshold, data parenthesis is executed in batches
Sentence, each essential information is inserted into respectively in tables of data corresponding in relevant database.
As shown in Fig. 2, the step S30 includes:
Step S301, the essential information that simultaneously counting user table is extracted in log is broadcasted from second part of program of duplication；
After the program broadcast log that will acquire copies as two parts, is broadcasted from a program therein and extracted in log and count use
The essential information of family table, the essential information of user's table include user's browsing pages information, user broadcasting video information, user
Answering information, user's lottery information, user's sharing information.It is intelligible, the essential information of user's table be not limited to for
The above content according to analysis can also need that other content is added.
Step S302, memory type database is written into the essential information of user's table.
In one embodiment, as shown in figure 4, the step S302 includes:
Step S3021, the essential information of user's table of extraction is generated into data statistics corresponding with the essential information
Sentence；That is, the content that this program broadcasts each field of log is analyzed first after reading a program and broadcasting log, and
The difference for detecting target data table structure, when target matrix is the associated data table of memory type database, from every program
It broadcasts and is extracted in log and generate data statistics sentence corresponding with the essential information of corresponding tables of data.
Step S3022, execute data statistics sentence and by the statistical result after execution be inserted into memory type database with
In its corresponding tables of data；In this step, it executes data statistics sentence and statistical result is written in memory type database
In tables of data.
Step S3023, data are remained to hard disk, to avoid service by the backup operation for executing the memory type database
Think highly of loss of data caused by opening.
The above method provided in an embodiment of the present invention obtains program and broadcasts log；Log is broadcasted according to the program to generate
Listing, advertisement table and person chart；The essential information of the listing includes channel, program broadcasting time, section where program
Mesh title and program click number；The essential information of the advertisement table includes advertiser, ad click number and advertisement quilt every time
The time of click；The essential information of the person chart includes user present position, user using equipment, user's gender, User ID
The programm name watched with user；Log, which is broadcasted, according to the program generates user's table；The essential information of user's table includes
User's browsing pages information, user play video information, user's answering information, user's lottery information, user's sharing information.The party
After case is analyzed by the program broadcast log to each channel program and extracts relevant information, after generating all kinds of can be used for
The tables of data of continuous analysis, improves working efficiency.
The data processing method of corresponding programme information provided in an embodiment of the present invention, the present invention also provides the numbers of programme information
According to processing unit, as shown in figure 5, the device can include:
Module 61 is obtained, broadcasts log for obtaining program；
First tables of data generation module 62 generates listing, advertisement table and people for broadcasting log according to the program
Member's table；The essential information of the listing includes that channel, program broadcasting time, programm name and program where program click people
Number；The essential information of the advertisement table includes the time that advertiser, ad click number and advertisement are clicked every time；The personnel
The essential information of table includes the program names that user present position, user are watched using equipment, user's gender, User ID and user
Claim；
Second tables of data generation module 63 generates user's table for broadcasting log according to the program；User's table
Essential information includes user's browsing pages information, user broadcasting video information, user's answering information, user's lottery information, user
Sharing information.
In one embodiment, as shown in fig. 6, the first tables of data generation module 62 includes:
First extracting sub-module 621, the program for will acquire broadcast log and copy as two parts, and from the of duplication
A program broadcasts the essential information that listing, advertisement table and person chart are extracted in log；
First write-in submodule 622, for by the essential information of the listing, the advertisement table and the person chart
Relevant database is written；
The second tables of data generation module 63 includes:
Second extracting sub-module 631 extracts simultaneously counting user for broadcasting from second part of program of duplication in log
The essential information of table；
Second write-in submodule 632, for memory type database to be written in the essential information of user's table.
In one embodiment, as shown in fig. 7, the first write-in submodule 622 includes:
It is inserted into sentence generation unit 6221, the listing, the advertisement table and the person chart for that will extract
Every essential information generate corresponding with this essential information data insertion sentence respectively；
Detection unit 6222, for detecting whether the data generated insertion sentence reaches preset threshold；
First execution unit 6223 is held in batches when the quantity for the data insertion sentence in generation reaches preset threshold
Row data are inserted into sentence, and each essential information is inserted into respectively in tables of data corresponding in relevant database.
In one embodiment, as shown in figure 8, the second write-in submodule 632 includes:
Sentence generation unit 6321 is counted, the essential information of user's table for that will extract generates and the essential information
Corresponding data statistics sentence；
Second execution unit 6322, for executing data statistics sentence and the statistical result after execution being inserted into memory type
In database in corresponding tables of data；
Backup units 6323, for executing the backup operation of the memory type database.
In one embodiment, the program broadcasts log program broadcast day corresponding for each program of each channel
Will, the quantity of the listing are equal to channel number multiplied by number of programs.
It should be understood by those skilled in the art that, the embodiment of the present invention can provide as method, system or computer program
Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the present invention
Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the present invention, which can be used in one or more,
The shape for the computer program product implemented in usable storage medium (including but not limited to magnetic disk storage and optical memory etc.)
Formula.
The present invention be referring to according to the method for the embodiment of the present invention, the process of equipment (system) and computer program product
Figure and/or block diagram describe.It should be understood that every one stream in implementation flow chart and/or block diagram can be requested by computer program
The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs
Request the processor to general purpose computer, special purpose computer, Embedded Processor or other programmable information processing equipments to produce
A raw machine, so that being generated by the request that computer or the processor of other programmable information processing equipments execute for real
The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.
The request of these computer programs, which may also be stored in, is able to guide computer or other programmable information processing equipments with spy
Determine in the computer-readable memory that mode works, so that it includes asking that request stored in the computer readable memory, which generates,
Seek the manufacture of device, the request unit realize in one box of one or more flows of the flowchart and/or block diagram or
The function of being specified in multiple boxes.
The request of these computer programs can also be loaded into computer or other programmable information processing equipments, so that counting
Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or
The request executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one
The step of function of being specified in a box or multiple boxes.
Obviously, various changes and modifications can be made to the invention without departing from essence of the invention by those skilled in the art
Mind and range.In this way, if these modifications and changes of the present invention belongs to the range of the claims in the present invention and its equivalent technologies
Within, then the present invention is also intended to include these modifications and variations.
Claims (4)
1. a kind of data processing method of programme information characterized by comprising
It obtains program and broadcasts log；
Log, which is broadcasted, according to the program generates listing, advertisement table and person chart；The essential information of the listing includes
Channel, program broadcasting time, programm name and program click number where program；The essential information of the advertisement table includes advertisement
The time that main, ad click number and advertisement are clicked every time；The essential information of the person chart includes user present position, uses
The programm name that family is watched using equipment, user's gender, User ID and user；
Log, which is broadcasted, according to the program generates user's table；The essential information of user's table include user's browsing pages information,
User plays video information, user's answering information, user's lottery information, user's sharing information；
It is described that log generation listing, advertisement table and person chart are broadcasted according to the program, comprising:
The program that will acquire broadcasts log and copies as two parts, and broadcasts in log and extract from first part of program of duplication
The essential information of listing, advertisement table and person chart；
Relevant database is written into the essential information of the listing, the advertisement table and the person chart；
It is described that log generation user's table is broadcasted according to the program；Include:
The essential information that simultaneously counting user table is extracted in log is broadcasted from second part of program of duplication；
Memory type database is written into the essential information of user's table；
Relevant database is written in the essential information by the listing, the advertisement table and the person chart, comprising:
Every essential information of the listing of extraction, the advertisement table and the person chart is generated and this base respectively
The corresponding data of this information are inserted into sentence；
Whether the data insertion sentence that detection generates reaches preset threshold；
When the quantity of the data insertion sentence of generation reaches preset threshold, data insertion sentence is executed in batches, each item is basic
Information is inserted into respectively in tables of data corresponding in relevant database；
Memory type database is written in the essential information by user's table, comprising:
The essential information of user's table of extraction is generated into data statistics sentence corresponding with the essential information；
It executes data statistics sentence and the statistical result after execution is inserted into tables of data corresponding in memory type database
In；
Execute the backup operation of the memory type database.
2. the method as described in claim 1, which is characterized in that the program broadcasts log as each program institute difference of each channel
Corresponding program broadcasts log, and the quantity of the listing is equal to channel number multiplied by number of programs.
3. a kind of data processing equipment of programme information characterized by comprising
Module is obtained, broadcasts log for obtaining program；
First tables of data generation module generates listing, advertisement table and person chart for broadcasting log according to the program；Institute
The essential information for stating listing includes that channel, program broadcasting time, programm name and program where program click number；It is described wide
The essential information of announcement table includes the time that advertiser, ad click number and advertisement are clicked every time；The person chart it is basic
Information includes the programm name that user present position, user are watched using equipment, user's gender, User ID and user；
Second tables of data generation module generates user's table for broadcasting log according to the program；The basic letter of user's table
Breath includes user's browsing pages information, user's broadcasting video information, user's answering information, user's lottery information, user's sharing letter
Breath；
The first tables of data generation module includes:
First extracting sub-module, the program for will acquire broadcast log and copy as two parts, and from first part of institute of duplication
It states program and broadcasts the essential information for extracting listing, advertisement table and person chart in log；
First write-in submodule, is closed for the essential information of the listing, the advertisement table and the person chart to be written
It is type database；
The second tables of data generation module includes:
Second extracting sub-module, for broadcasted from second part of the duplication program extracted in log and counting user table it is basic
Information；
Second write-in submodule, for memory type database to be written in the essential information of user's table；
Described first, which is written submodule, includes:
It is inserted into sentence generation unit, every base of the listing, the advertisement table and the person chart for that will extract
This information generates data insertion sentence corresponding with this essential information respectively；
Detection unit, for detecting whether the data generated insertion sentence reaches preset threshold；
First execution unit executes in batches data and inserts when the quantity for the data insertion sentence in generation reaches preset threshold
Enter sentence, each essential information is inserted into respectively in tables of data corresponding in relevant database；
Described second, which is written submodule, includes:
Sentence generation unit is counted, the essential information of user's table for that will extract generates number corresponding with the essential information
Sentence according to statistics；
Second execution unit, for executing data statistics sentence and the statistical result after execution being inserted into memory type database
In corresponding tables of data；
Backup units, for executing the backup operation of the memory type database.
4. device as claimed in claim 3, which is characterized in that the program broadcasts log as each program institute difference of each channel
Corresponding program broadcasts log, and the quantity of the listing is equal to channel number multiplied by number of programs.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610377174.9A CN105898540B (en) | 2016-05-31 | 2016-05-31 | A kind of data processing method and device of programme information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610377174.9A CN105898540B (en) | 2016-05-31 | 2016-05-31 | A kind of data processing method and device of programme information |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105898540A CN105898540A (en) | 2016-08-24 |
| CN105898540B true CN105898540B (en) | 2019-04-12 |
Family
ID=56709145
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610377174.9A Expired - Fee Related CN105898540B (en) | 2016-05-31 | 2016-05-31 | A kind of data processing method and device of programme information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105898540B (en) |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| DE19914101C1 (en) * | 1999-03-22 | 2000-10-12 | Schering Ag | Perfluoroalkylamides, their preparation and their use in diagnostics |
| CN1980381B (en) * | 2005-12-08 | 2010-07-14 | 厦门雅迅网络股份有限公司 | Taxi networked advertisement playing effect data processing method |
| CN101071496A (en) * | 2006-05-10 | 2007-11-14 | 北京中青凯诚网络电视传媒有限公司 | Intelligent advertising playing method |
| CA2697481C (en) * | 2007-08-24 | 2013-03-26 | Lg Electronics Inc. | Digital broadcasting system and method of processing data in digital broadcasting system |
| CN104182438A (en) * | 2014-02-25 | 2014-12-03 | 无锡天脉聚源传媒科技有限公司 | Message counting method and device |
| CN103942707B8 (en) * | 2014-04-08 | 2018-06-29 | 璧合科技股份有限公司 | Advertising results optimization system based on real time bid |
| CN104317939A (en) * | 2014-10-31 | 2015-01-28 | 北京思特奇信息技术股份有限公司 | Log statistics method and system on basis of digital film playing server |
-
2016
- 2016-05-31 CN CN201610377174.9A patent/CN105898540B/en not_active Expired - Fee Related
Also Published As
| Publication number | Publication date |
|---|---|
| CN105898540A (en) | 2016-08-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Law et al. | Systematic review and validation of the game experience questionnaire (geq)-implications for citation and reporting practice | |
| US10390094B2 (en) | Methods and apparatus to create a panel of media device users | |
| CN108108996B (en) | Method and device for delivering advertisements in video, computer equipment and readable medium | |
| CN107832437B (en) | Audio/video pushing method, device, equipment and storage medium | |
| CN108965956B (en) | Method, medium, server and system for providing video presentation comments | |
| Shimada et al. | Automatic summarization of lecture slides for enhanced student previewtechnical report and user study | |
| CN109511015B (en) | Multimedia resource recommendation method, device, storage medium and equipment | |
| CN102216945B (en) | Networking with media fingerprints | |
| JP2012227873A (en) | Comment distribution system, operating method of the same, and program | |
| RU2011113814A (en) | METHOD FOR PROVIDING FAVORITE FAVORITE AUDIO-VISUAL FILES TO THE USER ON A CONSTANT BASIS | |
| CN112507163A (en) | Duration prediction model training method, recommendation method, device, equipment and medium | |
| JP2019520011A (en) | Media Environment Driven Content Delivery Platform | |
| Cummins et al. | Mediated intra-audience effects in the appreciation of broadcast sports | |
| Wu | Agenda-setting in cross-national coverage of COVID-19: an analysis of elite newspapers in US and China with topic modeling | |
| CN105898540B (en) | A kind of data processing method and device of programme information | |
| CN106060589B (en) | A kind of analysis method and device of programme information | |
| CN105979287B (en) | Program keyword extraction and statistics method and device | |
| CN110225374A (en) | The user information acquiring and processing method of Interactive Internet TV | |
| Cummins et al. | Sight versus sound: The differential impact of mediated spectator response in sport broadcasts | |
| Pharo | The effect of granularity and order in XML element retrieval | |
| KR100768074B1 (en) | System for offering advertisement moving picture and service method thereof | |
| Löbbers et al. | Seeing sounds, hearing shapes: a gamified study to evaluate sound-sketches | |
| KR101821602B1 (en) | System to insert a customized information of video content | |
| McGrady et al. | Dialing for Videos: A Random Sample of YouTube | |
| Romão et al. | Designing a system for the automatic generation of sport video summaries |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: A data processing method and device for program information Effective date of registration: 20210104 Granted publication date: 20190412 Pledgee: Inner Mongolia Huipu Energy Co.,Ltd. Pledgor: WUXI TVMINING MEDIA SCIENCE & TECHNOLOGY Co.,Ltd. Registration number: Y2020990001517 |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20190412 Termination date: 20210531 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |