Bridging Database Applications and Declarative Similarity Matching

Authors

  • Leonardo Andrade Ribeiro Universidade Federal de Goiás
  • Natália Cristina Schneider Universidade Federal de Lavras
  • Andrei de Souza Inácio Universidade Federal de Santa Catarina
  • Harley Michel Wagner Universidade Federal de Santa Catarina
  • Aldo von Wangenheim Universidade Federal de Santa Catarina

DOI:

https://doi.org/10.5753/jidm.2016.1592

Keywords:

advanced query processing, architectural patterns, object persistence, similarity matching, string databases

Abstract

Effective manipulation of string data is of fundamental importance to modern database applications. Very often, textual inconsistencies render equality comparisons meaningless and strings have to be matched in terms of their similarity. Previous work has proposed techniques to express similarity operations using declarative SQL statements. However, the non-trivial issue of embedding similarity support into object-oriented applications has received little attention. Particularly, declarative similarity matching requires maintenance of a number of auxiliary tables for each combination of similarity function and string attribute in query predicates. As a result, persistence of application objects is severely complicated, thereby leading to excessively intricate and hardly reusable application code. In this article, we present SimDataMapper, an architectural pattern to provide easy, efficient, and flexible integration of declarative similarity matching with applications and programming environments. We describe implementation details and experimentally evaluate the performance of our approach.

Downloads

Download data is not yet available.

Downloads

Published

2017-03-21

How to Cite

Andrade Ribeiro, L., Schneider, N. C., de Souza Inácio, A., Wagner, H. M., & von Wangenheim, A. (2017). Bridging Database Applications and Declarative Similarity Matching. Journal of Information and Data Management, 7(3), 217. https://doi.org/10.5753/jidm.2016.1592

Issue

Section

SBBD 2015