A review of methods and tools for database integration in biomedicine

Current Bioinformatics

Volumn 5, Issue 4, 2010, Pages 253-269

  Anguita, Alberto ^a   Martín, Luis ^a   Pérez Rey, David ^a   Maojo, Víctor ^a  

^a UNIVERSIDAD POLITÉCNICA DE MADRID   (Spain)

Author keywords

Biomedicine; Database integration; Ontologies; Semantic mediation

Indexed keywords

DATABASE SYSTEMS; GENES; INFORMATION MANAGEMENT; SEMANTICS;

'OMICS'; BIOMEDICAL DATA; BIOMEDICINE; DATABASES INTEGRATIONS; GENOMIC ERA; HETEROGENEOUS SOURCES; HUMAN GENOME PROJECT; MANAGEMENT IS; ONTOLOGY'S; SEMANTIC MEDIATION;

DATA INTEGRATION;

ARTICLE; BIOINFORMATICS; BIOMEDICINE; DATA ANALYSIS; DATA BASE; GENE MAPPING; HYBRID; INFORMATION SYSTEM; PRIORITY JOURNAL; SYSTEMS BIOLOGY;

EID: 78951482231     PISSN: 15748936     EISSN: None     Source Type: Journal    
DOI: 10.2174/157489310794072481     Document Type: Article

References (114)

1. Bajic VB, Brusic V, Li J, Ng SK, Wong L. From informatics to bioinformatics. Proceedings of the First Asia-Pacific bioinformatics conference on Bioinformatics. Adelaide, Australia: Australian Computer Society 2003; pp. 3-12.
2. Perez-Rey D, Anguita A, Crespo J. OntoDataClean: ontology-based integration and preprocessing of distributed data. in: Maglaveras N, Chouvarda I, Koutkias V, Brause R, Eds. Biological and medical data analysis. Lecture Notes in Computer Science. Berlin, Heidelberg: Springer Berlin/Heidelberg 2006; vol. 4345 pp. 262-72.
3. Alonso-Calvo R, Maojo V, Billhardt H, Martin-Sanchez F, García-Remesal M, Pérez-Rey D. An agent- and ontology-based system for integrating public gene, protein, and disease databases. J Biomed Inform 2007; 40(1): 17-29.
4. Maojo V, García-Remesal M, Billhardt H, Alonso-Calvo R, Pérez-Rey D, Martín-Sánchez F. Designing new methodologies for integrating biomedical information in clinical trials. Methods Inf Med 2006; 45(2): 180-5.
5. Grotkjaer T, Nielsen J. Enhancing yeast transcription analysis through integration of heterogeneous data. Curr Genomics 2004; 5(8): 673-86.
6. Gurwitz D, Lunshof JE, Altman RB. A call for the creation of personalized medicine database. Nat Rev Drug Disc 2006; 5: 23-6.
7. Philippi S, Köhler J. Addressing the problems with life-science databases for traditional uses and systems biology. Nat Rev Genet 2006; 7(6): 482-8.
8. Jansen R, Lan N, Qian J, Gerstein M. Integration of genomic datasets to predict protein complexes in yeast. J Struct Funct Genomics 2002; 2: 71-81.
9. Jiang H, Deng Y, Chen HS, et al. Joint analysis of two microarraygene-expression data sets to select lung adenocarcinoma marker genes. BMC Bioinformatics 2004; 5: 81.
10. Longtin R. An integrated approach: Systems biology seeks order in complexity. J Natl Cancer Inst 2005; 97(7): 476-8.
11. Wong L. Technologies for integrating biological data. Brief Bioinform 2002; 3(4): 389-404.
12. Galperin MY. The molecular biology database collection: 2008 update. Nucleic Acids Res 2008; 36(Database issue): 2-4.
13. Zheng WJJ. Engineering approaches toward biological information integration at the systems level. Curr Bioinformatics 2006; 1(1): 85-93.
14. Lee TJ, Pouliot Y, Wagner V, et al. BioWarehouse: a bioinformatics database warehouse toolkit. BMC Bioinformatics 2006; 7: 170.
15. Ameur A, Yankovski V, Enroth S, Spjuth O, Komorowski J. The LCB Data Warehouse. Bioinformatics 2006; 22: 1024-6.
16. Mesiti M, Jimenez-Ruiz E, Sanz I, et al. XML-based approaches for the integration of heterogeneous bio-molecular data. BMC Bioinformatics 2009; 10(12): S7.
17. Sources and classification of semantic heterogeneities http://www.mkbergman.com/?p=232 (Accessed Mar 26, 2010).
18. Cimino J. Desiderata for controlled medical vocabularies in the twenty-first century. Methods Inf Med 1998; 37(4-5): 394-403.
19. Burgun A, Bodenreider O. Accessing and integrating data and knowledge for biomedical research. Yearbook of Medical informatics 2008; pp. 91-101.
20. Rahm H. Do. Data cleaning: Problems and current approaches. IEEE Data Eng Bull 2000; 23(4): 3-13.
21. Verykios VS, Elmagarmid AK, Houstis EN. Automating the approximate record-matching process. Inform Sci 2000; 126(1): 83-98.
22. Luján-Mora S, Palomar M. Comparing string similarity measures for reducing inconsistency in integrating data from different sources. In: WAIM '01: Proceedings of the Second International Conference on Advances in Web-Age Information Management. London, UK: Springer-Verlag 2001; pp. 191-202.
23. Hernández MA, Stolfo SJ. Real-world data is dirty: Data cleansing and the merge/purge problem. Data Mining Knowl Disc 1998; 2(1): 9-37.
24. Zhao H, Ram S. Entity identification for heterogeneous database integration-a multiple classifier system approach and empirical evaluation. Inform Syst 2005; 30(2): 119-32.
25. Sujansky W. Heterogeneous database integration in biomedicine. J Biomed Inform 2001; 34(4): 285-98.
26. Kimball R. The data warehouse toolkit: Practical techniques for building dimensional data warehouses New York: John Wiley & Sons, Inc: USA 1996.
27. Lopatenko AS. Information retrieval in current research information systems. In Proc of Workshop on Knowledge Markup and Semantic Annotation, K-CAP01 2001.
28. Gruber TR. A translation approach to portable ontology specifications. Knowl Acquisition 1993; 5(2): 199-220.
29. Jakoniene V, Lambrix P. Ontology-based integration for bioinformatics. Proceedings of the VLDB Workshop on Ontologies-bases techniques for DataBases and Information Systems - ODBIS. Haraldsalen, Norway Sep 2-3, 2005; pp. 55-58.
30. Gene Ontology Consortium Gene Oncology (GO) project in 2006. Nucleic Acids Res 2006; 34(Database issue): 3: 22-6.
31. Rosse C, Mejino JLV. A reference ontology for biomedical informatics: the foundational model of anatomy. J Biomed Inform 2003; 36(6): 478-500.
32. Smith B, Ashburner M, Rosse C, et al. The OBO Foundry: coordinated evolution of ontologies to support biomedical data integration. Nat Biotechnol 2007; 25(11): 1251-5.
33. O'Reilly T. What is Web2.0. Design patterns and business models for the next generation of software. O'Reilly Media 2005. http://oreilly.com/web2/archive/what-is-web-20.html (Accessed Mar 26,2010).
34. Jarke M, Jeusfeld MA, Quix C, Vassiliadis P. Architecture and quality in data warehouses. In: Pernici B, Thanos C, Eds. of Lecture Notes in Computer Science. Springer-Verlag: 1998; vol. 1413 pp. 93-113.
35. Kimball R. Bringing up supermarts. DBMS 1998; 11(1): 47-53.
36. Inmon WH, Rudin K, Buss CK, Sousa R. Data Warehouse Performance. New York, USA John Wiley & Sons, Inc: 1999.
37. Lenzerini M. Data integration: a theoretical perspective. In: Proceedings of the Twenty-First ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems. Madison, USA 2002; pp. 233-46.
38. Wache H, Scholz T, Stieghahn H, König-Ries B. An integration method for the specification of rule-oriented mediators. In: Proceedings of the International Symposium on Database Applications in Non-Traditional Environments. Kyoto, Japan 1999; pp. 109-12.
39. Ullman JD. Information integration using logical views. In: Proceedings of the International Conference on Database Theory; Lecture Notes in Computer Science Barcelona: Spain 1997; vol. 1186: pp. 19-40.
40. Levy AY, Rajaraman A, Ordille J. Querying heterogeneous information sources using source descriptions. In: Proceedings of the Twenty-second International Conference on Very Large Data Bases. Bombai, India 1996; pp. 251-62.
41. Wiederhold G. Mediators in the architecture of future information systems. IEEE Comput 1992; 25(3): 38-49.
42. Pottinger R, Halevy A. Minicon: a scalable algorithm for answering queries using views. VLDB J 2001; 10(2); 182-98.
43. Halevy AY. Answering queries using views: A survey. Int J Very Large Data Bases 2001; 10(4), 270-94.
44. Xu L, Embley DW. Combining the best of global-as-view and local-as-view for data integration. In: Proceedings of ISTA 2004: 3rd International Conference on Information Systems Technology and its Applications; Budapest, Hundary. New York, USA: Springer-Verlag 2004; pp. 123-36.
45. Lehti P, Fankhauser P. XML Data Integration with OWL: Experiences and challenges. In: Proceeding of the Symposium on Applications and the Internet. Tokio, Japan 2004; pp. 160-70.
46. Cali A, Calvanese D, De Giacomo G, Lenzerini M, Naggar P, Vernacotola F. IBIS: Semantic data integration at work. In: Proceedings of the 15th Int. Conf. on Advanced Information Systems Engineering (CAiSE 2003) Klagenfurt, Austria. Lecture Notes in Computer Science: Springer 2003; vol. 2681: pp. 79-94.
47. Lin J, Mendelzon AO. Merging databases under constraints. Int J Coop Inform Syst 1998; 7(1): 55-76.
48. Lembo D, Lenzerini M, Rosati R. Source inconsistency and incompleteness in data integration. In: Proceedings of the 9th Int. Workshop on Knowledge Representation meets Databases. Toulouse, France 2002.
49. Amann B, Beeri C, Fundulaki I, Scholl M. Ontology-Based Integration of XML Web Resources. In. Proceedings of the 1st International Semantic Web Conference. Sardinia, Italy. Lecture Notes in Computer Science 2002; pp. 117-31.
50. Jian L, Beihong J. Query division and reformulation in ontology-based heterogeneous information integration. In: Proceedings of the 15th International Conference on Computing; Mexico city, Mexico 2006; pp. 186-96.
51. Martín L, Anguita A, Jiménez A, Crespo J. Enabling cross constraint satisfaction in rdf-based heterogeneous database integration. In: Proceedings of the 20th IEEE Int'l Conference on Tools with Artificial Intelligence. Dayton, USA 2008; pp. 5-11.
52. Zobel J, Dart P. Phonetic string matching: lessons from information retrieval. In: Proceedings of the 19th Annual international ACM SIGIR Conference on Research and Development in information Retrieval. Zurich, Switzerland 1996; pp. 166-72.
53. Hernández MA, Stolfo SJ. Real-world data is dirty: data cleansing and the merge/purge problem. Data Mining Knowl Disc 1998; 2(1): 9-37.
54. Chen ALP, Tsai PSM, Koh JL. Identifying object isomerism in multidatabase systems. Distrib Parallel Databases 1996; 4(2): 143-68.
55. Segev A, Chatterjee A. A framework for object matching in federated databases and its implementation. Int J Coop Inform Syst 1996; 5(1): 73-99.
56. Dey D, Sarkar S, De P. Entity matching in heterogeneous data-bases: a distance-based decision model. Proceedings of the HICSS; Kohala Coast, USA. IEEE Computer Society. Washington, DC, USA 1998; pp. 305-13.
57. Dey D, Sarkar S, De P. A distance-based approach to entity reconciliation in heterogeneous databases. IEEE Trans Knowl Data Eng 2002; 14(3): 567-82.
58. Weiss SM, Kulikowski CA. Computer systems that learn: classification and prediction methods from statistics, Neural Nets, Machine Learning and Expert Systems. Morgan Kaufmann, San Francisco, CA 1991.
59. Jain AK, Duin RPW, Mao J. Statistical pattern recognition: a review. IEEE Trans Patt Anal Mach Intel 2000; 22(1): 4-37.
60. Jensen F. An introduction to bayesian networks. USA: Springer 1996.
61. Duda R, Hart P. Pattern classification and scene analysis. New York: John Wiley and Sons 1973.
62. Quinlan JR. C4.5: Programs for machine learning. San Matco CA: Morgan Kaufmann Publishers 1993.
63. Sarkans U, Parkinson H, Lara GG, et al. The ArrayExpress gene expression database: a software engineering and implementation perspective. Bioinformatics 2005; 21(8): 1495-501.
64. Gene Expression Omnibus. http://www.ncbi.nlm.nih.gov/geo/ (Accessed Mar 26, 2010).
65. Stanford Microarray Database. http://smd.stanford.edu/ (Accessed Mar 26, 2010).
66. MGED Society. http://www.mged.org/ (Accessed Mar 26, 2010).
67. Hammer J, Mchugh J, Garcia-Molina H. Semistructured data: the TSIMMIS experience. In Proceedings of the First East-European Symp. Advances in Databases and Information Systems (ADBIS); St.Petersburg, Rusia 1997; pp. 1-8.
68. Knoblock CA, Minton S, Ambite JL, et al. The Ariadne approach to web-based information integration. Int J Coop Inform Syst 2001; 10(1-2): 145-69.
69. Alonso-Calvo R, Maojo V, Billhardt H, Martin-Sanchez F, García-Remesal M, Pérez-Rey D. An agent- and ontology-based system for integrating public gene, protein, and disease databases. J Bio-med Inform 2007; 40(1): 17-29.
70. García-Remesal M. Using hierarchical task network planning techniques to create custom web search services over multiple bio-medical databases. In: 12th international conference on Knowledge-Based Intelligent Information and Engineering Systems. Lect Notes Comput Sci. Zagreb, Croatia 2008; vol. 5178: pp. 42-9.
71. Huang Y, Ni T, Zhou L, Su S. JXP4BIGI: a generalized, Java XML-based approach for biological information gathering and integration. Bioinformatics 2003; 19(18): 2351-8.
72. Do HH, Rahm E. Flexible integration of molecular-biological annotation data. In: Proceedings of the 9th International Conference on Extending Database Technology; 2004 Mar 14-18; Heraklion, Crete. Adv Database Technol 2004; 2992; 811-22.
73. Shah SP, Huang Y, Xu T, Yuen MM, Ling J, Ouellette BF. Atlas -a data warehouse for integrative bioinformatics. BMC Bioinformatics 2005; 6: 34.
74. Huang H, Hu ZZ, Arighi CN, Wu CH. Integration of bioinformatics resources for functional analysis of gene expression and proteomic data. Front Biosci 2007; 12: 5071-88.
75. Critchlow T, Fidelis K, Ganesh M, Musick R, Slezak T. DataFoundry: information management for scientific data. IEEE Trans Inf Technol Biomed 2000; 4(1): 52-7.
76. Eckman BA, Kosky AS, Laroco LA Jr. Extending traditional query-based integration approaches for functional characterization of post-genomic data. Bioinformatics 2001; 17(7): 587-601.
77. Freier A, Hofestädt R, Lange M, Scholz U, Stephanik A. Bio-DataServer: a SQL-based service for the online integration of life science data. In Silico Biol 2002; 2(2): 37-57.
78. Höding M, Hofestädt R, Saake G, Scholz U. Schema derivation for WWW information sources and their integration with databases in bioinformatics. In: Advances in Databases and Information Systems. Lect Notes Comp Sci Poznan, Poland 1998; vol. 1475: pp. 296-304.
79. Chung SY, Wong L. Kleisli: a new tool for data integration in biology. Trends Biotechnol 1999; 17(9): 351-5.
80. Wong L. Bioinformatics integration simplified: the Kleisli way. Frontiers in human genetics: diseases and technologies. In: Lai P.S, Yap E, Eds. World Scientific: Singapore 2001; pp. 79-90.
81. Gupta A, Ludascher B, Martone ME. Knowledge-based integration of neuroscience data sources. In: Proceedings of the 12th International Conference on Scientific and Statistical Database Management. IEEE Comp Soc Berlin, Germany 2000; pp: 39-52.
82. Goble CA, Stevens R, Ng G, et al. Transparent access to multiple bioinformatics information sources. IBM Syst J 2001; 40(2): 532-51.
83. Baker PG, Goble CA, Bechhofer S, Paton NW, Stevens R, Brass A. An ontology for bioinformatics applications. Bioinformatics 1999; 15(6): 510-20.
84. Kemp GJL, Angelopoulos N, Gray PMD. A schema-based approach to building a bioinformatics database federation. Proceedings of the 1st IEEE International Symposium on Bioinformatics and Biomedical Engineering. IEEE Comp Soc. Arlington, USA 2000; pp. 13-20.
85. Kemp GJ, Angelopoulos N, Gray PM. Architecture of a mediator for a bioinformatics database federation. IEEE Trans Inf Technol Biomed 2002; 6(2): 116-22.
86. Shipman DW. The functional data model and the data language DAPLEX. ACM Trans. Database Syst 1981; 6(1): 140-73.
87. Köhler J, Philippi S, Lange M. SEMEDA: ontology based semantic integration of biological databases. Bioinformatics 2003; 19(18): 2420-7.
88. Haas LM, Schwarz PM, Kodali P, Kotlar E, Rice JE, Swope WC. DiscoveryLink: a system for integrated access to life sciences data sources. IBM Syst J 2003; 40(2): 489-511.
89. Aldana J, Roldán M, Navas I, Pérez A, Trelles O. Integrating biological data sources and data analysis tools through mediators. In: Proceedings of the 2004 ACM Symp Appl Comp Nicosia, Cyprus 2004; pp. 127-31.
90. Donelson L, Tarczy-Hornoch P, Mork P, et al. The biomediator system as a data integration tool to answer diverse biologic queries. Stud Health Technol Inform 2004; 107(Pt 2): 768-72.
91. Wang K, Tarczy-Hornoch P, Shaker R, Mork P, Brinkley JF. Bio-Mediator data integration: beyond genomics to neuroscience data. In: Proceedings ot the AMIA Annu Symp Proc. Austin, USA 2005; pp. 779-83.
92. Caragea D, Pathak J, Bao J, et al. Information integration and knowledge acquisition from semantically heterogeneous biological data sources. Data integration in the life sciences. San Diego, USA. Lecture Notes Comp Sci: Springer 2005; vol. 3615: pp. 175-90.
93. Arredondo T, Seeger M, Dombrovskaia L, et al. Bioinformatics Integration Framework for Metabolic Pathway Data-Mining. In: Advances in Applied Artificial Intelligence Lecture Notes Comp Sci Annecy France 2006; vol. 4031: pp. 917-26.
94. Pérez-Rey D, Maojo V, García-Remesal M, et al. ONTOFUSION: ontology-based integration of genomic and clinical databases. Comput Biol Med 2006; 36(7-8): 712-30.
95. Kirsten T, Rahm E. BioFuice, mapping-based data integration in bioinformatics. In: Proceedings of the third international workshop on Data Integration in the Life Sciences Hinxton, UK. Lecture Notes Comp Sci: Springer 2006; vol. 4075: pp. 124-35.
96. Rahm E, Thor A, Aumueller D, Do HH, Golovin N, Kirsten T. iFuice - Information Fusion utilizing Instance Correspondences and Peer Mappings. In: Proceedings of the 8th Int. Workshop on the Web & Databases (WebDB). Baltimore, USA 2005; pp. 7-12.
97. Belleau F, Nolin MA, Tourigny N, Rigault P, Morissette J. Bio2RDF: Towards a mashup to build bioinformatics knowledge systems. J Biomed Inform 2008; 41(5): 706-16.
98. Hansen HL, Ingvaldsen K. Dynamic Schema Integration - The ACRoSS Prototype. PhD Thesis, University of Bergen, Norway 2004.
99. Park J, Ram S. Information systems interoperability: What lies beneath? ACM Trans Inform Syst 2004; 22(4): 595-632.
100. Ram S, Park J. Semantic Conflict Resolution Ontology (SCROL): An ontology for detecting and resolving data and schema-level semantic conflicts. IEEE Trans Knowl Data Eng 2004; 16(2): 189-202.
101. Madnick S, Zhu H. Improving data quality through effective use of data semantics. Data Knowl Eng 2006; 59(2): 460-75.
102. Zhu H, Madnick S. Scalable interoperability through the use of coin lightweight ontology. In: Ontologies-Based Databases and Information Systems. Lecture Notes Comp Sci Auckland. New Zealand 2007; vol. 4623: pp. 37-50.
103. Haas LM, Miller RJ, Niswonger B, Tork Roth M, Schwarz PM, Wimmers EL. Transforming heterogeneous data with database middleware: beyond integration. IEEE Tech Bull Data Eng 1999; 22(1): 31-6.
104. Anguita A, Martín L, Crespo J, Tsiknakis M. An ontology based method to solve query identifier heterogeneity in post-genomic clinical trials. Stud Health Technol Inform 2008; 136: 3-8.
105. Anguita A, Perez-Rey D, Crespo J, Maojo V. Automatic generation of integration and preprocessing ontologies for biomedical sources in a distributed scenario. 21st IEEE International Symposium on Computer-Based Medical Systems. IEEE Jyväskylä. Finland 2008; pp. 336-41.
106. Fan W, Lu H, Madnick SE, Cheung D. Discovering and reconciling value conflicts for numerical data integration. Inform Syst 2001; 26(8): 635-56.
107. Fan W, Lu H, Madnick SE, Cheung D. DIRECT: a system for mining data value conversion rules from disparate data sources. Dec Supp Syst 2002; 34(1): 19-39.
108. Zhao H, Ram S. Combining schema and instance information for integrating heterogeneous data sources. Data Knowl Eng 2007; 61(2): 281-303.
109. Brazas MD, Fox JA, Brown T, McMillan S, Ouellette BF. Keeping Pace with the Data: 2008 Update on the Bioinformatics Links Directory. Nucleic Acids Res 2008; 36(2): W2-4.
110. De la Calle G, García-Remesal M, Chiesa S, de la Iglesia D, Maojo V. BIRI: a new approach for automatically discovering and indexing available public bioinformatics resources from the literature. BMC Bioinformatics 2009; 10(1): 320.
111. Church GM. The personal genome project. Mol Syst Biol 2005; 1(1); E1-E3.
112. Rebbeck TR. Inherited genetic markers and cancer outcomes: personalized medicine in the postgenome era. J Clin Oncol 2006; 24(13): 1972-74.
113. Bhowmick SS, Singh DT, Laud A. Data management in metaboloinformatics: issues and challenges. In: Proceedings of the 14th International Workshop on Database and Expert Systems Applications Prague, Czech Republic. Lecture Notes Comp Sci 2003, vol. 2736; pp 392-402.
114. Maojo V, Martin-Sanchez F, Kulikowski C, Rodriguez-Paton A, Fritts M. Nanoinformatics and DNA-based computing: catalyzing nanomedicine. Pediatr Res 2010; 67(5): 481-9.