Abstracts |
T. Lahey, J. Rock, R. Sass, H. Shoaee, K. Underwood
Since its inception in the early 1980's, the SLC control system has been driven by a highly structured memory resident realtime database. While efficient, it's rigid structure and file-based sources makes it difficult to maintain and extract relevant information. The goal of transforming this into a relational form is to enable it to be part of a Control System Enterprise Database that is an integrated central repository for SLC accelerator device and control system data with links to other associated databases. We have taken the concepts developed for the NLC Enterprise Database and used them to create and load a relational model of the online SLC control system database. This database contains data and structure to allow 1) querying and reporting on beamline devices, their associations and parameters, 2) generation of controls software configurations (e.g. EPICS and SLC), 3) configuration and setup of applications, 4) links to other databases such as accelerator maintenance, financial and personnel records, cabling information, documentation etc. The database is implemented using Oracle 8i. In the short term it will be updated daily from the online SLC database. In the longer term it will serve as the primary source for control system static data, an R&D platform for the NLC, and contribute to SLAC control system operations.
[1]H. Shoaee, 'The Role of a Central Database for Configuration Management' International Conference on Accelerator and Large Experimental Physics Control Systems International Conference on Accelerator and Large Experimental Physics Control Systems, 1999, Trieste, Italy
{*}Work supported by Department of Energy contract DE^VAC03^V76SF00515.
eCONF
C011127
ePROCEEDINGS
COMMITTEES
PARTICIPANTS
PROGRAM
SUMMARY
ICALEPCS 2001
eCONF
|
||
Last updated: September 13, 2002 Website Problem? Contact Technical Publications |