This page describes the relational databases and related systems of the LCLS controls environment.
Note: This document represents an ongoing effort of improvement, and so, will change as new paradigms are incorporated.
Attachments and External References
Model Database Conceptual Requirements and Design (in sharepoint)
Current Database Applications and Schema
Control System Application |
Critical to ops |
Description |
Input/Load |
UI/Output |
Dependencies |
Users |
Accelerator |
Responsible person |
Schema@Instance |
|
---|---|---|---|---|---|---|---|---|---|---|
LCLS Infrastructure |
|
Multi-function database of LCLS devices and related data:
|
|
|
AIDA Tables |
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 |
|
Firewall Rules |
Engineers |
LCLS |
Greg White, Bob Hall |
AIDAPROD@ |
|
IRMIS |
x |
EPICS database configuration data:
|
perl crawler scripts/cron jobs run daily |
|
Firewall Rules |
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 |
LcLs Tables |
Operators |
LCLS |
Paul Chu |
MACHINE_MODEL@ |
Future plans
Timeframe |
Application |
footnote (below) |
Uses Model data |
Descr. |
Input/Load |
UI/Output |
Users |
Accelerator |
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.
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 |