100 likes | 260 Views
Save/Compare/Restore (SCORE). Paul Chu. Background. Originally developed by J. Galambos at SNS Technologies Used: Java Client application Database configuration tool (JERI) Relational database Java Channel Access XAL framework (GUI and menu utilities ) Main functions
E N D
Save/Compare/Restore (SCORE) Paul Chu
Background • Originally developed by J. Galambos at SNS • Technologies Used: • Java • Client application • Database configuration tool (JERI) • Relational database • Java Channel Access • XAL framework (GUI and menu utilities) • Main functions • Save machine settings and their associated readbacks • Compare saved settings to the live machine values • Restore the machine to a set of saved values • SLAC/LCLS also uses a modified SCORE P. Chu, Controls Database Collaboration, 18 Nov 2011
How Does It Work? • Needs a database to store data captured. • (XML) files will work with some work around but not recommended • SNS SCORE database schema • 3 main tables P. Chu, Controls Database Collaboration, 18 Nov 2011
SCORE Database Configuration • SNS • JERI -- A GUI configuration tool for changing the PV list – run as Java Web Start. • Can select PVs from signal table with filtering • To get full functional JERI, need additional tables • LCLS • Oracle APEX Web interface • Load a formatted Excel file P. Chu, Controls Database Collaboration, 18 Nov 2011
SCORE GUI • XAL based GUI • SNS • LCLS P. Chu, Controls Database Collaboration, 18 Nov 2011
LCLS SCORE Schema P. Chu, Controls Database Collaboration, 18 Nov 2011
LCLS SCORE Schema Details [1] • Tables (5 for SCORE data, 3 for PV list configuration file upload) • SCORE_SNAPSHOT_GRP_SGNL • SCORE_SNAPSHOT_SGNL • SCORE_SNAPSHOT_GRP • SCORE_SUBSYSTEMS (new) • SYST (new) • SCORE_UPLOAD_LOG (new) • SCORE_UPLOAD (new) • CHECK_FLE_LOG (new) • 5 joined tables for faster query, 2 tables for QA purpose • The 3 tables for file upload are not needed for SNS – SNS uses JERI tool P. Chu, Controls Database Collaboration, 18 Nov 2011
LCLS SCORE Schema Details [2] P. Chu, Controls Database Collaboration, 18 Nov 2011
LCLS SCORE Additional Feature • PV validation check with IRMIS signals • At application level • Restore with LEM (Linac Energy Manager) energy scaled • GUI modification • Table columns rearranged • better color coded P. Chu, Controls Database Collaboration, 18 Nov 2011
Path Forward • IRMIS Save/Restore database schema should be relatively straightforward based on SCORE • Links to Component, Lattice and other sub-schemas should be considered • Lattice need not have its own snapshot of the machine for model replay • Service and GUI are next • A new GUI application similar to JERI and APEX for PV list configuration • Should be an IRMIS package • Data access API for clients • Energy scaling should be in a different service provider with input from Model Server • Other features in Save/Restore Service • Periodic snapshot P. Chu, Controls Database Collaboration, 18 Nov 2011