Evaluation of relational and NoSQL database architectures to manage genomic annotations.
While the adoption of next generation sequencing has rapidly expanded, the informatics infrastructure used to manage the data generated by this technology has not kept pace. Historically, relational databases have provided much of the framework for data storage and retrieval. Newer technologies based on NoSQL architectures may provide significant advantages in storage and query efficiency, thereby reducing the cost of data management. But their relative advantage when applied to biomedical data sets, such as genetic data, has not been characterized. To this end, we compared the storage, indexing, and query efficiency of a common relational database (MySQL), a document-oriented NoSQL database (MongoDB), and a relational database with NoSQL support (PostgreSQL). When used to store genomic annotations from the dbSNP database, we found the NoSQL architectures to outperform traditional, relational models for speed of data storage, indexing, and query retrieval in nearly every operation. These findings strongly support the use of novel database technologies to improve the efficiency of data management within the biological sciences.
Yale University, Department of Laboratory Medicine, New Haven, CT, United States. Electronic address: wade.schulz@yale.edu.
Wade L
WL
Schulz
University of Minnesota, Department of Psychiatry, Minneapolis, MN, United States.
Brent G
BG
Nelson
Agilevent, Scottsdale, AZ, United States.
Donn K
DK
Felker
Yale University, Department of Laboratory Medicine, New Haven, CT, United States.
Thomas J S
TJS
Durant
Yale University, Department of Laboratory Medicine, New Haven, CT, United States.
Richard
R
Torres
D003628:Database Management Systems; D030541:Databases, Genetic; D023281:Genomics; D059014:High-Throughput Nucleotide Sequencing; D006801:Humans; D016247:Information Storage and Retrieval
Genomics; MongoDB; MySQL; NoSQL; PostgreSQL; Relational database