Definition
Data’s organization is referred to as a schema. When multiple sources of data must be combined to retrieve information that is not contained entirely in either one, typically they do not have the same schemas. For example, database A’s schema may store information about roads as “roads” and database B’s schema may use “streets” for roads. In order for information from database A and database B to be integrated, they must resolve the fact that the same information is stored in different schemas; this is referred to as semantic schema heterogeneity. To resolve semantic schema heterogeneity, there must be some mechanism to allow queries to be asked over multiple schemas. This involves (1) creating a database schema that is the integration of the original schemas (i.e., performing database schema integration), (2) creating a schema mappingbetween the original schemas (a...
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 subscriptionsReferences
Batini C, Lenzerini M, Navathe SB (1986) A comparative analysis of methodologies for database schema integration. ACM Comput Surv 18:323–364
Bernstein PA, Giunchiglia F, Kementsietsidis A, Mylopoulos J, Serafini L, Zaihrayeu I (2002) Data management for peer-to-peer computing: a vision. In: International workshop on the web and databases (WebDB), Madison, 6–7 June 2002
Buneman P, Davidson SB, Kosky A (1992) Theoretical aspects of schema merging. In: International conference on extending database technology (EDBT), Vienna, 23–27 Mar 1992
Calvanese D, Giacomo GD, Lenzerini M, Nardi D (1998) Rosati: schema and data integration methodology for DWQ. Technical report, DWQ Consortium. TR# DWQ-UNIROMA-004, Sept 1998, Università di Roma “La Sapienza”
Dhamankar R, Lee Y, Doan A, Halevy AY, Domingos P (2004) iMAP: discovering complex mappings between database schemas. In: Proceedings of the ACM SIGMOD international conference on management of data (SIGMOD), Paris, 13–18 June 2004
Doan A, Domingos P, Halevy A (2001) Reconciling schemas of disparate data sources: a machine learning approach. In: Proceedings of the ACM SIGMOD international conference on management of data (SIGMOD), Santa Barbara, 21–24 May 2001
Fagin R, Kolatis PG, Popa L, Tan WC (2004) Composing schema mappings: second-order dependencies to the rescue. In: Symposium on principles of database systems (PODS), Paris, 14–16 June 2004
Gray J, Chaudhuri S, Bosworth A, Layman A, Reichart D, Venkatrao M, Pellow F, Pirahesh H (1997) Data cube: a relational aggregation operator generalizing group-by, cross-tab, and sub totals. Data Min Knowl Disc 1:29–53
Halevy AY, Ives ZG, Suciu D, Tatarinov I (2003) Piazza: data management infrastructure for semantic web applications. In: Proceedings of the international conference on data engineering (ICDE), Bangalore, 5–8 Mar 2003
Madhavan J, Halevy AY (2003) Composing mappings among data sources. In: Proceedings of the very large data bases conference (VLDB), Berlin, 9–12 Sept 2003
Madhavan J, Halevy AY, Cohen S, Dong XL, Jeffrey SR, Ko D, Yu C (2006) Structured data meets the web: a few observations. IEEE Data Eng Bull 29: 19–26
Melnik S, GarciaMolina H, Rahm E (2002) Similarity flooding: a versitile graph matching algorithm and its application to schema matching. In: Proceedings of the international conference on data engineering, Madison, 3–6 June 2002
Melnik S, Rahm E, Bernstein PA (2003) Rondo: a programming platform for generic model management. In: Proceedings of the ACM SIGMOD international conference on management of data (SIGMOD), San Diego, 9–12 June 2003
Miller RJ, Haas LM, Hernández MA (2000) Schema mapping as query discovery. In: Proceedings of the very large data bases conference (VLDB), Cairo, 10–14 Sept 2000
Mitchell TM (1997) Machine learning, 1st edn. McGraw-Hill, New York
Pottinger RA, Bernstein PA (2000) Merging models based on given correspondences. In: Proceedings of the very large data bases conference (VLDB), Cairo, 10–14 Sept 2000
Rahm E, Bernstein PA (2001) A survey of approaches to automatic schema matching. VLDB J 10: 334–350
Shu NC, Housel BC, Lum VY (1975) CONVERT: a high level translation definition language for data conversion. Commun ACM 18:557–567
Ullman JD (1997) Information integration using logical views. In: Proceedings of the international conference on database theory (ICDT), Delphi, 8–10 Jan 1997
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2017 Springer International Publishing AG
About this entry
Cite this entry
Pottinger, R. (2017). Database Schema Integration. In: Shekhar, S., Xiong, H., Zhou, X. (eds) Encyclopedia of GIS. Springer, Cham. https://doi.org/10.1007/978-3-319-17885-1_259
Download citation
DOI: https://doi.org/10.1007/978-3-319-17885-1_259
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-17884-4
Online ISBN: 978-3-319-17885-1
eBook Packages: Computer ScienceReference Module Computer Science and Engineering