IRMIS at TRIUMF

1
IRMIS at TRIUMF

• R.Keitel
• Epics Collaboration Meeting, Padova, Oct. 2008

2
TRIUMF Environment

• Use PostgreSQL
• Asset database
• Device database (EPICS devices)
• Workflow database
• IRMIS
• Web apps
• Perl / Perl-CGI / Perl-DBI
• Dont use crawlers, PV part of IRMIS
• For IOC databases use prescriptive approach
• instantiate devices from device database ?
  capfast ? .db
• IRMIS objectives
• Implement component model
• Integrate with asset database
• Start with IRMIS 3 schema
• Web tools for users

3
What we did

• Converted from MySQL to PostgreSQL (Jane
  Richards)
• Added consistent foreign keys
• Added database views
• Added TRIUMF component types, etc

4
(No Transcript)
5
Views
6
Component Type Editor
7
Hierarchy Display