SNS Database Status Smita Sathe SNS Project, BNL

1
SNS Database Status Smita SatheSNS Project,
BNL
2
SNS Databases
SNS NAMES Magnets, Power Supplies, Diagnostics
Devices, EPICS Records, Beam Elements, Vacuum,
Events .
Magnets
Power Supplies
Diagnostics Devices
Optics
EPICS
Mag_Ps
Ps_EPICS
Dd_EPICS
3
SNS Names Schema

• Contains names for Magnets, Power Supplies,
  Diagnostics Devices, RF devices, EPICS Records,
  Beam Elements, Vacuum devices etc.
• Names follow SNS Naming Convention
• Database Design and Basic Data Entry Tools are
  built to help follow the naming convention
  automatically

4
SNS Names Schema

• Expected to serve as a glue for other schemas
  such as Optics, Magnets etc. to keep the name
  consistency
• Schema design, Data Entry Forms and Reports are
  available on the WEB
• Many names have been entered in the database
  (thanks to Joanne and Jenny)
• Replication of the BNL database to ORNL is
  expected

5
Magnet Measurement and Survey Schema

• This database has been modeled after the work
  done on the LHC project, a multi lab
  collaboration (CERN, FNAL, BNL, KEK ).
• Magnet Schema is designed to be used for
• production-magnet quality assurance
• field and alignment error impact analysis
• multi-element assembly assistance and
• ring installation assistance.

6
Magnet Measurement and Survey Schema

• The Database Structure can be extended to
  include magnet data from Linac, HEBT and RTBT
• Logical and Physical design of the Magnet
  database is done using Designer 2000
• Design reports and diagrams are available on the
  WEB
• Schema has been installed at BNL as well as at
  ORNL

7
Optics Schema

• Contains the description of various components of
  the SNS Accelerator
• Database design is based on the Accelerator
  Definition Exchange Format(ADXF) document by
  Nikolay Malitsky
• A Schema of the Optics Database is published in a
  report, A Prototype of the SNS Optics Database

8
EPICS Requirements, Analysis and Design

• Background ..
• SNS Management initiative to use Oracle for EPICS
  Configuration
• A report on EPICS Configuration Database
  Requirements and Analysis for SNS
• Based on the requirements from Jinhu Song
• Based on observations and study of Bessys Power
  supply and Microtron Databases and KEK design
• Our experience in using AGS and RHIC
  Configuration databases

9
Background

• The report contains
• What information needs to be in the Database
• Some preliminary Design Ideas
• Expected Configuration Database Usage and
• Data Management and Viewing Tools Required
• Preliminary Design Ideas were presented in
  Jefferson Lab Database Workshop

10
EPICS Configuration With RDBMS
EPICS Application Capfast File
EPICS Record Database File (.db)
dbLoadTemplate
scripts
EPICS Config In RDBMS . IOC Info . EPICS
Application Info . Record Info . Device
Support . Driver Info
EPICS Record Template File
.dbd File
dbdcr
EPICS Record Macro Substitution File
Startup File (.cmd)
subcr
startcr
11
Configuration Management and Display Tools
An Application for . Data entry . Data
management . Create startup, .dbd files
WEB Based Config Browsers and Reporting Tools
EPICS Configuration in RDBMS
12
Conclusions

• Overall plan for SNS Database has been proposed
• Prototype version of SNS Names Database has been
  designed and implemented
• Magnets and Optics Database Schemas have been
  implemented
• A report on EPICS Configuration Database
  Requirements and Analysis has been written and
  Preliminary Design Ideas have been presented