1 / 11

Oracle a t BESSY

This seminar outlines the current status, experiences, and future concept of using Oracle at BESSY. It also covers archiving tools and hints for using Oracle.

lishar
Download Presentation

Oracle a t BESSY

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. Oracle at BESSY Ralph LangeEPICS Seminar IHEP Beijing 2002

  2. Outline • System • Data Content • Current Status • Experiences • Future Concept • Archiving • Tools • Hints

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

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

  5. Current Status – Import

  6. Current Status – Export

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

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

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

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

  11. Hints Oracle Services (web based support database) • Metalink (available with Oracle license): bugs, patches, … Technet (free): documentation, test software

More Related