Oracle a t bessy
This presentation is the property of its rightful owner.
Sponsored Links
1 / 11

Oracle a t BESSY PowerPoint PPT Presentation


  • 66 Views
  • Uploaded on
  • Presentation posted in: General

Oracle a t BESSY. Ralph Lange EPICS Seminar IHEP Beijing 2002. Outline. System Data Content Current Status Experiences Future Concept Archiving Tools Hints. Some System Figures. Oracle 8.05 on HP-UX 10.20  in preparation: Oracle 8i on HP-UX 11 ~ 250 tables (not optimized)

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Oracle a t bessy

Oracle at BESSY

Ralph LangeEPICS Seminar IHEP Beijing 2002


Outline

Outline

  • System

  • Data Content

  • Current Status

  • Experiences

  • Future Concept

  • Archiving

  • Tools

  • Hints


Some system figures

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


Data contents

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)


Current status import

Current Status – Import


Current status export

Current Status – Export


Experiences and new approach

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


Properties and migration status

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


Archiving

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


Tools in use at bessy

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)


Hints

Hints

Oracle Services (web based support database)

  • Metalink (available with Oracle license): bugs, patches, …

    Technet (free): documentation, test software


  • Login