IRMIS at the CLS E Matias Canadian Light

IRMIS at the CLS E. Matias Canadian Light Source www. lightsource. ca

Design Constraints • Needed to work with Microsoft SQL Server 2000 • Needed to be cross-platform – Needed to work on both on Windows and Linux • Ideally building on existing work – based on the Integrated Relational Model of Installed Systems (IRMIS) project at APS www. lightsource. ca

www. lightsource. ca

Implementation • Web Service – Purpose id to service SQL commands received from a client. – SQL commands are received as SOAP messages. – SOAP is XML so clients can be written in any language or live on any type of platform. – Hides the true database away from the client – Written in C# www. lightsource. ca

Implementation • Security – Security Manager • In charge of checking for user authentication. • Creates a session id if the user is authenticated. – Soap Security • In charge of checking if the client is allowed to read and write from the database • Makes sure the session id is valid www. lightsource. ca

Implementation • PV Crawler – Based off of the code in the IRMIS project – Written in Perl. – Modified to work with the Web Service instead of the PV database directly – Purpose is to mine for PV information from the st. cmd and. db files. – Sends PV information to the Web Service www. lightsource. ca

Implementation • Web Client – Purpose is to allow user to search and view from PV information in the PV database. – User can search by different criteria: • Search for a PV by name. • Search for a PV by type. • Search for an IOC by name. – Written in XHTML and PHP. www. lightsource. ca

GUI For PV Database www. lightsource. ca

Future? Wish-list: • Port “. net”/C# to J 2 EE/Java • Crawling P&ID drawings (Auto. CAD) • Port Cables Database to IRMIS • Closing the loop – Generate Basic PV Definition – Generate Summary PV Definition – Generate EDM Screens • Preventative Maintenance Integration? www. lightsource. ca

Port to J 2 EE and Java? • First experience with SOA. Better choice for us today is J 2 EE/Java • Possible structure: www. lightsource. ca

PID Example www. lightsource. ca

Cable Database Schema www. lightsource. ca

www. lightsource. ca

Search for “Pump” Acronyms www. lightsource. ca

Details on a Cable ? www. lightsource. ca

Closing The Loop – Dash Board? www. lightsource. ca

Future? Wish-list: • Port “. net”/C# to J 2 EE/Java • Crawling P&ID drawings (Auto. CAD) • Port Cables Database to IRMIS • Closing the loop – Generate Basic PV Definition – Generate Summary PV Definition – Generate EDM Screens • Preventative Maintenance Integration? www. lightsource. ca

Funding Partners 38 supporting University Partners and growing… www. lightsource. ca