Page History

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
  

Engineers
CAD Designers
Installation
Physicists
High Level Applicatons
Operators

LCLS

Andrea Chan, Elie Grunhaus

LCLS_INFRASTRUCTURE@SLACPROD INFRASTRUCTURE@
SLACPROD

LCLS_INFRASTRUCTURE@SLACDEVINFRASTRUCTURE@
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

Engineers
Physicists

LCLS
PEPII
NLCTA

Greg White, Bob HallAIDAPROD@SLACPROD

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

AIDA
pvlist
Operators
Engineers

LCLS
PEPII
NLCTA

Judy Rock

IRMISDB@
SLACPROD
IRMISDB@SLACPROD
IRMISDB@
IRMISDB@SLACDEVSLACDEV

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

MADD and Online data

Java application

Java application

Operators
Engineers
Physicists

LCLS

Paul Chu

MACHINE_MODEL@SLACPROD