Report Open Access

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

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

Citation Style Language JSON Export

  "publisher": "Zenodo", 
  "DOI": "10.5281/zenodo.61069", 
  "title": "Test of Oracle JSON support in the view of CMS JSON data", 
  "issued": {
    "date-parts": [
  "abstract": "<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>", 
  "author": [
      "given": "Sartaj Singh", 
      "family": "Baveja"
      "given": "Katarzyna Maria", 
      "family": "Dziedziniewicz-Wojcik"
      "given": "Valentin", 
      "family": "Kuznetsov"
  "type": "article", 
  "id": "61069"
All versions This version
Views 9696
Downloads 383383
Data volume 1.1 GB1.1 GB
Unique views 9595
Unique downloads 362362


Cite as