Skip to main content
SpringerLink
Log in

Cluster Based Integration of Heterogeneous Biological Databases Using the AutoMed Toolkit

  • Conference paper
Data Integration in the Life Sciences (DILS 2005)

Part of the book series: Lecture Notes in Computer Science ((LNBI,volume 3615))

Included in the following conference series:

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 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)

    Chapter  Google Scholar 

  2. Buneman, P., Libkin, L., Suciu, D., Tannen, V., Wong, L.: Comprehension syntax. SIGMOD Record 23(1), 87–96 (1994)

    Article  Google Scholar 

  3. 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)

    Article  Google Scholar 

  4. Golovin, A., et al.: E-MSD: an integrated data resource for bioinformatics. Nucleic Acids Res. 32 Database issue(1362-4962), D211–D216 (2004)

    Article  Google Scholar 

  5. Goble, C.A., et al.: Transparent access to multiple bioinformatics information sources. IBM Systems Journal 40(20), 532–552 (2001)

    Article  Google Scholar 

  6. Orengo, C.A., et al.: CATH–a hierarchic classification of protein domain structures. Structure 5(8), 1093–1109 (1997)

    Article  Google Scholar 

  7. Wheeler, D.L., et al.: Database resources of the National Center for Biotechnology: update. Nucl. Acids Res. 32 Database Issue, D35–D40 (2004)

    Article  Google Scholar 

  8. Haas, L.M., et al.: DiscoveryLink: A system for integrated access to life sciences data sources. IBM Systems Journal 40(20), 489–511 (2001)

    Article  Google Scholar 

  9. Ashburner, M., et al.: Gene Ontology: tool for the unification of biology. The Gene Ontology Consortium. Nature Genet. 25(1), 25–29 (2000)

    Article  Google Scholar 

  10. Kersey, P.J., et al.: The International Protein Index: An integrated database for proteomics experiments. Proteomics 4(7), 1985–1988 (2004)

    Article  Google Scholar 

  11. 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)

    Article  Google Scholar 

  12. Davidson, S., et al.: K2/Kleisli and GUS: Experiments in integrated access to genomic data sources. IBM Systems Journal 40(20), 512–531 (2001)

    Article  Google Scholar 

  13. 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)

    Google Scholar 

  14. Fan, H., Poulovassilis, A.: Using AutoMed metadata in data warehousing environments. In: Proc. DOLAP 2003, pp. 86–93 (2003)

    Google Scholar 

  15. 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)

    Chapter  Google Scholar 

  16. Goldman, R., Widom, J.: DataGuides: Enabling Query Formulation and Optimization in Semistructured Databases. In: Proc. VLDB 1997, pp. 436–445 (1997)

    Google Scholar 

  17. Hernandez, T., Kambhampati, S.: Integration of biological sources: Current systems and challenges ahead. Sigmod Record 33(3), 51–60 (2004)

    Article  Google Scholar 

  18. Jasper, E., Poulovassilis, A., Zamboulis, L.: Processing IQL queries and migrating data in the AutoMed toolkit. Technical Report 20, Automed Project (2003)

    Google Scholar 

  19. 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)

    Google Scholar 

  20. 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)

    Article  Google Scholar 

  21. Lee, D., Grant, A., Marsden, R., Orengo, C.: Identification and distribution of protein families in 120 completed genomes using Gene3D. Proteins (2004) (In Press)

    Google Scholar 

  22. McBrien, P., Poulovassilis, A.: A formalisation of semantic schema integration. Inf. Syst. 23(5), 307–334 (1998)

    Article  Google Scholar 

  23. 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)

    Chapter  Google Scholar 

  24. McBrien, P., Poulovassilis, A.: Data integration by bi-directional schema transformation rules. In: Proc. ICDE 2003, pp. 227–238 (2003)

    Google Scholar 

  25. OMG. Life Sciences Identifiers RFP response (2003), http://www.omg.org/cgi-bin/doc?lifesci/2003-12-02

  26. 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)

    Article  Google Scholar 

  27. 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)

    Google Scholar 

  28. 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)

    Chapter  Google Scholar 

  29. Zamboulis, L., Poulovassilis, A.: Using AutoMed for XML data transformation and integration. In: Proceedings of DIWeb 2004, June 2004. Springer, Heidelberg (2004)

    Google Scholar 

  30. Zdobnov, E.M., Lopez, R., Apweiler, R., Etzold, T.: The EBI SRS Server - recent developments. Bioinformatics 18(2), 368–373 (2002)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Biochemistry and Molecular Biology, University College London, Gower Street, London, WC1E 6BT

    Michael Maibaum & Christine Orengo

  2. School of Computer Science and Information Systems, Birkbeck College, University of London, London, WC1E 7HX

    Lucas Zamboulis, Galia Rimon, Nigel Martin & Alexandra Poulovassilis

Authors
  1. Michael Maibaum
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Lucas Zamboulis
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Galia Rimon
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Christine Orengo
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Nigel Martin
    View author publications

    You can also search for this author in PubMed Google Scholar

  6. Alexandra Poulovassilis
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science, University of California, Davis,  

    Bertram Ludäscher

  2. University of Maryland, College Park, 20742, MD, USA

    Louiqa Raschid

Rights and permissions

Reprints 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)

Publish with us

Policies and ethics

Search

Navigation