• DocumentCode
    2311312
  • Title

    On a fuzzy group-by clause in SQLf

  • Author

    Bosc, Patrick ; Pivert, Olivier

  • Author_Institution
    ENSSAT, IRISA, Lannion, France
  • fYear
    2010
  • fDate
    18-23 July 2010
  • Firstpage
    1
  • Lastpage
    6
  • 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;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Fuzzy Systems (FUZZ), 2010 IEEE International Conference on
  • Conference_Location
    Barcelona
  • ISSN
    1098-7584
  • Print_ISBN
    978-1-4244-6919-2
  • Type

    conf

  • DOI
    10.1109/FUZZY.2010.5584604
  • Filename
    5584604