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:
- modelling deck
- devices
- polynomials
- cabling data
- laser device parameters
- inventory, links to QA documents and drawings
- web interface for IRMIS and Aida devices_and_attributes lists
| - APEX applications
- excel spreadsheet upload
- sql update (SQL Developer)
- insert/updates apps
- IRMIS devices_and_attributes list view
| - APEX query apps (for devices, etc.) with Excel spreadsheet export
- Modelling app (Affects AIDA tables in schemas AIDADEV and AIDAPROD)
| DRAW.MDDRAW AIDA_NAMES AIDA Tables SID Tables DRAW Tables Database Links Firewall Rules | Engineers CAD Designers Installation Physicists High Level Applicatons Operators | LCLS | Andrea Chan, Elie Grunhaus | LCLS_INFRASTRUCTURE@ SLACPROD
LCLS_INFRASTRUCTURE@ SLACDEV |
CAPTAR | | Racks, crates, cabling database | - Excel spreadsheet for initial upload
- Data administrator uses Oracle Forms
| web: cgi, asp, html | | Engineers | LCLS PEPII NLCTA | Andrea Chan, Elie Grunhaus | CAPTAR@SLACPROD |
CATER | | Problem reporting and management application | APEX | APEX | | Engineers Physicists Operators | LCLS PEPII NLCTA | Andrea Chan, et al | MCC_MAINT@SLACPROD |
AIDA | x | "Accelerator Integrated Data Access" accelerator data interactions (get, put, control operations) | shell and perl scripts/cron jobs run daily, and after DBINSTALL | - matlab, bigtime
- java applications (e.g. SCORE)
- web: jsp
- command line interface
- all
| Firewall Rules | Engineers Physicists | LCLS PEPII NLCTA | Greg White, Bob Hall | AIDAPROD@ SLACPROD AIDADEV@ SLACPROD |
IRMIS | x | EPICS database configuration data:
- list of IOCs
- IOC configuration data
- list of PVs and configured fields
- list of PVs by PV client
| perl crawler scripts/cron jobs run daily | - java
- web: jsp (now in development)
- APEX query page (from LCLS Infrastructure app)
- ad hoc queries (TOAD)
- AIDA query scripts
- pvlist query script
- LCLS Infrastructure queries
| Firewall Rules | AIDA pvlist Operators Engineers
| LCLS PEPII NLCTA | Judy Rock | IRMISDB@ SLACPROD
IRMISDB@ SLACDEV |
e-log:
- ELOG_OWNER
- ELOG_READER
- ELOG_WRITER
- PVLOGGER
| x | logging for accelerator operations | - web: php
- tcl/tk application
- unix watchdog
- control system applications
| - web: php
- tcl/tk application
| | Operations Engineers Physicists
| LCLS PEPII NLCTA | Bob Hall | ELOG_OWNER@MCCO ELOG_READER@MCCO ELOG_WRITER@MCCO
PVLOGGER@SLACDEV |
SCORE | x | save/restore ("configs") for accelerator operation setpoints and readbacks | - SCORE java application
- APEX application:
- excel spreadsheet upload
| - SCORE java application
- APEX query application
- shell scripts for deleting data
| | Operations Engineers Physicists | LCLS | Debbie Rogind (UI), Elie Grunhaus, Judy Rock (DB) | SCORE@MCCO SCORE@SLACDEV |
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 Physicists | NLCTA | Terri Lahey (DB), Judy Rock (load jobs) | DEMODB VMS |
Button macro database | x | stores SCP button macros | SCP | SCP | | Operators Physicists | PEPII NLCTA LCLS | Terri Lahey | MCCDB |
pvlists databases owned by Oracle users
- nlcdev
- nlcprod
- pvudb
- cd
these could probably be eliminated, with some work
| x | Databases of PV names assembled from IRMIS and PEPII-specific ascii file sources:
- nlcprod.pmu_list is used for the Artemis pmu selection lists.
- pvudb.pvu_rec contains PV names used as for AIDA batch load.
| load scripts | - AIDA update scripts
- Remedy snapshot for Artemis
| | AIDA scripts | PEPII NLCTA LCLS | Judy Rock | NLCDEV@SLACPROD NLCPROD@SLACPROD PVUDB@SLACPROD CD@SLACPROD
NLCDEV@SLACDEV NLCPROD@SLACDEV PVUDB@SLACDEV CD@SLACDEV |
BPM Orbit Display | x | BPM Orbit Display | Java application | Java application | | Operators Engineers Physicists | LCLS | Mike Zelazny | MACHINE_MODEL@SLACPROD |
Model DB | x | MAD and Online model data ERD | Java application | Java application | LcLs Tables AIDA Tables Database Links Firewall Rules | Operators Engineers Physicists | LCLS | Paul Chu | MACHINE_MODEL@ SLACPROD |