Efficient semantically equal join on strings

Authors:
Juggapong Natwichai;Xingzhi Sun;Maria E. Orlowska
Affiliations:
School of Information Technology and Electrical Engineering, The University of Queensland, Brisbane, Australia;School of Information Technology and Electrical Engineering, The University of Queensland, Brisbane, Australia;School of Information Technology and Electrical Engineering, The University of Queensland, Brisbane, Australia
Venue:
DASFAA'07 Proceedings of the 12th international conference on Database systems for advanced applications
Year:
2007

Citing 2
Cited 0

Approximate String Joins in a Database (Almost) for Free

Proceedings of the 27th International Conference on Very Large Data Bases
A survey of approaches to automatic schema matching

The VLDB Journal — The International Journal on Very Large Data Bases

Quantified Score

Hi-index	0.00

Visualization

Abstract

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.