Database Scheme for Unified Operation of SACLA / SPring-8

Okada, Kensuke; Fujiwara, Takahiro; Fukui, Toru; Hosoda, Naoyasu; Ishii, Miho; Maruyama, Toshiyuki; Sugimoto, Takashi; Sumitomo, Hiroshi; Watanabe, Kazuki; Yamaga, Mitsuhiro

doi:10.18429/JACoW-ICALEPCS2017-TUBPA03

Joint Accelerator Conferences Website

The Joint Accelerator Conferences Website (JACoW) is an international collaboration that publishes the proceedings of accelerator conferences held around the world.

RIS citation export for TUBPA03: Database Scheme for Unified Operation of SACLA / SPring-8

TY - CONF
AU - Okada, K.
AU - Fujiwara, T.
AU - Fukui, T.
AU - Hosoda, N.
AU - Ishii, M.
AU - Maruyama, T.
AU - Sugimoto, T.
AU - Sumitomo, H.
AU - Watanabe, K.
AU - Yamaga, M.
ED - Schaa, Volker RW
ED - Costa, Isidre
ED - FernÃ¡ndez, David
ED - Matilla, Ãscar
TI - Database Scheme for Unified Operation of SACLA / SPring-8
J2 - Proc. of ICALEPCS2017, Barcelona, Spain, 8-13 October 2017
C1 - Barcelona, Spain
T2 - International Conference on Accelerator and Large Experimental Control Systems
T3 - 16
LA - english
AB - For reliable accelerator operation, it is essential to have a centralized data handling scheme, for such as unique equipment ID's, archive and online data from sensors, and operation points and calibration parameters those are to be restored upon a change in operation mode. Since 1996, when SPring-8 got in operation, a database system has been utilized for this role. However, as time passes the original design got shorthanded and new features equipped upon requests pushed up maintenance costs. For example, as SACLA started in 2010, we introduced a new data format for the shot by shot synchronized data. Also number of tables storing operation points and calibrations increased with various formats. Facing onto the upgrade project at the site*, it is the time to overhaul the whole scheme. In the plan, SACLA will be the high quality injector to a new storage ring while in operation as the XFEL user machine. To handle shot by shot multiple operation patterns, we plan to introduce a new scheme where multiple tables inherits a common parent table information. In this paper, we report the database design for the upgrade project and status of transition.
PB - JACoW
CP - Geneva, Switzerland
SP - 201
EP - 205
KW - ion
KW - database
KW - operation
KW - FEL
KW - controls
DA - 2018/01
PY - 2018
SN - 978-3-95450-193-9
DO - 10.18429/JACoW-ICALEPCS2017-TUBPA03
UR - http://jacow.org/icalepcs2017/papers/tubpa03.pdf
ER -