A database scheme to manage operational points and calibration values at SPring-8/SACLA

Taking the opportunity that the control framework of SPring-8/SACLA accelerators is replaced toward upgrade projects, we developed a new database scheme to manage operational points and calibration values. In the scheme, each parameter group has a work area and a storage area in the relational database (RDB). At the end of each tuning step, the data in the work area are copied to the storage area with a proper label at any point of their tree structure for later use. The RDB tables are designed to handle a general format, so that the common access functions are available. One of challenges in the deployment is to make many user-level applications reusable. As an example, the calibration values of the beam position monitors were used to be scattered around in tables of various formats. Those are now rearranged in the same structure by assigning each aspect to an identifier like eqip_–id, element_–id, and bpmckt_–id, so that the manageability has been greatly improved. Since 2018, the new scheme has been used in the operation. (author)