Advanced search
Start date
Betweenand


The SIMILARQL framework: similarity queries in plain SQL

Full text
Author(s):
Traina, Caetano, Jr. ; Moriyama, Andre ; Rocha, Guilherme ; Cordeiro, Robson ; Ciferri, Cristina D. A. ; Traina, Agma ; Assoc Comp Machinery
Total Authors: 7
Document type: Journal article
Source: SAC '19: PROCEEDINGS OF THE 34TH ACM/SIGAPP SYMPOSIUM ON APPLIED COMPUTING; v. N/A, p. 4-pg., 2019-01-01.
Abstract

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)

FAPESP's process: 18/05714-5 - Mining Frequent Data Streams of High Dimensionality with a Case Study in Digital Games
Grantee:Robson Leonardo Ferreira Cordeiro
Support Opportunities: Regular Research Grants
FAPESP's process: 16/17078-0 - Mining, indexing and visualizing Big Data in clinical decision support systems (MIVisBD)
Grantee:Agma Juci Machado Traina
Support Opportunities: Research Projects - Thematic Grants
FAPESP's process: 18/22277-8 - Processing of OLAP and SOLAP Queries on Parallel and Distributed Environments
Grantee:Cristina Dutra de Aguiar
Support Opportunities: Regular Research Grants