1 / 14

Oracle Applications for Control Systems

Oracle Applications for Control Systems. By Katia Danilova 09/29/2005. Both are Oracle Applications developed for Controls Systems Data used comes from several groups (Magnet Mapping, Power Supply, Physics, Operations, Controls) and labs (BNL, LANL, LBNL)

langer
Download Presentation

Oracle Applications for Control Systems

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 Applications for Control Systems By Katia Danilova09/29/2005

  2. Both are Oracle Applications developed for Controls Systems Data used comes from several groups (Magnet Mapping, Power Supply, Physics, Operations, Controls) and labs (BNL, LANL, LBNL) One of these two programs (PSReport) uses data produced by another one (SplineFit) Magnet Mapping (SplineFit) PS Info Program (PSReport) Why to discuss 2 programs together:

  3. Part I: Magnet Mapping • SplineFit program • Idea and requirements: John Galambos • Design and coding: Katia Danilova • Pure Java • Web Start • linked under Control Systems>Software>Oracle Applications • User Manual online

  4. Magnet Mapping in Controls data flow Spreadsheets with magnet measurement data from J. Animesh and J.G. SSLoader (java program) Magnet Mapping java program (SplineFit) SNS Relational Database (Oracle) tables .mmt files IOC

  5. Magnet Mapping Program Features: • GUI • clicking on the points of the spline curve in the graph area • selecting from lists • using buttons • All names and data are automatically taken from the Oracle database • Program allows to: • select a magnet • view data in different modes ( B(I) or I(B) mode) • add/remove points • calculate spline coefficients • calculate average data (fields and coefficients) for magnets related to one PS • save/ delete records in .mmt files and Oracle mag_spline table

  6. Features (cont.) • Data quality control: • visualizes mapping data • it allows easy detection and removal of bad points • => only good (checked by user) magnet data are saved • shows if some of data is missing • shows which magnets do not have mapping data in DB • Output • xxx.mmt files • saves into Oracle tables

  7. Additional Benefits and Problems • “Side effect”: PS data • determines operational range for Power Supplies • saves this data in Oracle, then this data are used by PSReport program to produce xxx.substitution files • Problem: • Delays with receiving the data that are already measured! • Plan: adding new features • For Magnets: Manual selection of magnet group • For PS: Ramp profile (from Oracle cycle_on table to xxx.mct files)

  8. Part II: Power Supply Info Program • PSReport Program • Idea and requirements: Coles Sibley • Design and coding: Katia Danilova • Pure Java • Web Start • linked under Controls>Software>Oracle Applications • No need in User Manual because the program is so user friendly

  9. PSReport in Controls data flow: EPICS calibration data spreadsheets SSLoader java program SNS Relational Database (Oracle) tables PSReport java program Spreadsheets used to produce EPICS XXX.substitution files Load from st.cmd

  10. PSReport Features: • User friendly: • GUI • Everything is automatically taken from DB • “Lazy user” approach • Program Input: • Selection of IOC by user • All other data (like PSC/PSI/PS names and relations, magnet and PS data ) are automatically taken from Oracle • Program Output: • Calculates PS values such as HIHI, DRVH, ADEL, MDEL etc • Produces 3 spreadsheets of PS data (xxx.substitution files)

  11. PSReport Benefits and Problems • Benefits: • Configuration control of data • Selecting PS limits based on mapping data, operational and PS requirements • Extra features helping detect gaps in Oracle • Logfile showing gaps in DB relations if any • Messages inside the spreadsheets showing where exactly in the database data is missing • Problems: • Missing data in the database • “RDB has too many constraints. We don’t need all serial numbers, just Manufacturer and Model #” Coles

  12. Role of 2 appls in controls data flow: SSLoader (java program) Magnet Mapping java program (SplineFit) Spreadsheets from different sources PSReport java program SNS Relational Database (Oracle) tables xxx.mmt files Spreadsheets used to produce EPICS XXX.substitution files IOC Load from st.cmd

  13. Instead of Conclusion • Benefits of using the applications and Oracle: • Central DB repository (data in one place, update once) • History of calibration data • Data Quality control • Plans • Development of an application that will allow automatic/easy loading of calibration data from EPICS to Oracle database (and potentially vice versa) • to develop a program need REQUIREMENTS! • Development of an application that will check for missing or duplicate data in Oracle database

  14. The End Thank you!

More Related