oracle a t bessy
Download
Skip this Video
Download Presentation
Oracle a t BESSY

Loading in 2 Seconds...

play fullscreen
1 / 11

Oracle a t BESSY - PowerPoint PPT Presentation


  • 118 Views
  • Uploaded on

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)

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Oracle a t BESSY' - chynna


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

ad