基于MySQL的空管设备集中监控系统数据库设计

Design of Centralized Monitoring System Database for ATC Equipment Based on MySQL

为适应智慧机场建设这一未来机场发展的必然趋势,依据具体需求,选用MySQL设计一套用于空管设备集中监控系统的数据库,并使其承担系统数据存储、回查、分析等核心任务。设计利用E-R图进行需求分析,使用Navicat软件进行数据库的建立和管理,详细建立包含机场地区信息、台站信息、设备信息、设备本地、设备参数、历史数据、实时数据、告警信息、人员、事件等数据库表。经实验验证,数据库运转良好,设计方案现实可行。该设计已实际应用于国内多家机场。

In order to adapt to the development of smart airport,which is the inevitable trend of future airport development,MySQL is selected to design a set of database for centralized monitoring system of air traffic control equipment according to specific requirements,and it undertakes the core tasks of system data storage,back check and analysis.E-R graph is used to analysis demand,Navicat software is used for database establishment and management,and database tables including airport area information,station information,equipment information,local equipment,equipment parameters,historical data,real-time data,alarm information,personnel and events are established in detail.Experiments show that the database works well and the design scheme is practical and feasible.The design has been applied to many domestic airports.