skip to main content
OSTI.GOV title logo U.S. Department of Energy
Office of Scientific and Technical Information

Title: An Integrated Enterprise Accelerator Database for the SLC Control System

Abstract

Since its inception in the early 1980's, the SLC Control System has been driven by a highly structured memory-resident real-time database. While efficient, its rigid structure and file-based sources makes it difficult to maintain and extract relevant information. The goal of transforming the sources for this database 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 querying and reporting on beamline devices, their associations and parameters. In the future this will be extended to allow generation of EPICS and SLC database files, setup of applications and links to other databases such as accelerator maintenance, archive data, financial and personnel records, cabling information, documentation etc. The database is implemented using Oracle 8i. In the short term it will be updated daily in batch from the online SLC database. In the longer term, it will serve as themore » primary source for Control System static data, an R&D platform for the NLC, and contribute to SLC Control System operations.« less

Authors:
Publication Date:
Research Org.:
Stanford Linear Accelerator Center, Menlo Park, CA (US)
Sponsoring Org.:
USDOE Office of Energy Research (ER) (US)
OSTI Identifier:
799982
Report Number(s):
SLAC-PUB-9338
TRN: US200308%%468
DOE Contract Number:  
AC03-76SF00515
Resource Type:
Technical Report
Resource Relation:
Other Information: PBD: 7 Aug 2002
Country of Publication:
United States
Language:
English
Subject:
43 PARTICLE ACCELERATORS; ACCELERATORS; CONTROL SYSTEMS; DOCUMENTATION; MAINTENANCE; PERSONNEL

Citation Formats

Lahey, Terri E. An Integrated Enterprise Accelerator Database for the SLC Control System. United States: N. p., 2002. Web. doi:10.2172/799982.
Lahey, Terri E. An Integrated Enterprise Accelerator Database for the SLC Control System. United States. doi:10.2172/799982.
Lahey, Terri E. Wed . "An Integrated Enterprise Accelerator Database for the SLC Control System". United States. doi:10.2172/799982. https://www.osti.gov/servlets/purl/799982.
@article{osti_799982,
title = {An Integrated Enterprise Accelerator Database for the SLC Control System},
author = {Lahey, Terri E},
abstractNote = {Since its inception in the early 1980's, the SLC Control System has been driven by a highly structured memory-resident real-time database. While efficient, its rigid structure and file-based sources makes it difficult to maintain and extract relevant information. The goal of transforming the sources for this database 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 querying and reporting on beamline devices, their associations and parameters. In the future this will be extended to allow generation of EPICS and SLC database files, setup of applications and links to other databases such as accelerator maintenance, archive data, financial and personnel records, cabling information, documentation etc. The database is implemented using Oracle 8i. In the short term it will be updated daily in batch 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 SLC Control System operations.},
doi = {10.2172/799982},
journal = {},
number = ,
volume = ,
place = {United States},
year = {2002},
month = {8}
}

Technical Report:

Save / Share: