2018
DOI: 10.3791/57439
|View full text |Cite
|
Sign up to set email alerts
|

Executing Complexity-Increasing Queries in Relational (MySQL) and NoSQL (MongoDB and EXist) Size-Growing ISO/EN 13606 Standardized EHR Databases

Abstract: This research shows a protocol to assess the computational complexity of querying relational and non-relational (NoSQL (not only Structured Query Language)) standardized electronic health record (EHR) medical information database systems (DBMS). It uses a set of three doubling-sized databases, i.e. databases storing 5000, 10,000 and 20,000 realistic standardized EHR extracts, in three different database management systems (DBMS): relational MySQL object-relational mapping (ORM), document-based NoSQL MongoDB, a… Show more

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...
2
2
1

Citation Types

0
7
0

Year Published

2019
2019
2023
2023

Publication Types

Select...
5
2
1

Relationship

0
8

Authors

Journals

citations
Cited by 15 publications
(7 citation statements)
references
References 5 publications
0
7
0
Order By: Relevance
“…Database development. All the database files were stored as JavaScript Object Notation (JSON) 51 files in MongoDB database 52 . These JSON files was uploaded on the server localhost using pymongo and query commands were made in the command line client in MongoDB compass.…”
Section: Discussionmentioning
confidence: 99%
“…Database development. All the database files were stored as JavaScript Object Notation (JSON) 51 files in MongoDB database 52 . These JSON files was uploaded on the server localhost using pymongo and query commands were made in the command line client in MongoDB compass.…”
Section: Discussionmentioning
confidence: 99%
“…EHR-derived PheWAS codes in MGI library 17 to map object oriented models onto MySQL database. 18 A gene-centered Manhattan plot represents noticed SNP to gene associations a round gene of curiosity, and an SNP-centered line chart illustrates observed eQTLs surrounding SNPs of interest. Tested on a Bluegene super computing with ∼32 GB of RAM in response to set a parameters based on load samples and component for dynamic balancing of virtual machines within the cloud infrastructure resource, as soon as it is uploaded, our server can fetch per SNP-probe pairs from these >75 people in <0.0257s from the database, and calculates Spearman’s rhos and nominal P -values for 486 SNP-probe pairs in 3 s.…”
Section: Methodsmentioning
confidence: 99%
“…Finally, after collection, processing and enrichment of the data, all the database files were stored as JavaScript Object Notation (JSON) files in MongoDB database relational database ( 50 ). These JSON files were uploaded on the server localhost using PyMongo, and query commands were made in the command line client in MongoDB compass.…”
Section: Methodsmentioning
confidence: 99%