Oracle applications for control systems
Download
1 / 14

Oracle Applications for Control Systems - PowerPoint PPT Presentation


  • 88 Views
  • Uploaded on

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)

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 Applications for Control Systems' - langer


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 applications for control systems

Oracle Applications for Control Systems

By Katia Danilova09/29/2005


Why to discuss 2 programs together

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:


Part i magnet mapping
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


Magnet mapping in controls data flow
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


Magnet mapping program features
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


Features cont
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


Additional benefits and problems
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)


Part ii power supply info program
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


Psreport in controls data flow
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


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


Psreport benefits and problems
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


Role of 2 appls in controls data flow
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


Instead of conclusion
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


The End

Thank you!


ad