CN101242356B - Realization method and IPTV system for memory database in IPTV system - Google Patents
Realization method and IPTV system for memory database in IPTV system Download PDFInfo
- Publication number
- CN101242356B CN101242356B CN200710178891XA CN200710178891A CN101242356B CN 101242356 B CN101242356 B CN 101242356B CN 200710178891X A CN200710178891X A CN 200710178891XA CN 200710178891 A CN200710178891 A CN 200710178891A CN 101242356 B CN101242356 B CN 101242356B
- Authority
- CN
- China
- Prior art keywords
- service
- memory database
- database
- application server
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Fee Related
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an implementation method of a main memory database in IPTV system, comprising the steps that: the main memory database is arranged in each content distribution node and/or EPG application server; when the content distribution node and/or EPG application server are started, local main memory database is started and acquires required total service data of the content distribution node and/or EPG application server; when the service data in the service database is updated, the main memory database acquires increment service data from the service database. Accordingly, the invention provides an IPTV system for implementing the main memory database. Therefore, the processing ability of the EPG system and/or content distribution node in the IPTV system is improved.
Description
Technical field
The present invention relates to the technical field of memory in IPTV (Internet Protocol Television, the IPTV) system, relate in particular to the implementation method and the IPTV system thereof of memory database in a kind of IPTV system.
Background technology
The IPTV business is meant with set-top box and is linked into broadband network, is display terminal with PC or television set, thereby the broad band value-added service of a kind of interactive television experience and multimedia service is provided for the user.The IPTV system can provide video request program (Video on Demand, VOD), live telecast (Live TV) and time-moving television services such as (Time-shifted TV).
Fig. 1 shows IPTV system module structure, this IPTV system 10 respectively with OSS/BSS 20, in real time/non real-time content source 30, multicast control unit 40 and set-top box 50 communications connect, and described IPTV system 10 mainly comprises several subsystems: OSS 11, DRM (Digital RightManagement, digital copyright management) system 12, EPG (Electronic Program Guide, electronic program list) system 13, content-processing system 14, Content Management System 15, distributed flow media system 16, increased value service system 17, valut system 19 etc., wherein:
OSS 11 provides service management, business support and system management for IPTV system 10.12 pairs of streaming medium contents of DRM system are encrypted.EPG system 13 is divided into WEB service and EPG application service, and these two kinds of services can be finished in same station server.Content-processing system 14 is responsible for the processing of IPTV program, mainly comprises real time content processing and non real-time contents processing.Content Management System 15 is responsible for the Content Management of IPTV system 10.Valut system 19 is responsible for the various media contents that storage SP/CP (ServiceProvider/Content Provider, service provider/content supplier) offers IPTV system 10.Distributed flow media system 16 comprises: DSS-CDN (Distribution Streamingmedia System-Content DeliveryNetwork, the distribution of distributed flow media content) system 161 and SS (Streaming Server, streaming media server) 162.The position of increased value service system 17 in IPTV system 10 is identical with distributed flow media system 16, and it provides various value-added services to the user.
Following emphasis is described EPG system 13 and distributed flow media system 16.
In conjunction with illustrated in figures 1 and 2, distributed flow media system 16 comprises: distributed flow media content distribution (DSS-CDN) system 161 and streaming media server (SS) 162.Can comprise a streaming media server group of planes 1621, a media library group of planes 1622 and load equalizer 1623 in the streaming media server 162.DSS-CDN system 161 comprises: content distribution global controller (CDN-Manager) 1611 and Node Controller (CDN-Agent) 1612; A CDN-Agent 1612 and content distribution nodes 160 of a streaming media server group of planes 1621 common compositions form a service point simultaneously, comprise CDN Centroid and CDN fringe node.Each streaming media server 162 of CDN-Agent 1612 control these content distribution nodes 160 carries out content scheduling, content distribution, hot statistics, local being redirected.CDN-Manager1611 manage concentratedly content information, content in the whole DSS-CDN system 161 be injected into CDN, carry out DSS-CDN system 161 master data configuration, GSLB, between each content distribution nodes 160, carry out content scheduling, to improve the service quality that 16 pairs of user terminals 60 of whole distributed flow media system provide.Bring a problem simultaneously: each content distribution nodes 160 is in when operation, content and service parameter information that all must this node of access; There is a large amount of content distribution nodes 160 in a large-scale IPTV system 10, if each content distribution nodes 160 is disposed with gyp Service Database, certainly will increase cost; And if this content distribution nodes 160 adopts file storage, then must cause performance to reduce.
In summary, the memory technology in the existing IPTV system obviously exists inconvenience and defective, so be necessary to be improved on reality is used.
Summary of the invention
At above-mentioned defective, the object of the present invention is to provide the implementation method and the IPTV system thereof of memory database in a kind of IPTV system, it can improve the handling property of EPG system in the IPTV system and/or content distribution nodes.
To achieve these goals, the invention provides the implementation method of memory database in a kind of IPTV system, this IPTV system comprises some content distribution nodes, EPG application server and Service Database at least, and described method comprises that step has:
A, in each content distribution nodes and/or EPG application server, be deployed with memory database;
B, when described content distribution nodes and/or EPG application server start, simultaneously that it is local memory database starts, and described memory database obtains this content distribution nodes and/or the required full dose business datum of EPG application server from this Service Database;
C, when the business datum in the described Service Database take place to be upgraded, described memory database obtains the increment business datum from this Service Database;
Wherein, when described EPG application server and memory database collaborative work, the full dose business datum comprises various basic configuration data, all data relevant with this EPG application server in this EPG application server startup, Service Database; When described content distribution nodes and memory database collaborative work, the full dose business datum, comprise content-data, node basic configuration data, direct broadcast band the recording task table, generate aging contents table, and required other business datum of this node work.
The method according to this invention, in described EPG application server and the memory database collaborative work, described step B further comprises:
When B11, the startup of described EPG application server, start local memory database in the function call mode;
B12, described memory database send to Service Database and obtain the required full dose service data request of this EPG application server, and described Service Database returns this full dose business datum to memory database;
B13, described memory database import to the internal storage data structure with the full dose business datum that is obtained;
Described step C further comprises:
C11, the business datum of judging in this Service Database when described memory database are upgraded, and send to described Service Database and obtain the increment service data request;
C12, described Service Database are given this memory database with this increment business data transmission;
C13, described memory database import to the internal storage data structure with this increment business datum.
The method according to this invention, described step C11 further comprises:
Business datum in C111, described this Service Database of IPTV system update, stab the update time of upgrading simultaneously in the content synchronization table of this Service Database;
Stab the update time in the content synchronization table of C112, described this Service Database of memory database timing scan;
C113, described Service Database return to memory database stabbing the update time in this content synchronization table;
C114, described memory database are with the local time stamp of last successful synchrodata and stab this update time and compare, if stab local time stamp described update time, then send and obtain the increment service data request to described Service Database greater than last successful synchrodata; Otherwise turn back to step C112, to continue to wait for next timing scan processing.
The method according to this invention, described step C13 further comprises the step of EPG application server processes user terminal requests afterwards:
C14, user terminal are initiated service request to the EPG application server;
C15, described EPG application server send user's service data request of obtaining this service to this memory database;
C16, if described memory database does not retrieve this user's service data in this locality, then send the request of user's service data of obtaining this this service to this Service Database;
C17, described Service Database return this user's service data to this memory database;
C18, described memory database return this user's service data to the EPG application server.
The method according to this invention, described IPTV system comprises a distributed flow media system, this distributed flow media system comprises distributed flow media content delivering system and streaming media server, this distributed flow media content delivering system comprises content distribution global controller and some Node Controllers, and this Node Controller and a streaming media server group of planes are formed a content distribution nodes; In described content distribution nodes and memory database collaborative work, described step B further comprises:
When B21, the startup of described Node Controller, start local memory database in the function call mode;
B22, described memory database send to this Service Database and obtain the required full dose service data request of this content distribution nodes, and described Service Database returns this full dose business datum to memory database;
B23, described memory database import to the internal storage data structure with the full dose business datum that is obtained;
Described step C further comprises:
C21, described IPTV system send service message to this content distribution global controller;
C22, described content distribution global controller are handled this service message, and are upgraded this Service Database;
C23, described content distribution global controller send service message to the Node Controller of this content distribution nodes;
C24, described Node Controller are handled this service message, and upgrade local memory database.
The method according to this invention is provided with the Hash table of an overall situation in the described memory database, the definition of every table in this memory database and data that should table together as table element, and are inserted into this overall Hash table with this table element.
The method according to this invention, described table element further comprises:
Gauge outfit includes the data acknowledgment number of table name, field number, table and/or the pointer of first field;
Field element, include field name, field type, field precision length, this field the data strip number, point to the pointer of next field and/or point to the pointer of this first element of field;
Data element includes the pointer of data buffer zone, data buffer zone and/or points to the pointer of next data element.
The method according to this invention, if described data element is a character string type, then this data element uses the data buffer zone of fixed length to deposit character string; Perhaps this data element uses the data buffer zone of pointed one variable length of this data buffer zone, and the binding data length field is deposited character string.
The method according to this invention comprises at least one atomic operation function in the described memory database, the internal storage data structure in this atomic operation function direct control memory database;
When the described memory database of operation, directly call this atomic operation function, finish operation to internal storage data structure in the memory database; Perhaps
Also comprise a syntax parsing device in the described memory database, when the described memory database of operation, the input SQL statement, this SQL statement is after this syntax parsing device is resolved, the atomic operation function of invoke memory database is finished the operation to internal storage data structure in the memory database again.
The present invention also provides a kind of IPTV system that realizes memory database, this IPTV system comprises some content distribution nodes, EPG application server and Service Database at least, is deployed with memory database in described each content distribution nodes and/or the EPG application server; When described content distribution nodes and/or EPG application server start, simultaneously that it is local memory database starts, and described memory database obtains this content distribution nodes and/or the required full dose business datum of EPG application server from this Service Database; When the business datum in the described Service Database took place to upgrade, described memory database obtained the increment business datum from this Service Database.
The present invention is by being deployed to memory database each content distribution nodes and/or EPG application server, when content distribution nodes and/or the startup of EPG application server, memory database obtains required full dose business datum from Service Database, and when the business datum in Service Database took place to upgrade, described memory database obtained the increment business datum from this Service Database.Because the disposal ability of memory database is better than common database greatly, so the present invention has improved the disposal ability and the response speed of EPG system and each content distribution nodes in the IPTV system.Moreover the present invention does not need to dispose Service Database in each content distribution nodes, thereby has reduced the cost of each content distribution nodes, and then has reduced the cost of entire I PTV system.In addition, the present invention has improved the disposal ability and the performance of EPG system, makes the user when obtaining media services, can access more smooth experience.
Description of drawings
Fig. 1 is an IPTV system module structure chart;
Fig. 2 is an IPTV grid deployment diagram;
Fig. 3 is the IPTV system configuration schematic diagram that the present invention realizes memory database;
Fig. 4 is first kind of storage node composition that memory database of the present invention adopts;
Fig. 5 is second kind of storage node composition that memory database of the present invention adopts;
Fig. 6 is the implementation method flow chart of memory database in the IPTV of the present invention system;
Fig. 7 is EPG application server and a memory database collaborative work sequential chart among the present invention;
Fig. 8 is Node Controller among the present invention (CDN-Agent) and memory database collaborative work sequential chart.
Embodiment
In order to make purpose of the present invention, technical scheme and advantage clearer,, the present invention is further elaborated below in conjunction with drawings and Examples.Should be appreciated that specific embodiment described herein only in order to explanation the present invention, and be not used in qualification the present invention.
Basic thought of the present invention is: by memory database being deployed to each content distribution nodes and/or EPG application server, when content distribution nodes and/or the startup of EPG application server, memory database obtains required full dose business datum from Service Database, and when the business datum in Service Database took place to upgrade, described memory database obtained the increment business datum from this Service Database.
Fig. 3 shows the IPTV system configuration that the present invention realizes memory database, and this IPTV system 10 comprises some content distribution nodes 160, EPG application server 131 and Service Database 18 at least.Wherein:
Each content distribution nodes 160 is made of jointly a Node Controller (CDN-Agent) 1612 and a streaming media server group of planes 1621, and referring to illustrated in figures 1 and 2, content distribution nodes 160 comprises CDN Centroid and CDN fringe node.Among the present invention, can dispose memory database 1613 in the described content distribution nodes 160.
Described EPG application server 131 is used to realize the EPG application service of EPG system 13, also can realize the WEB service.Can dispose memory database 1311 in the described EPG application server 131.
Described Service Database 18 is used for the required miscellaneous service data of storing IP TV system 10.
In the present invention, be deployed with memory database 1613 and/or 1311 in each content distribution nodes 160 in the described IPTV system 10 and/or the EPG application server 131; When described content distribution nodes 160 and/or EPG application server 131 start, simultaneously that it is local memory database 1613 and/or 1311 starts, and described memory database 1613 and/or 1311 obtains the required full dose business datum of this content distribution nodes 160 and/or EPG application server 131 from this Service Database 18; When the business datum in the described Service Database 18 took place to upgrade, described memory database 1613 and/or 1311 obtained the increment business datum from this Service Database 18.
Wherein, mainly comprise EPG application server 131 and memory database 1311 collaborative works in the described IPTV system 10, and CDN-Agent 1612 and memory database 1613 collaborative works in the content distribution nodes 160, wherein:
When A1) EPG application server 131 starts, with memory database 1311 related startups, memory database 1311 obtains the required full dose business datum of this EPG application server 131 from Service Database 18, comprise various basic configuration data, by the end of this EPG application server 131 start, all data relevant in the Service Database 18 with this EPG application server 131, it is synchronous to be called full dose, and this full dose business datum is loaded into the internal storage data structure of memory database 1311 self.The described Service Database 18 preferred database servers that adopt are realized.
B1) processing of other subsystems in the IPTV system 10, upgraded the business datum in the Service Database 18 after, stabbed the update time of upgrading in the content synchronization table (synctable) of Service Database 18.For example, Content Management System 15 shown in Figure 1 is responsible for the Content Management of IPTV system 10, comprising: columns management, channel manage, program source management, Content Management, user management etc.Content Management System 15 carries out after the Business Processing, will increase Service Database 18, operation such as deletion, renewal.Simultaneously, stab the update time in the synctable table of Content Management System 15 renewal Service Databases.
C1) stab the update time in the synctable of memory database 1311 timing scan Service Databases 18 table, it is compared with the local time stamp of last successful synchrodata, and obtaining increment business datum in the Service Database 18, to be called an increment synchronous; If this increment is success synchronously, then memory database 1311 is updated to the value that stab update time in the synctable table on the Service Database 18 with the value of the local time stamp of local variable.
D1) as user terminal when EPG application server 131 sends service requests, EPG application server 131 at first obtains user's service data of this service to local memory database 1311, comprise the information such as column, program, channel, content and user property that the user asks; If relevant user's service data this locality does not exist, then memory database 1311 sends user's service data request of obtaining this service to Service Database 18, and user's service data of obtaining is returned to EPG application server 131.
CDN-Agent 1612 and memory database 1613 collaborative works comprise the steps: in the content distribution nodes 160
When A2) CDN-Agent 1612 starts, related startup memory database 1613, this memory database 1613 obtains this content distribution nodes 160 needed full dose business datums from Service Database 18, the aging contents table of recording task table, generation that comprises content-data, node basic configuration data, direct broadcast band, and required other business datum of this node work etc.
B2) in whole DSS-CDN system 16 runnings, can relate to the miscellaneous service operation, operations such as, channel recording aging such as: content injection, content scheduling, content, data configuration all can cause the renewal of this content distribution nodes 160 data; CDN-Manager 1611 upgrades Service Database 18; After treating that CDN-Manager 1611 upgrades Service Database 18 successes, CDN-Manager 1611 sends corresponding business message to CDN-Agent 1612; CDN-Agent 1612 at first handles the service message of receiving, upgrades local memory database 1613 then; If failure, then memory database 1613 and Service Database 18 cascade rollback.
Fig. 3 and Fig. 4 illustrate two kinds of storage organizations of memory database 1311 among the present invention and/or 1613, are provided with the Hash table (Hash Table) of an overall situation in the described memory database 1311 and/or 1613, are also referred to as the database Hash table.The definition of every table in this memory database 1311 and/or 1613 and data that should table together as table element, and are inserted into this overall Hash table with this table element.
Table element is mainly supported two kinds of data types: integer (int) and character string (string).The field of integer and character string type can have precision length, such as int (4) and string (255).Table element specifically comprises gauge outfit, field element, data element, wherein:
Described gauge outfit includes table name (TableName), field number (ColumnNum), the data acknowledgment number (RecordNum) of table and/or the pointer (next) of first field etc.
Described field element, include field name, field type, field precision length, this field data strip number (Datacounter), point to the pointer (next) of next field and/or point to the pointer (DataPointer) etc. of this first element of field.
Described data element includes the pointer of data buffer zone (Databuf), data buffer zone and/or points to pointer (DataPointer) of next data element etc.
Wherein, if data element is a character string type, because character string itself is elongated, thus can use the data buffer zone of a fixed length to deposit character string in the data element, as shown in Figure 3.Perhaps, this data element also can use the data buffer zone of pointed one variable length of this data buffer zone, as shown in Figure 4, and this pointer binding data length (DataLen) field, deposit a character string field.
The operating technology of memory database can realize some different atomic operation functions according to different storage organizations, the internal storage data structure in these atomic operation function direct control memory databases 1311 and/or 1613, just storage organization entity.In operation described memory database 1311 and/or 1613 o'clock, can directly call this atomic operation function, finish operation to internal storage data structure in memory database 1311 and/or 1613.Perhaps, one syntax parsing device also is provided in the described memory database 1311 and/or 1613, when the described memory database of operation, input SQL (Structured Query Language, SQL) statement, this SQL statement is after this syntax parsing device is resolved, and invoke memory database 1311 and/or 1613 atomic operation function are finally finished the operation to internal storage data structure in memory database 1311 and/or 1613 again.
Fig. 6 shows the implementation method flow process of memory database in the IPTV of the present invention system, and it is realized by IPTV system shown in Figure 3 10, comprises that specifically step is as follows:
Step S601 is deployed with memory database 1613 and/or 1311 in each content distribution nodes 160 and/or EPG application server 131.
Step S602, when described content distribution nodes 160 and/or 131 startups of EPG application server, simultaneously that it is local memory database 1613 and/or 1311 starts, and described memory database 1613 and/or 1311 obtains the required full dose business datum of this content distribution nodes 160 and/or EPG application server 131 from this Service Database 18.Described full dose business datum comprises in various basic configuration data, the Service Database 18 data that all are relevant with this EPG application server 131 and/or content distribution nodes 160, and it is synchronous to be called full dose.
Step S603, when the business datum in the described Service Database 18 took place to upgrade, described memory database 1613 and/or 1311 obtained the increment business datum of being upgraded from this Service Database 18, and it is synchronous to be called an increment.
Fig. 7 shows EPG application server and memory database collaborative work sequential among the present invention, and it is realized by IPTV system 10 shown in Figure 3, specifically comprises:
Step S701, EPG application server 131 starts.
Step S702, EPG application server 131 start local memory database 1311 in the mode of function call.
Step S703, memory database 1311 send to Service Database 18 and obtain the required full dose service data request of this EPG application server 131.
Step S704, Service Database 18 returns this full dose business datum to memory database 1311.
Step S705, memory database 1311 imports the internal storage data structure with the full dose business datum that is obtained.
Step S706, other subsystems in the described IPTV system 10 upgrade the business datum in (being access) these Service Databases 18, and stab the update time of upgrading simultaneously in the synctable table of this Service Database 18.Such as, the business datum in the Content Management System 15 storage service databases 18 shown in Figure 1, stab the update time of upgrading simultaneously in the synctable table in the Service Database 18.
Step S707, whether stab the update time in the memory database 1311 timing scan Service Databases 18 in the synctable table, upgrade to judge the business datum in this Service Database 18.
Stamp update time that step S708, Service Database 18 return in the synctable table turns back to memory database 1311.
Step S709, stab the update time that memory database 1311 will obtain from the synctable table, compare with the local time stamp (being the timestamp of synchrodata success last time) in the local variable, if stab greater than the local time stamp of preserving in the local variable update time in the synctable table, then execution in step S710 operation; Otherwise, otherwise turn back to step S707, to continue to wait for next timing scan processing.Described step S707～S709 is by memory database 1311 regularly cyclings.
Step S710, memory database 1311 send to Service Database 18 and obtain the increment service data request.
Step S711, Service Database 18 arrives memory database 1311 with the increment business data transmission.
Step S712, memory database 1311 imports to the internal storage data structure with the increment business datum of increment synchronization gain.
Step S713, other system in the IPTV system 10 or terminal are initiated service request to EPG application server 131.In the present embodiment, user terminal is initiated the multimedia service request to EPG application server 131.
Step S714, EPG application server 131 sends user's service data request of obtaining this service to memory database 1311, and this user's service data comprises the information such as column, program, channel, content and user property that the user asks.
Step S715 if memory database 1311 does not retrieve this user's service data at local internal memory, sends user's service data request of obtaining this service to this Service Database 18.
Step S716, Service Database 18 returns this to memory database 1311 and serves this user's service data.
Step S717, memory database 1311 return user's service data of this service to EPG application server 131.
Step S718, EPG application server 131 begin to provide service for user terminal.
Fig. 8 is Node Controller among the present invention (CDN-Agent) and memory database collaborative work sequential, and it is realized by IPTV system shown in Figure 3 10, comprises that specifically step has:
Step S801, Node Controller 1612 starts.
Step S802, Node Controller 1612 starts local memory database 1613 in the mode of function call.
Step S803, memory database 1613 send to Service Database 18 and obtain the required full dose service data request of this content distribution nodes 160, the i.e. whole business datums of content distribution nodes 160 required main points.
Step S804, Service Database 18 returns this full dose business datum to memory database 1613, and it is synchronous to be called a full dose.
Step S805, memory database 1613 will import to the internal storage data structure from the full dose business datum of Service Database 18 acquisitions.
Step S806, other subsystems are distributed global controller (CDN-Manager) 1611 transmission service messages to content in the IPTV system 10.
Step S807, CDN-Manager 1611 manage business after the message, and access Service Database 18 just upgrades this Service Database 18.
Step S808, CDN-Manager 1611 sends service message to Node Controller (CDN-Agent) 1612.
Step S809, Node Controller 1612 manage business after the message, upgrade the content of local memory database 1613.
In sum, the present invention is by being deployed to memory database each content distribution nodes and/or EPG application server, when content distribution nodes and/or the startup of EPG application server, memory database obtains required full dose business datum from Service Database, and when the business datum in Service Database took place to upgrade, described memory database obtained the increment business datum from this Service Database.Because the disposal ability of memory database is better than common database greatly, so the present invention has improved the disposal ability and the response speed of EPG system and each content distribution nodes in the IPTV system.Moreover the present invention does not need to dispose Service Database in each content distribution nodes, thereby has reduced the cost of each content distribution nodes, and then has reduced the cost of entire I PTV system.In addition, the present invention has improved the disposal ability and the performance of EPG system, makes the user when obtaining media services, can access more smooth experience.
Certainly; the present invention also can have other various embodiments; under the situation that does not deviate from spirit of the present invention and essence thereof; those of ordinary skill in the art work as can make various corresponding changes and distortion according to the present invention, but these corresponding changes and distortion all should belong to the protection range of the appended claim of the present invention.
Claims (10)
1. the implementation method of memory database in the IPTV system, this IPTV system comprises some content distribution nodes, EPG application server and Service Database at least, it is characterized in that, described method comprises that step has:
A, in each content distribution nodes and/or EPG application server, be deployed with memory database;
B, when described content distribution nodes and/or EPG application server start, simultaneously that it is local memory database starts, and described memory database obtains this content distribution nodes and/or the required full dose business datum of EPG application server from this Service Database;
C, when the business datum in the described Service Database take place to be upgraded, described memory database obtains the increment business datum from this Service Database;
Wherein, when described EPG application server and memory database collaborative work, the full dose business datum comprises various basic configuration data, all data relevant with this EPG application server in this EPG application server startup, Service Database; When described content distribution nodes and memory database collaborative work, the full dose business datum, comprise content-data, node basic configuration data, direct broadcast band the recording task table, generate aging contents table, and required other business datum of this node work.
2. method according to claim 1 is characterized in that, in described EPG application server and the memory database collaborative work, described step B further comprises:
When B11, the startup of described EPG application server, start local memory database in the function call mode;
B12, described memory database send to Service Database and obtain the required full dose service data request of this EPG application server, and described Service Database returns this full dose business datum to memory database;
B13, described memory database import to the internal storage data structure with the full dose business datum that is obtained;
Described step C further comprises:
C11, the business datum of judging in this Service Database when described memory database are upgraded, and send to described Service Database and obtain the increment service data request;
C12, described Service Database are given this memory database with this increment business data transmission;
C13, described memory database import to the internal storage data structure with this increment business datum.
3. method according to claim 2 is characterized in that, described step C11 further comprises:
Business datum in C111, described this Service Database of IPTV system update, stab the update time of upgrading simultaneously in the content synchronization table of this Service Database;
Stab the update time in the content synchronization table of C112, described this Service Database of memory database timing scan;
C113, described Service Database return to memory database stabbing the update time in this content synchronization table;
C114, described memory database are with the local time stamp of last successful synchrodata and stab this update time and compare, if stab local time stamp described update time, then send and obtain the increment service data request to described Service Database greater than last successful synchrodata; Otherwise turn back to step C112, to continue to wait for next timing scan processing.
4. method according to claim 2 is characterized in that, further comprises the step of EPG application server processes user terminal requests after the described step C13:
C14, user terminal are initiated service request to the EPG application server;
C15, described EPG application server send user's service data request of obtaining this service to this memory database;
C16, if described memory database does not retrieve this user's service data in this locality, then send the request of user's service data of obtaining this this service to this Service Database;
C17, described Service Database return this user's service data to this memory database;
C18, described memory database return this user's service data to the EPG application server.
5. method according to claim 1, it is characterized in that, described IPTV system comprises a distributed flow media system, this distributed flow media system comprises distributed flow media content delivering system and streaming media server, this distributed flow media content delivering system comprises content distribution global controller and some Node Controllers, and this Node Controller and a streaming media server group of planes are formed a content distribution nodes; In described content distribution nodes and memory database collaborative work, described step B further comprises:
When B21, the startup of described Node Controller, start local memory database in the function call mode;
B22, described memory database send to this Service Database and obtain the required full dose service data request of this content distribution nodes, and described Service Database returns this full dose business datum to memory database;
B23, described memory database import to the internal storage data structure with the full dose business datum that is obtained;
Described step C further comprises:
C21, described IPTV system send service message to this content distribution global controller;
C22, described content distribution global controller are handled this service message, and are upgraded this Service Database;
C23, described content distribution global controller send service message to the Node Controller of this content distribution nodes;
C24, described Node Controller are handled this service message, and upgrade local memory database.
6. method according to claim 1, it is characterized in that, be provided with the Hash table of an overall situation in the described memory database, the definition of every table in this memory database and data that should table together as table element, and are inserted into this overall Hash table with this table element.
7. method according to claim 6 is characterized in that, described table element further comprises:
Gauge outfit includes the data acknowledgment number of table name, field number, table and/or the pointer of first field;
Field element, include field name, field type, field precision length, this field the data strip number, point to the pointer of next field and/or point to the pointer of this first element of field;
Data element includes the pointer of data buffer zone, data buffer zone and/or points to the pointer of next data element.
8. method according to claim 7 is characterized in that, if described data element is a character string type, then this data element uses the data buffer zone of fixed length to deposit character string; Perhaps this data element uses the data buffer zone of pointed one variable length of this data buffer zone, and the binding data length field is deposited character string.
9. method according to claim 1 is characterized in that, comprises at least one atomic operation function in the described memory database, the internal storage data structure in this atomic operation function direct control memory database;
When the described memory database of operation, directly call this atomic operation function, finish operation to internal storage data structure in the memory database; Perhaps
Also comprise a syntax parsing device in the described memory database, when the described memory database of operation, the input SQL statement, this SQL statement is after this syntax parsing device is resolved, the atomic operation function of invoke memory database is finished the operation to internal storage data structure in the memory database again.
10. a realization is as the IPTV system of claim 1～9 method as described in each, this IPTV system comprises some content distribution nodes, EPG application server and Service Database at least, it is characterized in that, be deployed with memory database in described each content distribution nodes and/or the EPG application server; When described content distribution nodes and/or EPG application server start, simultaneously that it is local memory database starts, and described memory database obtains this content distribution nodes and/or the required full dose business datum of EPG application server from this Service Database; When the business datum in the described Service Database took place to upgrade, described memory database obtained the increment business datum from this Service Database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200710178891XA CN101242356B (en) | 2007-12-06 | 2007-12-06 | Realization method and IPTV system for memory database in IPTV system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200710178891XA CN101242356B (en) | 2007-12-06 | 2007-12-06 | Realization method and IPTV system for memory database in IPTV system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101242356A CN101242356A (en) | 2008-08-13 |
| CN101242356B true CN101242356B (en) | 2010-08-18 |
Family
ID=39933572
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200710178891XA Expired - Fee Related CN101242356B (en) | 2007-12-06 | 2007-12-06 | Realization method and IPTV system for memory database in IPTV system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101242356B (en) |
Families Citing this family (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101959089B (en) * | 2009-07-17 | 2013-06-12 | 中兴通讯股份有限公司 | Method for managing network element data in centralized mode and network element equipment |
| CN101635728B (en) * | 2009-09-02 | 2012-09-26 | 中兴通讯股份有限公司 | Method and system for data synchronization in content distribution network |
| CN101867613B (en) * | 2010-06-08 | 2014-12-17 | 中兴通讯股份有限公司 | Content delivery CDN sub system and data synchronization method |
| CN102480505A (en) * | 2010-11-30 | 2012-05-30 | 金蝶软件（中国）有限公司 | Data increment transmission method and device |
| CN102739704A (en) * | 2011-04-02 | 2012-10-17 | 中兴通讯股份有限公司 | Method and system for data migration in peer-to-peer network |
| CN102231749B (en) * | 2011-08-12 | 2013-12-11 | 乐视网信息技术（北京）股份有限公司 | System and method for transmitting live stream by utilizing content delivery network (CDN) |
| CN102279885A (en) * | 2011-08-16 | 2011-12-14 | 中兴通讯股份有限公司 | Method and device for operating data by memory database |
| CN102495834A (en) * | 2011-10-18 | 2012-06-13 | 成都康赛电子科大信息技术有限责任公司 | Incremental data cleaning method based on memory mapping |
| CN102685552B (en) * | 2012-05-08 | 2015-01-21 | 华为技术有限公司 | Error pattern generator (EPG) content metadata management method, server and system |
| CN102724548B (en) * | 2012-05-30 | 2017-10-10 | 中兴通讯股份有限公司 | A kind of IPTV service control unit, application process and IPTV system |
| CN102710665A (en) * | 2012-06-27 | 2012-10-03 | 深圳中兴网信科技有限公司 | Mobile terminal, and data synchronization method of server and mobile terminal |
| CN103701884A (en) * | 2013-12-18 | 2014-04-02 | 乐视网信息技术（北京）股份有限公司 | Data acquisition method, server and system |
| CN105025376B (en) * | 2014-04-30 | 2019-11-08 | 南京中兴新软件有限责任公司 | A kind of method and device realizing electronic program list and showing |
| CN105338367A (en) * | 2014-08-06 | 2016-02-17 | 中兴通讯股份有限公司 | Programme content inquiry processing method and device |
| CN105573732B (en) * | 2014-10-14 | 2019-06-11 | 阿里巴巴集团控股有限公司 | A kind for the treatment of method and apparatus of the business object based on distributed system |
| CN104268288B (en) * | 2014-10-21 | 2018-06-19 | 福州瑞芯微电子股份有限公司 | A kind of media library scan method and device based on NTFS |
| CN105260475B (en) * | 2015-10-30 | 2019-08-16 | 努比亚技术有限公司 | A kind of data search method, date storage method and related device |
| CN105912552A (en) * | 2015-12-23 | 2016-08-31 | 乐视网信息技术（北京）股份有限公司 | Method for capturing webpage video and terminal device for capturing webpage video |
| CN107465944A (en) * | 2017-08-31 | 2017-12-12 | 江苏省公用信息有限公司 | The gray scale delivery system and method for a kind of IPTV Content Management |
| CN112995723B (en) * | 2019-12-12 | 2023-09-22 | 中兴通讯股份有限公司 | EPG data management method and EPG server |
| CN112911370A (en) * | 2021-01-21 | 2021-06-04 | 海信视像科技股份有限公司 | Recording file and recording list display method and display equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1187695C (en) * | 2001-03-20 | 2005-02-02 | 宏碁股份有限公司 | Data fast taking system for server and its data updating method |
| CN1808394A (en) * | 2006-02-20 | 2006-07-26 | 南京联创科技股份有限公司 | Soft co-standby method based on memory database |
| WO2007067176A2 (en) * | 2005-12-08 | 2007-06-14 | Nortel Networks Limited | Session initiation protocol (sip) multicast management method |
| CN101055591A (en) * | 2007-05-25 | 2007-10-17 | 中兴通讯股份有限公司 | Data access method for all-memory database |
-
2007
- 2007-12-06 CN CN200710178891XA patent/CN101242356B/en not_active Expired - Fee Related
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1187695C (en) * | 2001-03-20 | 2005-02-02 | 宏碁股份有限公司 | Data fast taking system for server and its data updating method |
| WO2007067176A2 (en) * | 2005-12-08 | 2007-06-14 | Nortel Networks Limited | Session initiation protocol (sip) multicast management method |
| CN1808394A (en) * | 2006-02-20 | 2006-07-26 | 南京联创科技股份有限公司 | Soft co-standby method based on memory database |
| CN101055591A (en) * | 2007-05-25 | 2007-10-17 | 中兴通讯股份有限公司 | Data access method for all-memory database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101242356A (en) | 2008-08-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101242356B (en) | Realization method and IPTV system for memory database in IPTV system | |
| US20200245021A1 (en) | Reception apparatus, reception method, program, and information processing system | |
| US11350139B2 (en) | Video live broadcast method and apparatus | |
| CN103365865B (en) | Date storage method, data download method and its device | |
| CN101360221B (en) | Network television service adaptation method, server and system | |
| CN101867613B (en) | Content delivery CDN sub system and data synchronization method | |
| CN110555015B (en) | Database entity management method and device, electronic equipment and storage medium | |
| JP2007074724A (en) | Method and apparatus for synchronizing epg information between server and client in digital broadcasting network | |
| CN104079983A (en) | System and method for HLS program recording and service | |
| CN101489103A (en) | Recording method and profiling method for play-on-demand program | |
| CN102480520A (en) | Media data synchronism method based on differential metadata description structure | |
| CN101378397A (en) | Transmission system, transmission apparatus and method, reception apparatus and method, and recording medium | |
| CN109936751A (en) | Video recording method, device, equipment, computer readable storage medium and system | |
| CN101212664B (en) | Program editing, distribution, and request method | |
| CN101742247B (en) | Method and system for interactive web TV service authentication and EPG server | |
| CN103024477A (en) | Method, device and system for implementing IPTV (internet protocol television) system advertisements | |
| CN102172035A (en) | Manufacturing method and system of audio special | |
| CN102006156B (en) | Method and system for synchronizing configuration data among boards | |
| CN102158345B (en) | Method, device and system for data management | |
| CN102457760A (en) | Method, apparatus and system for realizing play insertion of content | |
| CN111225248B (en) | On-demand content management method and content distribution network on-demand server | |
| CN103686247A (en) | Method and system for video distribution based on synchronization and asynchronization | |
| CN103051929A (en) | Live playback content management method, system and content management system | |
| CN104065678B (en) | A kind of dual mode data based on built-in browser is received and access method | |
| CN102289494A (en) | System and method for generating video on demand one-way or two-way WEB navigation page |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20100818 Termination date: 20141206 |
|
| EXPY | Termination of patent right or utility model |