基于MySQL的上海光源光束线运行数据管理系统

Operation Data Management System Based on MySQL for SSRF

上海光源(SSRF)的控制系统采用的是基于Linux的EPICS系统,并使用自带的数据获取工具Channel Archiver实现运行数据的存储与管理。论文介绍了使用功能性较强的RDBMS(本文使用的是MySQL)和通用性较强的web方式来实现上海光源光束线的运行数据管理。在分析了Channel Ar-chiver以及它在EPICS的通信方式后,开发了数据获取引擎,并由此将数据导入MySQL数据库。之后开发了相关的查询系统,并提出一种改进型的提示查询方式。最后实现了基于MySQL的web方式的运行数据管理系统。该系统实现方便快捷,界面友好,并且可以实现跨平台的数据访问。

SSRF use the EPICS（Experimental Physics and Industrial Control System） system which is based on Linux for its control.Its data management system is based on the Channel Archiver which is an additional tool for getting system running data.But the Channel Archiver that we are still using has many defects in funtionality.So we use MySQL to manage the running data of SSRF for remedy.To achieve this,we developed a engine for sending data to MySQL server from Channel Archiver.In addition,we developed a web based data query system,which is more user friendly and more effective than before.Moreover,we developed a new suggestion method for user input,which make the UI more effective.