This page describes the relational databases and related systems of the LCLS controls environment. These are presently exclusively ORACLE.
Date of last (real) update: about 2014.
Attachments and External References
External References
Controls -> Database Infrastructure in sharepoint.
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 |