ABSTRACT
ICALEPCS 2001

Abstracts



WEAP072 (Poster)

Presenter: Robert Sass (SLAC)
email: robert.sass@slac.stanford.edu
Review Status: Proceedings Ready - 01/08/02
FullText: pdf
Eprint: physics/0111146

An Integrated Enterprise Accelerator Database for the SLC Control System

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.
ICAL Footer

  eCONF C011127    ePROCEEDINGS COMMITTEES PARTICIPANTS    PROGRAM SUMMARY ICALEPCS 2001  eCONF

 

ICALEPCS 2001

Last updated: September 13, 2002

Website Problem? Contact Technical Publications

SLAC