SNSIntegratedControlSystem.pptVIP

EPICS IOCs – Relational DB Connectivity Bridge A. Liyu, A. Zhukov EPICS (standard) and SNS architectures Main advantage of single data storage Problems to solve… Different IOC operating systems (vxWorks, Linux, Windows, Windows - Shared Memory - LabView…) Usually RTOSs have no SQL RDB support Different Databases (Oracle, MySQL, MS Access…) Universal Solution Demo: test-diag-ioc-blm1 retrieves files from RDB Demo: test-diag-ioc-blm1 retrieves files from RDB IOC requests file list from Web server Web Server looks up IOC’s host name in RDB and returns list of file names, paths and IDs for this particular IOC IOC requests a file having specific ID from Web Server Web Server requests the file from RDB and returns to the IOC IOC writes the file to disk Demo: RDB structure Demo: test-diag-ioc-blm1 retrieves files from RDB #st.cmd … cd topbin ld blm.munch cd top hostAdd(“audit”,”6”) vFGetFilesByHTTP(“audit:8080”) cd top dbLoadDatabase(“dbd/blm.dbd”,0,0) blm_registerRecordDeviceDriver(pdbbase) … Current status at SNS Next possible steps Next possible steps (continued) RDB (IRMIS ?) RDB definitions for Records, Drivers, … Definition of interface to RDB RDB clients VDCT changes IOC changes … SNS Integrated Control System IOC OPI (like EDM) IOC OPI (like EDM) RDB (ORACLE) XAL applications CA CA SNS EPICS architecture EPICS architecture (standard) Boot file server JERI + Boot file server IOC RDB (ORACLE) CA client applications CA Other client applications Single central datastorage (RDB) IOCs and client applications take data from the same place IOC and client applications are always synchronized Straightforward way: create a RDB driver per each OS-database combination Easy way: create intermediate universal server between OS and RDB. … and possible solutions IOC RDB (ORACLE) Any Web server (on Linux, Windows…) Apache is fine Requests HTTP EPICS Socket Library TCP/IP OS independence Standard Web server – RDB connectivity: PHP, JSP, ASP RDB independence ORACL