Rdb systems at SNS

1
Rdb systems at SNS
EPICS Meeting 2005

• Jeff Patton
• and cast

April 27-29, 2005
2
Status

• Good level of integration in
• Acceleration Physics Application Programs
• Operations
• Document control
• Diagnostics
• Magnets
• Behind in the Controls arena but picking up steam
• Building accelerator while trying to design the
  software
• Better to have everything in place beforehand
• Increasing automation Sure Id love to use the
  dataYou mean I have to put data in?

3
Software systems

• Jeri
• PV Logger
• SCORE (Save Compare and Restore)
• Network Registration
• Application physics programs
• Electronic Logbook
• MPS audit
• Power Supply configuration
• Operations administration
• Bypass tracking

• Web Reports
• Panosophy (Jefferson Lab)
• Electronic Checklist
• Cable installation
• DataStream (COTS)
• ProjectWise (COTS PDM)
• Primavera (COTS)
• Instrumentation
• ODBC and JDBC do your own thing

4
Software systems
5
Obligatory ERD
6
IRMISBase

• Participating in the IRMISBase collaboration
• PVCrawler running at SNS on one boot server
• Added extensions for IOC version information
• Good test bed. Engineers from the 6 partner labs
  plus others. Still detecting new patterns
• Lots of data. Each reboot will initiate a full
  scan
• SNS is a descriptive and prescriptive model
  (primarily descriptive) so we have integrated the
  two

7
Jeri (Java EPICS Rdb Interface)

• Now built using the new desktop based XAL user
  interface classes (Chris Fowlkes)
• Breakout of useful classes into the ../Tools for
  database connector, Rdb table editor, etc. Tom
  Pelaia considering breaking UI components into
  SourceForge package
• Controls framework branch planned as part of
  IRMISBase collaboration
• Model-Viewer-Controller (MVC) design for heavy
  and thin client user interfaces
• Heavy client deployed via Java Webstart to be
  platform and location independent

8
Jeri IOCs
9
Jeri - IOC
10
Jeri - IOC
11
Electronic Logbook

• New features for Operations
• Daily Orders Required Reading
• Integrated Call List
• Improved thread display

12
Electronic Logbook
13
Operations
14
Operations
15
Operations

• Logbook entry on IOC reboot
• EDM screen passes field values to OS shell script
  which calls Perl script which executes database
  stored procedure to make Logbook entry
• ODBC connectivity within EDM?

16
Operations
17
Directions

• Continue to work with IRMISBase collaboration on
  additional crawlers, the hardware and cable
  crawlers
• Construct the XAL controls framework
• Build on existing infrastructure more and more
  detailed reports
• More prescriptive tools