基于大数据平台的EPICS历史数据归档系统  

EPICS historical data archiving system based on big data platform

作　　者：李嘉曾 韩利峰[1] 李丹清 黄文博[1] 吴丽梅 张立园 LI Jiazeng;HAN Lifeng;LI Danqing;HUANG Wenbo;WU Limei;ZHANG Liyuan(Shanghai Institute of Applied Physics,Chinese Academy of Sciences,Shanghai 201800,China;University of Chinese Academy of Sciences,Beijing 100049,China;Shanghai Jiao Tong University,Shanghai 200240,China)

机构地区：[1]中国科学院上海应用物理研究所,上海201800 [2]中国科学院大学,北京100049 [3]上海交通大学,上海200240

出　　处：《核技术》2019年第11期88-94,共7页Nuclear Techniques

基　　金：中国科学院战略先导科技专项(No.XDA02010300)资助~~

摘　　要：实验物理与工业控制系统(Experimental Physics and Industrial Control System,EPICS)用于大装置所产生的数据累积量,按照关系型数据库中所占字节计算可接近TB量级,目前采用的RDB Channel Archiver归档系统在这个量级上的查询性能已达到瓶颈状态,为了满足钍基熔盐堆(Thorium Molten Salt Reactor,TMSR)实验装置SF0(Solid Fuel)的运行数据保存和查询需要,本文对新一代归档系统Archiver Appliance进行了深层次的研究,并将其应用在SF0仪控系统上。该系统在功能上相比原归档系统具有更加快速的检索性能、丰富的系统状态查看界面,并具有直观的图表查看功能等。经过对其结构进行深入分析,发现了提高其查询速率的因素并进行了测试验证;同时针对系统的功能缺陷开发了实时监控工具,进行了页面的并发性能、查询性能等测试。经过测试比较,该系统的综合性能要明显优于RDB Channel Archiver,目前已在SF0仪控项目中稳定运行。[Background]The history data archived in an experimental physics and industrial control system(EPICS)-based control system for large-scale facility could reach the size of terabyte(TB)over a long period of time.For a large number of history data,the RDB Channel Archiver does not perform well in data retrieval.[Purpose]This study aims to implement a stable data storage as well as a faster retrieval system on solid fuel thorium molten salt reactor(TMSR-SF0).[Methods]First of all,the Archiver Appliance(AA),a new generation of archiving system,was studied in depth and applied to TMSR-SF0 instrument and controls.Compared with the RDB Channel Archiver,the AA system achieved faster retrieval speed,richer web interface including system status view,intuitive chart display,etc.Then,based on the depth analysis of AA system structure,factors related to the query rate were found and verified.Finally,a real-time monitoring tool was developed to display a process variable(PV's)value change on the web.The concurrency performance test and query performance test were performed on the web interface.[Results&Conclusions]The overall performance of AA system is proved to be better than that of RDB Channel Archiver.

关 键 词：SF0仪控系统 数据归档 Archiver APPLIANCE 实验物理与工业控制系统 

分 类 号：TL99[核科学技术—核技术及应用]