190 likes | 200 Views
EpicsOra. building Epics-db-files from an Oracle Database. Programmed by Anatoli Khvorostianov. Basic Idea. Use database instead of flat files make it master of all info Import dbd-files (define EPICS-version) Export db-files to be loaded to IOCs Modify here / re-import modified db-files
E N D
EpicsOra building Epics-db-files from an Oracle Database Programmed by Anatoli Khvorostianov EPICS rdb Workshop 2005 March 9-11
Basic Idea • Use database instead of flat filesmake it master of all info • Import dbd-files (define EPICS-version) • Export db-files to be loaded to IOCs • Modify here / re-import modified db-files • Define “objects” • Structure: group of records • Structure: can be nested (complex objects) • Parameters • Inheritance EPICS rdb Workshop 2005 March 9-11
Further ideas • Link different fields of interest • Epics • Hardware devices (also asset management) • “registry” for graphics, alarming • etc. • Use “io_name” as link • Name of sensor/actor in drawings • Name of sensor/actor in graphics • Associated to cable/wires in cabling • … EPICS rdb Workshop 2005 March 9-11
EPICS and rdb at DESY EPICS rdb Workshop 2005 March 9-11
dbd files→ epicsOra → db file EPICS rdb Workshop 2005 March 9-11
Prototypes:inheritance for record-fields EPICS rdb Workshop 2005 March 9-11
Record Fields • Can be modified at all levels • Inherit values from higher level • Can use parameters in prototypese.g. $(desc), $(egu) • Can use functions in prototypese.g. $CONT(record.field), $LINK(record), $ROUND(0.9*$(eguhi)),$IONAME(io_name) EPICS rdb Workshop 2005 March 9-11
Link to hardware • Fields: INP, OUT,… Development • Assign address string at instance level • Calculate address string from variables • Take address string from special table • Calculate address string and DTYP from device- /asset-tables EPICS rdb Workshop 2005 March 9-11
Project (base) prototype composite prototype Instance Structure • Re-usable • Nested • Link records • Inherit field values • Name rules • Copy structure • New object • New epics version EPICS rdb Workshop 2005 March 9-11
Hierarchy in EpicsOra EPICS rdb Workshop 2005 March 9-11
Inside EpicsOra(Oracle AS 10g, Forms 9) Object properties record fields Navigator EPICS rdb Workshop 2005 March 9-11
Inside EpicsOra:project EPICS rdb Workshop 2005 March 9-11
Inside EpicsOrabase prototype EPICS rdb Workshop 2005 March 9-11
Inside EpicsOrarecord of base prototype EPICS rdb Workshop 2005 March 9-11
Inside EpicsOracomposite prototype EPICS rdb Workshop 2005 March 9-11
Inside EpicsOrarecord in composite prototype EPICS rdb Workshop 2005 March 9-11
Inside EpicsOrainstance of composite prototype EPICS rdb Workshop 2005 March 9-11
Inside EpicsOrainstance of base prototype EPICS rdb Workshop 2005 March 9-11
Inside EpicsOrainstance of record EPICS rdb Workshop 2005 March 9-11