RELATIONAL DATABASE SYSTEM IN THE KEKB ACCELERATOR CONTROL SYSTEM M.Kaji * , S.Yoshida ** , T.Kitabayashi *** , M.Takagi ** , N.Koizumi **** , T.Katoh, N.Yamamoto, T.T.Nakamura, J.Odagiri, A.Akiyama and K.Kudo, KEK, 1-1 Oho, Tsukuba, 305-0801 Japan * Mitsubishi Electric Co. Ltd. ** Kanto Information Service Co. Ltd. *** Mitsubishi Electric System & Service Co. Ltd. **** Mitsubishi Space Software Co. Ltd. Abstract A relational database system Oracle was installed in the KEKB accelerator control system. The database contains all the data concerning accelerator components such as magnets, power supplies, vacuum ducts, pumps, control modules and so on. It keeps the history of the equipment, parameters of the component, physical location, electrical characteristics, wire connection list and so on. It is also utilized to derive control parameters for EPICS such as name of the channel address, converting coefficients and so on. In the KEKB control system, number of control points is so large that it is not efficient to edit configuration files such as EPICS database files and MEDM files (configuration files of control windows). We have developed methods to create these files. 1. CONCEPT In the large accelerator system such as KEKB, the number of data to administrate is very large. It is necessary to have centralized data management system in the control system to maintain consistency of data. Centralized data system also encourages people to share data. We build the central data management system based on RDBMS (Relational Database Management System), “Oracle”. Our goal is to store all the data used in the KEKB system in this database and to configure the KEKB control system using these data. The KEKB control system uses EPICS (Experimental Physics and Industrial Control System, [1][2][3]) tool kit. EPICS tool kit is a collection of software on which a control system with a distributed runtime database is built. Each EPICS tool has its own configuration file. EPICS runtime database is also configured using a configuration file. In the KEKB control system, RDBMS provides various parameters to the EPICS database (device addresses, constants, and calibration data...). This scheme makes mass production of the EPICS database easy. RDBMS is also used for other EPICS tools (MEDM, ALH, and Archiver...). Therefore, when a parameter is changed or wiring is changed, all we have to do is to update data in the KEKB database and re-generate updated configuration files. For making this scheme work, it is important to keep the database on Oracle up to date. We use web browsers such as Netscape communicator and Microsoft Internet explorer as a tool to view or update data on the KEKB database. If a user can have proper permission, he can update data on the database from anywhere where a PC and network are available. 2. SPECIFICATION OF DATABASE Specification of the KEKB database system is shown bellow. RDBMS Oracle 7.3 Database Size about 1GB Server MITSUBISHI ME-RK 460 OS HP-UX 10.20 3. ELEMENTS OF THE KEKB DATABASE The KEKB database consists of six parts, the wiring database part, the control database part, the magnet database part, the RF database part, the vacuum database part and the BT (Beam Transport) database part. 3.1 Wiring Database The wiring database treats the data about wiring between two components as a form of “From” and “To” data. It can handle field bus cable connections, analog wire connections and analog cable connections. In the wiring database, the cables are treated as a batch of several wires. 3.2 Control Database The control database deals with the data about control devices such as VME subracks, VXI mainframes, CAMAC crates, and racks. In addition, it maintains logs of control devices, serial numbers of modules, failure reports, delivery dates, installation dates and so on. 3.3 Magnet Database The magnet database treats the data about devices related with magnets, such as magnets themselves, magnet power supplies, digital voltmeters of monitoring system and so on. It also stores measured data of magnetic field and parameters of excitation curves.