TABLE 1 Summary of the Four Semantic Heterogeneity Types
Semantic Heterogeneity Type	Automatic Detection During:		How to Handle in Action to Prevent or to Help Detection	Manual Script Modifications
	Schema Comparison	Data Comparison
Naming Conflict	Detected, but not handled	NA	Use sensible names	Renaming in conversion scripts
Domain Conflict	Partially detected, but not handled	Partially detected	Use subtypes and check constraints Proof read synchronization scripts and contrast with the documentation	Conversion functions if possible
Metadata Conflict	Detected, but not handled	NA	Can only be prevented at global levels Use of standards	Complex conversion in scripts, that possibly split rows, handle multiple tables, etc.
Structural Conflict	Partially detected, but not handled	NA		Conversion functions if possible