110 likes | 290 Views
RDB Tools at TRIUMF/ISAC . R. Keitel IRMIS Workshop, APS, 9-Mar-2005. Outline. EPICS environment Current RDB use What next? Wish-list. State of ISAC. half way ISAC-I routine operation ISAC-II start installation no change in man-power (6) tools are vital. EPICS Environment at ISAC .
E N D
RDB Tools at TRIUMF/ISAC R. Keitel IRMIS Workshop, APS, 9-Mar-2005
Outline • EPICS environment • Current RDB use • What next? • Wish-list
State of ISAC • half way • ISAC-I routine operation • ISAC-II start installation • no change in man-power (6) • tools are vital
EPICS Environment at ISAC • EPICS 3.13.10 • EPICS 3.14.6 (softIOC, gateway) • vxWorks 5.5 (MV162, 486, Pentium) • Capfast • Edd/dm >>> Edm • Trar archiver • Striptool, alh, … • IOCs • 20 >>25 ( ISAC) • 10 (other systems) • 80k EPICS records
Relational Database Web Application RDB “devices” Perl Tools EPICS configuration files
Basic Ideas • Collaborating tools • Loose coupling • Minimize mission-critical items Web Servers Database Servers Development Computers Production File Servers
Relational Database (PostgreSQL) • Device classes • Capfast • I/O ports • Macros • Device instances • Hardware addresses • Macros • interlocks • Hardware info • PLC drops • VME crates • IOC info • Boot area etc.
Usage (RDB+Tools) • generate Capfast schematics (device instantiation) • generate dm device control panels • Interlock display • hyperlinks to other device control panels • store interlock specs • verify interlock implementation against spec • build configuration scripts • generate html-documentation • manage IOC configuration and roll-back • database crawler (off-line – no db) • adl file crawler (no db) • Interaction with other databases (QA, operations)
What’s next (missing) • Configuration scripts? • Request files? • Cables etc. • Device locations IRMIS? • Integrate with asset RDB
Wish List • We will not abandon our system • Need add-on to our system • Or “coexistence” • Tool-kit for picking and choosing • Portability between SQL RDBs • Web interface • Smooth transition from design >> IRMIS