The SIMILARQL framework: similarity queries in plain SQL

Autor(es)

Traina, Caetano, Jr. ; Moriyama, Andre ; Rocha, Guilherme ; Cordeiro, Robson ; Ciferri, Cristina D. A. ; Traina, Agma ; Assoc Comp Machinery

• Tipo de documento: Artigo Científico
• Fonte: SAC '19: PROCEEDINGS OF THE 34TH ACM/SIGAPP SYMPOSIUM ON APPLIED COMPUTING; v. N/A, p. 4-pg., 2019-01-01.

Resumo

As the variety and complexity of collected data increases, also does the need to analyze them by similarity. However, current Database Management Systems (DBMS) do not provide effective support for similarity queries, and the research on the subject has, until now, provided only a limited support through tools that are not simple to be deployed nor maintained. Thus, what to do if you need to perform a quick exploratory analysis over your data, and must do it 'now'? In this paper we show how to use the readily available support from standard DBMS to target this issue, and present the simple, yet powerful SimilarQL framework, which provides a complete and flexible set of similarity query operators. It can be readily deployed over conventional DBMS, without depending on the bulk data structures and software systems required to handle long term standing similarity queries. We present results from a real world dataset regarding the query execution times using SimilarQL, and show that acceptable runtimes may be achieved, while intuitively and easily exploring complex data by similarity. (AU)

• Processo FAPESP: 18/05714-5 - Mineração de Fluxos de Dados Frequentes e de Alta Dimensionalidade: estudo de caso em jogos digitais
• Beneficiário: Robson Leonardo Ferreira Cordeiro
• Modalidade de apoio: Auxílio à Pesquisa - Regular
• Processo FAPESP: 16/17078-0 - Mineração, indexação e visualização de Big Data no contexto de sistemas de apoio à decisão clínica (MIVisBD)
• Beneficiário: Agma Juci Machado Traina
• Modalidade de apoio: Auxílio à Pesquisa - Temático
• Processo FAPESP: 18/22277-8 - Processamento de Consultas OLAP e SOLAP em Ambientes Computacionais Paralelos e Distribuídos
• Beneficiário: Cristina Dutra de Aguiar
• Modalidade de apoio: Auxílio à Pesquisa - Regular