Abstract
This paper presents an extensible architecture that can be used to support the integration of heterogeneous biological data sets. In our architecture, a clustering approach has been developed to support distributed biological data sources with inconsistent identification of biological objects. The architecture uses the AutoMed data integration toolkit to store the schemas of the data sources and the semi-automatically generated transformations from the source data into the data of an integrated warehouse. AutoMed supports bi-directional, extensible transformations which can be used to update the warehouse data as entities change, are added, or are deleted in the data sources. The transformations can also be used to support the addition or removal of entire data sources, or evolutions in the schemas of the data sources or of the warehouse itself. The results of using the architecture for the integration of existing genomic data sets are discussed.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Boyd, M., Kittivoravitkul, S., Lazanitis, C., McBrien, P.J., Rizopoulos, N.: AutoMed: A BAV data integration system for heterogeneous data sources. In: Persson, A., Stirna, J. (eds.) CAiSE 2004. LNCS, vol. 3084, pp. 82–97. Springer, Heidelberg (2004)
Buneman, P., Libkin, L., Suciu, D., Tannen, V., Wong, L.: Comprehension syntax. SIGMOD Record 23(1), 87–96 (1994)
Enright, A.J., Van Dongen, S., Ouzounis, C.A.: An efficient algorithm for large-scale detection of protein families. Nucleic Acids Res. 30(7), 1575–1584 (2002)
Golovin, A., et al.: E-MSD: an integrated data resource for bioinformatics. Nucleic Acids Res. 32 Database issue(1362-4962), D211–D216 (2004)
Goble, C.A., et al.: Transparent access to multiple bioinformatics information sources. IBM Systems Journal 40(20), 532–552 (2001)
Orengo, C.A., et al.: CATH–a hierarchic classification of protein domain structures. Structure 5(8), 1093–1109 (1997)
Wheeler, D.L., et al.: Database resources of the National Center for Biotechnology: update. Nucl. Acids Res. 32 Database Issue, D35–D40 (2004)
Haas, L.M., et al.: DiscoveryLink: A system for integrated access to life sciences data sources. IBM Systems Journal 40(20), 489–511 (2001)
Ashburner, M., et al.: Gene Ontology: tool for the unification of biology. The Gene Ontology Consortium. Nature Genet. 25(1), 25–29 (2000)
Kersey, P.J., et al.: The International Protein Index: An integrated database for proteomics experiments. Proteomics 4(7), 1985–1988 (2004)
Spellman, P.T., et al.: Design and implementation of microarray gene expression markup language (MAGE-ML). Genome Biology 3(9), research 0046.1–0046.9–1988 (2002)
Davidson, S., et al.: K2/Kleisli and GUS: Experiments in integrated access to genomic data sources. IBM Systems Journal 40(20), 512–531 (2001)
Fan, H., Poulovassilis, A.: Tracing data lineage using schema transformation pathways. In: Knowledge Transformation for the Semantic Web. Frontiers in Artificial Intelligence and Applications, vol. 95, pp. 64–79. IOS Press, Amsterdam (2003)
Fan, H., Poulovassilis, A.: Using AutoMed metadata in data warehousing environments. In: Proc. DOLAP 2003, pp. 86–93 (2003)
Fan, H., Poulovassilis, A.: Schema Evolution in Data Warehousing Environments – A Schema Transformation-Based Approach. In: Atzeni, P., Chu, W., Lu, H., Zhou, S., Ling, T.-W. (eds.) ER 2004. LNCS, vol. 3288, pp. 639–653. Springer, Heidelberg (2004)
Goldman, R., Widom, J.: DataGuides: Enabling Query Formulation and Optimization in Semistructured Databases. In: Proc. VLDB 1997, pp. 436–445 (1997)
Hernandez, T., Kambhampati, S.: Integration of biological sources: Current systems and challenges ahead. Sigmod Record 33(3), 51–60 (2004)
Jasper, E., Poulovassilis, A., Zamboulis, L.: Processing IQL queries and migrating data in the AutoMed toolkit. Technical Report 20, Automed Project (2003)
Jasper, E., Tong, N., McBrien, P., Poulovassilis, A.: View generation and optimisation in the AutoMed data integration framework. In: Eder, J., Missikoff, M. (eds.) CAiSE 2003. LNCS, vol. 2681, pp. 29–32. Springer, Heidelberg (2003)
Kanehisa, M., Goto, S., Kawashima, S., Okuno, Y., Hattori, M.: The KEGG resources for deciphering the genome. Nucl. Acids Res. 32 Database Issue, D277–D280 (2004)
Lee, D., Grant, A., Marsden, R., Orengo, C.: Identification and distribution of protein families in 120 completed genomes using Gene3D. Proteins (2004) (In Press)
McBrien, P., Poulovassilis, A.: A formalisation of semantic schema integration. Inf. Syst. 23(5), 307–334 (1998)
McBrien, P., Poulovassilis, A.: Schema evolution in heterogeneous database architectures, a schema transformation approach. In: Pidduck, A.B., Mylopoulos, J., Woo, C.C., Ozsu, M.T. (eds.) CAiSE 2002. LNCS, vol. 2348, pp. 484–499. Springer, Heidelberg (2002)
McBrien, P., Poulovassilis, A.: Data integration by bi-directional schema transformation rules. In: Proc. ICDE 2003, pp. 227–238 (2003)
OMG. Life Sciences Identifiers RFP response (2003), http://www.omg.org/cgi-bin/doc?lifesci/2003-12-02
Shepherd, A.J., Martin, N.J., Johnson, R.G., Kellam, P., Orengo, C.A.: PFDB: a generic protein family database integrating the CATH domain structure database with sequence based protein family resources. Bioinformatics 18(12), 1666–1672 (2002)
Williams, D., Poulovassilis, A.: Combining data integration with natural language technology for the semantic web. In: Proc.Workshop on Human Language Technology for the Semantic Web and Web Services, ISWC 2003 (2003)
Zamboulis, L.: XML data integration by graph restructuring. In: Williams, H., MacKinnon, L.M. (eds.) BNCOD 2004. LNCS, vol. 3112, pp. 57–71. Springer, Heidelberg (2004)
Zamboulis, L., Poulovassilis, A.: Using AutoMed for XML data transformation and integration. In: Proceedings of DIWeb 2004, June 2004. Springer, Heidelberg (2004)
Zdobnov, E.M., Lopez, R., Apweiler, R., Etzold, T.: The EBI SRS Server - recent developments. Bioinformatics 18(2), 368–373 (2002)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Maibaum, M., Zamboulis, L., Rimon, G., Orengo, C., Martin, N., Poulovassilis, A. (2005). Cluster Based Integration of Heterogeneous Biological Databases Using the AutoMed Toolkit. In: Ludäscher, B., Raschid, L. (eds) Data Integration in the Life Sciences. DILS 2005. Lecture Notes in Computer Science(), vol 3615. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11530084_16
Download citation
DOI: https://doi.org/10.1007/11530084_16
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-27967-9
Online ISBN: 978-3-540-31879-8
eBook Packages: Computer ScienceComputer Science (R0)