Powered by OpenAIRE graph
Found an issue? Give us feedback
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/ ZENODOarrow_drop_down
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
ZENODO
Report . 2016
License: CC BY
Data sources: ZENODO
versions View all 1 versions
addClaim

This Research product is the result of merged Research products in OpenAIRE.

You have already added 0 works in your ORCID record related to the merged Research product.

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

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

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

Abstract

Abstract 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.

Keywords

CERN openlab summer student

Powered by OpenAIRE graph
Found an issue? Give us feedback