Atlas - a data warehouse for integrative bioinformatics.
BACKGROUND
We present a biological data warehouse called Atlas that locally stores and integrates biological sequences, molecular interactions, homology information, functional annotations of genes, and biological ontologies. The goal of the system is to provide data, as well as a software infrastructure for bioinformatics research and development.


METHODS
The Atlas system is based on relational data models that we developed for each of the source data types. Data stored within these relational models are managed through Structured Query Language (SQL) calls that are implemented in a set of Application Programming Interfaces (APIs). The APIs include three languages: C++, Java, and Perl. The methods in these API libraries are used to construct a set of loader applications, which parse and load the source datasets into the Atlas database, and a set of toolbox applications which facilitate data retrieval. Atlas stores and integrates local instances of GenBank, RefSeq, UniProt, Human Protein Reference Database (HPRD), Biomolecular Interaction Network Database (BIND), Database of Interacting Proteins (DIP), Molecular Interactions Database (MINT), IntAct, NCBI Taxonomy, Gene Ontology (GO), Online Mendelian Inheritance in Man (OMIM), LocusLink, Entrez Gene and HomoloGene. The retrieval APIs and toolbox applications are critical components that offer end-users flexible, easy, integrated access to this data. We present use cases that use Atlas to integrate these sources for genome annotation, inference of molecular interactions across species, and gene-disease associations.


CONCLUSIONS
The Atlas biological data warehouse serves as data infrastructure for bioinformatics research and development. It forms the backbone of the research activities in our laboratory and facilitates the integration of disparate, heterogeneous biological sources of data enabling new scientific inferences. Atlas achieves integration of diverse data sets at two levels. First, Atlas stores data of similar types using common data models, enforcing the relationships between data types. Second, integration is achieved through a combination of APIs, ontology, and tools. The Atlas software is freely available under the GNU General Public License at: http://bioinformatics.ubc.ca/atlas/
Shah
Sohrab P
SP
UBC Bioinformatics Centre, University of British Columbia, Vancouver, BC, Canada. sohrab@bioinformatics.ubc.ca <sohrab@bioinformatics.ubc.ca>
Huang
Yong
Y
Xu
Tao
T
Yuen
Macaire M S
MM
Ling
John
J
Ouellette
B F Francis
BF
D019295:Computational Biology / Q000295:instrumentation* / Q000379:methods*; D003196:Computer Graphics; D003628:Database Management Systems; D019992:Databases as Topic; D016208:Databases, Factual; D030541:Databases, Genetic; D020869:Gene Expression Profiling; D016678:Genome; D015894:Genome, Human; D023281:Genomics; D006801:Humans; D016247:Information Storage and Retrieval; D020407:Internet; D008957:Models, Genetic; D011381:Programming Languages; D025941:Protein Interaction Mapping; D012333:RNA, Messenger / Q000378:metabolism; D012984:Software; D014584:User-Computer Interface
D012333:RNA, Messenger
Nucleic Acids Res. 2004 Jan 1;32(Database issue):D449-51
14681454
Nat Genet. 2002 Dec;32 Suppl:469-73
12454640
Nucleic Acids Res. 2004 Jan 1;32(Database issue):D258-61
14681407
Nucleic Acids Res. 2004 Jan 1;32(Database issue):D31-4
14681352
Genome Biol. 2002;3(12):RESEARCH0082
12537571
BMC Bioinformatics. 2004 Apr 19;5:40
15096276
BMC Bioinformatics. 2002 Oct 25;3:32
12401134
Bioinformatics. 2000 Feb;16(2):184-5
10842744
Genome Res. 2004 Jan;14(1):160-9
14707178
Nucleic Acids Res. 2003 Jan 1;31(1):94-6
12519956
Nat Biotechnol. 2004 Feb;22(2):177-83
14755292
Nucleic Acids Res. 2001 Jan 1;29(1):242-5
11125103
J Leukoc Biol. 2000 Mar;67(3):441-7
10733106
Nucleic Acids Res. 2004 Jan 1;32(Database issue):D452-5
14681455
Nucleic Acids Res. 2004 Jan 1;32(Database issue):D23-6
14681350
Bioinformatics. 2003 Dec 12;19(18):2351-8
14668218
Bioinformatics. 1999 Jun;15(6):510-20
10383475
Nucleic Acids Res. 2001 Jan 1;29(1):137-40
11125071
Nucleic Acids Res. 2003 Jan 1;31(1):248-50
12519993
Nat Genet. 2000 May;25(1):25-9
10802651
Nucleic Acids Res. 2003 Jan 1;31(1):51-4
12519945
Proc Natl Acad Sci U S A. 2003 Jan 21;100(2):605-10
12529507
Nucleic Acids Res. 2004 Jan 1;32(Database issue):D35-40
14681353
Nurs Stand. 2015 Feb 3;29(22):30
25627520
Nucleic Acids Res. 2004 Jan 1;32(Database issue):D497-501
14681466
Pac Symp Biocomput. 1998;:683-94
9697222
Nucleic Acids Res. 2004 Jan 1;32(Database issue):D27-30
14681351
J Biol Chem. 1999 Sep 24;274(39):27975-80
10488147
Nucleic Acids Res. 2001 Jan 1;29(1):11-6
11125038
Nucleic Acids Res. 2004 Jan 1;32(Database issue):D115-9
14681372
Bioinformatics. 2000 May;16(5):465-77
10871269
Brief Bioinform. 2002 Dec;3(4):331-41
12511062
Science. 2003 Oct 10;302(5643):249-55
12934013