An Implementation for SQL Fuzzy Grouping
| dc.contributor.author | Aguilera Faraco, Ana Isabel | |
| dc.contributor.author | Goncalves Da Silva, Marlene | |
| dc.date.accessioned | 2022-11-30T02:46:09Z | |
| dc.date.available | 2022-11-30T02:46:09Z | |
| dc.date.issued | 2021 | |
| dc.description.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). | en_ES |
| dc.facultad | Facultad de Ingeniería | en_ES |
| dc.file.name | Aguilera_Imp2021.pdf | |
| dc.identifier.citation | Aguilera-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.doi | https://doi.org/10.22209/rt.v44n1a05 | |
| dc.identifier.uri | http://repositoriobibliotecas.uv.cl/handle/uvscl/7205 | |
| dc.language | en | |
| dc.publisher | Universidad De Zulia | |
| dc.source | Revista Técnica de la Facultad de Ingeniería | |
| dc.subject | FUZZY GROUP BY | en_ES |
| dc.subject | POSTGRESQLF | en_ES |
| dc.subject | ARQUITECTURA FUERTEMENTE ACOPLADA / FUZZY GROUP BY, TIGHT COUPLED ARCHITECTURE | en_ES |
| dc.title | An Implementation for SQL Fuzzy Grouping | |
| dc.type | Articulo | |
| uv.departamento | Escuela de Ingenieria Informatica |
Archivos
Bloque original
1 - 1 de 1
No hay miniatura disponible
- Nombre:
- Aguilera_Imp2021.pdf
- Tamaño:
- 3.14 MB
- Formato:
- Adobe Portable Document Format