Standard SQL Approaches for Similarity Searching

@article{Siqueira2018StandardSA,
  title={Standard SQL Approaches for Similarity Searching},
  author={Pedro Henrique Braga Siqueira and Paulo Henrique Oliveira and Marcos Vinicius Naves Bedo and Daniel dos Santos Kaster},
  journal={2018 XLIV Latin American Computer Conference (CLEI)},
  year={2018},
  pages={472-481}
}
This paper addresses complex data storage and retrieval in RDBMS, which depends on metric distance functions for the assessment of data dissimilarity. However, both the empirical analysis of strategies for complex data storage and the definition of a suitable representation for similarity query operators are still open issues in the literature. Here, we fulfill those gaps through the classification, implementation, and evaluation of existing approaches for complex data storage according to four… CONTINUE READING

Figures, Tables, Results, and Topics from this paper.

Key Quantitative Results

  • Por exemplo, a recuperação de dados complexos no modelo relacional necessitou de, no máximo, 3%, 11% e 9% do tempo gasto pelo competidor XML OR considerando as funções L1, L2 e Mahalanobis, respectivamente.
  • Na comparação com o armazenamento relacional (2o colocado), o VArray gastou apenas 68% e 54% do tempo para inserir vetores de caracterı́sticas de 12 e 282 dimensões, respectivamente.

References

Publications referenced by this paper.
SHOWING 1-10 OF 26 REFERENCES

MSQL: efficient similarity search in metric spaces using SQL

  • The VLDB Journal
  • 2017
VIEW 8 EXCERPTS
HIGHLY INFLUENTIAL

Preserving Location Privacy in Geosocial Applications

  • IEEE Transactions on Mobile Computing
  • 2014
VIEW 1 EXCERPT