Oracle at BESSY

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 wont 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 developmentEmbacadero (ER/Studio) _at_
  WindowsTORA (Freeware) _at_ Win, LinuxOracle
  Tools
• Web interfacePHP ? 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