Synonyms
Resolving semantic schema heterogeneity; Schema mapping; Data warehousing; Peer data management
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...
This is a preview of subscription content, log in via an institution.
Recommended Reading
Shu, N.C., Housel, B.C., Lum, V.Y.: CONVERT: A high level translation definition language for data conversion. Commun. ACM 18, 557–567 (1975)
Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. VLDB J. 10, 334–350 (2001)
Doan, A., Domingos, P., Halevy, A.: Reconciling schemas of disparate data sources: a machine learning approach. In: Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD) 2001, May 21–24. Santa Barbara, CA
Mitchell, T.M.: Machine Learning, 1st edn. McGraw-Hill, New York: (1997)
Melnik, S., Garcia‐Molina, H., Rahm, E.: Similarity flooding: a versitile graph matching algorithm and its application to schema matching. In: Proceedings of the International Conference on Data Engineering 2002, June 3–6, Madison, WI
Miller, R.J., Haas, L.M., Hernández, M.A.: Schema mapping as query discovery. In: Proceedings of the Very Large Data Bases Conference (VLDB) 2000, Sept. 10–14, Cairo, Eqypt
Batini, C., Lenzerini, M., Navathe, S.B.: A comparative analysis of methodologies for database schema integration, ACM Comput. Surv. 18, 323–364 (1986)
Buneman, P., Davidson, S.B., Kosky, A.: Theoretical aspects of schema merging. In: International Conference on Extending Database Technology (EDBT) 1992, March 23–27, Vienna, Austria
Melnik, S., Rahm, E., Bernstein, P.A.: Rondo: A programming platform for generic model management. In: Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD) 2003, June 9–12, San Diego, CA
Pottinger, R.A., Bernstein, P.A.: Merging models based on given correspondences. In: Proceedings of the Very Large Data Bases Conference (VLDB) 2000, Sept. 10–14, Cairo, Egypt
Calvanese, D., Giacomo, G.D., Lenzerini, M., Nardi, D., Rosati: Schema and Data Integration Methodology for DWQ. Technical report, DWQ Consortium. TR# DWQ-UNIROMA-004, Sept. 1998, Università di Roma “La Sapienza” (1998)
Gray, J., Chaudhuri, S., Bosworth, A., Layman, A., Reichart, D., Venkatrao, M., Pellow, F., Pirahesh, H.: Data Cube: A relational aggregation operator generalizing group-by, cross-tab, and sub totals. Data Min. Knowl. Disc. 1, 29–53 (1997)
Ullman, J.D.: Information integration using logical views. In: Proceedings of the International Conference on Database Theory (ICDT) 1997, January 8–10, Delphi, Greece
Bernstein, P.A., Giunchiglia, F., Kementsietsidis, A., Mylopoulos, J., Serafini, L., Zaihrayeu, I.: Data management for peer-to-peer computing: a vision. In: International Workshop on the Web and Databases (WebDB) 2002, June 6–7, Madison, WI
Halevy, A.Y., Ives, Z.G., Suciu, D., Tatarinov, I.: Piazza: Data management infrastructure for semantic web applications. In: Proceedings of the International Conference on Data Engineering (ICDE) 2003, March 5–8, Bangalore, India
Fagin, R., Kolatis, P.G., Popa, L., Tan, W.C.: Composing schema mappings: second-order dependencies to the rescue: In: Symposium on Principles of Database Systems (PODS) 2004, June 14–16, Paris, France
Madhavan, J., Halevy, A.Y.: Composing mappings among data sources. In: Proceedings of the Very Large Data Bases Conference (VLDB) 2003, Sept. 9–12, Berlin, Germany
Dhamankar, R., Lee, Y., Doan, A., Halevy, A.Y., Domingos, P.: iMAP: discovering complex mappings between database schemas. In: Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD), 2004, June 13–18, Paris, France
Madhavan, J., Halevy, A.Y., Cohen, S., Dong, X.L., Jeffrey, S.R., Ko, D., Yu, C.: Structured data meets the web: a few observations. IEEE Data Eng. Bull. 29, 19–26 (2006)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2008 Springer-Verlag
About this entry
Cite this entry
Pottinger, R. (2008). Database Schema Integration. In: Shekhar, S., Xiong, H. (eds) Encyclopedia of GIS. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-35973-1_259
Download citation
DOI: https://doi.org/10.1007/978-0-387-35973-1_259
Publisher Name: Springer, Boston, MA
Print ISBN: 978-0-387-30858-6
Online ISBN: 978-0-387-35973-1
eBook Packages: Computer ScienceReference Module Computer Science and Engineering