180 likes | 297 Views
RDB for Diamond. V.Smithers & K.Vijayan June 2003. EPICS Schema contains. Domain, Subdomain, Technical Area, Component Crate Device IOC DBD DBGroups DB File DB file Templates Slot Carrier & IP Cards Connection Between the Cards & the Device. Device Naming.
E N D
RDB for Diamond V.Smithers & K.Vijayan June 2003 K.Vijayan : RDB for Diamond Control Systems
EPICS Schema contains • Domain, Subdomain, Technical Area, Component • Crate • Device • IOC • DBD • DBGroups • DB File • DB file Templates • Slot • Carrier & IP Cards • Connection Between the Cards & the Device K.Vijayan : RDB for Diamond Control Systems
Device Naming • Domain, Subdomain, Technical Area & Component • DD[SSS]-TT-CCCCC-NN • Examples: LI-VA-PIRG-01 BR01C-MA-VSTR-01 BS-MA-QUAD-01 SR01A-MA-QUAD-10 K.Vijayan : RDB for Diamond Control Systems
DBD File • Record types, device support options, menus, and other configuration options are defined in “database definition files” (.dbd) • A Database definition file (extension .dbd) containing the specifications for the various record and device types that are going to be referenced by the .db file • During the IOC booting process, one or more dbd files are loaded K.Vijayan : RDB for Diamond Control Systems
DB File • Record instances are describe in “database files” (.db). • During the IOC booting process, one or more .db files are loaded. K.Vijayan : RDB for Diamond Control Systems
DB File K.Vijayan : RDB for Diamond Control Systems
DB Template File • DB Template Files stored in RDB • VDCT Comment & user comments stored in RDB • Export & Import - Template files using Perl scripts K.Vijayan : RDB for Diamond Control Systems
DB Template File K.Vijayan : RDB for Diamond Control Systems
Connection between Cards & Device • Carrier Card • IP Card • Transition Cards • Connection Details • Device K.Vijayan : RDB for Diamond Control Systems
Connection between Cards & Device Serial Device IP Card Transition Card Controllers Device Channels 1 MKS937a TST-VA-PENG-01 Signals 2 0 7 3 IPCard 3 TST-VA-PIRG-01 ty/20/0 4 MKS937a TST-VA-PIRG-02 ty/20/1 TST-VA-PENG-02 0 7 IPCard 2 A1 Balzers TPG 300 A2 ty/20/2 B1 TST-VA-PIRG-05 B2 Balzers TPG 300 TST-VA-PIRG-06 0 7 IPCard 1 TST-VA-PENG-05 Digitel MPC TST-VA-PING-06 IPCard 0 0 7 Digitel MPC 1 TST-VA-IONP-05 Varian Dual 2 TST-VA-IONP-06 Varian Dual K.Vijayan : RDB for Diamond Control Systems
Connection between Cards & Device Analog / Digital Signals IP Card Transition Card Device Signals 0 7 IPCard 3 Power Supply 0 7 IPCard 2 0 7 IPCard 1 IPCard 0 0 7 K.Vijayan : RDB for Diamond Control Systems
Connection between Cards & Device K.Vijayan : RDB for Diamond Control Systems
EPICS in RDB Epics Record Template File Substitution File dbLoadTemplate Perl Scripts Expanded DB Files RDB Perl Scripts Expanded DB Files & Template DB Files Perl Scripts Template DB Files Perl Scripts DBD File Front end screens (web browser) using Apache/PHP K.Vijayan : RDB for Diamond Control Systems
ER Diagram : EPICS Database K.Vijayan : RDB for Diamond Control Systems
What we will use Oracle 9i on Red Hat Linux AS v2.1 - Dell Server Apache Web Server PHP for user interface screens / forms for data input & reading using web browser Perl for the uploading of flat files to the RDB & vice versa ER Studio Logical and Physical design of the EPICS database K.Vijayan : RDB for Diamond Control Systems
Web Browser K.Vijayan : RDB for Diamond Control Systems
Summary • A central repository for storing all the EPICS information. • Unique Record names are maintained • Hierarchy maintained in the record & field • Open DB Template files, without alignment change in vdct • ER Design and user interface screens/forms for data inputare available on the web browser K.Vijayan : RDB for Diamond Control Systems
THE END K.Vijayan : RDB for Diamond Control Systems