CN103731687A

CN103731687A - Method for realizing channel change and fast prompting EPG information

Info

Publication number: CN103731687A
Application number: CN201410033086.8A
Authority: CN
Inventors: 孟令军; 李晓峰; 许宏吉; 房兰涛; 刘永辉
Original assignee: Inspur Software Group Co Ltd
Current assignee: Inspur Software Group Co Ltd
Priority date: 2014-01-24
Filing date: 2014-01-24
Publication date: 2014-04-16

Abstract

The invention provides a method for realizing fast EPG prompting during channel change, which belongs to the field of digital television set-top boxes and specifically comprises the following steps: a. the third-party EPG manufacturer updates EPG data in real time and uploads the EPG data to the FTP server; b. the head end detects whether the EPG information is updated in real time, if so, the EPG information is inserted into a database, and an updated EPG file on the FTP server is deleted; c. the head end generates a sqlite database db file containing EPG information; d. the head end packs the sqlite database db file to generate a TS file by using an OC protocol, and broadcasts the TS file in turn through preset frequency points; e. when the set top box is started, receiving the sqlite database db file through locking a preset frequency point, and storing the sqlite database db file in a set directory; f. the set-top box background monitors channel change events, and when a user changes channels, the user responds to the channel change events, feeds back EPG information quickly by inquiring the database and presents the EPG information. The user experience effect is improved, and the user waiting time is reduced.

Description

A kind of implementation method of zapping quick prompt EPG information

Technical field

The present invention relates to top box of digital machine TV domain, be specially a kind of implementation method of zapping quick prompt EPG information.

Background technology

Electronic program guides (Electronic Program Guide, EPG) is a kind of TV guide, along with TV programme signal is broadcast Set Top Box end.Set Top Box can be pointed out EPG information when zapping, the program that next this channel can broadcast.Traditional approach receives the mode that pat table, pmt table, NIT table, SDT table and EIT table are resolved in the common employing of EPG successively, and adopting the obvious shortcoming of which is that the response time is long, poor user experience.

Summary of the invention

One for the slow-footed problem of traditional approach zapping prompting EPG information response, and the present invention proposes a kind of method of zapping quick prompt EPG information, reduces period of reservation of number, improves user and experiences.

Specifically comprise the docking of YuEPG manufacturer, the real-time update EPG of EPG manufacturer data, and uploading to ftp server, head end detects more new data of EPG in real time, will upgrade in EPG data insert head client database, then generate the sqlite database db file that comprises concise and to the point EPG information, db file is packaged as to the TS road wheel of going forward side by side and broadcasts, Set Top Box receives db file, during user's zapping, response zapping event, portal presents EPG.

Described method, its head end, by depositing the file of EPG information on periodic polling ftp server, if find that there is new data, is thought the EPG information of upgrading, be inserted in head end epg database, and delete and on ftp server, deposit the lower corresponding data of EPG message file folder; If do not find new data, automatic regular polling.

Described method, its periodic polling head end database, is used all channels to generate the sqlite database db file that comprises concise and to the point EPG information with interior EPG information for 7 days.

Described method, its db file by generation is packaged as TS file, and once, version number circulates and increases progressively successively between 0 to 31 in every generation.

Described method, it generates after TS file, uses OC agreement at a certain default EPG frequency carousel TS file.

Described method, during its set-top-box opening, by locking default EPG frequency, whether the identical decision of version number of whether preserving with this locality according to TSLiu Zhong EPG version number upgrades EPG data, if identical, do not receive, if difference receives EPG data, and preserve EPG version number, be put under set catalogue.

Described method, listen for user zapping thread is opened on its backstage, if user carries out zapping operation, responds zapping event, first obtains user's zapping information, comprises programm name, current time; Then according to programm name and current time, by searching this program in database, be about to the program broadcasting, and feed back to portal and present.

The invention has the beneficial effects as follows:

Shorten the zapping prompting EPG information rate response time, improved user's experience effect, reduced user's stand-by period.

Accompanying drawing explanation

Accompanying drawing 1 is workflow diagram of the present invention.

Embodiment

Below in conjunction with accompanying drawing, 1 couple of the present invention is further elaborated.

1, EPG provider uploads to ftp server by renewal EPG information in real time.EPG information format is as follows:

< xml version="1.0" encoding="UTF-8" >

<epg>

The annual finals in <name> Avenue of Stars-2013 (1) </name>

</program>

<program>

</program>

<name> begins lecturing </name>

</program>

</channel>

</epg>

Each channel is as an independent XML file, and the information comprising in XML file specifically comprises the information such as channel designation, programm name, program start time, program end time, program category and program brief introduction.

2, database design, mainly comprises channelEpg(ID, ChannelName, ProgramName, StartTime, EndTime, Duration, Sort, Summay), INS_PUB_Task(TaskID, TaskName, IssueTime, Status, ConfigXML, DataFolder) two tables.

3, EPG extracts server automatic regular polling ftp server, obtain XML listed files, if list is not sky, XML file is read to this locality, according to set mode, resolve and be written in database table channelEpg, after having write, delete the EPG information of having resolved on ftp server.The Status field value simultaneously upgrading in database table INS_PUB_Task is 1, the existing renewal of sign EPG information.

4, db file generator real-time query database table INS_PUB_Task, is 1 if Status field value detected, by 7 days of all channels, with interior EPG information, by sqlite, generates db file, and uploads to ftp server.The Status field value simultaneously upgrading in INS_PUB_Task table is 10.Sign has generated db file.

5, set and generate TS file parameters, with XML file mode, describe, specifying information is as follows:

<Epg>

<OC>

<OCDir>C:\7EPGData\Data\epg</OCDir>

<OCcarousel_id>0x00000001</OCcarousel_id>

</OCData>

</OC>

</Epg>

ServiceName: for describing the title of EPG business.

VersionNumber: the version number of business.

OC: business datum object carousel specification handles, child node comprises the information such as source file path, PSI/SI information.

OCDir: source file path.

OCPID: primary flow PID.

OCextag: associated tag, the tag value associated with primary flow (to forming after business datum packing), value is 0x21 at present.

OCcarousel_id: carousel ID, the identifier of this object carousel, value is 0x00000001 at present.

UdpIP: multicast group address.

UdpSrcIP: the IP that broadcasts server.

UdpPort: multicast port number.

BitRate: send code check, the kbps of unit.

6, broadcast server by timing Query Database, find that there is db file generated, db file is downloaded to and broadcasts server, and be packaged as TS file according to the profile information in 3, after having packed, versionnumber in configuration file increases progressively and adds 1, then uses OC agreement that it is broadcast by broadcasting and TV transmission network.

7,, during set-top-box opening, by locking default EPG frequency, whether the identical decision of version number of whether preserving with this locality according to TSLiu Zhong EPG version number upgrades EPG data, if identical, does not receive, if difference receives EPG data, and preserves EPG version number.

Claims

1. the implementation method of a zapping quick prompt EPG information, it is characterized in that the real-time update EPG of EPG manufacturer data, and uploading to ftp server, head end detects more new data of EPG in real time, will upgrade in EPG data insert head client database, then generate the sqlite database db file that comprises concise and to the point EPG information, db file is packaged as to the TS road wheel of going forward side by side and broadcasts, Set Top Box receives db file, during user's zapping, response zapping event, portal presents EPG.

2. the method for claim 1, it is characterized in that head end is by depositing the file of EPG information on periodic polling ftp server, if find that there is new data, think the EPG information of upgrading, be inserted in head end epg database, and delete and on ftp server, deposit the lower corresponding data of EPG message file folder; If do not find new data, automatic regular polling.

3. the method for claim 1, is characterized in that periodic polling head end database, and all channels are used and generate the sqlite database db file that comprises concise and to the point EPG information with interior EPG information for 7 days.

4. method as claimed in claim 2 or claim 3, is characterized in that the db file of generation to be packaged as TS file, every generation once, version number between 0 to 31 successively circulation increase progressively.

5. method as claimed in claim 4, is characterized in that generating after TS file, uses OC agreement at a certain default EPG frequency carousel TS file.

6. method as claimed in claim 5, while it is characterized in that set-top-box opening, by locking default EPG frequency, whether the identical decision of version number of whether preserving with this locality according to TSLiu Zhong EPG version number upgrades EPG data, if identical, do not receive, if difference receives EPG data, and preserve EPG version number.

7. the method for claim 1, is characterized in that backstage unlatching listen for user zapping thread, if user carries out zapping operation, responds zapping event, first obtains user's zapping information, comprises programm name, current time; Then according to programm name and current time, by searching this program in database, be about to the program broadcasting, and feed back to portal and present.