Report Open Access

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

Sneha; Limper, Maaike


JSON Export

{
  "files": [
    {
      "links": {
        "self": "https://zenodo.org/api/files/22136faa-1ad5-4ec5-9d2b-88df955bcef4/CERN_openlab_Sneha.pdf"
      }, 
      "checksum": "md5:2f2f62203130e51322ceae842a6d2993", 
      "bucket": "22136faa-1ad5-4ec5-9d2b-88df955bcef4", 
      "key": "CERN_openlab_Sneha.pdf", 
      "type": "pdf", 
      "size": 901521
    }
  ], 
  "owners": [
    5887
  ], 
  "doi": "10.5281/zenodo.11785", 
  "stats": {
    "version_unique_downloads": 149.0, 
    "unique_views": 66.0, 
    "views": 66.0, 
    "version_views": 66.0, 
    "unique_downloads": 149.0, 
    "version_unique_views": 66.0, 
    "volume": 135228150.0, 
    "version_downloads": 150.0, 
    "downloads": 150.0, 
    "version_volume": 135228150.0
  }, 
  "links": {
    "doi": "https://doi.org/10.5281/zenodo.11785", 
    "latest_html": "https://zenodo.org/record/11785", 
    "bucket": "https://zenodo.org/api/files/22136faa-1ad5-4ec5-9d2b-88df955bcef4", 
    "badge": "https://zenodo.org/badge/doi/10.5281/zenodo.11785.svg", 
    "html": "https://zenodo.org/record/11785", 
    "latest": "https://zenodo.org/api/records/11785"
  }, 
  "created": "2014-10-13T08:27:47+00:00", 
  "updated": "2020-01-20T16:23:36.756241+00:00", 
  "conceptrecid": "605935", 
  "revision": 9, 
  "id": 11785, 
  "metadata": {
    "access_right_category": "success", 
    "doi": "10.5281/zenodo.11785", 
    "description": "<p><strong>Project Specification</strong></p>\n\n<p>SQLPlotter is a C++ macro written using ROOT classes which has previously&nbsp;been developed to&nbsp;allow the possibility of making histograms from the&nbsp;results of SQL-queries running on physics&nbsp;analysis data stored in a relational&nbsp;database.&nbsp;This project is aimed at developing a web &ndash; interface for this&nbsp;SQLPlotter with a ROOTinstallation&nbsp;running locally on the web-server,&nbsp;eliminating the requirement of learning ROOT in&nbsp;depth and providing the&nbsp;users with an easy to use interface that can be accessed&nbsp;anytime,&nbsp;anywhere&nbsp;to do physics analysis inside a database.</p>\n\n<p><strong>Abstract</strong></p>\n\n<p>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 &ldquo;SQLPlotter&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.</p>", 
    "license": {
      "id": "CC-BY-SA-4.0"
    }, 
    "title": "SQLPlotter : Developing a web-interface for a physics analysis database", 
    "relations": {
      "version": [
        {
          "count": 1, 
          "index": 0, 
          "parent": {
            "pid_type": "recid", 
            "pid_value": "605935"
          }, 
          "is_last": true, 
          "last_child": {
            "pid_type": "recid", 
            "pid_value": "11785"
          }
        }
      ]
    }, 
    "communities": [
      {
        "id": "cernopenlab"
      }
    ], 
    "keywords": [
      "CERN openlab Summer Student"
    ], 
    "publication_date": "2014-09-01", 
    "creators": [
      {
        "affiliation": "CERN openlab Summer Student", 
        "name": "Sneha"
      }, 
      {
        "affiliation": "Summer Student Supervisor", 
        "name": "Limper, Maaike"
      }
    ], 
    "access_right": "open", 
    "resource_type": {
      "subtype": "report", 
      "type": "publication", 
      "title": "Report"
    }
  }
}
66
150
views
downloads
All versions This version
Views 6666
Downloads 150150
Data volume 135.2 MB135.2 MB
Unique views 6666
Unique downloads 149149

Share

Cite as