EpicsOra

1
EpicsOra

• building Epics-db-files from an Oracle Database

Programmed by Anatoli Khvorostianov
2
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

3
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

4
EPICS and rdb at DESY
5
dbd files ? epicsOra ? db file
6
Prototypesinheritance for record-fields
7
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)

8
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

9
Structure

• Re-usable
• Nested
• Link records
• Inherit field values
• Name rules
• Copy structure
• New object
• New epics version

10
Hierarchy in EpicsOra
dbd dbd dbd dbd dbd
Base prototypes add structure Fields inherit values Define parameters
Composite prototypes add structure Fields inherit values Define parameters Assign values
Composite Instances Fields inherit values Assign values
Instances Fields inherit values Assign values
db file db file db file db file db file
11
Inside EpicsOra(Oracle AS 10g, Forms 9)
Object properties
record fields
Navigator
12
Inside EpicsOraproject
13
Inside EpicsOrabase prototype
14
Inside EpicsOrarecord of base prototype
15
Inside EpicsOracomposite prototype
16
Inside EpicsOrarecord in composite prototype
17
Inside EpicsOrainstance of composite prototype
18
Inside EpicsOrainstance of base prototype
19
Inside EpicsOrainstance of record