Speaker
Description
Since 2009 a relational database is used to store alignment data of accelerators at DESY. This includes magnets and other components together with their fiducialization data, nominal positions of accelerator components ("the lattice") and actual measurement data of components. Nominal alignment data for field work is produced "on the fly" by the database management system. After the alignment process the actual data is used to estimate the difference between nominal and actual lattice.
After a brief introduction to relational database management systems an overview of the internal table structure of the DESY coordinate database is given. The composition of the various tables into views that are suitable for everyday use is shown, as well as the database technology used for the adjustment of small measurement data sets.
