Abstract
Mediator architectures have become popular for systems that aim at providing transparent access to heterogeneous information sources. Similar to a view on a database, a mediator answers queries posed against the common domain schema by executing one or more queries against its underlying information sources and mapping the results back into the common schema. The mapping is usually specified declaratively by a set of rules, where the rule heads define queries against a common domain schema and the rule bodies define their implementations in terms of queries against one or more source schemas. In this paper a mechanism is presented that supports finding these mappings, a task that requires a fair amount of knowledge about the underlying schemas and that involves a lot of effort, thus becoming a major obstacle to scalability.
The work described in this paper was done at the IPD, University of Karlsruhe, Germany
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
S. Abiteboul, D. Quass, J. McHugh, J. Widom, and J. Wiener. The Lorel Query Language for Semistructured Data. Digital Libraries, 1997.
C. Baru, A. Gupta, B. Ludäscher, R. Marciano, Y. Papakonstantinou, P. Velikhov, and V. Chu. XML-based Information Mediation with MIX. In Exhibitions Prog. of ACM Sigmod, Philadelphia, USA, 1999.
C. Batini, M. Lenzerini, and S. B. Navathe. A Comparative Analysis of Methodologies for Database Schema Integration. ACM Computing Surveys, 18(4):323–364, December 1986.
C. Beeri and T. Milo. Schemas for Integration and Translation of Structured and Semi-structured Data. In Proc. of ICDT, Jerusalem, Israel, 1999.
P. Buneman, S. Davidson, M. Fernandez, and D. Suciu. Adding Structure to Unstructured Data. In Proc. of ICDT, Delphi, Greece, 1997.
S. Chawathe, H. Garcia-Molina, J. Hammer, K. Ireland, Y. Papakonstantinou, J. Ullman, and J. Widom. The Tsimmis Project: Integration of Heterogeneous Information Sources. In Proc. of IPSJ, Tokyo, Japan, 1994.
K.-H. Cheung and D.-G. Shin. A Framework Designed to Represent Both Data and Meta-Data to Enhance Database Interoperability. In Proc. of the 3rd Biennial World Conf. on Integrated Design and Process Technologies — Issues and Applications of Database Technology, Berlin, Germany, 1998.
A. Deutsch, M. Fernandez, and D. Suciu. Storing Semistructured Data with STORED. In Proc. of ACM SIGMOD, Phildadelphia, USA, 1999.
P. Fankhauser and E. J. Neuhold. Knowledge Based Integration of Heterogeneous Databases. In D.K. Hsiao, E. J. Neuhold, and R. Sacks-Davis, eds., Interoperable Database Systems(DS-5), 1993.
M. Garcia-Solaco, M. Castellanos, and F. Saltor. Discovering Interdatabase Resemblance of Classes for Interoperable Databases. In Proc. of RIDE-IMS, 1993.
M. Garcia-Solaco, F. Saltor, and M. Castellanos. Object-Oriented Multidatabase-Systems (ed. Omran Bukhres and Ahmed Elmagarmid), chapter: Semantic Heterogeneity in Multidatabase Systems. Prentice Hall, 1996.
R. Goldman, J. McHugh, and J. Widom. From Semistructured Data to XML: Migrating the Lore Data Model and Query Language. In Proc. of the 2nd Intl.WebDB Workshop, Philadelphia, USA, 1999.
R. Goldman and J. Widom. Dataguides: Enabling Query Formulation and Optimization in Semistructured Databases. In Proc. of 23rd VLDB Conf., Athens, Greece, 1997.
W. Kim, I. Choi, S. Gala, and M. Scheevel. Modern Database Systems, chapter: On Resolving Schematic Heterogeneity in Multidatabase Systems, Addison Wesley, 1995.
W. Li and C. Clifton. Semantic Integration in Heterogeneous Databases Using Neural Networks. In Proc. of 20th VLDB Conf., Santiago, Chile, 1994.
G. Miller, R. Beckwith, C. Fellbaum, D. Gross, and K. Miller. Introduction to Wordnet: an On-Line Lexical Database. Intl. Journal of Lexicography, 3(4):235–244, 1990.
T. Milo and S. Zohar. Using Schema Matching to Simplify Heterogeneous Data Translation. In Proc. of 24th VLDB, New York City, USA, 1998.
S. Nahar, S. Sahni, and E. Shragowitz. Simulated Annealing and Combinatorial Optimization Alternatives. In Proc. of the 23rd Design Automation Conf., 1986.
S. Navathe, J. Larson and R. Elmasri. A Theory of Attribute Equivalence in Databases with Application to Schema Integration. IEEE Trans. on Software Engineering, 14(4), 1989.
S. Nestorov, S. Abiteboul, and R. Motwani. Inferring Structure in Semistructured Data. In Ws. on Management of Semistructured Data, Tucson, 1997.
Y. Papakonstantinou and P. Velikhov. Enhancing Semistructured Data Mediators with Document Type Definitions. In Proc. of ICDE, Sydney, Australia, 1999.
A. Swami. Optimization of Large Join Queries. In Proc. of the 1989 ACM-SIGMOD Conf., Portland, OR, 1989.
H. Wache. Towards Rule-Based Context Transformation in Mediators. In Proc. of EFIS, Kuehlungsborn, Germany, 1999.
G. Wiederhold. Mediators in the Architecture of Future Information Systems. IEEE Computer, p. 38–48, March 1992.
L. Yan, M. Özsu, and L. Liu. Accessing Heterogeneous Data Through Homogenization and Integration Mediators. In Proc. of CoopIS 97, Kiawah Island, USA, 1997.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2000 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
König-Ries, B. (2000). An Approach to the Semi-automatic Generation of Mediator Specifications. In: Zaniolo, C., Lockemann, P.C., Scholl, M.H., Grust, T. (eds) Advances in Database Technology — EDBT 2000. EDBT 2000. Lecture Notes in Computer Science, vol 1777. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-46439-5_7
Download citation
DOI: https://doi.org/10.1007/3-540-46439-5_7
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-67227-2
Online ISBN: 978-3-540-46439-6
eBook Packages: Springer Book Archive