CANADAS NATIONAL LABORATORY FOR PARTICLE AND NUCLEAR PHYSICS

CANADA’S NATIONAL LABORATORY FOR PARTICLE AND NUCLEAR PHYSICS Owned and operated as a joint venture by a consortium of Canadian universities via a contribution through the National Research Council Canada IRMIS at TRIUMF R. Keitel Epics Collaboration Meeting, Padova, Oct. 2008 LABORATOIRE NATIONAL CANADIEN POUR LA RECHERCHE EN PHYSIQUE NUCLÉAIRE ET EN PHYSIQUE DES PARTICULES Propriété d’un consortium d’universités canadiennes, géré en co-entreprise à partir d’une contribution administrée par le Conseil national de recherches Canada

TRIUMF Environment • Use Postgre. SQL – – • Web apps – • Perl / Perl-CGI / Perl-DBI Don’t use crawlers, PV part of IRMIS - • Asset database Device database (“EPICS devices”) Workflow database 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 EPICS Collaboration Meeting, Padova, Oct. 15, 2008 R. Keitel – tdct

What we did • • Converted from My. SQL to Postgre. SQL (Jane Richards) Added consistent foreign keys Added database views Added TRIUMF component types, etc… EPICS Collaboration Meeting, Padova, Oct. 15, 2008 R. Keitel – tdct

EPICS Collaboration Meeting, Padova, Oct. 15, 2008 R. Keitel – tdct

Views EPICS Collaboration Meeting, Padova, Oct. 15, 2008 R. Keitel – tdct

Component Type Editor EPICS Collaboration Meeting, Padova, Oct. 15, 2008 R. Keitel – tdct

Hierarchy Display EPICS Collaboration Meeting, Padova, Oct. 15, 2008 R. Keitel – tdct