Efficient Semantically Equal Join on Strings.

In this paper, we address a data-level data integration problem where the compared data is semantically equivalent but the data native representation of the values of given attributes is different. We assume that a semantic relationship between potentially used terms is established by a human expert prior to the designed computations, and is represented in an auxiliary table built and maintained for each attribute. We introduce a notion of semantically equal join (SEJ), which is the join operation based on pre-defined semantic relationship. Our goal is to propose a solution for SEJ that can be supported by a standard SQL. [ABSTRACT FROM AUTHOR]