A Historical Database for the ESRF Machine Control System

E.Taurel
ESRF

The European Synchrotron Radiation Facility (ESRF) is a 6 Gev synchrotron radiation source which has been in operation now for more than 3 years. This paper describes the system recently implemented for the ESRF machine control system history database. This set of software is based on the ORACLE RDBMS tool (release 7.1). The author details how data are stored into the database, the database structure, the database filling and the possible storage modes, how the user acts on the filling mechanism (storage mode choice, data to store...) and how it is possible to get data out of this database for analysis or for long term archiving.