作者通过分析BEPCII动态历史数据获取与查询系统存在的问题,深入研究了Oracle数据库,重新建立了BEPCII历史数据库,将表空间和表分区等技术引入Oracle历史数据库中,建立了独特的数据库模型。另外,通过研究EPICS数据获取机制,采用Java编程技术,开发了基于RCP的EPICS数据获取软件,并提供了友好的操作界面。通过该软件界面,用户可实时监测EPICS PV连接的状态,便于管理和维护。同时,作者建立了新的历史数据查询系统,并提供了曲线绘图、曲线放大、数据点时间提示、数据导出等功能,方便用户查看带有时间戳的历史数据。相关的研究内容,也可以应用到任何EPICS控制系统中。
After analyzing the problems with the dynamic data acquisition and historical data query system in the BEPCII deeply , the authors import the technology of the table -space and the table -partition to build a special database schema in Oracle .In addition , based on RCP and Java , EPICS data acquiring system is developed successfully with a very friendly user interface .It''s easy for users to look up the status of each PV''s connection , manage or maintain the system .Meanwhile , the authors also develop the system of data query , which provides many functions, including data query, data plotting, data exporting, data zooming, etc.All these work above can be applied in any EPICS control system .