IPAC2013 - List of Authors (Chang, Y.-T.)

Paper	Title	Page
THPEA049	Implementation of the EPICS Data Archive System for the TPS Project	3255
	Y.-S. Cheng, Y.-T. Chang, J. Chen, P.C. Chiu, K.T. Hsu, C.H. Kuo, C.Y. Liao NSRRC, Hsinchu, Taiwan
	The EPICS framework was chosen as control system infrastructure for the new project of 3 GeV synchrotron light source (Taiwan Photon Source, TPS). Various control system prototypes of TPS with the EPICS mechanism have been gradually built and tested. One EPICS archive system is necessary to be developed to record various machine parameters and status information for long time logging. The archive system of CSS (Control System Studio) which named BEAUTY (Best Ever Archive Toolset, yet) was built to be used as the TPS data archive system in 3rd quarter of 2012. An archive engine takes PV data from EPICS IOCs via channel access, and stores them in the data storage. The PostgreSQL RDB (Relational Database) was adopted as the data storage for the BEAUTY. Both the historic PVs data and the archive engine configuration are saved into the same RDB. The archived data can be retrieved in a form of graphical representation using the CSS-based data browser. Taking the performance and redundancy into considerations, the storage servers and RDB table structures are tuned relatively. The efforts will be described at this report.

Paper

Title

Page

Implementation of the EPICS Data Archive System for the TPS Project

3255

Y.-S. Cheng, Y.-T. Chang, J. Chen, P.C. Chiu, K.T. Hsu, C.H. Kuo, C.Y. Liao
NSRRC, Hsinchu, Taiwan

The EPICS framework was chosen as control system infrastructure for the new project of 3 GeV synchrotron light source (Taiwan Photon Source, TPS). Various control system prototypes of TPS with the EPICS mechanism have been gradually built and tested. One EPICS archive system is necessary to be developed to record various machine parameters and status information for long time logging. The archive system of CSS (Control System Studio) which named BEAUTY (Best Ever Archive Toolset, yet) was built to be used as the TPS data archive system in 3rd quarter of 2012. An archive engine takes PV data from EPICS IOCs via channel access, and stores them in the data storage. The PostgreSQL RDB (Relational Database) was adopted as the data storage for the BEAUTY. Both the historic PVs data and the archive engine configuration are saved into the same RDB. The archived data can be retrieved in a form of graphical representation using the CSS-based data browser. Taking the performance and redundancy into considerations, the storage servers and RDB table structures are tuned relatively. The efforts will be described at this report.