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 |
Accelerator |
Responsible person |
Schema@Instance |
|
---|---|---|---|---|---|---|---|---|---|
LCLS Infrastructure |
|
Multi-function database of LCLS devices and related data:
|
|
|
Engineers |
LCLS |
Andrea Chan, Elie Grunhaus |
LCLS_INFRASTRUCTURE@ |
|
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@ |
|
IRMIS |
x |
EPICS database configuration data:
|
perl crawler scripts/cron jobs run daily |
|
AIDA |
LCLS |
Judy Rock |
IRMISDB@ |
|
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 |
MAD and Online model data |
Java application |
Java application |
Operators |
LCLS |
Paul Chu |
MACHINE_MODEL@ |
Future plans:
Timeframe |
Application |
footnote (below) |
Uses Model data |
Descr. |
Input/Load |
UI/Output |
Users |
Acclerator |
Responsible person |
Instance
|
Longer Term |
Save/restore phase II |
|
|
implement phase II, with features as listed in the Save/Restore specs doc |
see above - existing app |
see above - existing app |
see above - existing app |
see above - existing app |
Debbie Rogind, Greg White |
see above - existing app |
? |
Message Log |
1 |
|
|
Applications:
|
APEX application |
Operations |
LCLS |
? |
MCCO |
Short/Long Term |
LCLS Infrastructure |
|
|
Enhance for XAL |
see above - existing app, and additional apps below |
see above - existing app, and additional apps below |
see above - existing app, and additional apps below |
see above - existing app, and additional apps below |
Andrea Chan, Elie Grunhaus |
see above - existing app, and additional apps below |
Shortterm |
CAPTAR |
|
|
|
|
|
|
|
Andrea Chan, Elie Grunhaus |
|
Feb, 2008 |
MPS |
|
|
"... a relational database for MPS so that both generation of code and queries can be derived from this master list." |
APEX App |
APEX App |
Engineers |
LCLS |
Stephen Norum, Andrea Chan, Elie Grunhaus |
SLACPROD |
Shortterm |
Modelling |
|
|
1. Model beamline and section definitions. An accelerator "section" is a part of the machine like the "injector spectrometer excursion" and is delineated by two so called "marker" |
? |
Model DB Access API |
Physicists |
LCLS |
Paul |
MCCO |
Longterm |
Emittance |
|
|
see * below
|
? |
? |
Physicists |
LCLS |
Debbie Rogind |
MCCO |
Longterm |
Profile Monitor |
|
|
|
? |
? |
Physicists |
LCLS |
Mike Zelazny, Sergei Chevtsov |
MCCO |
Longterm |
Wire Scans |
|
|
|
? |
? |
Physicists |
LCLS |
Sheng Peng |
MCCO |
Longterm |
Orbit Correction |
|
|
|
? |
? |
Physicists |
LCLS |
HLA group |
MCCO |
Longterm |
Orbit Applications |
|
|
|
? |
? |
Physicists |
LCLS |
HLA group |
MCCO |
unlikely - holdover from VMS system |
BPM Sampler |
|
|
Do we want a similar facility for LCLS. Is this a generalization of PV Logger? |
? |
? |
Physicists |
LCLS |
HLA group |
MCCO |
Longterm |
LEM |
|
|
|
? |
? |
Physicists |
LCLS |
HLA group |
MCCO |
Longterm |
Multiknobs and bumps |
|
|
|
? |
? |
Physicists |
LCLS |
HLA group |
MCCO |
Longterm |
Feedback |
|
|
|
? |
? |
Physicists |
LCLS |
Diane Fairley |
MCCO |
May be shortterm |
Start to End simulation |
1 |
|
Predict FEL power |
? |
? |
Physicists |
LCLS |
HLA group |
MCCO |
Longterm |
Button macro functions as saved scripts |
|
|
|
? |
? |
Operations |
LCLS |
HLA group |
MCCO |
Longterm |
Correlation Plots |
|
|
|
java |
java |
Operations |
LCLS |
HLA Group |
MCCO |
Longterm |
Matching |
|
|
|
java |
java |
Operations |
LCLS |
HLA Group |
MCCO |
Longterm |
Photon Applications |
|
|
Applications to support the photon beam and its interaction with the electron beam |
? |
? |
Operations |
LCLS |
? |
? |
Longterm |
Electron system data to be shared with the photon system |
|
|
Shared data (and api's?) |
? |
? |
Operations |
LCLS |
? |
? |
Footnotes:
- Predicted to produce large amounts of data.
Elements of HLA applications listed above:
- M&A = "Measurement", "Analysis" (M&A)
- "Configs" = stored sets of M&A setups, that can be configured and recalled interactively.
- Results
Issues to address:
- Need some mechanism for flagging large changes in production data that can affect (or break) existing applications.
Tasks:
- For the future database projects, and for the applications to be moved to MCCO need to approximate:
- initial data volume
- rate of data growth (start with "rows per day" and work from there)
-
-
- Database Instance Hosts and Locations*
Instance
Host
Location
SLACDEV
slac-oracle02
SCCS
SLACPROD
slac-oracle03
SCCS
MCCO
mccora2
MCC
MCCDB
mcc
MCC
DEMODB
mccdev
MCC
ORAP
?
SCCS
- Database Instance Hosts and Locations*
-