Understanding complex relationships among heterogeneous biological data is one of the fundamental goals in biology. In most cases, diverse biological data are stored in relational databases, such as MySQL and Oracle, which store data in multiple tables and then infer relationships by multiple-join s...
Understanding complex relationships among heterogeneous biological data is one of the fundamental goals in biology. In most cases, diverse biological data are stored in relational databases, such as MySQL and Oracle, which store data in multiple tables and then infer relationships by multiple-join statements. Recently, a new type of database, called the graph-based database, was developed to natively represent various kinds of complex relationships, and it is widely used among computer science communities and IT industries. Here, we demonstrate the feasibility of using a graph-based database for complex biological relationships by comparing the performance between MySQL and Neo4j, one of the most widely used graph databases. We collected various biological data (protein-protein interaction, drug-target, gene-disease, etc.) from several existing sources, removed duplicate and redundant data, and finally constructed a graph database containing 114,550 nodes and 82,674,321 relationships. When we tested the query execution performance of MySQL versus Neo4j, we found that Neo4j outperformed MySQL in all cases. While Neo4j exhibited a very fast response for various queries, MySQL exhibited latent or unfinished responses for complex queries with multiple-join statements. These results show that using graph-based databases, such as Neo4j, is an efficient way to store complex biological relationships. Moreover, querying a graph database in diverse ways has the potential to reveal novel relationships among heterogeneous biological data.
Understanding complex relationships among heterogeneous biological data is one of the fundamental goals in biology. In most cases, diverse biological data are stored in relational databases, such as MySQL and Oracle, which store data in multiple tables and then infer relationships by multiple-join statements. Recently, a new type of database, called the graph-based database, was developed to natively represent various kinds of complex relationships, and it is widely used among computer science communities and IT industries. Here, we demonstrate the feasibility of using a graph-based database for complex biological relationships by comparing the performance between MySQL and Neo4j, one of the most widely used graph databases. We collected various biological data (protein-protein interaction, drug-target, gene-disease, etc.) from several existing sources, removed duplicate and redundant data, and finally constructed a graph database containing 114,550 nodes and 82,674,321 relationships. When we tested the query execution performance of MySQL versus Neo4j, we found that Neo4j outperformed MySQL in all cases. While Neo4j exhibited a very fast response for various queries, MySQL exhibited latent or unfinished responses for complex queries with multiple-join statements. These results show that using graph-based databases, such as Neo4j, is an efficient way to store complex biological relationships. Moreover, querying a graph database in diverse ways has the potential to reveal novel relationships among heterogeneous biological data.
* AI 자동 식별 결과로 적합하지 않은 문장이 있을 수 있으니, 이용에 유의하시기 바랍니다.
제안 방법
In this work, we set up a graph database and tested its performance in storing and retrieving heterogeneous and complex biological networks. We used Neo4j (http://neo4j.
We performed the same query on each server to compare the query performance of non-optimized and optimized servers. We measured the time to return results by performing a query to retrieve all data that traverse the relationships among genes, drugs, and diseases that increased the expression of the BRCA1 gene (Supplementary Fig. 1). When the two servers were queried using the same search term, the optimized server returned results in 138 ms, while the non-optimized server returned results in 316 ms for the same query (Fig.
성능/효과
We used Neo4j, one of the most actively developed, open-source graph databases with property graph models. We first optimized various parameters of a graph database server for maximum performance, as suggested by the Neo4j community, and achieved more than 40% improvement in performance. During the optimization, we found that Neo4j creates many index files for the storage of many relationships and depends heavily on system memory to read and write those index files.
참고문헌 (38)
1 Hartwell LH Hopfield JJ Leibler S Murray AW From molecular to modular cell biology Nature 1999 402 6761 Suppl C47 C52 10591225
2 Kitano H Computational systems biology Nature 2002 420 206 210 12432404
7 Li J Zhao PX Mining functional modules in heterogeneous biological networks using multiplex PageRank approach Front Plant Sci 2016 7 903 27446133
8 Pavlopoulos GA Secrier M Moschopoulos CN Soldatos TG Kossida S Aerts J Using graph theory to analyze biological networks BioData Min 2011 4 10 21527005
10 Lysenko A RoznovăŢ IA Saqi M Mazein A Rawlings CJ Auffray C Representing and querying disease networks using graph databases BioData Min 2016 9 23 27462371
12 Henkel R Wolkenhauer O Waltemath D Combining computational models, semantic annotations and simulation experiments in a graph database Database (Oxford) 2015 2015 bau130 25754863
13 Mullen J Cockell SJ Woollard P Wipat A An integrated data driven approach to drug repositioning using gene-disease associations PLoS One 2016 11 e0155811 27196054
14 Balaur I Saqi M Barat A Lysenko A Mazein A Rawlings CJ EpiGeNet: a graph database of interdependencies between genetic and epigenetic events in colorectal cancer J Comput Biol 2016 9 14 [Epub] 10.1089/cmb.2016.0095
15 Robinson I Webber J Eifrem E Graph Databases: New Opportunities for Connected Data 2nd ed Sebastopol O'Reilly Media, Inc. 2015
16 Neo Technology Inc The Neo4j Operations Manual v3.0, Performance [Internet] Baltimore Neo Technology, Inc. 2016 cited 2016 Jan 10 Available from: https://neo4j.com/docs/operations-manual/current
17 Van Bruggen R Learning Neo4j Birmingham Packt Publishing Ltd. 2014
18 Bravo À Cases M Queralt-Rosinach N Sanz F Furlong LI A knowledge-driven approach to extract disease-related biomarkers from the literature Biomed Res Int 2014 2014 253128 24839601
19 Stark C Breitkreutz BJ Reguly T Boucher L Breitkreutz A Tyers M BioGRID: a general repository for interaction datasets Nucleic Acids Res 2006 34 D535 D539 16381927
21 Gaulton A Bellis LJ Bento AP Chambers J Davies M Hersey A ChEMBL: a large-scale bioactivity database for drug discovery Nucleic Acids Res 2012 40 D1100 D1107 21948594
23 Liu CC Tseng YT Li W Wu CY Mayzus I Rzhetsky A DiseaseConnect: a comprehensive web server for mechanism-based disease-disease connections Nucleic Acids Res 2014 42 W137 W146 24895436
24 Wishart DS Knox C Guo AC Shrivastava S Hassanali M Stothard P DrugBank: a comprehensive resource for in silico drug discovery and exploration Nucleic Acids Res 2006 34 D668 D672 16381955
25 Welter D MacArthur J Morales J Burdett T Hall P Junkins H The NHGRI GWAS Catalog, a curated resource of SNP-trait associations Nucleic Acids Res 2014 42 D1001 D1006 24316577
27 Bult CJ Eppig JT Kadin JA Richardson JE Blake JA Mouse Genome Database Group The Mouse Genome Database (MGD): mouse biology and model systems Nucleic Acids Res 2008 36 D724 D728 18158299
28 Chatr-aryamontri A Ceol A Palazzi LM Nardelli G Schneider MV Castagnoli L MINT: the Molecular INTeraction database Nucleic Acids Res 2007 35 D572 D574 17135203
29 Peters LB Bahr N Bodenreider O Evaluating drug-drug interaction information in NDF-RT and DrugBank J Biomed Semantics 2015 6 19 25964850
30 Hamosh A Scott AF Amberger JS Bocchini CA McKusick VA Online Mendelian Inheritance in Man (OMIM), a knowl-edgebase of human genes and genetic disorders Nucleic Acids Res 2005 33 D514 D517 15608251
31 Schriml LM Arze C Nadendla S Chang YW Mazaitis M Felix V Disease Ontology: a backbone for disease semantic integration Nucleic Acids Res 2012 40 D940 D946 22080554
33 Gottlieb A Stein GY Ruppin E Sharan R PREDICT: a method for inferring novel drug indications with application to personalized medicine Mol Syst Biol 2011 7 496 21654673
34 Twigger SN Shimoyama M Bromberg S Kwitek AE Jacob HJ RGD Team The Rat Genome Database, update 2007: easing the path from disease to data and back again Nucleic Acids Res 2007 35 D658 D662 17151068
35 Krallinger M Valencia A Hirschman L Linking genes to literature: text mining, information extraction, and retrieval applications for biology Genome Biol 2008 9 Suppl 2 S8
36 Kuhn M Campillos M Letunic I Jensen LJ Bork P A side effect resource to capture phenotypic effects of drugs Mol Syst Biol 2010 6 343 20087340
37 Chen X Ji ZL Chen YZ TTD: Therapeutic Target Database Nucleic Acids Res 2002 30 412 415 11752352
※ AI-Helper는 부적절한 답변을 할 수 있습니다.