XAL based PV Browser

Jeff Patton, Chris Fowlkes

EPICS Collaboration Meeting – RDB SIG

June 12, 2006

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

2EPICS Collaboration Meeting, June 12, 2006

Environment

• Oracle RDB

• IRMISBase data structure

• SNS data structure

• XAL Framework (See XAL Status presentation by Tom Pelaia)

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

3EPICS Collaboration Meeting, June 12, 2006

Philosophy

• Integrate IRMISBase data with SNS data

• Use the XAL framework whose look and feel most SNS users are familiar with

• Simple RDB interaction through POJOsand database views to adapt IRMIS to SNS

• Tailor functions to SNS users

• But make UI configurable for anyone

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

4EPICS Collaboration Meeting, June 12, 2006

Installation

• Populate configuration table

• Set RDB connection parameters

• Install jars and JNLP files on web server

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

5EPICS Collaboration Meeting, June 12, 2006

PV Browser

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

6EPICS Collaboration Meeting, June 12, 2006

Startup

• Connects to RDB with a read only account

• Reads configuration table to determine objects to define

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

7EPICS Collaboration Meeting, June 12, 2006

Wild Card search

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

8EPICS Collaboration Meeting, June 12, 2006

Drill down by SNS naming components

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

9EPICS Collaboration Meeting, June 12, 2006

History

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

10EPICS Collaboration Meeting, June 12, 2006

Search Results

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

11EPICS Collaboration Meeting, June 12, 2006

Preview

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

12EPICS Collaboration Meeting, June 12, 2006

Search

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

13EPICS Collaboration Meeting, June 12, 2006

So I used all invalid names for my PV’s. It drives that

database guy nuts!

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

14EPICS Collaboration Meeting, June 12, 2006

Preview

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

15EPICS Collaboration Meeting, June 12, 2006

Probe

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

16EPICS Collaboration Meeting, June 12, 2006

View Links

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

17EPICS Collaboration Meeting, June 12, 2006

Map Links

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

18EPICS Collaboration Meeting, June 12, 2006

Probe multiple PV’s

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

19EPICS Collaboration Meeting, June 12, 2006

Export to .db file

OAK RIDGE NATIONAL LABORATORYU. S. DEPARTMENT OF ENERGY

20EPICS Collaboration Meeting, June 12, 2006

Future

• Advanced search

• Seamless export to VDCT

• Differences between IOC boots