CONTROLS DATABASE OVERVIEW: CURRENT USE and PLANS
Note: This document represents an ongoing effort of improvement, and so, will change as new paradigms are incorporated.
Current:
Control System Application | Critical to ops | Description | Input/Load | UI/Output | Users | Acclerator Accelerator | Responsible person | Schema@Instance | ||
---|---|---|---|---|---|---|---|---|---|---|
LCLS Infrastructure |
| Multi-function database of LCLS devices and related data:
|
|
| Engineers | LCLS | Andrea Chan, Elie Grunhaus | LCLS_INFRASTRUCTURE@SLACPROD | ||
CAPTAR |
| Racks, crates, cabling database |
| web: cgi, asp, html | Engineers | LCLS | Andrea Chan, Elie Grunhaus | CAPTAR@SLACPROD | ||
CATER |
| Problem reporting and management application | APEX | APEX | Engineers | LCLS | Andrea Chan, et al | MCC_MAINT@SLACPROD | ||
AIDA | x | "Accelerator Integrated Data Access" | shell and perl scripts/cron jobs run daily, and after DBINSTALL |
| Engineers | LCLS | Greg White, Bob Hall | AIDAPROD@SLACPROD | ||
IRMIS | x | EPICS database configuration data:
| perl crawler scripts/cron jobs run daily |
| AIDA | LCLS | Judy Rock | IRMISDB@SLACPROD | ||
e-log:
| x | logging for accelerator operations |
|
| Operations | LCLS | Bob Hall | ELOG_OWNER@MCCO | ||
SCORE | x | save/restore ("configs") for accelerator operation setpoints and readbacks |
|
| Operations | LCLS | Debbie Rogind (UI), | SCORE@MCCO | ||
History Buffers wildcard PV select feature: pvlist table** | x | displays SLC history for selected signals. Signal selection can be done using wildcard characters in names, which are matched in the Oracle DB. | pv list load is ultimately from the IRMIS database | SCP | Operators | NLCTA | Terri Lahey (DB), Judy Rock (load jobs) | DEMODB VMS | ||
Button macro database | x | stores SCP button macros | SCP | SCP | Operators | PEPII | Terri Lahey | MCCDB | ||
pvlists databases owned by Oracle users
| x | Databases of PV names assembled from IRMIS and PEPII-specific ascii file sources:
| load scripts |
| AIDA scripts | PEPII | Judy Rock | NLCDEV@SLACPROD | ||
BPM Orbit Display | x | BPM Orbit Display | Java application | Java application | Operators | LCLS | Mike Zelazny | MACHINE_MODEL@SLACPROD | ||
Model DB | x | MADD and Online data | Java application | Java application | Operators | LCLS | Paul Chu | MACHINE_MODEL@SLACPROD |
...