A Metadata Integration Assistant Generator for Heterogeneous Distributed Databases

  • Young-Kwang Nam
  • Joseph Goguen
  • Guilian Wang
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2519)


This paper describes a metadata interchange approach for semi-automated integration of heterogeneous distributed databases. Our system prototype uses distributed metadata to generate a GUI tool for a meta-user (who does the metadata integration) to describe mappings between master and source databases by assigning index number and specifying conversion function names; the system uses Quilt as its XML query language. The queries for the local databases being transparent for users are generated, which is based on the metadata built semi-automatically. An experiment testing feasibility is reportedin which 3 different publishers’ databases are integrated.


Resource Description Framework Description Logic Index Number Local Database Local Query 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    C. Baru, A. Gupta, B. Ludascher, R. Marciano, Y. Papakonstantinou, P. Velikhov, V. Chu. XML-BasedInformation Mediation with MIX. Exhibition program, ACM Conf. on Management of Data, SIGMOD’99, Philadelphia, 1999.Google Scholar
  2. 2.
    D. Brickley, R. Guha, eds. Resource Description Framework (RDF) Schema Specification. W3C Proposed Recommendation. March 1999.
  3. 3.
    K. Beard, T. Smith. A framework for meta-information in digital libraries. In Sheth A, Klas W (eds) Multimedia Data Management: Using Metadata to Integrate and Apply Digital Media. McGraw Hill: 341–365. 1998.Google Scholar
  4. 4.
    V. K. Chaudhri, A. Farquhar, et al. OKBC: Open Knowledge Base Connectivity 2.0. Technical report KSL-98-06, Knowledge System Laboratory, Stanford, July 1997.Google Scholar
  5. 5.
    Online Computer Library Center, Inc 1997 Dublin Core Metadata Element Set: Reference Description. 1997. Office of Research and Special Projects, Dublin, Ohio.
  6. 6.
    D. Calvanese, G. Giacomo, and M. Lenzerini. Ontology of Integration and Integration of Ontologies. Proc. of the 2001 Description Logic Workshop (DL 2001). 2001.Google Scholar
  7. 7.
    D. Calvanese, G. Giacomo, M. Lenzerini, D. Nardi, R. Rosati. Description Logic Framework for Information Integration. In Proc. of Principles of Knowledge Representation andReasoning (KR’98), pages 2–13, 1998.Google Scholar
  8. 8.
    S. Cluet, P. Veltri and D. Vodislav. Views in a Large Scale XML Repository. 27th International Conference on Very Large Data Bases (VLDB 2001), Roma, Italy, 2001.Google Scholar
  9. 9.
    D. Chamberlin, J. Robie and D. Florescu. Quilt: An XML Query Language for Heterogeneous Data Sources. Proceedings of WebDB 2000 Conference, in Lecture Notes in Computer Science, Springer-Verlag, 2000.Google Scholar
  10. 11.
    A. Farquhar, R. Fikes and J. Rice. The Ontiliqua Server: A Tool for Collaborative Ontology Construction. International Journal of Human-Computer Studies, 46:707–728, 1997.CrossRefGoogle Scholar
  11. 12.
    A. Gupta, B. Ludascher, M. E. Martone. Knowledge-Based Integration of Neuroscience Data Sources, 12th Intl. Conference on Scientific andStatistical Database Management (SSDBM), Berlin, Germany, IEEE Computer Society, July, 2000.Google Scholar
  12. 13.
    O. Gunther, A. Voisard. Metadata in geographic and environmental data management. In Sheth A, Klas W (eds) Multimedia Data Management: Using Metadata to Integrate andApply Digital Media. McGraw Hill: 57–87. 19Google Scholar
  13. 14.
    L. M. Haas, R. J. Miller, B. Niswonger, M. Tork Roth, P. M. Schwarz and E. L. Wimmers. Transforming Heterogeneous Data with Database Middleware: Beyond Integration. Bulletin of IEEE Computer Society Technical Committee on Data Engineering. 1999.Google Scholar
  14. 17.
    B. Ludascher, A. Gupta, M. E. Martone. Model-Based Mediation with Domain Maps. 17th Intl. Conference on Data Engineering (ICDE), Heidelberg, Germany, IEEE Computer Society, April 2001.Google Scholar
  15. 18.
    B. Ludascher, R. Himmeroder, G. Lausen, W. May, and C. Schlepphorst. Managing SemistructuredData with FLORID: A Deductive Object-Oriented Perspective. Information Systems, 23(8):589–613, 1998.CrossRefGoogle Scholar
  16. 19.
    A. Y. Levy, A. Rajaraman, J. J. Ordille: Querying Heterogeneous Information Sources Using Source Descriptions. In Proc. of VLDB. pp. 251–262, Bombay, India, 1996.Google Scholar
  17. 20.
    R. J. Miller, L. M. Haas and M. A. Hernandez. Schema Mapping as Query Discovery. Proceedings of the 26th VLDB Conference. Cairo Egypt, 2000.Google Scholar
  18. 21.
    R. J. Miller. Using Schematically Heterogeneous Structures. SIGMOD’ 98 Seattle WA, USA. ACM 0-89791-995-5. 1998.Google Scholar
  19. 22.
    Y. Papakonstantinou, H. Garcia-Molina, J. Ullman. MedMaker: A Mediation System Basedon Declarative Specifications. Data Engineering (ICDE). 1996.Google Scholar
  20. 23.
    C. Parent and S. Spaccapietra. Issues andApproac hes of Database Integration. Communications of the ACM, 41(5):166–178, 1998.CrossRefGoogle Scholar
  21. 24.
    O. Reichman, J. Brunt, J. Helly, M. Jones, M. Willig. A Knowledge Network for Biocomplexity: Building and Evaluating a Metadata-based Framework for Integrating Heterogeneous Scientific Data.
  22. 25.
    A. P. Sheth. Changing focus on interoperability in information systems: from system, syntax, structure to semantics. In M F Good child, M J Egenhofer, R Fegeas and C A Kottman (eds), Interoperating Geographic Information Systems. Kluwer. 1998.Google Scholar
  23. 26.
    J. D. Ullman. Information Integration Using Logical Views 6th Int. Conference on Database Theory, LNCS 1186, 1997.Google Scholar
  24. 27.
    G. Wiederhold. Mediators in the Architecture of Future Information System. IEEE Computer 25:3, pp. 38–49, 1992.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2002

Authors and Affiliations

  • Young-Kwang Nam
    • 1
  • Joseph Goguen
    • 2
  • Guilian Wang
    • 2
  1. 1.Dept. of Computer ScienceYonsei UniversityWonjooRepublic of Korea
  2. 2.Dept. of Computer Science andEngineeringUCSDLa Jolla

Personalised recommendations