An Implementation for SQL Fuzzy Grouping
Date
2021
item.contributor.advisor
item.page.type
Articulo
item.page.orcidurl
Journal Title
Journal ISSN
Volume Title
Publisher
Universidad De Zulia
item.page.ubicacion
item.page.isbn
item.page.issn
item.page.issne
item.page.doiurl
item.page.dc.facultad
Facultad de Ingeniería
item.page.uv.departamento
Escuela de Ingenieria Informatica
item.page.uv.especie.determinador
item.page.uv.especie.recolector
item.page.uv.especie
item.page.uv.notageneral
Abstract
Relational DataBasemanagement systems (DBMS) have a great utility in the efficient storage of large data volumes. Also, some DBMS extensions based on fuzzy logic have been proposed to improve the expressiveness of query languages. Among which SQLf is an extension of SQL that supports fuzzy conditions. Separately, the Group-By is a database operator widely used in data analysis and decision support systems. In many cases, it seems useful to group values according to their similarity to a certain concept rather than establishing grouping on the basis of equal values. In this context, a new SQLf structure called Fuzzy Group By (FGB) has been proposed to support a grouping based on fuzzy partitions. In this work, we incorporated the fuzzy grouping in PostgreSQLf, which is an extension of the PostgreSQL DBMS for the handling of fuzzy queries using the SQLf language on the basis of a tight coupled architecture, i.e., directly into the DBMS. We have proposed an algorithm based on a hash to evaluate the FGB operator and also empirically assessed the performance of PostgreSQLf over the TPC BenchmarkTM -H (TPC-H).
Description
item.page.coverage.spatial
item.page.sponsorship
Keywords
FUZZY GROUP BY, POSTGRESQLF, ARQUITECTURA FUERTEMENTE ACOPLADA / FUZZY GROUP BY, TIGHT COUPLED ARCHITECTURE