title: Atlas - a data warehouse for integrative bioinformatics.
abstract: 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/
authors.affiliation: UBC Bioinformatics Centre, University of British Columbia, Vancouver, BC, Canada. sohrab@bioinformatics.ubc.ca <sohrab@bioinformatics.ubc.ca>
authors.forename: Sohrab P
authors.initials: SP
authors.lastname: Shah
authors.forename: Yong
authors.initials: Y
authors.lastname: Huang
authors.forename: Tao
authors.initials: T
authors.lastname: Xu
authors.forename: Macaire M S
authors.initials: MM
authors.lastname: Yuen
authors.forename: John
authors.initials: J
authors.lastname: Ling
authors.forename: B F Francis
authors.initials: BF
authors.lastname: Ouellette
mesh_terms: 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
chemical_list: D012333:RNA, Messenger
references.citation: Nucleic Acids Res. 2004 Jan 1;32(Database issue):D449-51
references.pmid: 14681454
references.citation: Nat Genet. 2002 Dec;32 Suppl:469-73
references.pmid: 12454640
references.citation: Nucleic Acids Res. 2004 Jan 1;32(Database issue):D258-61
references.pmid: 14681407
references.citation: Nucleic Acids Res. 2004 Jan 1;32(Database issue):D31-4
references.pmid: 14681352
references.citation: Genome Biol. 2002;3(12):RESEARCH0082
references.pmid: 12537571
references.citation: BMC Bioinformatics. 2004 Apr 19;5:40
references.pmid: 15096276
references.citation: BMC Bioinformatics. 2002 Oct 25;3:32
references.pmid: 12401134
references.citation: Bioinformatics. 2000 Feb;16(2):184-5
references.pmid: 10842744
references.citation: Genome Res. 2004 Jan;14(1):160-9
references.pmid: 14707178
references.citation: Nucleic Acids Res. 2003 Jan 1;31(1):94-6
references.pmid: 12519956
references.citation: Nat Biotechnol. 2004 Feb;22(2):177-83
references.pmid: 14755292
references.citation: Nucleic Acids Res. 2001 Jan 1;29(1):242-5
references.pmid: 11125103
references.citation: J Leukoc Biol. 2000 Mar;67(3):441-7
references.pmid: 10733106
references.citation: Nucleic Acids Res. 2004 Jan 1;32(Database issue):D452-5
references.pmid: 14681455
references.citation: Nucleic Acids Res. 2004 Jan 1;32(Database issue):D23-6
references.pmid: 14681350
references.citation: Bioinformatics. 2003 Dec 12;19(18):2351-8
references.pmid: 14668218
references.citation: Bioinformatics. 1999 Jun;15(6):510-20
references.pmid: 10383475
references.citation: Nucleic Acids Res. 2001 Jan 1;29(1):137-40
references.pmid: 11125071
references.citation: Nucleic Acids Res. 2003 Jan 1;31(1):248-50
references.pmid: 12519993
references.citation: Nat Genet. 2000 May;25(1):25-9
references.pmid: 10802651
references.citation: Nucleic Acids Res. 2003 Jan 1;31(1):51-4
references.pmid: 12519945
references.citation: Proc Natl Acad Sci U S A. 2003 Jan 21;100(2):605-10
references.pmid: 12529507
references.citation: Nucleic Acids Res. 2004 Jan 1;32(Database issue):D35-40
references.pmid: 14681353
references.citation: Nurs Stand. 2015 Feb 3;29(22):30
references.pmid: 25627520
references.citation: Nucleic Acids Res. 2004 Jan 1;32(Database issue):D497-501
references.pmid: 14681466
references.citation: Pac Symp Biocomput. 1998;:683-94
references.pmid: 9697222
references.citation: Nucleic Acids Res. 2004 Jan 1;32(Database issue):D27-30
references.pmid: 14681351
references.citation: J Biol Chem. 1999 Sep 24;274(39):27975-80
references.pmid: 10488147
references.citation: Nucleic Acids Res. 2001 Jan 1;29(1):11-6
references.pmid: 11125038
references.citation: Nucleic Acids Res. 2004 Jan 1;32(Database issue):D115-9
references.pmid: 14681372
references.citation: Bioinformatics. 2000 May;16(5):465-77
references.pmid: 10871269
references.citation: Brief Bioinform. 2002 Dec;3(4):331-41
references.pmid: 12511062
references.citation: Science. 2003 Oct 10;302(5643):249-55
references.pmid: 12934013