ATLAS DCS Offline Data Access Stefan Schlenker ATLAS

ATLAS DCS Offline Data Access Stefan Schlenker, ATLAS Central DCS JCOP FWWG Tech Meeting Stefan Schlenker, CERN

Requirements Access to DCS data ► Availability in P 1, GPN, world-wide ► Access to DCS operator interfaces in historical mode ► Access Trends, Histograms for multiple DCS parameters ► Evaluate validity of data, relational queries ► Data export in non-graphical form (Ascii, ROOT) Three Categories 1) Operator interface in historical mode 2) Sophisticated access and analysis tool for Oracle data from inside CERN, batch mode, multiple output formats 3) Easy-to-use, web-based tool to access Oracle data from everywhere, mainly graphical output, possible to embed in other apps JCOP FWWG Tech Meeting Stefan Schlenker, CERN

Operator UI History 1) PVSS UI accessing Oracle instead of Online system ► Method: use PVSS API to overload internal PVSS functions (dp. Get, dp. Connect) and redirect parameter access to Oracle history data ► Use global reference time to query PVSS Oracle archive ► ALL FSM panels can be reused (complete hierarchy), however only archived values can be displayed ► Status: testing API Snapshots – Make Online Web Status persistent ► Poll online web server and store full set of pages on GPN web server ► Polling interval 1 h: store 10 years on 1 TB disk ► Identical web interface + give reference time ► Status: Available JCOP FWWG Tech Meeting Stefan Schlenker, CERN

DBExplorer 2) File Inner detector project (Sergey Kovalenko) ► Browse tables in PVSS Oracle archive, ATLAS Cond. DB ► Plot data from PVSS Oracle (trends, histograms 1 D/2 D), multiple variables ► Perform simple arithmetics and plot derived results for multiple variables ► Save plot configuration (XML) and pre -define graphical representation (tool expertise necessary to prepare) ► Status: Available (URL) ► CERN/AFS: minimal installation effort ► Outside CERN: more complex installation, need direct access to Oracle JCOP FWWG Tech Meeting Stefan Schlenker, CERN

DCS Data Viewer 2), 3) ATLAS-wide project DPE Selector PVSS Metadata retrieval Create output configuration ada ta t Data Cache Holds DP data ( a Dat Output Server - CERN Cherry. Py Client – UI, batch st que a re t n) ues req onditio a t Da ime, c t list, DPE Dat JCOP FWWG Tech Meeting que s Holds Metadata DP data queries to Oracle Security, Performance Filter ► Possibility to couple other viewers to server-side (e. g. DBExplorer) ► Server should use PVSS PL/SQL API when available and fast enough ► Server can also be accessed in batch mode without client ta re Met Output configuration data Met ad req ata ues t Met ada ta Client - UI a Dat ► Specs: Trends, Histograms for multiple variables, relational queries ► Server based DB access, based on DB Metadata Cherry. Py URL access Quasi-static data PVSS Metadata queries to Oracle ► Client is based on Java/Google. Web. Toolkit Server - CERN ► Pre-defined configurations (XML) ► Batch mode possible PVSS Oracle ► Embedding in other web. Archive applications (plot-on-click) ► Status: Server and Client prototype DB Data Queries ► Maintenance: ATLAS Central DCS+ Plugin for custom displays Java GWT Client – UI, batch Stefan Schlenker, CERN