CN102724548A - IPTV service control unit, application method and IPTV system - Google Patents
IPTV service control unit, application method and IPTV system Download PDFInfo
- Publication number
- CN102724548A CN102724548A CN2012101716908A CN201210171690A CN102724548A CN 102724548 A CN102724548 A CN 102724548A CN 2012101716908 A CN2012101716908 A CN 2012101716908A CN 201210171690 A CN201210171690 A CN 201210171690A CN 102724548 A CN102724548 A CN 102724548A
- Authority
- CN
- China
- Prior art keywords
- service control
- database
- control unit
- sized
- 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.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an IPTV (Internet Protocol Television) service control unit which comprises an SCP (Service Control Point). The SCP comprises a service control server (CP) and a service data server (DB); and a large-scale relational database is deployed in the service data server (DB). The IPTV service control unit is characterized in that at least one miniature relational database is deployed in the IPTV service control unit, and data in the large-scale relational database is distributed into the miniature relational database in a slicing manner. The service control unit also comprises an internal memory database for caching session level data. The invention also discloses an IPTV service control method and an IPTV system. The IPTV service control unit, the IPTV service control method and the IPTV system have the benefits that the deployment manner of a traditional IPTV service control unit database is changed, the pressures of the relational databases are reduced, and on the other hand, the reading-writing speed of the data is accelerated, and the performance of the system is improved.
Description
Technical field
The present invention relates to IPTV Web TV field, particularly IPTV Service Control Unit, application process and IPTV system.
Background technology
IPTV also is IPTV; Be the infrastructure of utilizing broadband networks; With domestic television set or computer as main terminal equipment; Integrate multiple technologies such as the Internet, multimedia, communication, the brand-new technology of the multiple interactive digital media services that comprise DTV is provided to the domestic consumer through the IP agreement.
In order to guarantee that the IPTV system can satisfy the demand of ever-increasing customer volume, we often need go whole system is carried out dilatation, increase each network element device, change more high performance hardware device, with the performance of elevator system.Service Database is as the single-point of system; Can't promote performance through increase equipment; And only promote disposal ability through promoting the hardware device performance, had too many difficulties to cope with, in order to guarantee the lasting available of system; And satisfy the high concurrency of large user under measuring, the adoptable method of industry generally has following several kinds of modes:
One, adopts the data-base cluster mode, come load to bear the data processing pressure of whole system with distributed framework;
Two, adopt the hardware device of two-shipper+magnetic battle array
For first kind of mode, though solved the problem of database as single-point, the price comparison of data-base cluster is expensive, and secondly at 2-4 equipment, the performance boost of DB is apparent in view, and along with increasing of equipment, the cluster performance boost is also not obvious.
The second way can only be taken over service by equipment two when one of double-machine equipment breaks down, can't finally be promoted for the performance of DB; And for the magnetic battle array; Also be a single-point, when the magnetic battle array was unusual, two-shipper also can't provide service; Do not solve Service Database as single-point, owing to one point data storehouse system in case of system halt causes the disabled problem of whole system.
Summary of the invention
The invention provides a kind of IPTV Service Control Unit, application process and IPTV system,, improved the reading speed of data and the performance of system, and solved the problem of database single-point at service control server deployed database.
Technical scheme is following:
The Service Control Unit of a kind of IPTV; Comprise Service Control Point; Described SCP comprises service control server (CP) and business datum server (DB); Be deployed with large-scale relevant database in the described business datum server (DB), it is characterized in that: dispose at least one small-sized relevant database in the said IPTV Service Control Unit, the data in the said large-scale relevant database are assigned in the said small-sized relevant database through slicing mode.
Further, said IPTV Service Control Unit also comprises small-sized data server, and described small-sized data server is connected with said CP, and described small-sized relevant database is deployed in the described small-sized data server.
Further, said small-sized relevant database is deployed among the described CP.
Further, dispose at least one in the said IPTV Service Control Unit and be used for the memory database of buffer memory session level data.
The invention also discloses a kind of IPTV system, comprise described Service Control Unit.
The invention also discloses a kind of application process of Service Control Unit, it is characterized in that: said method comprises:
A, peripheral module issue data through interface and in described large-scale relevant database, store;
B, said large-scale relevant database with transfer of data in each said small-sized relevant database;
C, user login the IPTV system, and pass through terminal equipment when said CP sends landing request information, and said CP visits described small-sized relevant database, and the user is carried out authentication, if authentication is passed through, then the user lands;
When said CP sent program authentication request information, said CP visited described small-sized relevant database through terminal equipment for D, user, to user in the database the program that will watch carry out authentication, authentication is passed through, then broadcast program.
Further, step B further comprises:
B1, large-scale relevant database recording operation type and time stamp data, and with the mode spanned file of increment;
B2, small-sized relevant database are got delta file with the mode of FTP in large-scale relevant database;
B3, small-sized relevant database are resolved delta file, and the storehouse that Updates Information.
Further, step C further comprises:
C1, user login the IPTV system; And pass through terminal equipment when said CP sends landing request information; Said CP visits described memory database, if there is user's session information in the described memory database, said CP visits described small-sized relevant database; If authentication is passed through, then user's login;
C2, if do not have user's session information in the described memory database, then said CP is buffer memory new session information in described memory database, and visit described small-sized relevant database and carry out authentication.
Further, step D further comprises:
Described step D further comprises:
The user passes through terminal equipment when said CP sends program authentication request information; Said CP visits described memory database, and checking user's session information is if verify successfully; Said CP visits described small-sized relevant database; If authentication passes through, then said CP visits described small-sized relevant database, to user in the database the program that will watch carry out authentication.
The present invention introduces small-sized relevant database in CP, every CP only visits the small-sized relevant database of oneself, has alleviated the pressure of large-scale relevant database, and has accelerated data write speed, has improved the performance of system; The present invention has also introduced memory database in CP in addition, is used for buffer memory session level data, in the original system; These deposit data are in large-scale relevant database; Because frequent operation is very big to the performance impact of large-scale relevant database, behind the introducing memory database; Session data leaves in the memory database, and performance boost is obvious.
Description of drawings
Fig. 1 is according to the flow chart of transfer of data between the database in the embodiment of the invention;
Fig. 2 is the flow chart according to transfer of data between CP in the embodiment of the invention and the DB;
Fig. 3 is the flow chart according to method in the embodiment of the invention.
Embodiment
Below in conjunction with accompanying drawing preferential embodiment of the present invention is described, should be appreciated that preferred embodiment described herein only is used for explanation and explains the present invention, but be not used in qualification the present invention.
According to Fig. 1-shown in Figure 2; The invention discloses the Service Control Unit of a kind of IPTV; Comprise Service Control Point, SCP comprises service control server 1 and business datum server 5, is deployed with ORACLE database 3 in the business datum server 1; Dispose MYSQL database 2 in the service control server 1, the data in the ORACLE database 3 are assigned in each MYSQL database 2 through slicing mode.Service Control Unit also comprises the dcache database 4 that is used for buffer memory session level data, and dcache database 4 adopts trunking mode to be deployed in the service control server 1.
The Service Control Unit application flow is following:
S1, peripheral module issue data to ORACLE database 3 through interface;
S2, ORACLE database 3 storage data, and with the form spanned file of increment;
S3, MYSQL database 2 are got delta file with the mode of FTP in ORACLE database 3;
S4, MYSQL database 2 are resolved delta file, and file data are updated in the MYSQL database 2;
S5, user login the IPTV system; And passing through terminal equipment when service control server 1 is sent landing request information, service control server 1 visit dcache database 4 is if exist user's session information in the dcache database 4; Service control server 1 visit MYSQL database 2; If authentication is passed through, then user's login
S6, if there is not user's session information in the dcache database 4, then service control server 1 buffer memory new session information in dcache database 4, and visit MYSQL database 2 carries out authentication.
S7, user pass through terminal equipment when service control server is sent program authentication request information; Service control server 1 visit dcache database 4, checking user's session information is if verify successfully; Service control server 1 visit MYSQL database 2; If authentication passes through, service control server 1 visit MYSQL database 2 then, to user in the database the program that will watch carry out authentication.
S8, authentication are passed through, and the user watches program.
The distributed use of MYSQL database 2 effectively reduces the dependence performance of existing system to ORACLE database 3, and the MYSQL failure of single node does not influence user's service.
DCACHE uses the key-value interface; Performance can reach the concurrency of single node 24W, and adopts the DCACHE pattern of cluster, has promoted the reliability of DCACHE more; In the situation that one or more DCACHE crash, other DCACHE server can normally be taken over service.
The present invention also provides a kind of IPTV system, comprises described Service Control Unit.
MYSQL database 2 among the present invention can be deployed in the small-sized data server separately; Also can be deployed among the CP; Dcache database 4 can be deployed in separately in the Inmemory data server; Also can be deployed among the CP, the data of handling if desired are many, can increase the quantity of MYSQL database 2 and dcache database 4.
Claims (11)
1. the Service Control Unit of an IPTV; Comprise Service Control Point; Described SCP comprises service control server (CP) and business datum server (DB); Be deployed with large-scale relevant database in the described business datum server (DB), it is characterized in that: dispose at least one small-sized relevant database in the said IPTV Service Control Unit, the data in the said large-scale relevant database are assigned in the said small-sized relevant database through slicing mode.
2. Service Control Unit according to claim 1; It is characterized in that: said IPTV Service Control Unit also comprises small-sized data server; Described small-sized data server is connected with said CP, and described small-sized relevant database is deployed in the described small-sized data server.
3. Service Control Unit according to claim 1 is characterized in that: said small-sized relevant database is deployed among the described CP.
4. according to claim 2 or 3 described Service Control Units, it is characterized in that: dispose at least one in the said IPTV Service Control Unit and be used for the memory database of buffer memory session level data.
5. Service Control Unit according to claim 4; It is characterized in that: said IPTV Service Control Unit also comprises Inmemory data server; Described Inmemory data server is connected with said CP, and said memory database is deployed in the described Inmemory data server.
6. Service Control Unit according to claim 4 is characterized in that: said memory database is deployed among the described CP.
7. an IPTV system is characterized in that: comprise according to claim 5 or 6 described Service Control Units.
8. application process according to claims 1 described Service Control Unit is characterized in that: said method comprising the steps of:
A, peripheral module issue data through interface and in described large-scale relevant database, store;
B, said large-scale relevant database with transfer of data in each said small-sized relevant database;
C, user login the IPTV system, and pass through terminal equipment when said CP sends landing request information, and said CP visits described small-sized relevant database, and the user is carried out authentication, if authentication is passed through, then the user lands;
When said CP sent program authentication request information, said CP visited described small-sized relevant database through terminal equipment for D, user, to user in the database the program that will watch carry out authentication, authentication is passed through, then broadcast program.
9. application process according to claim 8 is characterized in that: said step B further comprises:
B1, described large-scale relevant database recording operation type and time stamp data, and with the mode spanned file of increment;
B2, said small-sized relevant database are got delta file with the mode of FTP in said large-scale relevant database;
B3, said small-sized relevant database are resolved delta file, and the storehouse that Updates Information.
10. application process according to claim 8 is characterized in that: described step C further comprises:
C1, user login the IPTV system; And pass through terminal equipment when said CP sends landing request information; Said CP visits described memory database, if there is user's session information in the described memory database, said CP visits described small-sized relevant database; If authentication is passed through, then user's login;
C2, if do not have user's session information in the described memory database, then said CP is buffer memory new session information in described memory database, and visit described small-sized relevant database and carry out authentication.
11. application process according to claim 8 is characterized in that: described step D further comprises:
The user passes through terminal equipment when said CP sends program authentication request information; Said CP visits described memory database, and checking user's session information is if verify successfully; Said CP visits described small-sized relevant database; If authentication passes through, then said CP visits described small-sized relevant database, to user in the database the program that will watch carry out authentication.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210171690.8A CN102724548B (en) | 2012-05-30 | 2012-05-30 | A kind of IPTV service control unit, application process and IPTV system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210171690.8A CN102724548B (en) | 2012-05-30 | 2012-05-30 | A kind of IPTV service control unit, application process and IPTV system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102724548A true CN102724548A (en) | 2012-10-10 |
| CN102724548B CN102724548B (en) | 2017-10-10 |
Family
ID=46950190
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210171690.8A Active CN102724548B (en) | 2012-05-30 | 2012-05-30 | A kind of IPTV service control unit, application process and IPTV system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102724548B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101242356A (en) * | 2007-12-06 | 2008-08-13 | 中兴通讯股份有限公司 | Realization method and IPTV system for memory database in IPTV system |
| US20090198834A1 (en) * | 2000-04-04 | 2009-08-06 | Broadjump, Inc. | Distributed services architecture through use of a dynamic service point map |
| US20090292740A1 (en) * | 2008-05-23 | 2009-11-26 | Orbitz Worldwide, L.L.C | Database management system and method |
| US7702698B1 (en) * | 2005-03-01 | 2010-04-20 | Yahoo! Inc. | Database replication across different database platforms |
-
2012
- 2012-05-30 CN CN201210171690.8A patent/CN102724548B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090198834A1 (en) * | 2000-04-04 | 2009-08-06 | Broadjump, Inc. | Distributed services architecture through use of a dynamic service point map |
| US7702698B1 (en) * | 2005-03-01 | 2010-04-20 | Yahoo! Inc. | Database replication across different database platforms |
| CN101242356A (en) * | 2007-12-06 | 2008-08-13 | 中兴通讯股份有限公司 | Realization method and IPTV system for memory database in IPTV system |
| US20090292740A1 (en) * | 2008-05-23 | 2009-11-26 | Orbitz Worldwide, L.L.C | Database management system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102724548B (en) | 2017-10-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104104717B (en) | Deliver channel data statistical approach and device | |
| CN107943841A (en) | Stream data processing method, system and computer-readable recording medium | |
| CN110647512B (en) | Data storage and analysis method, device, equipment and readable medium | |
| CN104572689A (en) | Data synchronizing method, device and system | |
| CN101557427A (en) | Method for providing diffluent information and realizing the diffluence of clients, system and server thereof | |
| CN109218100A (en) | Distributed objects storage cluster and its request responding method, system and storage medium | |
| CN105530272A (en) | Method and device for application data synchronization | |
| CN111343241B (en) | Graph data updating method, device and system | |
| CN103336815A (en) | System and method of pushing network advertising | |
| CN107888666A (en) | A kind of cross-region data-storage system and method for data synchronization and device | |
| CN105094868A (en) | Software upgrading method, server and terminal | |
| CN103164525A (en) | Method and device for WEB application release | |
| US9374475B1 (en) | System for processing customer records | |
| CN103034722A (en) | Network video comment gathering device and network video comment gathering method | |
| CN103167428A (en) | Picture adaptive method, mobile phone newspaper delivering device and system | |
| CN112559513A (en) | Link data access method, device, storage medium, processor and electronic device | |
| CN105868170A (en) | Method for generating industrial data report in server | |
| CN110442564A (en) | Incremental data method of calibration, storage medium | |
| CN109871394B (en) | Full-distributed high-concurrency calculation method and device | |
| CN115641180A (en) | Request processing method, related device and equipment | |
| CN102929561A (en) | Method for solving disorder of magnetic disks set up by hadoop cluster | |
| US11460321B2 (en) | Enhanced meter management solution | |
| CN105024974B (en) | The message treatment method and device of IPTV | |
| CN105723365A (en) | Method for optimizing index, master database node and subscriber database node | |
| CN113934797B (en) | Banking industry super-large data synchronization method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |