Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
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.
D. Brickley, R. Guha, eds. Resource Description Framework (RDF) Schema Specification. W3C Proposed Recommendation. March 1999. http://www.w3.org/1999/TR/PR-rdf-schema.
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.
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.
Online Computer Library Center, Inc 1997 Dublin Core Metadata Element Set: Reference Description. 1997. Office of Research and Special Projects, Dublin, Ohio. http://www.oclc.org:5046/research/dublin_core/
D. Calvanese, G. Giacomo, and M. Lenzerini. Ontology of Integration and Integration of Ontologies. Proc. of the 2001 Description Logic Workshop (DL 2001). 2001.
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.
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.
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.
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.
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.
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. 19
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.
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.
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.
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.
R. J. Miller, L. M. Haas and M. A. Hernandez. Schema Mapping as Query Discovery. Proceedings of the 26th VLDB Conference. Cairo Egypt, 2000.
R. J. Miller. Using Schematically Heterogeneous Structures. SIGMOD’ 98 Seattle WA, USA. ACM 0-89791-995-5. 1998.
Y. Papakonstantinou, H. Garcia-Molina, J. Ullman. MedMaker: A Mediation System Basedon Declarative Specifications. Data Engineering (ICDE). 1996.
C. Parent and S. Spaccapietra. Issues andApproac hes of Database Integration. Communications of the ACM, 41(5):166–178, 1998.
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. http://www.nceas.ucsb.edu/
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.
J. D. Ullman. Information Integration Using Logical Views 6th Int. Conference on Database Theory, LNCS 1186, 1997.
G. Wiederhold. Mediators in the Architecture of Future Information System. IEEE Computer 25:3, pp. 38–49, 1992.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Nam, YK., Goguen, J., Wang, G. (2002). A Metadata Integration Assistant Generator for Heterogeneous Distributed Databases. In: Meersman, R., Tari, Z. (eds) On the Move to Meaningful Internet Systems 2002: CoopIS, DOA, and ODBASE. OTM 2002. Lecture Notes in Computer Science, vol 2519. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-36124-3_84
Download citation
DOI: https://doi.org/10.1007/3-540-36124-3_84
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-00106-5
Online ISBN: 978-3-540-36124-4
eBook Packages: Springer Book Archive