Report Open Access

Test of Oracle JSON support in the view of CMS JSON data

Baveja, Sartaj Singh; Dziedziniewicz-Wojcik, Katarzyna Maria; Kuznetsov, Valentin


JSON Export

{
  "files": [
    {
      "links": {
        "self": "https://zenodo.org/api/files/5c7fb9cf-07f6-4cd4-a685-65bb44e6fa1d/Final_Report-Sartaj_Singh_Baveja.pdf"
      }, 
      "checksum": "md5:a9b59da826ec0d59be3e91d8b45af5f9", 
      "bucket": "5c7fb9cf-07f6-4cd4-a685-65bb44e6fa1d", 
      "key": "Final_Report-Sartaj_Singh_Baveja.pdf", 
      "type": "pdf", 
      "size": 2749401
    }
  ], 
  "owners": [
    20695
  ], 
  "doi": "10.5281/zenodo.61069", 
  "stats": {
    "version_unique_downloads": 299.0, 
    "unique_views": 83.0, 
    "views": 84.0, 
    "downloads": 317.0, 
    "unique_downloads": 299.0, 
    "version_unique_views": 83.0, 
    "volume": 871560117.0, 
    "version_downloads": 317.0, 
    "version_views": 84.0, 
    "version_volume": 871560117.0
  }, 
  "links": {
    "doi": "https://doi.org/10.5281/zenodo.61069", 
    "latest_html": "https://zenodo.org/record/61069", 
    "bucket": "https://zenodo.org/api/files/5c7fb9cf-07f6-4cd4-a685-65bb44e6fa1d", 
    "badge": "https://zenodo.org/badge/doi/10.5281/zenodo.61069.svg", 
    "html": "https://zenodo.org/record/61069", 
    "latest": "https://zenodo.org/api/records/61069"
  }, 
  "created": "2016-08-31T07:41:59+00:00", 
  "updated": "2019-04-10T03:46:13.577815+00:00", 
  "conceptrecid": "640721", 
  "revision": 8, 
  "id": 61069, 
  "metadata": {
    "access_right_category": "success", 
    "doi": "10.5281/zenodo.61069", 
    "description": "<p>Abstract</p>\n\n<p>Oracle has introduced native support for Javascript Object Notation (JSON) data in its 12c release with relational database features, including transactions, indexing, declarative querying and views. The requirements for the CMS WMArchive project, whose goal is to reliably store its Workflow and Data Management framework job report (FWJR) documents, include storing deep nested JSON structures, running queries over them and aggregating data in an effective way. The objective of this project is to assess, evaluate and test the capabilities and performance of Oracle JSON with respect to the currently used solution, MongoDB. The comparison is based on functionality, read/write rates and indexing. Initially, JSON documents are created by randomizing a sample CMS FWJR document and inserted into both MongoDB and Oracle to evaluate the performance. Then, the data stored in these databases is queried with and without indexes. Performance is then evaluated and a comparison is made. Other performance metrics such as CPU Usage, data and index size are also compared.</p>", 
    "license": {
      "id": "CC-BY-4.0"
    }, 
    "title": "Test of Oracle JSON support in the view of CMS JSON data", 
    "relations": {
      "version": [
        {
          "count": 1, 
          "index": 0, 
          "parent": {
            "pid_type": "recid", 
            "pid_value": "640721"
          }, 
          "is_last": true, 
          "last_child": {
            "pid_type": "recid", 
            "pid_value": "61069"
          }
        }
      ]
    }, 
    "communities": [
      {
        "id": "cernopenlab"
      }
    ], 
    "keywords": [
      "CERN openlab summer student"
    ], 
    "publication_date": "2016-08-28", 
    "creators": [
      {
        "affiliation": "CERN openlab Summer Student", 
        "name": "Baveja, Sartaj Singh"
      }, 
      {
        "affiliation": "Summer Student Supervisor", 
        "name": "Dziedziniewicz-Wojcik, Katarzyna Maria"
      }, 
      {
        "affiliation": "Summer Student Supervisor", 
        "name": "Kuznetsov, Valentin"
      }
    ], 
    "access_right": "open", 
    "resource_type": {
      "subtype": "report", 
      "type": "publication", 
      "title": "Report"
    }
  }
}
84
317
views
downloads
All versions This version
Views 8484
Downloads 317317
Data volume 871.6 MB871.6 MB
Unique views 8383
Unique downloads 299299

Share

Cite as