An Implementation for SQL Fuzzy Grouping

Vista sencilla de ítem
dc.contributor.authorAguilera Faraco, Ana Isabel
dc.contributor.authorGoncalves Da Silva, Marlene
dc.date.accessioned2022-11-30T02:46:09Z
dc.date.available2022-11-30T02:46:09Z
dc.date.issued2021
dc.description.abstractRelational 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).en_ES
dc.facultadFacultad de Ingenieríaen_ES
dc.file.nameAguilera_Imp2021.pdf
dc.identifier.citationAguilera-Faraco, A. I. y Goncalves-Da Silva, M. (2020) «Una Implementación para el Agrupamiento Difuso en SQL », Revista Técnica de la Facultad de Ingeniería. Universidad del Zulia, 44(1), pp. 36-43. Disponible en: https://produccioncientificaluz.org/index.php/tecnica/article/view/34822 (Accedido: 21noviembre2022).en_ES
dc.identifier.doihttps://doi.org/10.22209/rt.v44n1a05
dc.identifier.urihttp://repositoriobibliotecas.uv.cl/handle/uvscl/7205
dc.languageen
dc.publisherUniversidad De Zulia
dc.sourceRevista Técnica de la Facultad de Ingeniería
dc.subjectFUZZY GROUP BYen_ES
dc.subjectPOSTGRESQLFen_ES
dc.subjectARQUITECTURA FUERTEMENTE ACOPLADA / FUZZY GROUP BY, TIGHT COUPLED ARCHITECTUREen_ES
dc.titleAn Implementation for SQL Fuzzy Grouping
dc.typeArticulo
uv.departamentoEscuela de Ingenieria Informatica

Archivos

Bloque original
Mostrando 1 - 1 de 1
Miniatura
Nombre:
Aguilera_Imp2021.pdf
Tamaño:
3.14 MB
Formato:
Adobe Portable Document Format
Descargar

Colecciones

Artículos investigadores UV