广播电视台光纤信息分层结构的设计与实现  

Design and Implementation of Optical Fiber Information Hierarchical Structure in Radio and Television Station

作　　者：李瑞民[1] 王史荣 高哲明 姚力 张毓鸣 Li Ruimin;Wang Shirong;Gao Zheming;Yao Li;Zhang Yuming(Shanghai Media Group,Shanghai 200041,China)

机构地区：[1]上海文化广播影视集团技术中心,上海200041

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

摘　　要：上海文化广播影视集团有限公司目前使用的是专用光纤网络,覆盖了上海主要区域。由于规划早、建设周期长、各阶段迭代式建设,因此网络的站点、光缆、业务都呈"多对多"的关系,如果数据结构设计不当,就会造成大量数据冗余,或者导致程序开发、排障困难,甚至造成使用时的数据修改不统一等问题。要解决这些问题,数据库需要采用分层化设计,即分为站点层、光缆层、光缆段层、光纤层、业务层,各层之间只通过关键字进行关联。通过基于数据库的网站设计、编码、开发、测试,以及试运行、正式运行,证实本文所述的数据结构设计清晰有效,开发直观,排障简易,具有一定的实用性。SMG is currently using a dedicated optical fiber network, covering main areas of Shanghai. Due to early planning, long construction period and iterative construction in each stage, network sites, optical cables and services are all in a many-to-many relationship. If data structure is not designed properly, it will cause a lot of data redundancy, or cause difficulties in program development and troubleshooting, and even cause problems such as inconsistent data modification during use. To solve these problems, database needs to adopt hierarchical design, that is, it is divided into site layer, optical cable layer, optical cable segment layer, optical fiber layer and business layer, and each layer is only related by keywords. In subsequent website design, coding, development, testing, trial operation and formal operation based on the database, it is proved that data structure design described in this paper is clear and effective, development is intuitive, troubleshooting is simple, and it has certain practicability.

关 键 词：光纤管理系统 数据库设计 分层规划 SMG 

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