CN105898540A - Program information data processing method and device - Google Patents
Program information data processing method and device Download PDFInfo
- Publication number
- CN105898540A CN105898540A CN201610377174.9A CN201610377174A CN105898540A CN 105898540 A CN105898540 A CN 105898540A CN 201610377174 A CN201610377174 A CN 201610377174A CN 105898540 A CN105898540 A CN 105898540A
- Authority
- CN
- China
- Prior art keywords
- program
- user
- information
- essential information
- daily record
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Multimedia (AREA)
- Signal Processing (AREA)
- Computer Networks & Wireless Communication (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Social Psychology (AREA)
- Two-Way Televisions, Distribution Of Moving Picture Or The Like (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a program information data processing method and device. The method and the device are used for producing data tables for analyzing program related information according to program broadcast logs. The method comprises following steps of obtaining the program broadcast logs; producing a program table, an advertisement table and a personnel table according to the program broadcast logs, wherein the basic information of the program table comprises program channels, program broadcast time, program names and program click number of people; and producing a user table according to the program broadcast logs, wherein the basic information of the user table comprises user browse page information, user broadcast video information, user answer information, user lottery information and user sharing information. According to the scheme, after related information is analyzed and extracted from the program broadcast logs of the channel programs, various data tables for follow-up analysis are produced, and the working efficiency is improved.
Description
Technical field
The present invention relates to data processing field, particularly to data processing method and the dress of a kind of programme information
Put.
Background technology
Along with development and the raising of living standards of the people of science and technology, the program viewing and admiring each channel has become as
People's work, study, the social and irreplaceable important way of amusement and recreation.Broadcasting of each channel program
During putting, substantial amounts of program can be automatically generated and broadcast daily record, and increasing along with various programs and channel,
The program produced broadcasts the data content of daily record and also gets more and more, and broadcasts daily record can obtain from substantial amounts of program
What the program taking a lot of relevant information, such as user preferences is, the regional distribution of user preferences program,
The adline that user pays close attention to, and any program throws in the effect of advertisement preferably etc., but lack one at present
Program is broadcasted daily record and carries out statistics and analysis the method obtaining relevant information.
Summary of the invention
The present invention provides data processing method and the device of a kind of programme information, by the joint to each channel program
After mesh broadcast daily record is analyzed and extracts relevant information, generate all kinds of data that may be used for subsequent analysis
Table, improves work efficiency.
First aspect according to embodiments of the present invention, it is provided that the data processing method of a kind of programme information, including:
Obtain program and broadcast daily record；
Broadcast daily record according to described program and generate listing, advertisement table and person chart；The base of described listing
This information includes that program place channel, program broadcasting time, programm name and program click on number；Described extensively
The essential information of announcement table includes the time that advertiser, ad click number of times and advertisement are the most clicked；Described people
The essential information of member's table includes that user present position, user use equipment, user's sex, ID and use
The programm name that family is watched；
Broadcast daily record according to described program and generate user's table；The essential information of described user's table includes that user browses
Page info, user play video information, user's answering information, user draw a lottery information, user's sharing information.
In one embodiment, described according to described program broadcast daily record generation listing, advertisement table and people
Member's table, including:
The described program obtained is broadcasted daily record and copies as two parts, and broadcast from the first part of described program replicated
Daily record is extracted listing, advertisement table and the essential information of person chart；
The essential information of described listing, described advertisement table and described person chart is write relational data
Storehouse；
Described according to described program broadcast daily record generation user's table；Including:
Broadcast from the second part of described program replicated and daily record is extracted and the essential information of counting user table；
The essential information of described user's table is write internal memory type data base.
In one embodiment, described basic by described listing, described advertisement table and described person chart
Information write relevant database, including:
Every essential information of the described listing, described advertisement table and the described person chart that extract is given birth to respectively
The data becoming corresponding with this essential information insert statement；
The data that detection generates insert whether statement reaches predetermined threshold value；
When the quantity that the data generated insert statement reaches predetermined threshold value, batch performs data and inserts statement,
Each bar essential information is inserted in tables of data corresponding in relevant database respectively.
In one embodiment, described by the essential information write internal memory type data base of described user's table, bag
Include:
The essential information of the described user's table extracted is generated the data statistics statement corresponding with this essential information；
It is right with it that statistical result after performing data statistics statement and performing is inserted in internal memory type data base
In the tables of data answered；
Perform the backup operation of described internal memory type data base.
In one embodiment, described program broadcast daily record be each channel each program institute difference correspondence joint
Mesh broadcasts daily record, and the quantity of described listing is multiplied by number of programs equal to channel number.
Second aspect according to embodiments of the present invention, also provides for the data processing equipment of a kind of programme information, bag
Include:
Acquisition module, is used for obtaining program and broadcasts daily record；
First tables of data generation module, for according to described program broadcast daily record generate listing, advertisement table with
And person chart；The essential information of described listing includes program place channel, program broadcasting time, program names
Claim and program clicks on number；The essential information of described advertisement table includes advertiser, ad click number of times and advertisement
The most clicked time；The essential information of described person chart include user present position, user use equipment,
The programm name that user's sex, ID and user watch；
Second tables of data generation module, generates user's table for broadcasting daily record according to described program；Described user
The essential information of table includes that user's browsing pages information, user play video information, user's answering information, use
Family prize drawing information, user's sharing information.
In one embodiment, described first tables of data generation module includes:
First extracts submodule, copies as two parts for the described program obtained is broadcasted daily record, and from duplication
First part of described program broadcast daily record extracted listing, advertisement table and the essential information of person chart；
First write submodule, basic for by described listing, described advertisement table and described person chart
Information write relevant database；
Described second tables of data generation module includes:
Second extracts submodule, extracts for broadcasting from the second part of described program replicated and adds up use daily record
The essential information of family table；
Second write submodule, for writing internal memory type data base by the essential information of described user's table.
In one embodiment, described first write submodule includes:
Insert statement signal generating unit, for described listing, described advertisement table and the described personnel that will extract
Every essential information of table generates the data corresponding with this essential information respectively and inserts statement；
For detecting the data of generation, detector unit, inserts whether statement reaches predetermined threshold value；
First performance element, is used for when the quantity that the data generated insert statement reaches predetermined threshold value, in batches
Perform data and insert statement, each bar essential information is inserted into number corresponding in relevant database respectively
According in table.
In one embodiment, described second write submodule includes:
Statistics statement signal generating unit, believes with this substantially for the essential information of the described user's table extracted being generated
The data statistics statement that breath is corresponding；
Second performance element, the statistical result after performing data statistics statement and performing is inserted into internal memory
In tables of data corresponding in type data base；
Backup units, for performing the backup operation of described internal memory type data base.
In one embodiment, described program broadcast daily record be each channel each program institute difference correspondence joint
Mesh broadcasts daily record, and the quantity of described listing is multiplied by number of programs equal to channel number.
The technical scheme that the embodiment of the present invention provides can produce following beneficial effect: obtains program and broadcasts daily record；
Broadcast daily record according to described program and generate listing, advertisement table and person chart；The basic letter of described listing
Breath includes that program place channel, program broadcasting time, programm name and program click on number；Described advertisement table
Essential information include the time that advertiser, ad click number of times and advertisement are the most clicked；Described person chart
Essential information include that user present position, user use equipment, user's sex, ID and user to receive
The programm name seen；Broadcast daily record according to described program and generate user's table；The essential information bag of described user's table
Include user's browsing pages information, user plays video information, user's answering information, user draw a lottery information, use
Family sharing information.The program is analyzed by the program of each channel program broadcasts daily record and extracts relevant letter
After breath, generate all kinds of tables of data that may be used for subsequent analysis, improve work efficiency.
Other features and advantages of the present invention will illustrate in the following description, and, partly from explanation
Book becomes apparent, or understands by implementing the present invention.The purpose of the present invention and other advantages can
Realize by structure specifically noted in the description write, claims and accompanying drawing and obtain
?.
Below by drawings and Examples, technical scheme is described in further detail.
Accompanying drawing explanation
Accompanying drawing is for providing a further understanding of the present invention, and constitutes a part for description, with this
Bright embodiment is used for explaining the present invention together, is not intended that limitation of the present invention.
In the accompanying drawings:
Fig. 1 is the present invention data processing method according to a kind of programme information shown in an exemplary embodiment
Flow chart.
Fig. 2 is the present invention data processing method according to the another kind of programme information shown in an exemplary embodiment
Flow chart.
Fig. 3 is that the present invention is according to step in the data processing method of the programme information shown in an exemplary embodiment
The flow chart of S202.
Fig. 4 is that the present invention is according to step in the data processing method of the programme information shown in an exemplary embodiment
The flow chart of S302.
Fig. 5 is the present invention data processing equipment according to a kind of programme information shown in an exemplary embodiment
Block diagram.
Fig. 6 is the present invention data processing equipment according to the another kind of programme information shown in an exemplary embodiment
Block diagram.
Fig. 7 is that the present invention is according in the data processing equipment of the programme information shown in an exemplary embodiment first
The block diagram of write submodule 622.
Fig. 8 is that the present invention is according in the data processing equipment of the programme information shown in an exemplary embodiment second
The block diagram of write submodule 632.
Detailed description of the invention
Below in conjunction with accompanying drawing, the preferred embodiments of the present invention are illustrated, it will be appreciated that described herein
Preferred embodiment is merely to illustrate and explains the present invention, is not intended to limit the present invention.
Disclosure embodiment provides the data processing method of a kind of programme information, for by saving each channel
Purpose program broadcasts after daily record is analyzed and extracts relevant information, generates and all kinds of may be used for subsequent analysis
Tables of data, improve work efficiency.As it is shown in figure 1, the method comprising the steps of S10-S30:
In step slo, obtain program and broadcast daily record；Wherein, described program broadcasts daily record is each channel
Each program is distinguished the program of correspondence and is broadcasted daily record, that is, program broadcast daily record is equal with channel number and number of programs
Having relation, program broadcasts the quantity of daily record should be multiplied by number of programs equal to channel number.When program broadcasts, just
The relevant information record that program broadcasts can be broadcasted in the middle of daily record at described program, and the program on the same day broadcasts
After complete, it is possible to the program obtaining the same day broadcasts daily record.
In step S20, broadcast daily record according to described program and generate listing, advertisement table and person chart；
The essential information of described listing includes program place channel, program broadcasting time, programm name and program point
Hit number；Intelligible, the essential information of described listing is not limited to as above content, it is also possible to root
Addition other guide is needed according to analyze；In one embodiment, described program broadcasts daily record is each channel
Each program is distinguished the program of correspondence and is broadcasted daily record, and the quantity of described listing is multiplied by program equal to channel number
Number.The essential information of described advertisement table include advertiser, ad click number of times and advertisement the most clicked time
Between；The essential information of described person chart includes that user present position, user use equipment, user's sex, use
The programm name that family ID and user watch；Intelligible, described advertisement table is believed with the basic of described person chart
Breath is not limited to as above content, it is also possible to need addition other guide according to analyze.
In step s 30, broadcast daily record according to described program and generate user's table；The basic letter of described user's table
Breath includes that user's browsing pages information, user play video information, user's answering information, user draw a lottery information,
User's sharing information.Intelligible, the essential information of described user's table is not limited to as above content, also
Addition other guide can be needed according to analyze.
In one embodiment, as in figure 2 it is shown, described step S20 includes:
Step S201, by obtain described program broadcast daily record copy as two parts, and from replicate first part of institute
State program and broadcast extraction listing, advertisement table and the essential information of person chart in daily record；That is, due to joint
Mesh table, advertisement table and person chart will write relevant database, and user's table will write internal memory type number
According to storehouse, it is required to a program broadcasts daily record owing to two data bases writes the Data Source of data, it is therefore desirable to
First the described program obtained is broadcasted daily record and copy as two parts, and a copy of it is used for extracting listing, advertisement
Table and the essential information of person chart；The essential information of described listing includes that program place channel, program are broadcast
Go out time, programm name and program and click on number；Intelligible, the essential information of described listing does not limit
Schedule as above content, it is also possible to need addition other guide according to analyze；In one embodiment, institute
State program broadcast daily record be each channel each program institute difference correspondence program broadcast daily record, described listing
Quantity is multiplied by number of programs equal to channel number.The essential information of described advertisement table includes advertiser, ad click
The time that number is the most clicked with advertisement；The essential information of described person chart includes user present position, user
The programm name that use equipment, user's sex, ID and user watch；Intelligible, described advertisement
Table is not limited to as above content with the essential information of described person chart, it is also possible to the needs according to analyzing add
Enter other guide.
Step S202, the essential information of described listing, described advertisement table and described person chart is write and closes
It is type data base.
In one embodiment, as it is shown on figure 3, described step S202 includes:
Step S2021, described listing, described advertisement table and every the base of described person chart that will extract
This information generates the data corresponding with this essential information respectively and inserts statement；That is, reading a program
After broadcasting daily record, first analyze this program and broadcast the content of each field of daily record, and detect target matrix
The difference of structure, when the associated data table that target matrix is relevant database, broadcasts from every program
Daily record is extracted and generated the some data corresponding with the essential information of corresponding tables of data and inserts statement.
The data that step S2022, detection generate insert whether statement reaches predetermined threshold value；That is, detection is raw
The data become and be not carried out insert whether statement reaches predetermined threshold value, when the data generated and be not carried out are inserted
Entering statement when reaching predetermined threshold value, in step S2023, batch performs data and inserts statement, data is inserted
In corresponding tables of data.Wherein, described predetermined threshold value can be set as required.
Step S2023, generate data insert statement quantity reach predetermined threshold value time, batch perform number
According to inserting statement, each bar essential information is inserted into tables of data corresponding in relevant database respectively
In.
As in figure 2 it is shown, described step S30 includes:
Step S301, broadcast from the second part of described program replicated and daily record is extracted and counting user table basic
Information；After the described program obtained broadcast daily record is copied as two parts, from a program broadcast day therein
Extracting in will and the essential information of counting user table, the essential information of described user's table includes user's browsing pages
Information, user play video information, user's answering information, user draw a lottery information, user's sharing information.Can
Understanding, the essential information of described user's table is not limited to as above content, it is also possible to according to the need analyzed
Other guide to be added.
Step S302, the essential information of described user's table is write internal memory type data base.
In one embodiment, as shown in Figure 4, described step S302 includes:
Step S3021, the essential information of the described user's table extracted is generated the number corresponding with this essential information
Statement according to statistics；That is, after reading a program and broadcasting daily record, first analyze this program broadcast day
The content of each field of will, and detect the difference of target data list structure, when target matrix is internal memory type data
During the associated data table in storehouse, broadcast extract and generate with corresponding tables of data in daily record basic from every program
The data statistics statement that information is corresponding.
Step S3022, perform data statistics statement and will perform after statistical result be inserted into internal memory type data
In tables of data corresponding in storehouse；In this step, perform data statistics statement and statistical result is write
In tables of data in internal memory type data base.
Step S3023, perform the backup operation of described internal memory type data base, data are remained to hard disk, with
Avoid the loss of data that Server Restart causes.
The said method that the embodiment of the present invention provides, obtains program and broadcasts daily record；According to described program broadcast day
Will generates listing, advertisement table and person chart；The essential information of described listing include program place channel,
Program broadcasting time, programm name and program click on number；The essential information of described advertisement table include advertiser,
Ad click number of times and advertisement the most clicked time；The essential information of described person chart includes residing for user
Position, user use the programm name that equipment, user's sex, ID and user watch；According to described
Program broadcasts daily record and generates user's table；The essential information of described user's table includes user's browsing pages information, use
Video information is play at family, user's answering information, user draw a lottery information, user's sharing information.The program is passed through
The program of each channel program is broadcasted after daily record is analyzed and extracts relevant information, generate and all kinds of can use
In the tables of data of subsequent analysis, improve work efficiency.
The data processing method of the programme information that the corresponding embodiment of the present invention provides, the present invention also provides for program letter
The data processing equipment of breath, as it is shown in figure 5, this device comprises the steps that
Acquisition module 61, is used for obtaining program and broadcasts daily record；
First tables of data generation module 62, generates listing, advertisement table for broadcasting daily record according to described program
And person chart；The essential information of described listing includes program place channel, program broadcasting time, program
Title and program click on number；The essential information of described advertisement table includes advertiser, ad click number of times and wide
Accuse the most clicked time；The essential information of described person chart includes that user present position, user use and set
The programm name that standby, user's sex, ID and user watch；
Second tables of data generation module 63, generates user's table for broadcasting daily record according to described program；Described use
The essential information of family table include user's browsing pages information, user play video information, user's answering information,
User draws a lottery information, user's sharing information.
In one embodiment, as shown in Figure 6, described first tables of data generation module 62 includes:
First extracts submodule 621, copies as two parts for the described program obtained is broadcasted daily record, and from
The first part of described program replicated broadcasts the basic letter extracting listing, advertisement table and person chart in daily record
Breath；
First write submodule 622, for by described listing, described advertisement table and described person chart
Essential information write relevant database；
Described second tables of data generation module 63 includes:
Second extracts submodule 631, extracts for broadcasting from the second part of described program replicated and unites daily record
The essential information of meter user's table；
Second write submodule 632, for writing internal memory type data base by the essential information of described user's table.
In one embodiment, as it is shown in fig. 7, described first write submodule 622 includes:
Insert statement signal generating unit 6221, for the described listing that will extract, described advertisement table and described
Every essential information of person chart generates the data corresponding with this essential information respectively and inserts statement；
For detecting the data of generation, detector unit 6222, inserts whether statement reaches predetermined threshold value；
First performance element 6223, is used for when the quantity that the data generated insert statement reaches predetermined threshold value,
Batch performs data and inserts statement, is inserted in relevant database corresponding respectively by each bar essential information
Tables of data in.
In one embodiment, as shown in Figure 8, described second write submodule 632 includes:
Statistics statement signal generating unit 6321, the essential information of the described user's table for extracting generates and this base
The data statistics statement that this information is corresponding；
Second performance element 6322, the statistical result after performing data statistics statement and performing is inserted into
In tables of data corresponding in internal memory type data base；
Backup units 6323, for performing the backup operation of described internal memory type data base.
In one embodiment, described program broadcast daily record be each channel each program institute difference correspondence joint
Mesh broadcasts daily record, and the quantity of described listing is multiplied by number of programs equal to channel number.
Those skilled in the art are it should be appreciated that embodiments of the invention can be provided as method, system or meter
Calculation machine program product.Therefore, the present invention can use complete hardware embodiment, complete software implementation or knot
The form of the embodiment in terms of conjunction software and hardware.And, the present invention can use and wherein wrap one or more
Computer-usable storage medium containing computer usable program code (include but not limited to disk memory and
Optical memory etc.) form of the upper computer program implemented.
The present invention is with reference to method, equipment (system) and computer program product according to embodiments of the present invention
The flow chart of product and/or block diagram describe.It should be understood that can by computer program request flowchart and
/ or block diagram in each flow process and/or flow process in square frame and flow chart and/or block diagram and/
Or the combination of square frame.These computer programs can be provided to ask general purpose computer, special-purpose computer, embedding
The processor of formula datatron or other programmable information processing equipments is to produce a machine so that by calculating
The request that the processor of machine or other programmable information processing equipments performs produces for realizing at flow chart one
The device of the function specified in individual flow process or multiple flow process and/or one square frame of block diagram or multiple square frame.
The request of these computer programs may be alternatively stored in and computer or the process of other programmable informations can be guided to set
In the standby computer-readable memory worked in a specific way so that be stored in this computer-readable memory
Request produce and include the manufacture of request unit, this request unit realizes in one flow process or multiple of flow chart
The function specified in flow process and/or one square frame of block diagram or multiple square frame.
The request of these computer programs also can be loaded in computer or other programmable information processing equipments, makes
Sequence of operations step must be performed to produce computer implemented place on computer or other programmable devices
Reason, thus the request performed on computer or other programmable devices provides for realizing flow chart one
The step of the function specified in flow process or multiple flow process and/or one square frame of block diagram or multiple square frame.
Obviously, those skilled in the art can carry out various change and modification without deviating from this to the present invention
The spirit and scope of invention.So, if these amendments of the present invention and modification belong to the claims in the present invention
And within the scope of equivalent technologies, then the present invention is also intended to comprise these change and modification.
Claims (10)
1. the data processing method of a programme information, it is characterised in that including:
Obtain program and broadcast daily record；
Broadcast daily record according to described program and generate listing, advertisement table and person chart；The base of described listing
This information includes that program place channel, program broadcasting time, programm name and program click on number；Described extensively
The essential information of announcement table includes the time that advertiser, ad click number of times and advertisement are the most clicked；Described people
The essential information of member's table includes that user present position, user use equipment, user's sex, ID and use
The programm name that family is watched；
Broadcast daily record according to described program and generate user's table；The essential information of described user's table includes that user browses
Page info, user play video information, user's answering information, user draw a lottery information, user's sharing information.
2. the method for claim 1, it is characterised in that described according to the broadcast daily record of described program
Generate listing, advertisement table and person chart, including:
The described program obtained is broadcasted daily record and copies as two parts, and broadcast from the first part of described program replicated
Daily record is extracted listing, advertisement table and the essential information of person chart；
The essential information of described listing, described advertisement table and described person chart is write relational data
Storehouse；
Described according to described program broadcast daily record generation user's table；Including:
Broadcast from the second part of described program replicated and daily record is extracted and the essential information of counting user table；
The essential information of described user's table is write internal memory type data base.
3. method as claimed in claim 2, it is characterised in that described by described listing, described extensively
Accuse the essential information write relevant database of table and described person chart, including:
Every essential information of the described listing, described advertisement table and the described person chart that extract is given birth to respectively
The data becoming corresponding with this essential information insert statement；
The data that detection generates insert whether statement reaches predetermined threshold value；
When the quantity that the data generated insert statement reaches predetermined threshold value, batch performs data and inserts statement,
Each bar essential information is inserted in tables of data corresponding in relevant database respectively.
4. method as claimed in claim 2, it is characterised in that described by the basic letter of described user's table
Breath write internal memory type data base, including:
The essential information of the described user's table extracted is generated the data statistics statement corresponding with this essential information；
It is right with it that statistical result after performing data statistics statement and performing is inserted in internal memory type data base
In the tables of data answered；
Perform the backup operation of described internal memory type data base.
5. the method for claim 1, it is characterised in that it is each channel that described program broadcasts daily record
Each program distinguished the program of correspondence and broadcasted daily record, the quantity of described listing is multiplied by program equal to channel number
Number.
6. the data processing equipment of a programme information, it is characterised in that including:
Acquisition module, is used for obtaining program and broadcasts daily record；
First tables of data generation module, for according to described program broadcast daily record generate listing, advertisement table with
And person chart；The essential information of described listing includes program place channel, program broadcasting time, program names
Claim and program clicks on number；The essential information of described advertisement table includes advertiser, ad click number of times and advertisement
The most clicked time；The essential information of described person chart include user present position, user use equipment,
The programm name that user's sex, ID and user watch；
Second tables of data generation module, generates user's table for broadcasting daily record according to described program；Described user
The essential information of table includes that user's browsing pages information, user play video information, user's answering information, use
Family prize drawing information, user's sharing information.
7. device as claimed in claim 6, it is characterised in that
Described first tables of data generation module includes:
First extracts submodule, copies as two parts for the described program obtained is broadcasted daily record, and from duplication
First part of described program broadcast daily record extracted listing, advertisement table and the essential information of person chart；
First write submodule, basic for by described listing, described advertisement table and described person chart
Information write relevant database；
Described second tables of data generation module includes:
Second extracts submodule, extracts for broadcasting from the second part of described program replicated and adds up use daily record
The essential information of family table；
Second write submodule, for writing internal memory type data base by the essential information of described user's table.
8. device as claimed in claim 7, it is characterised in that described first write submodule includes:
Insert statement signal generating unit, for described listing, described advertisement table and the described personnel that will extract
Every essential information of table generates the data corresponding with this essential information respectively and inserts statement；
For detecting the data of generation, detector unit, inserts whether statement reaches predetermined threshold value；
First performance element, is used for when the quantity that the data generated insert statement reaches predetermined threshold value, in batches
Perform data and insert statement, each bar essential information is inserted into number corresponding in relevant database respectively
According in table.
9. device as claimed in claim 7, it is characterised in that described second write submodule includes:
Statistics statement signal generating unit, believes with this substantially for the essential information of the described user's table extracted being generated
The data statistics statement that breath is corresponding；
Second performance element, the statistical result after performing data statistics statement and performing is inserted into internal memory
In tables of data corresponding in type data base；
Backup units, for performing the backup operation of described internal memory type data base.
10. device as claimed in claim 6, it is characterised in that it is each channel that described program broadcasts daily record
Each program distinguished the program of correspondence and broadcasted daily record, the quantity of described listing is multiplied by program equal to channel number
Number.
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 true CN105898540A (en) | 2016-08-24 |
| CN105898540B 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) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1344262A (en) * | 1999-03-22 | 2002-04-10 | 舍林股份公司 | Perfuoroalkylamide, prodn. thereof and use thereof in diagnostics |
| CN1980381A (en) * | 2005-12-08 | 2007-06-13 | 厦门雅迅网络股份有限公司 | Taxi networked advertisement playing effect data processing method |
| CN101071496A (en) * | 2006-05-10 | 2007-11-14 | 北京中青凯诚网络电视传媒有限公司 | Intelligent advertising playing method |
| US20090052521A1 (en) * | 2007-08-24 | 2009-02-26 | Lg Electronics Inc. | Digital broadcasting system and method of processing data in digital broadcasting system |
| CN103942707A (en) * | 2014-04-08 | 2014-07-23 | 北京璧合科技有限公司 | Advertising effect optimizing system based on real-time bidding |
| CN104182438A (en) * | 2014-02-25 | 2014-12-03 | 无锡天脉聚源传媒科技有限公司 | Message counting method and device |
| 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
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1344262A (en) * | 1999-03-22 | 2002-04-10 | 舍林股份公司 | Perfuoroalkylamide, prodn. thereof and use thereof in diagnostics |
| CN1980381A (en) * | 2005-12-08 | 2007-06-13 | 厦门雅迅网络股份有限公司 | Taxi networked advertisement playing effect data processing method |
| CN101071496A (en) * | 2006-05-10 | 2007-11-14 | 北京中青凯诚网络电视传媒有限公司 | Intelligent advertising playing method |
| US20090052521A1 (en) * | 2007-08-24 | 2009-02-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 |
| CN103942707A (en) * | 2014-04-08 | 2014-07-23 | 北京璧合科技有限公司 | Advertising effect optimizing system based on real-time bidding |
| CN104317939A (en) * | 2014-10-31 | 2015-01-28 | 北京思特奇信息技术股份有限公司 | Log statistics method and system on basis of digital film playing server |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105898540B (en) | 2019-04-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11069367B2 (en) | Speaker association with a visual representation of spoken content | |
| CN110351578B (en) | Method and system for automatically producing video programs according to scripts | |
| KR101706745B1 (en) | Methods and apparatus to estimate demographics of users employing social media | |
| US10390094B2 (en) | Methods and apparatus to create a panel of media device users | |
| CN110248258A (en) | Recommended method, device, storage medium and the computer equipment of video clip | |
| JP6170023B2 (en) | Content recommendation device, content recommendation method, and content recommendation program | |
| CN107682719A (en) | A kind of monitoring and assessing method and device of live content health degree | |
| Snijder | Revisiting an open access monograph experiment: measuring citations and tweets 5 years later | |
| CN109618224A (en) | Video data handling procedure, device, computer readable storage medium and equipment | |
| CN109472017B (en) | Method and device for obtaining relevant information of text court deeds of referee to be generated | |
| CN111368141A (en) | Video tag expansion method and device, computer equipment and storage medium | |
| MX2011002217A (en) | Distributed digital media metering & reporting system. | |
| CN104679809A (en) | Approach and system for delaying presentation of social media communications | |
| US20200053409A1 (en) | Systems and Methods for Automated Extraction of Closed Captions in Real Time or Near Real-Time and Tagging of Streaming Data for Advertisements | |
| CN108491496A (en) | A kind of processing method and processing device of promotion message | |
| CN106605412A (en) | Improved interface for accessing television programs | |
| CN105979287B (en) | Program keyword extraction and statistics method and device | |
| CN105898540A (en) | Program information data processing method and device | |
| CN106095435B (en) | Information processing method and electronic equipment | |
| CN108073638B (en) | Data diagnosis method and device | |
| Cummins et al. | Sight versus sound: The differential impact of mediated spectator response in sport broadcasts | |
| CN106599209A (en) | News pushing method and device | |
| CN109284364A (en) | A kind of interaction vocabulary update method and device connecting wheat interaction for voice | |
| Hopfgartner et al. | Capturing multiple interests in news video retrieval by incorporating the ostensive model | |
| Mirsalami et al. | Reading the Physical Structure of Mosques on How to Perceive, Behave and Measure Audience Attendance, Case Study: Traditional and Contemporary Mosques in Qazvin |
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 | ||
| 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 |
|
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20190412 Termination date: 20210531 |