...
Note: This document represents an ongoing effort of improvement, and so, will change as new paradigms are incorporated.
Attachments and External References
Attachments |
---|
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@ |
...