Oracle a t BESSY
description
Transcript of Oracle a t BESSY
Berliner Elektronenspeicherring-Gesellschaft für Synchrotronstrahlung mbH (BESSY)
Oracle at BESSY
Ralph LangeEPICS Seminar IHEP Beijing 2002
R. Lange: Oracle at BESSY – EPICS Seminar IHEP Beijing 2002
EPICS
Outline
• System• Data Content• Current Status• Experiences• Future Concept• Archiving• Tools• Hints
R. Lange: Oracle at BESSY – EPICS Seminar IHEP Beijing 2002
EPICS
Some System Figures
• Oracle 8.05 on HP-UX 10.20 in preparation: Oracle 8i on HP-UX 11
• ~ 250 tables (not optimized)• Data store takes ~ 3 Mbyte• Complete installation is ~ 3.5 Gbyte
(including sources, web server etc.)
R. Lange: Oracle at BESSY – EPICS Seminar IHEP Beijing 2002
EPICS
Data Contents
• Machine Parameters• Geodesic data of all devices• Measured magnet conversion factors• Electronic runbook• Physical and electrical data of
– Power supplies
– Insertion devices
– Magnets
• EPICS configuration data• Administration data (names, phones, rooms)
R. Lange: Oracle at BESSY – EPICS Seminar IHEP Beijing 2002
EPICS
Current Status – Import
R. Lange: Oracle at BESSY – EPICS Seminar IHEP Beijing 2002
EPICS
Current Status – Export
R. Lange: Oracle at BESSY – EPICS Seminar IHEP Beijing 2002
EPICS
Experiences and New Approach
Script Wars The Chaos Strikes Back The Return of the API Design
• RDB should be only source of information• Generic structure to hold all EPICS
configuration data• Granularity in Oracle down to EPICS
database fields – no more templates• Structure contains hierarchy trees
R. Lange: Oracle at BESSY – EPICS Seminar IHEP Beijing 2002
EPICS
Properties and Migration Status
• Complicated structure (~ 25 tables) that is only accessible through tools
• Once the toolset is in use, additional applications´ configurations are easy to add Once it works, we won´t need it anymore?
• Structure definition is stable• Generic tools are being created
R. Lange: Oracle at BESSY – EPICS Seminar IHEP Beijing 2002
EPICS
Archiving
• Current work: using Oracle as a backend for the Channel Archiver (instead of the proprietary binary file format) BESSY (Thomas Birke) SLAC (Lee-Ann Yasukawa, Bob Hall)
• Will need Oracle 8i or later
R. Lange: Oracle at BESSY – EPICS Seminar IHEP Beijing 2002
EPICS
Tools in Use at BESSY
• Oracle development:Embacadero (ER/Studio) @ WindowsTORA (Freeware) @ Win, LinuxOracle Tools
• Web interface:PHP Oracle Library
• Parsers (creating config and EPICS db):Perl (and C?) DBI module (Oracle Libs)
R. Lange: Oracle at BESSY – EPICS Seminar IHEP Beijing 2002
EPICS
Hints
Oracle Services (web based support database)
Metalink (available with Oracle license): bugs, patches, …
Technet (free): documentation, test software