Report Open Access

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

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


MARC21 XML Export

<?xml version='1.0' encoding='UTF-8'?>
<record xmlns="http://www.loc.gov/MARC21/slim">
  <leader>00000nam##2200000uu#4500</leader>
  <datafield tag="653" ind1=" " ind2=" ">
    <subfield code="a">CERN openlab summer student</subfield>
  </datafield>
  <controlfield tag="005">20190410034613.0</controlfield>
  <controlfield tag="001">61069</controlfield>
  <datafield tag="700" ind1=" " ind2=" ">
    <subfield code="u">Summer Student Supervisor</subfield>
    <subfield code="a">Dziedziniewicz-Wojcik, Katarzyna Maria</subfield>
  </datafield>
  <datafield tag="700" ind1=" " ind2=" ">
    <subfield code="u">Summer Student Supervisor</subfield>
    <subfield code="a">Kuznetsov, Valentin</subfield>
  </datafield>
  <datafield tag="856" ind1="4" ind2=" ">
    <subfield code="s">2749401</subfield>
    <subfield code="z">md5:a9b59da826ec0d59be3e91d8b45af5f9</subfield>
    <subfield code="u">https://zenodo.org/record/61069/files/Final_Report-Sartaj_Singh_Baveja.pdf</subfield>
  </datafield>
  <datafield tag="542" ind1=" " ind2=" ">
    <subfield code="l">open</subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="c">2016-08-28</subfield>
  </datafield>
  <datafield tag="909" ind1="C" ind2="O">
    <subfield code="p">openaire</subfield>
    <subfield code="p">user-cernopenlab</subfield>
    <subfield code="o">oai:zenodo.org:61069</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="u">CERN openlab Summer Student</subfield>
    <subfield code="a">Baveja, Sartaj Singh</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Test of Oracle JSON support in the view of CMS JSON data</subfield>
  </datafield>
  <datafield tag="980" ind1=" " ind2=" ">
    <subfield code="a">user-cernopenlab</subfield>
  </datafield>
  <datafield tag="540" ind1=" " ind2=" ">
    <subfield code="u">http://creativecommons.org/licenses/by/4.0/legalcode</subfield>
    <subfield code="a">Creative Commons Attribution 4.0 International</subfield>
  </datafield>
  <datafield tag="650" ind1="1" ind2="7">
    <subfield code="a">cc-by</subfield>
    <subfield code="2">opendefinition.org</subfield>
  </datafield>
  <datafield tag="520" ind1=" " ind2=" ">
    <subfield code="a">&lt;p&gt;Abstract&lt;/p&gt;

&lt;p&gt;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.&lt;/p&gt;</subfield>
  </datafield>
  <datafield tag="024" ind1=" " ind2=" ">
    <subfield code="a">10.5281/zenodo.61069</subfield>
    <subfield code="2">doi</subfield>
  </datafield>
  <datafield tag="980" ind1=" " ind2=" ">
    <subfield code="a">publication</subfield>
    <subfield code="b">report</subfield>
  </datafield>
</record>
96
384
views
downloads
All versions This version
Views 9696
Downloads 384384
Data volume 1.1 GB1.1 GB
Unique views 9595
Unique downloads 363363

Share

Cite as