Report Open Access

SQLPlotter : Developing a web-interface for a physics analysis database

Sneha; Limper, Maaike

MARC21 XML Export

<?xml version='1.0' encoding='UTF-8'?>
<record xmlns="">
  <datafield tag="653" ind1=" " ind2=" ">
    <subfield code="a">CERN openlab Summer Student</subfield>
  <controlfield tag="005">20200120162336.0</controlfield>
  <controlfield tag="001">11785</controlfield>
  <datafield tag="700" ind1=" " ind2=" ">
    <subfield code="u">Summer Student Supervisor</subfield>
    <subfield code="a">Limper, Maaike</subfield>
  <datafield tag="856" ind1="4" ind2=" ">
    <subfield code="s">901521</subfield>
    <subfield code="z">md5:2f2f62203130e51322ceae842a6d2993</subfield>
    <subfield code="u"></subfield>
  <datafield tag="542" ind1=" " ind2=" ">
    <subfield code="l">open</subfield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="c">2014-09-01</subfield>
  <datafield tag="909" ind1="C" ind2="O">
    <subfield code="p">openaire</subfield>
    <subfield code="p">user-cernopenlab</subfield>
    <subfield code="o"></subfield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="u">CERN openlab Summer Student</subfield>
    <subfield code="a">Sneha</subfield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">SQLPlotter : Developing a web-interface for a physics analysis database</subfield>
  <datafield tag="980" ind1=" " ind2=" ">
    <subfield code="a">user-cernopenlab</subfield>
  <datafield tag="540" ind1=" " ind2=" ">
    <subfield code="u"></subfield>
    <subfield code="a">Creative Commons Attribution Share Alike 4.0 International</subfield>
  <datafield tag="650" ind1="1" ind2="7">
    <subfield code="a">cc-by</subfield>
    <subfield code="2"></subfield>
  <datafield tag="520" ind1=" " ind2=" ">
    <subfield code="a">&lt;p&gt;&lt;strong&gt;Project Specification&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;SQLPlotter is a C++ macro written using ROOT classes which has previously&amp;nbsp;been developed to&amp;nbsp;allow the possibility of making histograms from the&amp;nbsp;results of SQL-queries running on physics&amp;nbsp;analysis data stored in a relational&amp;nbsp;database.&amp;nbsp;This project is aimed at developing a web &amp;ndash; interface for this&amp;nbsp;SQLPlotter with a ROOTinstallation&amp;nbsp;running locally on the web-server,&amp;nbsp;eliminating the requirement of learning ROOT in&amp;nbsp;depth and providing the&amp;nbsp;users with an easy to use interface that can be accessed&amp;nbsp;anytime,&amp;nbsp;anywhere&amp;nbsp;to do physics analysis inside a database.&lt;/p&gt;


&lt;p&gt;As part of the CERN openlab collaboration a study was made into the possibility of performing analysis of the data collected by the experiments at the Large Hadron Collider (LHC) [1] through SQL-queries on data stored in a relational database[2]. To show how SQL-queries can be used to perform basic physics analysis tasks, a C++ macro called &amp;ldquo;SQLPlotter&amp;rdquo; was developed to make ROOT-plots using the output-data from SQL-queries. This project, a web-interface to SQLPlotter basically addresses two major objectives. One objective is to make particle physics analysis more accessible, especially to students who do not have the software skills currently needed to analyse LHC data. Another important aim is to demonstrate the underlying principle of SQLPlotter that SQL queries can be used to perform complex analysis tasks. The web-interface has been implemented using basic web-technologies, including PHP, HTML5 and JavaScript. In future, this web-interface can be envisaged to be brought into production as an educational tool for students interested in physics analysis.&lt;/p&gt;</subfield>
  <datafield tag="024" ind1=" " ind2=" ">
    <subfield code="a">10.5281/zenodo.11785</subfield>
    <subfield code="2">doi</subfield>
  <datafield tag="980" ind1=" " ind2=" ">
    <subfield code="a">publication</subfield>
    <subfield code="b">report</subfield>
All versions This version
Views 6666
Downloads 151151
Data volume 136.1 MB136.1 MB
Unique views 6666
Unique downloads 150150


Cite as