RUS  ENG
Full version
JOURNALS // Matematicheskaya Biologiya i Bioinformatika // Archive

Mat. Biolog. Bioinform., 2020 Volume 15, Issue 2, Pages 455–470 (Mi mbb442)

This article is cited in 3 papers

Bioinformatics

RDBMS and NoSQL based hybrid technology for transcriptome data structuring and processing

A. M. Mukhinab, M. A. Genaevacb, D. A. Rasskazovab, S. A. Lashinacb, D. A. Afonnikovabc

a The Federal Research Center Institute of Cytology and Genetics, Siberian Branch of the Russian Academy of Sciences, Novosibirsk, Russia
b Kurchatov Genomics Center, Institute of Cytology and Genetics SB RAS, Novosibirsk, Russia
c Novosibirsk State University, Novosibirsk, Russia

Abstract: The transcriptome sequencing experiment (RNA-seq) has become almost a routine procedure for studying both model organisms and crops. As a result of bioinformatics processing of such experimental output, huge heterogeneous data are obtained, representing nucleotide sequences of transcripts, amino acid sequences, and their structural and functional annotation. It is important to present the data obtained to a wide range of researchers in the form of databases. This article proposes a hybrid approach to creating molecular genetic databases that contain information about transcript sequences and their structural and functional annotation. The essence of the approach consists in the simultaneous storing both structured and weakly structured data in the database. The technology was used to implement a database of transcriptomes of agricultural plants. This paper discusses the features of implementing this approach and examples of generating both simple and complex queries to such a database in the SQL language. The OORT database is freely available at https://oort.cytogen.ru/.

Key words: database, indexing, queries, plants, SQL, RDBMS, NoSQL, transcriptomes, crops.

Received 26.10.2020, 14.12.2020, Published 28.12.2020

DOI: 10.17537/2020.15.455



© Steklov Math. Inst. of RAS, 2024