Querying complex objects by similarity in SQL.
Maria Camila N. Barioni, Humberto Razente, Caetano Traina, Agma J. M. Traina · 2005
Similarity search has received large attention on modern database applications involving complex objects, since the queries executed in such databases are seldom based on exact matches but rather on some specific notion of similarity. However, the SQL query language does not provide effective support for similarity queries. This paper proposes the addition of similarity queries to SQL, including a new set of similarity operators in order to search complex objects stored as sets of attributes in a relation. It also describes a prototype developed to validate and illustrate the concepts and syntax presented.