1 / 18

Comprehensive RDB for Diamond Control Systems and EPICS Schema Overview

This document presents a detailed overview of the Relational Database (RDB) structure for Diamond Control Systems. It elaborates on various components including domain and subdomain specifications, device naming conventions, and the relationship between hardware components. The RDB schema utilizes database definition files (DBD) and database files (DB) to define record types and device configurations. Moreover, it discusses integration with EPICS, web interfaces, and the use of Oracle on Linux servers, providing insights into system architecture and data management practices for effective control systems design.

shelley
Télécharger la présentation

Comprehensive RDB for Diamond Control Systems and EPICS Schema Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. RDB for Diamond V.Smithers & K.Vijayan June 2003 K.Vijayan : RDB for Diamond Control Systems

  2. 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

  3. 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

  4. 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

  5. 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

  6. DB File K.Vijayan : RDB for Diamond Control Systems

  7. 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

  8. DB Template File K.Vijayan : RDB for Diamond Control Systems

  9. Connection between Cards & Device • Carrier Card • IP Card • Transition Cards • Connection Details • Device K.Vijayan : RDB for Diamond Control Systems

  10. 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

  11. 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

  12. Connection between Cards & Device K.Vijayan : RDB for Diamond Control Systems

  13. 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

  14. ER Diagram : EPICS Database K.Vijayan : RDB for Diamond Control Systems

  15. 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

  16. Web Browser K.Vijayan : RDB for Diamond Control Systems

  17. 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

  18. THE END K.Vijayan : RDB for Diamond Control Systems

More Related