startthat.work home

IS-02 Schema matching and ontology matching (schema mapping; field mapping)

Establishes which fields or concepts in different sources mean the same thing and produces a mapping table of equivalent, partly equivalent and unmapped fields.

Integrate across sourcesEvidence: DocumentedPreparation technique, runs in step 5.2Strongest statement: describe

What it does

Establishes which fields or concepts in different sources mean the same thing. Artefact: a mapping table. Read which fields are equivalent, partly equivalent or unmapped.

When to use it

Use when you hold datasets from different sources that describe the same domain and need to know which columns correspond.

When it does not fit

Fits sources that describe the same domain. Misfit: similar names with different meanings.

Result format

The result is a mapping table with one row per field or concept, giving the matching field in each source and whether the match is equivalent, partly equivalent or unmapped. It lists the unmapped fields.

Requirements on the material

PropertyRequirement typeRequirement
StructureApplies in some casesrequires=structured; requires=semi-structured
Content typeAlways appliesrequires=tabular
Unit of analysisAlways appliesrequires=variable; requires=dataset
Level of detail availableAlways appliesrequires=aggregate tables
Number of sourcesAlways appliesrequires=two or more
Appraises source credibilityApplies in some casesno

Not restricted on: Variable types, Time structure, How the sample was chosen, Whether sources can be joined, Amount of material, Known data problems, Producer interest, Source dependence, Origin, Document genre, Language, Personal information, Security classification, Licence.

Minimum materialnone
Additional sources neededreference structure
Not for (rules)none
Not for (text)Fields have similar names but different meanings, or definitions are not documented.

Choosing and ordering

Kind of techniquePreparation technique, runs in step 5.2
Phase tagverify and prepare
Other phase tagsnone
Kind of findinggap; difference
Question answeredwhat
Strongest statement it supportsdescribe
Needs as input
Makes as output
Must exist firstNone
Loop targetproceed with limit stated

Library checks by stakes

Each stakes level includes the checks of the level below it. Checks that need a person apply at high stakes only, so the process leaves them out at lower stakes (decision 38). Repeatability: repeatable with fixed settings.

StakesCheckPerson involvedCounts as a different method
exploratoryspot checkoptionalno
decision-informingspot checkoptionalno
decision-informingrepeat runsnoneno
decision-informinghuman review sampleneeded; left out below high stakesno
high-stakesspot checkoptionalno
high-stakesrepeat runsnoneno
high-stakeshuman review sampleneededno
high-stakessecond technique with different assumptionsnoneconditional
high-stakesindependent reviewneededno

Failure modes and limits

Model suitabilitymodel plus code
Typical model failureMaps fields by name similarity and ignores differences in units or definitions.
Error sourcesinput data; coder or rater judgement; data transformation
Certainty limitsCertainty drops when field definitions are undocumented and when mappings are only partly equivalent (indirectness).

Evidence and tag basis

Documented. The tutorial gives a definition only. An annual evaluation campaign for ontology matching exists, but its page did not state the output format. (Dong and Naumann, VLDB tutorial; Ontology matching evaluation campaign page)

Tag basis: input profile inference; selection inference; sequencing inference; robustness inference. All tag values are inference unless a source is named.