播出系统数据库维护与改造方案的研究  

Research on Maintenance and Transformation Scheme of Broadcasting System Database

作　　者：滕兴中 Teng Xingzhong(Changsha Radio and Television Technology Centre,Hunan 410004,China)

机构地区：[1]长沙广播电视技术中心,湖南410004

出　　处：《广播与电视技术》2021年第4期124-128,共5页Radio & TV Broadcast Engineering

摘　　要：播出数据库是整个电视播出系统的数据核心,是播出软件、上载软件、编单软件、广告打包软件、技审软件正常运行的数据支撑。本文对电视播出系统使用Oracle数据库集群过程中出现的硬件和软件故障进行了分析、总结;并根据业务应用、经济效益和技术人员对数据库可维护性、可扩展性等方面的综合分析、研究,对播出数据库进行了技术改造,将Oracle数据库管理系统改造为SQL Server数据库管理系统,升级播出数据库实例,播出业务应用可同时支持B/C架构和B/S架构。Broadcasting database is data core of the whole TV broadcasting system, and it provides data support for normal operation of broadcasting software, upload software, bill compiling software, advertising packaging software and technical audit software. This paper analyzes and summarizes hardware and software failures in the process of using Oracle database cluster in TV broadcasting system. And according to comprehensive analysis and research of business application, economic benefits and technical personnel on database maintainability and scalability, broadcasting database is technically transformed. Oracle database management system is transformed into SQL Server database management system, and broadcasting database instance is upgraded. Broadcasting business application can support both B/C architecture and B/S architecture.

关 键 词：电视播出系统 ORACLE数据库 SQL Server数据库 

分 类 号：TN948[电子电信—信号与信息处理]