The method and apparatus for building mapping database, the method and apparatus of program push
Technical field
The present invention relates to multimedia technology field, more particularly to a kind of method and apparatus for building mapping database, one
The method and apparatus of kind program push.
Background technology
In the last few years, developing rapidly with multimedia technology, various terminals are also developing rapidly, and its function is also increasingly
Increase.Terminal can provide the user the sound of higher quality, picture, meet the various demands of user, have become people's life
Essential a kind of equipment in work.Intellectuality is the development trend of present multimedia terminal, builds cloud platform, there is provided is put down based on cloud
The rich and varied service of platform is intelligentized important content.Current most manufacturers have released the end product based on cloud platform
And propose the concept and pattern of " a cloud multi-screen ".Competition between different brands manufacturer handles energy via original hardware data
The competition of power and audio playback capability, progressively turn on the competition of content and service ability.
In the processing based on cloud platform, content-aggregated is an important content service, is a kind of establish in cloud platform
On the basis of, centered on user service, according to existing operation platform and professional ability, inside and outside money is integrated for target market
Source, form user, businessman, other participants in the market create the network commercial pattern of value jointly.The content for providing high quality is gathered
Close, user can be allowed to be easier to search and share new content resource, preferably enjoy network service, constantly lift user's body
Test, be finally reached the absorption affinity for improving user's stickiness and increasing intelligent terminal.
By taking intelligent television as an example, channel content polymerization is a kind of important content aggregation service.It is intended to provide third party
Server polymerize the digital TV channel and programme information that business provides beyond the clouds, is carried by intelligent television or other-end to user
For program service.But the channel and programme information that are polymerize beyond the clouds in server at present are very more (such as more than 2000
It is individual), and different regions, the user of different broadcasting and TV types, the channel number that it can be watched are less (such as 200).
At present, in the program push method based on cloud platform, the following two modes of generally use are handled:
1st, cloud server only provides the nationwide channel and programme information that can be watched, such as CCTV's channel, satellite TV
Channel etc..
But the channel that this method user can watch is limited, it is impossible to watch corresponding local channel, versatility compared with
Difference.
2nd, the whole channels and programme information of polymerization are supplied to each terminal by cloud server, and each terminal is further according to certainly
The channel that body can be watched is matched, filtered.
But this method can increase the pressure of terminal, cause the operation response of terminal slow, influence Consumer's Experience.
In a word, the problem of current method generally existing poor universality, increase terminal pressure, poor user experience.
The content of the invention
The invention provides a kind of method and apparatus for building mapping database, and the method and dress of a kind of program push
Put, to solve the problems, such as current method poor universality, increase terminal pressure, poor user experience.
In order to solve the above problems, the invention discloses a kind of method for building mapping database, it is characterised in that bag
Include:
The terminal iidentification that cloud server receiving terminal reports, and the first channel list corresponding to the terminal;Wherein, institute
State the local channel list that the first channel list is the terminal;
The second channel list according to corresponding to first channel list determines the terminal iidentification;Wherein, described second
Channel list is channel list corresponding to a certain type broadcasting and TV, and second channel list includes at least one broadcasting and TV channel name
Claim;
The broadcasting and TV channel designation is matched with preset web channel title, determines the broadcasting and TV channel designation pair
The web channel title answered;
First mapping relations are created using the terminal iidentification and corresponding second channel list, and, using described wide
Electric channel designation and corresponding web channel title create the second mapping relations;
By first mapping relations and the storage of the second mapping relations into mapping database.
Preferably, the step of second channel list according to corresponding to first channel list determines the terminal iidentification
Suddenly include:
Calculate the MD5 values of first channel list;
The MD5 values of the second channel list preserved are obtained, search whether MD5 values and first channel list be present
MD5 values the second channel list of identical;
If in the presence of, it is determined that the second channel list found is the second channel list corresponding to the terminal iidentification;
If being not present, preserved first channel list as newly-increased second channel list, and described in determination
Newly-increased second channel list is the second channel list corresponding to the terminal iidentification.
Preferably, first channel list identifies including at least one broadcasting and TV channel service,
The step of MD5 values of calculating first channel list, includes:
It is ranked up for first channel list according to broadcasting and TV channel service mark;
Broadcasting and TV channel service mark after sequence is spliced into character string;
Md5 encryption is carried out to the character string and obtains MD5 values, the MD5 using the MD5 values as first channel list
Value.
Preferably, in second channel list according to corresponding to first channel list determines the terminal iidentification
After step, in addition to:
Judge whether the first mapping relations of the terminal iidentification and other the second channel lists be present;
If in the presence of deleting the first mapping relations of the terminal iidentification and other second channel lists.
Preferably, the web channel title includes the standard name of web channel and at least one alias;
It is described to be matched the broadcasting and TV channel designation with preset web channel title, determine the broadcasting and TV channel name
Include corresponding to title the step of web channel title:
The broadcasting and TV channel designation is matched with the standard name and alias of preset web channel;
If there is the standard name or alias with the broadcasting and TV channel designation identical web channel, then by network frequency
The standard name in road is defined as web channel title corresponding to the broadcasting and TV channel designation;
If there is no the standard name or alias with the broadcasting and TV channel designation identical web channel, then search whether to deposit
In web channel corresponding with the broadcasting and TV channel designation;
If there is corresponding web channel, the then alias using the broadcasting and TV channel designation as the web channel, and will
The standard name of the web channel is as web channel title corresponding to the broadcasting and TV channel designation;
If there is no corresponding web channel, then web channel and the network corresponding to the broadcasting and TV channel designation are added
The standard name and alias of channel, and using the standard name of the web channel as web channel name corresponding to the broadcasting and TV channel designation
Claim.
According to another aspect of the present invention, a kind of method of program push is also disclosed, it is characterised in that including:
The push request that cloud server receiving terminal is sent;Wherein, the push request includes the terminal of the terminal
Mark and programme information;
Searched in the first mapping relations stored from the mapping database built in advance corresponding to the terminal iidentification
Two channel lists;Wherein, first mapping relations include terminal iidentification and corresponding second channel list;Second channel
List is channel list corresponding to a certain type broadcasting and TV, and second channel list includes at least one broadcasting and TV channel designation;
It is corresponding that the broadcasting and TV channel designation is searched in the second mapping relations stored from the mapping database built in advance
Web channel title;Wherein, second mapping relations include broadcasting and TV channel designation and corresponding web channel title;
Program data corresponding to the programme information is searched from web channel corresponding to the web channel title;
The program data is pushed to the terminal.
Preferably, the programme information includes Pgmtime section,
It is described to search program data corresponding to the programme information from web channel corresponding to the web channel title
The step of include:
Obtain the time corresponding to each program data in web channel corresponding to the web channel title;
The lookup corresponding time is located at the program data in the Pgmtime section, using the program data found as described in
Program data corresponding to programme information.
Preferably, the programme information includes program category,
It is described to search program data corresponding to the programme information from web channel corresponding to the web channel title
The step of include:
Obtain type corresponding to each program data in web channel corresponding to the web channel title;
The program data that corresponding types are the program category is searched, is believed the program data found as the program
Program data corresponding to breath.
According to another aspect of the present invention, a kind of device for building mapping database is also disclosed, it is characterised in that bag
Include:
Information receiving module, the terminal iidentification reported for receiving terminal, and the first channel list corresponding to the terminal;
Wherein, first channel list is the local channel list of the terminal;
First determining module, for the second channel column corresponding to determining the terminal iidentification according to first channel list
Table;Wherein, second channel list is channel list corresponding to a certain type broadcasting and TV, and second channel list is included at least
One broadcasting and TV channel designation;
Second determining module, for the broadcasting and TV channel designation to be matched with preset web channel title, it is determined that
Web channel title corresponding to the broadcasting and TV channel designation;
Creation module, for creating the first mapping relations using the terminal iidentification and corresponding second channel list, with
And the second mapping relations are created using the broadcasting and TV channel designation and corresponding web channel title;
Memory module, for first mapping relations and the second mapping relations to be stored into mapping database.
Preferably, first determining module includes:
Calculating sub module, for calculating the MD5 values of first channel list;
Submodule is searched, for obtaining the MD5 values of the second channel list preserved, searches whether MD5 values and institute be present
State MD5 values the second channel list of identical of the first channel list;
List determination sub-module, in the presence of being in the lookup result of the lookup submodule, it is determined that found
Second channel list is the second channel list corresponding to the terminal iidentification;It is not deposit in the lookup result of the lookup submodule
When, preserved first channel list as newly-increased second channel list, and determine newly-increased second channel column
Table is the second channel list corresponding to the terminal iidentification.
Preferably, first channel list identifies including at least one broadcasting and TV channel service,
The calculating sub module includes:
Sort subelement, for being ranked up for first channel list according to broadcasting and TV channel service mark;
Splice subelement, for the broadcasting and TV channel service mark after sequence to be spliced into character string;
Encryption sub-unit operable, MD5 values are obtained for carrying out md5 encryption to the character string, using the MD5 values as described the
The MD5 values of one channel list.
Preferably, the device of the structure mapping database also includes:
Judge module, for determining the terminal iidentification pair according to first channel list in first determining module
After the second channel list answered, judge whether the terminal iidentification and the first mapping of other the second channel lists be present
Relation;
Removing module, in the presence of being in the judged result of the judge module, delete the terminal iidentification and this its
First mapping relations of his the second channel list.
Preferably, the web channel title includes the standard name of web channel and at least one alias;
Second determining module includes:
A matched sub-block, for the standard name of the broadcasting and TV channel designation and preset web channel and alias to be carried out
Match somebody with somebody;
Title determination sub-module, for existing and the standard name of the broadcasting and TV channel designation identical web channel or other
During name, the standard name of the web channel is defined as web channel title corresponding to the broadcasting and TV channel designation;
Submodule is handled, in the absence of the standard name or alias with the broadcasting and TV channel designation identical web channel
When, search whether web channel corresponding with the broadcasting and TV channel designation be present;If there is corresponding web channel, then by institute
Alias of the broadcasting and TV channel designation as the web channel is stated, and using the standard name of the web channel as the broadcasting and TV channel designation
Corresponding web channel title;If there is no corresponding web channel, then network corresponding to the broadcasting and TV channel designation is added
The standard name and alias of channel and the web channel, and it is corresponding using the standard name of the web channel as the broadcasting and TV channel designation
Web channel title.
According to another aspect of the present invention, a kind of device of program push is also disclosed, it is characterised in that including:
Request receiving module, the push request sent for receiving terminal;Wherein, the push request includes the terminal
Terminal iidentification and programme information;
List lookup module, described in being searched in the first mapping relations for being stored from the mapping database built in advance
Second channel list corresponding to terminal iidentification;Wherein, first mapping relations include terminal iidentification and corresponding second channel
List;Second channel list is channel list corresponding to a certain type broadcasting and TV, and second channel list includes at least one
Individual broadcasting and TV channel designation;
Title searching modul, described in being searched in the second mapping relations for being stored from the mapping database built in advance
Web channel title corresponding to broadcasting and TV channel designation;Wherein, second mapping relations include broadcasting and TV channel designation and corresponding
Web channel title;
Program searching modul, for searching the programme information pair from web channel corresponding to the web channel title
The program data answered;
Pushing module, for the program data to be pushed into the terminal.
Preferably, the programme information includes Pgmtime section,
The program searching modul, specifically for obtaining each number of programs in web channel corresponding to the web channel title
According to the corresponding time;The lookup corresponding time is located at the program data in the Pgmtime section, and the program data found is made
For program data corresponding to the programme information.
Preferably, the programme information includes program category,
The program searching modul, specifically for obtaining each number of programs in web channel corresponding to the web channel title
According to corresponding type;The program data that corresponding types are the program category is searched, using the program data found as described in
Program data corresponding to programme information.
Compared with prior art, the present invention includes advantages below:
Cloud server is in the terminal iidentification for receiving terminal and reporting, and the first channel list corresponding to terminal in the present invention
Afterwards, can according to corresponding to the first channel list determines terminal iidentification the second channel list, and will be wrapped in the second channel list
The broadcasting and TV channel designation included is matched with web channel title preset at cloud server, determines that broadcasting and TV channel designation is corresponding
Web channel title;Then terminal iidentification and corresponding second channel list can be used to create the first mapping relations, used
Broadcasting and TV channel designation and corresponding web channel title create the second mapping relations, and first mapping relations and second are reflected
Relation storage is penetrated into mapping database.Subsequently after the push request of terminal transmission is received, you can according to above-mentioned mapping
To the channel corresponding to the terminal, these channels are the first mapping relations and the second mapping relationship searching stored in database
The channel that the terminal can watch.Therefore the program data for the channel that directly can be watched terminal in the present invention is pushed to
Counterpart terminal, versatility is stronger, and server is carried out calculating process beyond the clouds, makes full use of the calculating energy of cloud server
Power, reduce the calculating pressure of terminal, it is possible to increase response speed, lift Consumer's Experience.
Brief description of the drawings
Fig. 1 is a kind of flow chart of the method for structure mapping database of the embodiment of the present invention one;
Fig. 2 is a kind of flow chart of the method for program push of the embodiment of the present invention one;
Fig. 3 is a kind of flow chart of the method for structure mapping database of the embodiment of the present invention two;
Fig. 4 is a kind of flow chart of the method for program push of the embodiment of the present invention two;
Fig. 5 is a kind of structured flowchart of the device of structure mapping database of the embodiment of the present invention three;
Fig. 6 is a kind of structured flowchart of the device of program push of the embodiment of the present invention three.
Embodiment
In order to facilitate the understanding of the purposes, features and advantages of the present invention, it is below in conjunction with the accompanying drawings and specific real
Applying mode, the present invention is further detailed explanation.
The channel and programme information being polymerize beyond the clouds in server at present are very more, and different regions, different broadcasting and TV classes
The user of type, the channel number that it can be watched are less.Therefore whether the whole country is only provided using cloud server
The channel and the method for programme information that can be watched, or cloud server is used by the whole channels and programme information of polymerization
Each terminal is supplied to, the method that each terminal carries out matching filtering further according to the channel that itself can be watched, can not
Meet the needs of user, the problems such as poor universality, increase terminal pressure, poor user experience be present.The present invention is regarding to the issue above
A kind of method and apparatus for building mapping database, and a kind of method and apparatus of program push are proposed, can be reduced end
The calculating pressure at end, response speed is improved, lift Consumer's Experience, and it is versatile.
Below, following each embodiment method and apparatus to building mapping database, and program push respectively are passed through
Method and apparatus describe in detail.Terminal proposed in the present invention, which can be that smart television set top box etc. is various, to be broadcast
Put the intelligent terminal of channel program.
Embodiment one:
First, the method for introducing a kind of structure mapping database of the proposition of the embodiment of the present invention one.
Reference picture 1, show a kind of flow chart for the method for building mapping database of the embodiment of the present invention.The structure maps
The method of database may comprise steps of:
Step 101, the terminal iidentification that cloud server receiving terminal reports, and the first channel column corresponding to the terminal
Table.
In the embodiment of the present invention, terminal can be by the mark of the terminal, and the first channel list reports corresponding to the terminal
Cloud server, these information that follow-up cloud server can report according to terminal, is handled for the terminal.Wherein,
First channel list is the local channel list of terminal, i.e., the channel list that the terminal can watch.
Step 102, the second channel list according to corresponding to first channel list determines the terminal iidentification;Wherein,
Second channel list includes at least one broadcasting and TV channel designation.
Cloud server in the terminal iidentification for receiving terminal and reporting, and the first channel list corresponding to the terminal it
Afterwards, can according to corresponding to the first channel list determines the terminal iidentification the second channel list.Wherein, the second channel list is certain
Channel list corresponding to one type broadcasting and TV, at least one broadcasting and TV channel designation can be included in second channel list, belong to this
User under type broadcasting and TV can watch these broadcasting and TV channels.
Step 103, the broadcasting and TV channel designation is matched with preset web channel title, determines the broadcasting and TV frequency
Web channel title corresponding to road title.
The channel and programme information that it is provided can periodically be imported cloud server by third party content provider, in cloud
These channels are managed collectively as web channel in the server of end, can be these frequency channel preset web channel titles.Cloud
After end server determines the second channel list corresponding to terminal iidentification in above-mentioned steps 102, further by second frequency
The broadcasting and TV channel designation that road list includes is matched with preset web channel title, so that it is determined that going out each broadcasting and TV channel
Web channel title corresponding to title, and then can learn in the web channel preserved in server beyond the clouds, the terminal energy
Which channel what is enough watched is.
Step 104, the first mapping relations are created using the terminal iidentification and corresponding second channel list, and, adopt
The second mapping relations are created with the broadcasting and TV channel designation and corresponding web channel title.
After 101~step 103 of above-mentioned steps, you can the corresponding relation of terminal iidentification and the second channel list is obtained,
And broadcasting and TV channel designation and the corresponding relation of web channel title, therefore can subsequently use the terminal iidentification and corresponding
Second channel list creates the first mapping relations, and, created using the broadcasting and TV channel designation and corresponding web channel title
Build the second mapping relations.
Step 105, by first mapping relations and the storage of the second mapping relations into mapping database.
In the embodiment of the present invention, the first mapping relations and the second mapping relations can also be stored into mapping database,
To be managed as a whole to it.
After building above-mentioned mapping database, when terminal carries out program push, according to what is stored in the mapping database
First mapping relations and the second mapping relations can find the channel that the corresponding, terminal can watch.
Below, the mapping database constructed by the method based on the structure mapping database shown in above-mentioned Fig. 1 is introduced to carry out
The method of program push.
Reference picture 2, show a kind of flow chart of the method for program push of the embodiment of the present invention one.The program push
Method may comprise steps of:
Step 201, the push request that cloud server receiving terminal is sent;Wherein, the push request includes the end
The terminal iidentification and programme information at end.
, can in push request when terminal needs viewing channel program, it is necessary to send push request to cloud server
With the terminal iidentification including the terminal and programme information etc., cloud server can find corresponding frequency according to push request
Road program data.
Step 202, the terminal iidentification is searched in the first mapping relations stored from the mapping database built in advance
Corresponding second channel list.
The first mapping relations are stored with the mapping database built in advance, first mapping relations include terminal iidentification
With corresponding second channel list, therefore included terminal iidentification in being asked according to push can be from first mapping relations
The second channel list corresponding to the terminal iidentification is searched, i.e., is channel column corresponding to which kind broadcasting and TV corresponding to the terminal iidentification
Table.Wherein, the second channel list is channel list corresponding to a certain type broadcasting and TV, i.e. user under the broadcasting and TV of the type can receive
The channel list seen, the second channel list include at least one broadcasting and TV channel designation.
Step 203, the broadcasting and TV channel is searched in the second mapping relations stored from the mapping database built in advance
Web channel title corresponding to title.
The second mapping relations are also stored with the mapping database built in advance, second mapping relations include broadcasting and TV frequency
Road title and corresponding web channel title, therefore the broadcasting and TV channel in the second channel list found in step 202
Title can be searched from second mapping relations corresponding to web channel title.
Step 204, program corresponding to the programme information is searched from web channel corresponding to the web channel title
Data.
Also include programme information in the push request that terminal is sent, the information can instruction terminal currently to be played where is
Individual or which channel program, it is therefore desirable to further search the section from web channel corresponding to the web channel title
Program data corresponding to mesh information.
Step 205, the program data is pushed to the terminal.
After the program data that terminal needs is obtained, the program data can be pushed to terminal by cloud server, eventually
End can be chosen broadcasting.
Simple introduction is carried out to above-mentioned each step in the embodiment of the present invention one, for the specific mistake of above-mentioned each step
Journey, it will be discussed in detail in following embodiment two.
The program data for the channel that directly can be watched terminal in the embodiment of the present invention is pushed to counterpart terminal, leads to
It is stronger with property, and server is carried out calculating process beyond the clouds, is made full use of the computing capability of cloud server, is reduced terminal
Calculating pressure, it is possible to increase response speed, lifted Consumer's Experience.
Embodiment two:
First, the method for introducing a kind of specific structure mapping database of the proposition of the embodiment of the present invention two.
Reference picture 3, show a kind of flow chart of the method for structure mapping database of the embodiment of the present invention two.The structure
The method of mapping database may comprise steps of:
Step 301, the terminal iidentification that cloud server receiving terminal reports, and the first channel column corresponding to the terminal
Table.
In the embodiment of the present invention, the terminal of reception cloud server offer service first has to server beyond the clouds and noted
Volume, such as in registration, the registration request for carrying terminal iidentification can be sent to cloud server by terminal first, then
Cloud server verified for the registration request of the terminal, and the message that succeeds in registration is sent after being verified to terminal, terminal
After receiving the message that succeeds in registration, server succeeds in registration beyond the clouds, and cloud server can preserve terminal after registration
Log-on message of the information such as terminal iidentification as the terminal.
Cloud server provides the programme information of channel correlation for terminal, and terminal can be identified with reporting terminal, and the terminal
Corresponding first channel list is to cloud server, can be further to the terminal after cloud server receives these information
Verified, such as can be tested according to the terminal iidentification that the log-on message of the terminal pre-saved reports to the terminal
Card, after being verified, cloud server can preserve the first channel corresponding to the terminal iidentification that the terminal reports and the terminal
List.
Wherein, first channel list is the local channel list of the terminal, and terminal can be from cable digital TV
The channel information that can be watched is parsed in signal, these channel informations can compositing terminal local channel list.
Step 302, the second channel list according to corresponding to first channel list determines the terminal iidentification;Wherein,
Second channel list includes at least one broadcasting and TV channel designation.
In the embodiment of the present invention, the second channel list is channel list corresponding to a certain type broadcasting and TV.A certain type it is wide
Electricity corresponds to a channel list, and multiple users are might have under the broadcasting and TV of the type, therefore corresponding to the terminal of these users originally
Ground channel list should be identical, and these identical local channel lists also channel list phase corresponding with the type broadcasting and TV
Together.Therefore in the embodiment of the present invention, the first channel list can include at least one broadcasting and TV channel designation and broadcasting and TV channel service
Mark (Service ID, SID, the parameter of unique mark channel in the range of current broadcasting and TV), the second channel list can be included extremely
A few broadcasting and TV channel designation and broadcasting and TV channel service mark.
Therefore, in the embodiment of the present invention can according to corresponding to the first channel list determines terminal iidentification the second channel column
Table, you can so that the terminal iidentification to be ranged to channel list corresponding to a certain type broadcasting and TV belonging to it.
In one preferred embodiment of the invention, the method for the MD5 values of calculations list can be used to determine terminal iidentification
Corresponding second channel list.In such cases, the step 302 can include following sub-step:
Sub-step a1, calculate MD5 (the entitled Message Digest Algorithm 5 of Chinese, the Message of first channel list
Digest Algorithm) value.
In one preferred embodiment of the invention, can be identified according to the broadcasting and TV channel service that the first channel list includes
Its MD5 value is calculated, sub-step a1 can include following sub-step:
Sub-step a11, it is ranked up for first channel list according to broadcasting and TV channel service mark;
Sub-step a12, the broadcasting and TV channel service mark after sequence is spliced into character string;
Sub-step a13, md5 encryption is carried out to the character string and obtains MD5 values, using the MD5 values as the described first frequency
The MD5 values of road list.
Broadcasting and TV channel service mark can be numeral, and the first channel list can be taken according to broadcasting and TV channel therein first
Business mark is ranked up, and the sequence can be that ascending sort can also be descending sort, can also be the sequence of other modes, only
Ensure that the ordering rule of each list is consistent;Then the broadcasting and TV channel service mark after sequence is spliced into character string,
Can subsequently md5 encryption be carried out to the character string and obtain MD5 values, the MD5 values are the MD5 values of first channel list.
Sub-step a2, the MD5 values of the second channel list preserved are obtained, search whether MD5 values and described first be present
MD5 values the second channel list of identical of channel list;If in the presence of execution sub-step a3;If being not present, sub-step is performed
a4。
Each second channel list preserved also has a MD5 value, and the MD5 values can be according to above-mentioned sub-step
A11~sub-step a13 method is calculated for the second channel list, or using the first channel list as one
Newly-increased second channel list preserves (being introduced in following sub-step a4) herein when, directly by calculated this first
The MD5 values of channel list preserve as the MD5 values of newly-increased second channel.
Sub-step a3, it is determined that the second channel list found is the second channel list corresponding to the terminal iidentification.
, can if identical with the MD5 values for the second channel list that some has been preserved in the MD5 values of first channel list
To determine the second found channel list as the second channel list corresponding to the terminal iidentification.
Sub-step a4, preserve, and determine described new using first channel list as newly-increased second channel list
It is the second channel list corresponding to the terminal iidentification to increase the second channel list.
, then can should if there is no MD5 values the second channel list of identical of MD5 values and first channel list
First channel list preserves as newly-increased second channel list, while can also make the MD5 values of first channel list
The MD5 values for increasing the second channel list newly for this together preserve, without individually calculating the MD5 values of second channel list again.
It can determine that newly-increased second channel list is the second channel list corresponding to the terminal iidentification in such cases.
In another preferred embodiment of the present invention, the broadcasting and TV channel designation that can also be included according to the first channel list
Determine the second channel list corresponding to terminal iidentification.Detailed process can be:Obtain the second channel list and its bag preserved
The broadcasting and TV channel designation included;Respectively by the broadcasting and TV channel designation in first channel list and each second channel list
Broadcasting and TV channel designation is matched, and searches whether broadcasting and TV channel designation and the broadcasting and TV channel designation phase in the first channel list be present
With second channel list of (referring to all identical);If in the presence of, it is determined that the second channel list found is the terminal mark
Second channel list corresponding to knowledge;If being not present, protected first channel list as newly-increased second channel list
Deposit, and determine that newly-increased second channel list is the second channel list corresponding to the terminal iidentification.
Certainly, those skilled in the art are according to corresponding to practical experience can also determine terminal iidentification using other method
Two channel lists, as long as can interpolate that whether the first channel list and the second channel list are identical, and the embodiment of the present invention exists
This is no longer discussed in detail.
Step 303, judge whether the first mapping relations of the terminal iidentification and other the second channel lists be present;
If in the presence of deleting the first mapping relations of the terminal iidentification and other second channel lists.
It may be changed in view of the channel that terminal can watch, i.e. the local channel list of terminal may become
Change, therefore in one preferred embodiment of the invention, terminal can periodically reporting terminal identify and the terminal corresponding to first
Channel list is to cloud server, to update mapping database, i.e., the terminal iidentification that cloud server receiving terminal periodically reports,
And the first channel list corresponding to the terminal.Therefore, the end of information may be reported in server in the presence of this beyond the clouds
End and the first mapping relations of other the second channel lists.In the embodiment of the present invention, it can also further determine whether to have deposited
In the first mapping relations of the terminal iidentification He other the second channel lists, if in the presence of deleting the terminal iidentification and this its
First mapping relations of his the second channel list, and subsequent step is performed, so as to which first mapping relations related to the terminal are entered
Row renewal;If being not present, subsequent step can be directly performed without processing.
Step 304, the broadcasting and TV channel designation is matched with preset web channel title, determines the broadcasting and TV frequency
Web channel title corresponding to road title.
Third party content provider can provide the programme information of some channels and the channel to cloud server, take beyond the clouds
It will be managed collectively in business device as web channel, therefore can be these frequency channel preset web channel names first beyond the clouds
Claim.The title that different types of broadcasting and TV are distributed by same broadcasting and TV channel may be different, and different third party content providers carry
The title of the same channel supplied may also be different, for example, for this set of channel of center, it may have
Multiple titles such as " CCTV1 ", " CCTV-1 ", " center is a set of ".Therefore, in the embodiment of the present invention, preset web channel title
The standard name of web channel and at least one alias can be included, wherein, standard name can be from multiple titles of the channel
An optional title, remaining name are referred to as alias, and standard name can also be a name being separately provided for the channel
Claim, other names of the channel are referred to as alias, and the embodiment of the present invention is not any limitation as to this.
In one preferred embodiment of the invention, the step 304 can include following sub-step:
Sub-step b1, the broadcasting and TV channel designation is matched with the standard name and alias of preset web channel.
Second channel list corresponding to the above-mentioned terminal determined includes at least one broadcasting and TV channel designation, because this is wide
Electric channel designation may be corresponding the standard name of web channel differ, it is but identical with its alias, therefore can be by the
Broadcasting and TV channel designation in two channel lists is matched with the standard name and alias of preset web channel.
Sub-step b2, if there is the standard name or alias with the broadcasting and TV channel designation identical web channel, then will
The standard name of the web channel is defined as web channel title corresponding to the broadcasting and TV channel designation.
If for example, the broadcasting and TV channel designation is " CCTV-1 ", the standard of some web channel is entitled " CCTV1 ", not
Entitled " CCTV-1 " and " center is a set of ", it can now judge the alias phase of the broadcasting and TV channel designation and the web channel
Together, therefore the standard name " CCTV1 " of the web channel can be defined as web channel corresponding to the broadcasting and TV channel designation
Title.
Sub-step b3, if there is no the standard name or alias with the broadcasting and TV channel designation identical web channel, then
Search whether web channel corresponding with the broadcasting and TV channel designation be present.
If there is no the standard name or alias with the broadcasting and TV channel designation identical web channel, then be probably due to
In the absence of web channel corresponding to the broadcasting and TV channel designation, or web channel corresponding to the broadcasting and TV channel designation be present still
The standard name and alias of the web channel differ with the broadcasting and TV channel designation, can further search in that case
With the presence or absence of web channel corresponding with the broadcasting and TV channel designation.
Sub-step b4, if there is corresponding web channel, then using the broadcasting and TV channel designation as the web channel
Alias, and using the standard name of the web channel as web channel title corresponding to the broadcasting and TV channel designation.
Sub-step b5, if there is no corresponding web channel, then add network frequency corresponding to the broadcasting and TV channel designation
The standard name and alias in road and the web channel, and using the standard name of the web channel as corresponding to the broadcasting and TV channel designation
Web channel title.
In above-mentioned sub-step b4 and sub-step b5, this can be regard the broadcasting and TV channel designation as by cloud server automatically
The alias of web channel, or the standard name of web channel and the web channel corresponding to the broadcasting and TV channel designation is added automatically
And alias.Network frequency corresponding to the broadcasting and TV channel designation of upload can also be received in the processing subsequently through operation personnel
The alias in road, or receive upload the broadcasting and TV channel designation corresponding to the standard name of web channel and the web channel and not
Name.
In one preferred embodiment of the invention, cloud server is being judged to be not present and the broadcasting and TV channel designation
After the standard name or alias of identical web channel, it can also further record the broadcasting and TV channel designation not matched and not match
Web channel title, subsequently in search procedure, you can directly searched in the web channel title that never matches, so as to avoid
The web channel title matched is carried out to repeat lookup, further improves treatment effeciency.
Step 305, the first mapping relations are created using the terminal iidentification and corresponding second channel list, and, adopt
The second mapping relations are created with the broadcasting and TV channel designation and corresponding web channel title.
It is that can obtain the corresponding relation of terminal iidentification and the second channel list by above-mentioned steps, and broadcasting and TV channel designation
With the corresponding relation of web channel title, therefore in the embodiment of the present invention, cloud server can further use the terminal
Mark and corresponding second channel list create the first mapping relations, and, using the broadcasting and TV channel designation and corresponding net
Network channel designation creates the second mapping relations.
Step 306, by first mapping relations and the storage of the second mapping relations into mapping database.
Database is also applied in the embodiment of the present invention, by above-mentioned first mapping relations and the storage of the second mapping relations to reflecting
Penetrate in database, so as to be managed as a whole to first mapping relations and the second mapping relations.Wherein, the first mapping is closed
System and the second mapping relations can be stored into mapping database in the form of tables of data etc..
Below, the mapping database constructed by the method for the structure mapping database according to above-mentioned Fig. 3 is introduced to carry out
The method of program push.
Reference picture 4, show a kind of flow chart of the method for program push of the embodiment of the present invention two.The program push
Method may comprise steps of:
Step 401, the push request that cloud server receiving terminal is sent;Wherein, the push request includes the end
The terminal iidentification and programme information at end.
In the embodiment of the present invention, carried out data transmission between terminal and cloud server by network, therefore opened in terminal
After dynamic, network connection can be established with cloud server first, detailed process can be:Cloud server is monitored, in wait
The state of connection, monitors network state in real time;Terminal sends connection request to cloud server;Cloud server response terminal
Connection request, establish connection.
After the network connection established, terminal can send push to cloud server when needing broadcasting channel program and ask
Ask, terminal iidentification and programme information of the terminal etc. can be included in push request.
Step 402, the mapping database built in advance is obtained.
Cloud server can be verified to determine to the terminal first after the push request of terminal transmission is received
Whether it is legal, such as the terminal iidentification of the terminal can be verified according to the log-on message of the terminal pre-saved.
After being verified, cloud server obtains the mapping database built in advance.
Step 403, the terminal iidentification is searched in the first mapping relations stored from the mapping database built in advance
Corresponding second channel list.
The first mapping relations of storage are obtained from the mapping database built in advance, first mapping relations include terminal
Mark and corresponding second channel list, therefore end included in push request can be found from first mapping relations
Second channel list corresponding to the mark of end.
Wherein, the second channel list is that channel list, the second channel list corresponding to a certain type broadcasting and TV are included at least
One broadcasting and TV channel designation.
Step 404, the broadcasting and TV channel is searched in the second mapping relations stored from the mapping database built in advance
Web channel title corresponding to title.
The second mapping relations of storage are obtained from the mapping database built in advance, second mapping relations include broadcasting and TV
Channel designation and corresponding web channel title, therefore can be according to wide in the second channel list found in step 403
Electric channel designation, the web channel title corresponding to lookup from second mapping relations.
Step 405, program corresponding to the programme information is searched from web channel corresponding to the web channel title
Data.
In the embodiment of the present invention, multiple program datas can be included in each web channel, therefore in above-mentioned push request
Also include programme information, according to network frequency corresponding to the web channel title that the programme information can be found from step 405
Program data corresponding to the programme information is searched in road.
In one preferred embodiment of the invention, the programme information can include Pgmtime section, that is, specifying needs
Be which period program.In that case, the step 405 is specifically as follows:Obtain the web channel title
Time corresponding to each program data in corresponding web channel;The lookup corresponding time is located at the number of programs in the Pgmtime section
According to using the program data found as program data corresponding to the programme information.Wherein, the program in each web channel
Data are all corresponding with a time, time set when can be editing saving time.
In another preferred embodiment of the invention, the programme information can include program category, such as specify need
The program category wanted is film types or TV play type etc..In that case, the step 405 is specifically as follows:Obtain institute
State type corresponding to each program data in web channel corresponding to web channel title;Lookup corresponding types are the program category
Program data, using the program data found as program data corresponding to the programme information.Wherein, each web channel
In program data be all corresponding with a type, such as film class, TV play class, news category etc., the type can be that program is compiled
Set time when collecting.Step 406, the program data is pushed to the terminal.
After cloud server finds corresponding program data in step 405, you can be pushed to these program datas
Terminal, terminal may be selected program data therein after receiving and play out.
In the embodiment of the present invention, server is carried out calculating process beyond the clouds, makes full use of the computing capability of cloud server,
The calculating pressure of terminal is reduced, improves response speed, lifts Consumer's Experience.And it is directed to and the network frequency in cloud server
The broadcasting and TV channel designation that road title does not match can be recorded, after subsequently adding relevant information in server beyond the clouds, i.e.,
Corresponding mapping relations can be re-established, all channels for finally enabling the terminals to watch can be obtained from cloud server and saved
Mesh number evidence.
For foregoing each method embodiment, in order to be briefly described, therefore it is all expressed as to a series of combination of actions, but
It is that those skilled in the art should know, the present invention is not limited by described sequence of movement, because according to the present invention, certain
A little steps can use other orders or carry out simultaneously.Secondly, those skilled in the art should also know, be retouched in specification
The embodiment stated belongs to preferred embodiment, necessary to involved action and the module not necessarily present invention.
Embodiment three:
Reference picture 5, show a kind of structured flowchart of the device of structure mapping database of the embodiment of the present invention three.The structure
Building the device of mapping database can include with lower module:
Information receiving module 501, the terminal iidentification reported for receiving terminal, and the first channel column corresponding to the terminal
Table;Wherein, first channel list is the local channel list of the terminal;
First determining module 502, for the second frequency corresponding to determining the terminal iidentification according to first channel list
Road list;Wherein, second channel list is channel list corresponding to a certain type broadcasting and TV, and second channel list includes
At least one broadcasting and TV channel designation;
Second determining module 503, for the broadcasting and TV channel designation to be matched with preset web channel title, really
Web channel title corresponding to the fixed broadcasting and TV channel designation;
Creation module 504, for creating the first mapping relations using the terminal iidentification and corresponding second channel list,
And the second mapping relations are created using the broadcasting and TV channel designation and corresponding web channel title;
Memory module 505, for first mapping relations and the second mapping relations to be stored into mapping database.
In one preferred embodiment of the invention, the device of the structure mapping database can also include with lower module:
Judge module, for determining the terminal iidentification pair according to first channel list in first determining module
After the second channel list answered, judge whether the terminal iidentification and the first mapping of other the second channel lists be present
Relation;
Removing module, in the presence of being in the judged result of the judge module, delete the terminal iidentification and this its
First mapping relations of his the second channel list.
In one preferred embodiment of the invention, first determining module can include:
Calculating sub module, for calculating the MD5 values of first channel list;
Submodule is searched, for obtaining the MD5 values of the second channel list preserved, searches whether MD5 values and institute be present
State MD5 values the second channel list of identical of the first channel list;
List determination sub-module, in the presence of being in the lookup result of the lookup submodule, it is determined that found
Second channel list is the second channel list corresponding to the terminal iidentification;It is not deposit in the lookup result of the lookup submodule
When, preserved first channel list as newly-increased second channel list, and determine newly-increased second channel column
Table is the second channel list corresponding to the terminal iidentification.
The web channel title includes the standard name of web channel and at least one alias;Second determining module can
With including:
A matched sub-block, for the standard name of the broadcasting and TV channel designation and preset web channel and alias to be carried out
Match somebody with somebody;
Title determination sub-module, for existing and the standard name of the broadcasting and TV channel designation identical web channel or other
During name, the standard name of the web channel is defined as web channel title corresponding to the broadcasting and TV channel designation;
Submodule is handled, in the absence of the standard name or alias with the broadcasting and TV channel designation identical web channel
When, search whether web channel corresponding with the broadcasting and TV channel designation be present;If there is corresponding web channel, then by institute
Alias of the broadcasting and TV channel designation as the web channel is stated, and using the standard name of the web channel as the broadcasting and TV channel designation
Corresponding web channel title;If there is no corresponding web channel, then network corresponding to the broadcasting and TV channel designation is added
The standard name and alias of channel and the web channel, and it is corresponding using the standard name of the web channel as the broadcasting and TV channel designation
Web channel title.
Wherein, first channel list identifies including at least one broadcasting and TV channel service;The calculating sub module can be with
Including:
Sort subelement, for being ranked up for first channel list according to broadcasting and TV channel service mark;
Splice subelement, for the broadcasting and TV channel service mark after sequence to be spliced into character string;
Encryption sub-unit operable, MD5 values are obtained for carrying out md5 encryption to the character string, using the MD5 values as described the
The MD5 values of one channel list.
Reference picture 6, show a kind of structured flowchart of the device of program push of the embodiment of the present invention three.The program push
Device can include with lower module:
Request receiving module 601, the push request sent for receiving terminal;Wherein, the push request includes described
The terminal iidentification and programme information of terminal;
List lookup module 602, for being searched in the first mapping relations for being stored from the mapping database built in advance
Second channel list corresponding to the terminal iidentification;Wherein, first mapping relations include terminal iidentification and corresponding second
Channel list;Second channel list is channel list corresponding to a certain type broadcasting and TV, and second channel list is included extremely
A few broadcasting and TV channel designation;
Title searching modul 603, for being searched in the second mapping relations for being stored from the mapping database built in advance
Web channel title corresponding to the broadcasting and TV channel designation;Wherein, second mapping relations include broadcasting and TV channel designation and right
The web channel title answered;
Program searching modul 604, for searching the program letter from web channel corresponding to the web channel title
Program data corresponding to breath;
Pushing module 605, for the program data to be pushed into the terminal.
In one preferred embodiment of the invention, the programme information includes Pgmtime section.The program searches mould
Block, specifically for obtaining the time corresponding to each program data in web channel corresponding to the web channel title;Search corresponding
Time is located at the program data in the Pgmtime section, using the program data found as section corresponding to the programme information
Mesh number evidence.
In another preferred embodiment of the invention, the programme information includes program category.The program searches mould
Block, specifically for obtaining type corresponding to each program data in web channel corresponding to the web channel title;Search corresponding
Type is the program data of the program category, using the program data found as number of programs corresponding to the programme information
According to.
Cloud server is in the terminal iidentification for receiving terminal and reporting in the embodiment of the present invention, and the first frequency corresponding to terminal
After road list, can according to corresponding to the first channel list determines terminal iidentification the second channel list, and by the second channel column
The broadcasting and TV channel designation that table includes is matched with web channel title preset at cloud server, determines broadcasting and TV channel name
Web channel title corresponding to title;Then terminal iidentification and corresponding second channel list can be used to create the first mapping and close
System, the second mapping relations are created using broadcasting and TV channel designation and corresponding web channel title, and by first mapping relations
With the storage of the second mapping relations into mapping database.Subsequently after the push request of terminal transmission is received, you can according to
The first mapping relations and the second mapping relationship searching stored in above-mentioned mapping database to corresponding to the terminal channel, these
Channel is the channel that the terminal can watch.Therefore the channel that directly can be watched terminal in the embodiment of the present invention
Program data is pushed to counterpart terminal, and versatility is stronger, and server is carried out calculating process beyond the clouds, makes full use of high in the clouds to take
The computing capability of business device, reduce the calculating pressure of terminal, it is possible to increase response speed, lift Consumer's Experience.
For device embodiment, because it is substantially similar to embodiment of the method, so description is fairly simple, it is related
Part illustrates referring to the part of embodiment of the method.
Each embodiment in this specification is described by the way of progressive, what each embodiment stressed be with
The difference of other embodiment, between each embodiment identical similar part mutually referring to.
The present invention can be described in the general context of computer executable instructions, such as program
Module.Usually, program module includes performing particular task or realizes routine, program, object, the group of particular abstract data type
Part, data structure etc..The present invention can also be put into practice in a distributed computing environment, in these DCEs, by
Task is performed and connected remote processing devices by communication network.In a distributed computing environment, program module can be with
In the local and remote computer-readable storage medium including storage device.
Finally, it is to be noted that, herein, such as first and second or the like relational terms be used merely to by
One entity or operation make a distinction with another entity or operation, and not necessarily require or imply these entities or operation
Between any this actual relation or order be present.Moreover, term " comprising ", "comprising" or its any other variant meaning
Covering including for nonexcludability, so that process, method, commodity or equipment including a series of elements not only include that
A little key elements, but also the other element including being not expressly set out, or also include for this process, method, commodity or
The intrinsic key element of equipment.In the absence of more restrictions, the key element limited by sentence "including a ...", is not arranged
Except other identical element in the process including the key element, method, commodity or equipment being also present.
Above to it is provided by the present invention structure mapping database method and apparatus, the method and apparatus of program push,
It is described in detail, specific case used herein is set forth to the principle and embodiment of the present invention, and the above is real
The explanation for applying example is only intended to help the method and its core concept for understanding the present invention;Meanwhile for the general technology of this area
Personnel, according to the thought of the present invention, there will be changes in specific embodiments and applications, in summary, this theory
Bright book content should not be construed as limiting the invention.