CN103139254A - Data synchronization method and system of internet protocol television (IPTV) network and Internet - Google Patents
Data synchronization method and system of internet protocol television (IPTV) network and Internet Download PDFInfo
- Publication number
- CN103139254A CN103139254A CN2011103896953A CN201110389695A CN103139254A CN 103139254 A CN103139254 A CN 103139254A CN 2011103896953 A CN2011103896953 A CN 2011103896953A CN 201110389695 A CN201110389695 A CN 201110389695A CN 103139254 A CN103139254 A CN 103139254A
- Authority
- CN
- China
- Prior art keywords
- data
- network
- internet
- database server
- iptv
- 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.)
- Pending
Links
Images
Landscapes
- Two-Way Televisions, Distribution Of Moving Picture Or The Like (AREA)
Abstract
The invention discloses a data synchronization method of an internet protocol television (IPTV) network and the Internet. The data synchronization method comprises the following steps that a source database server in the IPTV network obtains sequence change information of a source database which needs synchronization, the source database server pushes the sequence change information to a target database server in the external Internet in a pushing mode, and the target database server modifies a target database according to the sequence change information so that the target database server obtains the same data content with the source database server. The data synchronization method and the system of the IPTV network and the Internet break the restrictions of data synchronization between an IPTV internal network and the external Internet in the prior art, achieve automatic and initiative synchronization of the IPTV internal network with data content of a service provider on the Internet, bridge the restrictions of network isolation, and solves the technical problem that the IPTV service provider captures data information in the IPTV network in deed.
Description
Technical field
The present invention relates to the mutual network TV technology field, and be particularly related to method of data synchronization and system between a kind of IPTV network and the Internet.
Background technology
IPTV is IPTV, is a kind of broadband cabled television network that utilizes, and integrates the multiple technologies such as the Internet, multimedia, communication; The brand-new technology of the multiple interactive services that comprises Digital Television is provided to the domestic consumer.The user can have three kinds of modes to enjoy the IPTV service at home: (1) computer, (2) network machine top box+general television set, (3) mobile terminal (as IPad, IPhone etc.).The trend that it can adapt to current network develop rapidly well fully effectively utilizes Internet resources.IPTV both had been different from traditional analog cable TV, also was different from classical Digital Television.Because, traditional and Digital Television classics all have frequency division system, regularly, the characteristics such as One-to-All Broadcast; Although classical Digital Television has many technological innovations with respect to simulated television, the just change of signal form, and the circulation way of not touching media content.
IPTV is the infrastructure of utilizing broadband cabled television network, as main terminal appliance, provides the multiple digital media service that comprises TV programme with domestic television set by internet protocol.It has following characteristics: (1) user can obtain high-quality (near the DVD level) digital media service.(2) user can have the video frequency program that on the wideband IP network of degree of freedom selection very widely, each website provides.(3) realize the substantive interaction of media supplier and media consumer's.The playing platform that IPTV adopts will be the Typical Representative of family digital media termination of new generation, it can multimedia service function multiple according to user's option and installment, comprise digital television program, visible IP phone, DVD/VCD plays, the Internet visit, Email, and multiple on-line information consultant, amusement, education and business function.(4) provide wide emerging market for network Development business and program provider.
Because IPTV has above plurality of advantages, the content that depends on the value-added service of IPTV network also gets more and more, also more and more diversified, for example: in order to enrich the content of IPTV, third party's media content provider can provide programme content to select for the user to the IPTV content server.
But due to the consideration of IPTV network for internet security, communication between itself and outside the Internet is very restricted, see also Fig. 1, the video service system of IPTV is generally to be in the Intranet of IPTV, isolated with external the Internet, and do not open to the Internet user, this closure of IPTV network makes the IPTV network can't easily and carry out data communication between external the Internet.Cause a lot of value-added service providers can't in time comprehensively obtain the data information that user in the IPTV network uses its value-added service, although some IPTV video service system also provides the interface of uploading of content of multimedia for third party's media content provider, but still be confined in the IPTV network, need supplier that the content of multimedia of uploading is uploaded in the IPTV network, the synchronous real-time of data is subject to larger restriction, and operation is also inconvenient.
Summary of the invention
The present invention is intended to solve in prior art due to relative isolation between the TV networks such as IPTV network and the Internet, there is certain closure, cause external the Internet user's, particularly IPTV third party service provider to be difficult to obtain easily it the relevant information of service in the IPTV network platform is provided.
In view of this, the invention provides method of data synchronization between a kind of IPTV network and the Internet, it comprises the following steps: the source database server in the IPTV network obtains the change sequence information that needs synchronous source data; Described source database server adopts the propelling movement mode with described change sequence information pushing target database server in the external the Internet; Described target database server comes the modifying target database according to described change sequence information, makes the target database server obtain the data content consistent with the source database server.
Further, the method that described source database server obtains change sequence information comprises the following steps: all records that needs are synchronized to the source data on the target database server in external the Internet produce a reflection immediately, as change sequence information.
Further, the method that described source database server obtains change sequence information comprises the following steps: be to need synchronous source data to create corresponding trigger in described source database server, when described source data is modified, during insert or delete operation, described trigger is waken up, the change records of described source data is got off, and sequence information changes.
Further, the method that described source database server obtains change sequence information comprises the following steps: for the synchronous source data of described needs is set up the shadow data, set up and change Track Table, analyze source data and described shadow data and obtain net change information and described change information is saved in described variation Track Table, obtain change sequence information.
The present invention also provides data synchronous system between a kind of IPTV network and the Internet, and it comprises: be arranged at the source database server in the IPTV network, with the storage source data; Synchronous configuration module is connected with the work storehouse, with operational factor that database synchronization is set and be stored in described work storehouse; Network sends server, is connected with described work storehouse and described source database server; The first log pattern sends server with described network and is connected, to record ruuning situation; The Network Isolation module is in order to isolate IPTV network and the Internet; Be arranged at the target database server in the Internet, with the storage target data; The network reception server by described Network Isolation module, sends server with described network and is connected; The second log pattern is connected with described network reception server; Data update module is connected to described target database server and described network reception server.
Further, described parameter comprises: the method for synchronization of set of source data, source data, the name map of source data, field name mapping, field data types mapping, the connection parameter of database, network connect parameter.
Further, described network reception server end is in listening state all the time; Each communication sends server end by network and initiates to connect, until successful connection or connection failure, surpass number of retries and withdraw from.
In sum, method of data synchronization and system between IPTV network provided by the invention and the Internet, broken the restriction that in the prior art, between IPTV Intranet and external the Internet, data are synchronizeed, realized IPTV Intranet automation initiatively with the synchronizeing of the service provider's who is positioned at the Internet data content, cross over the restriction of Network Isolation, truly solved the technical problem of IPTV service provider's crawl data information in the IPTV net.
Description of drawings
Fig. 1 is the network topological diagram of IPTV network platform system in prior art;
Figure 2 shows that method of data synchronization flow chart between IPTV network that one embodiment of the invention provides and the Internet;
Fig. 2 A is depicted as the method schematic diagram that obtains change sequence information between IPTV network that one embodiment of the invention provides and the Internet in method of data synchronization;
Fig. 2 B is depicted as the method schematic diagram that obtains change sequence information between IPTV network that another embodiment of the present invention provides and the Internet in method of data synchronization;
Fig. 2 C is depicted as the method schematic diagram that obtains change sequence information between IPTV network that another embodiment of the present invention provides and the Internet in method of data synchronization;
Figure 3 shows that data synchronous system frame diagram between IPTV network that one embodiment of the invention provides and the Internet.
Embodiment
For above-mentioned feature and advantage of the present invention can be become apparent, exemplary embodiment cited below particularly, and cooperation accompanying drawing are described in detail below.
In the prior art, the running of IPTV net plateform system sees also Fig. 1, and IPTV network platform system 110 comprises user 111, set-top box 112, TV 113, fire compartment wall 114, streaming media server 115, content server 116, source database server 117, gateway 118.
Wherein the media services content of IPTV network platform system 110 is largely provided by the third party service provider 130, and the third party service provider 130 is connected with the specific network port that passes through of IPTV network, particularly the content server 131 of the third party service provider 130 is by the Internet 120, particular port and authentication through gateway 118, be connected with the content server 116 of IPTV network, with the media services content delivery to the content server 116 of IPTV network for user's 111 program requests.Due to the relative closure of IPTV network, between the third party service provider 130 and IPTV network platform system 110, the one way link mode is connected, can only uploading data and can not pull data.Thereby the third party service provider 130 can't obtain its media services content that provides by the information of user's 111 program requests, thereby can't throw in accurately media services content with strong points, and then better service is provided can't for user 111.
For addressing the above problem, the embodiment of the present invention provides method of data synchronization and system between IPTV network and the Internet.
See also Fig. 2, it is depicted as method of data synchronization flow chart between IPTV network that one embodiment of the invention provides and the Internet, and the method comprises the following steps:
Source database server in S210 IPTV network obtains the change sequence information that needs synchronous source data;
For example, initialization procedure, first the order program data information with user 111 is recorded in as source data in the source database server 117 of IPTV network, and when the media services content of user's 111 program requests sent variation, the change sequence information of source data was synchronized in source database server 117.
The described source database server of S220 adopts the propelling movement mode with described change sequence information pushing target database server in the external the Internet;
Because the IPTV network is isolated sealing relatively; and the higher network of level of security normally of the Intranet under the Network Isolation environment; its information should be protected completely; generally can not allow the modification of external user; database synchronization in such cases is mainly one-way synchronization, i.e. synchronous to outer net by Intranet, and for the better information of protection Intranet; all synchronous settings are all completed at transmitting terminal, adopt pushing-type model distribution synchrodata.
The described target database server of S230 comes the modifying target database according to described change sequence information, makes the target database server obtain the data content consistent with the source database server.
For example, the target database server of the third party service provider 130 is resolved described change sequence information according to described change sequence information, upgrades data information, and then the modifying target database.
In one embodiment of this invention, seeing also the method that the described source database server of Fig. 2 A obtains change sequence information comprises the following steps: needs are synchronized in external the Internet all records of the source data on the target database server 201 produce a reflection immediately, as change sequence information 202.
In the present embodiment, data synchronously adopt snapshot, i.e. storage object instant map at a time in database, and by being snapshot of synchronization object definition or adopting similar approach, can be with its current map as the content of upgrading target database.
Be the most simply to change catching method based on snapshot, can realize on any database or even other structurings or partly-structured data source.Its one need to rely on special mechanism, the outer system resource of occupying volume not, and management and operation also are very easy to, and are necessary when synchronous initiation and collapse recover.
In another embodiment of the present invention, see also Fig. 2 B, the method that described source database server obtains change sequence information comprises the following steps:
In the present embodiment, data synchronously adopt the trigger method, be to need synchronous source data 201 ' to create corresponding trigger 203 in described source database server, when to described source data 201 ' according to operational order 204 modify, during insert or delete operation, described trigger 203 is waken up, the change records of described source data 201 ' is got off, and sequence information 202 ' changes.
In another embodiment of the present invention, see also Fig. 2 C, the method that described source database server obtains change sequence information comprises the following steps:
In the present embodiment, data synchronously adopt the shadow table method, at first for the synchronous source data 201 of described needs " set up shadow data 205; set up and change Track Table; analyze source datas and described shadow data obtain net change information and described change information is saved in described variation Track Table by comparison program 206, obtain change sequence information 202 ".
This shadow table method can realize on any types of database, and application program can easily in multi-platform transplanting, therefore be well suited for solving heterogeneous database synchronous, as long as the shadow table method has memory space and the not high management cost that is doubled in source database.Be the net change value due to what obtain, efficiency of transmission can also further improve.
For explanation the present invention, below in conjunction with Fig. 3 in detail the present invention is described in detail.
See also Fig. 3, it is depicted as data synchronous system frame diagram between IPTV network that one embodiment of the invention provides and the Internet.
Data synchronous system between this IPTV network and the Internet comprises: be arranged at the source database server 310 in the IPTV network, with the storage source data; Synchronous configuration module 320 is connected with work storehouse 330, with operational factor that database synchronization is set and be stored in described work storehouse 330; Network sends server 340, is connected with described work storehouse 330 and described source database server 310; The first log pattern 350 sends server 340 with described network and is connected, to record ruuning situation; Network Isolation module 360 is in order to isolate IPTV network and the Internet 370; Be arranged at the target database server 380 in the Internet, with the storage target data; Network reception server 381 by described Network Isolation module 360, sends server 340 with described network and is connected; The second log pattern 382 is connected with described network reception server 390; Data update module 383 is connected to described target database server 380 and described network reception server 381.
At first, in the IPTV network platform system, by synchronous configuration module 320 initialization and the operational factor of database synchronization is set and is stored in described work storehouse 330.
Secondly, when source database server 310 data changed, the associated change sequence information was written into the first log pattern 350.
Again, send server 340 by network and via Network Isolation module 360, change sequence information is sent to system of the third party service provider in the Internet 370.
Then, the network reception server 381 in system of the third party service provider receives change sequence information, and is stored in the second log pattern 382.
Then, the data update module 383 in system of the third party service provider receives and analyzes in the second log pattern 382 change sequence information and carries out Data Update.
At last, the data of upgrading are stored in target database server 380, complete database in phase.
In embodiments of the present invention, the parameter of synchronous configuration module 320 settings comprises: the method for synchronization of set of source data, source data, the name map of source data, field name mapping, field data types mapping, the connection parameter of database, network connect parameter.
In embodiments of the present invention, described network reception server 381 ends are in listening state all the time; Each communication sends server 340 ends by network and initiates to connect, until successful connection or connection failure, surpass number of retries and withdraw from.
In sum, method of data synchronization and system between the IPTV network that the embodiment of the present invention provides and the Internet, broken the restriction that in the prior art, between IPTV Intranet and external the Internet, data are synchronizeed, realized IPTV Intranet automation initiatively with the synchronizeing of the service provider's who is positioned at the Internet data content, crossed over the restriction of Network Isolation, truly solved the restriction that between IPTV Intranet and external the Internet, data are synchronizeed, both facilitate IPTV service provider's crawl data information in the IPTV net, also guaranteed the fail safe of IPTV network.
Above demonstration and described basic principle of the present invention, principal character and advantage of the present invention.Those skilled in the art should understand; the present invention is not restricted to the described embodiments; what describe in above-described embodiment and specification is principle of the present invention; the present invention also has various changes and modifications without departing from the spirit and scope of the present invention, and these changes and improvements all fall in claimed scope of the present invention.The protection range that the present invention requires is defined by appending claims and equivalent thereof.
Claims (7)
1. method of data synchronization between an IPTV network and the Internet, is characterized in that, comprises the following steps:
Source database server in the IPTV network obtains the change sequence information that needs synchronous source data;
Described source database server adopts the propelling movement mode with described change sequence information pushing target database server in the external the Internet;
Described target database server comes the modifying target database according to described change sequence information, makes the target database server obtain the data content consistent with the source database server.
2. method of data synchronization between IPTV network according to claim 1 and the Internet, is characterized in that, the method that described source database server obtains change sequence information comprises the following steps:
All records that needs are synchronized to the source data on the target database server in external the Internet produce a reflection immediately, as change sequence information.
3. method of data synchronization between IPTV network according to claim 1 and the Internet, is characterized in that, the method that described source database server obtains change sequence information comprises the following steps:
Be to need synchronous source data to create corresponding trigger in described source database server, when described source data is modified, during insert or delete operation, described trigger is waken up, and the change records of described source data is got off, and sequence information changes.
4. method of data synchronization between IPTV network according to claim 1 and the Internet, is characterized in that, the method that described source database server obtains change sequence information comprises the following steps:
For the synchronous source data of described needs is set up the shadow data, set up the variation Track Table, analyze source data and described shadow data and obtain net change information and described change information is saved in described variation Track Table, obtain change sequence information.
5. data synchronous system between an IPTV network and the Internet, is characterized in that, comprising:
Be arranged at the source database server in the IPTV network, with the storage source data;
Synchronous configuration module is connected with the work storehouse, with operational factor that database synchronization is set and be stored in described work storehouse;
Network sends server, is connected with described work storehouse and described source database server;
The first log pattern sends server with described network and is connected, to record ruuning situation;
The Network Isolation module is in order to isolate IPTV network and the Internet;
Be arranged at the target database server in the Internet, with the storage target data;
The network reception server by described Network Isolation module, sends server with described network and is connected;
The second log pattern is connected with described network reception server;
Data update module is connected to described target database server and described network reception server.
6. data synchronous system between IPTV network according to claim 5 and the Internet, it is characterized in that, described parameter comprises: the method for synchronization of set of source data, source data, the name map of source data, field name mapping, field data types mapping, the connection parameter of database, network connect parameter.
7. data synchronous system between IPTV network according to claim 5 and the Internet, is characterized in that, described network reception server end is in listening state all the time; Each communication sends server end by network and initiates to connect, until successful connection or connection failure, surpass number of retries and withdraw from.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011103896953A CN103139254A (en) | 2011-11-30 | 2011-11-30 | Data synchronization method and system of internet protocol television (IPTV) network and Internet |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011103896953A CN103139254A (en) | 2011-11-30 | 2011-11-30 | Data synchronization method and system of internet protocol television (IPTV) network and Internet |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103139254A true CN103139254A (en) | 2013-06-05 |
Family
ID=48498555
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011103896953A Pending CN103139254A (en) | 2011-11-30 | 2011-11-30 | Data synchronization method and system of internet protocol television (IPTV) network and Internet |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103139254A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107122476A (en) * | 2017-05-02 | 2017-09-01 | 山东浪潮通软信息科技有限公司 | The treating method and apparatus of publicly-owned data under a kind of network isolation mode |
| CN109462592A (en) * | 2018-11-20 | 2019-03-12 | 北京旷视科技有限公司 | Data sharing method, device, equipment and storage medium |
| CN113342845A (en) * | 2021-06-23 | 2021-09-03 | 乐刷科技有限公司 | Data synchronization method, computer device and readable storage medium |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101860470A (en) * | 2009-04-13 | 2010-10-13 | 中国联合网络通信集团有限公司 | File synchronous processing method, synchronous gateway and file synchronizing system |
-
2011
- 2011-11-30 CN CN2011103896953A patent/CN103139254A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101860470A (en) * | 2009-04-13 | 2010-10-13 | 中国联合网络通信集团有限公司 | File synchronous processing method, synchronous gateway and file synchronizing system |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107122476A (en) * | 2017-05-02 | 2017-09-01 | 山东浪潮通软信息科技有限公司 | The treating method and apparatus of publicly-owned data under a kind of network isolation mode |
| CN109462592A (en) * | 2018-11-20 | 2019-03-12 | 北京旷视科技有限公司 | Data sharing method, device, equipment and storage medium |
| CN109462592B (en) * | 2018-11-20 | 2021-06-22 | 北京旷视科技有限公司 | Data sharing method, device, equipment and storage medium |
| CN113342845A (en) * | 2021-06-23 | 2021-09-03 | 乐刷科技有限公司 | Data synchronization method, computer device and readable storage medium |
| CN113342845B (en) * | 2021-06-23 | 2024-02-20 | 乐刷科技有限公司 | Data synchronization method, computer device and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101707635B (en) | Internet-based resource supplying system | |
| CN102710992B (en) | A kind of interactive message methods of exhibiting, Apparatus and system | |
| CN102843589B (en) | Intelligent advertisement cut system and intelligent advertisement inserting method | |
| CN104602098A (en) | Video barrage display method and equipment thereof | |
| CN101505253B (en) | Method and apparatus for providing data to network appliance in auxiliary appliance of network appliance | |
| CN101360221B (en) | Network television service adaptation method, server and system | |
| CN104145434A (en) | Channel changer for intelligent television | |
| CN103430567B (en) | Distributed recording of content | |
| CN109561351A (en) | Network direct broadcasting back method, device and storage medium | |
| CN101115185B (en) | Device for the third party to implement audio-video play in IPTV and method therefor | |
| CN103888515A (en) | Media resource sharing method based on browser | |
| CN103455505A (en) | Media acquiring method, media acquiring device and media acquiring system | |
| CN103024491B (en) | The video broadcasting method of mobile terminal and system | |
| CN103702235A (en) | Data processing method and system for content delivery network | |
| US9294803B2 (en) | Kiosk set-top-box | |
| CN103118018A (en) | Media resource synchronized broadcast method based on digital living network alliance (DLNA) and media resource synchronized broadcast device | |
| CN102883192A (en) | Media type processing method, media playing method and device in IPTV system | |
| CN103475930B (en) | Method for acquiring information, equipment and system | |
| CN109451259A (en) | Tv line, television system and data capture method of televising | |
| CN104301400B (en) | Multi-screen collaboration and resource share method based on Samba agreements | |
| CN103139254A (en) | Data synchronization method and system of internet protocol television (IPTV) network and Internet | |
| CN103269450B (en) | A kind of multimedia system towards Android intelligent television | |
| CN103685303A (en) | Method and system for processing connection content delivery network | |
| CN103748586A (en) | Intelligent television | |
| CN103067234A (en) | Identification and discovery method and system of intelligent device under heterogeneous network |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20130605 |