Title :
On a fuzzy group-by clause in SQLf
Author :
Bosc, Patrick ; Pivert, Olivier
Author_Institution :
ENSSAT, IRISA, Lannion, France
Abstract :
Group-by is a core database operation that is used extensively in data analysis and decision support systems. In many application scenarios, it appears useful to group values according to their compliance with a certain concept instead of founding the grouping on value equality. In this paper, we propose a new SQLf construct that supports fuzzy-partition-based group-by (FGB). We show that FGB can be used to generate fuzzy summaries as well as to mine fuzzy association rules in a practical and efficient way.
Keywords :
SQL; data mining; database management systems; decision support systems; fuzzy set theory; SQLf; clause; core database operation; data analysis; decision support systems; fuzzy association rules; fuzzy group-by; Aggregates; Association rules; Clustering algorithms; Databases; Fuzzy sets; Pragmatics;
Conference_Titel :
Fuzzy Systems (FUZZ), 2010 IEEE International Conference on
Conference_Location :
Barcelona
Print_ISBN :
978-1-4244-6919-2
DOI :
10.1109/FUZZY.2010.5584604
