Schema Matching

The terms schema matching and mapping are often used interchangeably. For this article, we differentiate the two as follows: Schema matching is the process of identifying that two objects are semantically related (scope of this article) while mapping refers to the transformations between the objects. For example, in the two schemas DB1.Student (Name, SSN, Level, Major, Marks) and DB2.Grad-Student (Name, ID, Major, Grades); possible matches would be: DB1.Student ≈ DB2.Grad-Student; DB1.SSN = DB2.ID etc. and possible transformations or mappings would be: DB1.Marks to DB2.Grades (100-90 A; 90-80 B: etc.).

Automating these two approaches has been one of the fundamental tasks of data integration. In general it is not possible to determine fully automatically the different correspondences between two schemas, primarily because of the differing and often not explicated or documented semantics of the two schemas.

Read more about Schema MatchingImpediments To Schema Matching, See Also

Other articles related to "schema matching, matching, schemas, schema":

Federated Database System - FDBS Architecture - Distribution - Schema Matching, Schema Mapping
... In systems that are not planned top-down, a generic problem lies in matching semantically equivalent, but differently named parts from different schemas (=data models) (tables ... A common way out is to provide a global schema that comprises the relevant parts of all member schemas and provide mappings in the form of database views ... on the direction of the mapping Global as View (GaV) the global schema is defined in terms of the underlying schemas Local as View (LaV) the local schemas are defined in terms of the ...
Schema Matching - See Also
... Data Integration Dataspaces Ontology alignment Minimal Mappings Federated database system Schema crosswalk. ...