Report Open Access

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

Sneha; Limper, Maaike

DCAT Export

<?xml version='1.0' encoding='utf-8'?>
<rdf:RDF xmlns:rdf="" xmlns:adms="" xmlns:cnt="" xmlns:dc="" xmlns:dct="" xmlns:dctype="" xmlns:dcat="" xmlns:duv="" xmlns:foaf="" xmlns:frapo="" xmlns:geo="" xmlns:gsp="" xmlns:locn="" xmlns:org="" xmlns:owl="" xmlns:prov="" xmlns:rdfs="" xmlns:schema="" xmlns:skos="" xmlns:vcard="" xmlns:wdrs="">
  <rdf:Description rdf:about="">
    <rdf:type rdf:resource=""/>
    <dct:type rdf:resource=""/>
    <dct:identifier rdf:datatype=""></dct:identifier>
    <foaf:page rdf:resource=""/>
        <rdf:type rdf:resource=""/>
            <foaf:name>CERN openlab Summer Student</foaf:name>
        <rdf:type rdf:resource=""/>
        <foaf:name>Limper, Maaike</foaf:name>
            <foaf:name>Summer Student Supervisor</foaf:name>
    <dct:title>SQLPlotter : Developing a web-interface for a physics analysis database</dct:title>
    <dct:issued rdf:datatype="">2014</dct:issued>
    <dcat:keyword>CERN openlab Summer Student</dcat:keyword>
    <dct:issued rdf:datatype="">2014-09-01</dct:issued>
    <owl:sameAs rdf:resource=""/>
        <skos:notation rdf:datatype=""></skos:notation>
    <dct:isPartOf rdf:resource=""/>
    <dct:description>&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;&lt;strong&gt;Abstract&lt;/strong&gt;&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;</dct:description>
    <dct:accessRights rdf:resource=""/>
      <dct:RightsStatement rdf:about="info:eu-repo/semantics/openAccess">
        <rdfs:label>Open Access</rdfs:label>
          <dct:RightsStatement rdf:about="">
            <rdfs:label>Creative Commons Attribution Share Alike 4.0 International</rdfs:label>
        <dcat:accessURL rdf:resource=""/>
All versions This version
Views 6969
Downloads 162162
Data volume 146.0 MB146.0 MB
Unique views 6969
Unique downloads 161161


Cite as