Fuzzy Aggregation Queries in Relational Databases

Xiao Ling Ye; Hui Wang; Yi Fei Chen

doi:10.4028/www.scientific.net/AMM.40-41.195

Paper Titles

Mathematical Modelling for the Quality Evaluation of Baikal Skullcap Root
p.167

Research on Fuzzy Clustering Validity
p.174

Particle Swarm Optimization Based GM(1,1) Method on Short-Term Electricity Price Forecasting with Predicted Error Improvement
p.183

An Exact Algorithm for 3-Biclique Vertex Partition
p.189

Fuzzy Aggregation Queries in Relational Databases
p.195

A Particle Swarm Optimization Based on Dynamic Parameter Modification
p.201

Optimization of T-Tree Index of Main Memory Database in Critical Application
p.206

Sensitivity Analysis of the Quality Evaluation System for Baikal Skullcap Root
p.212

Research on the Metadata Storage Mode and Efficiency of Distributed File System Based on HGML
p.221

HomeApplied Mechanics and MaterialsApplied Mechanics and Materials Vols. 40-41Fuzzy Aggregation Queries in Relational Databases

Fuzzy Aggregation Queries in Relational Databases

Abstract:

Much of the existing work on fuzzy queries in relational databases has focused on simple queries, compound queries, multi-relational queries, sub-queries with weights etc. What has received less attention, however, is the fuzzy aggregation querying. In this paper, this kind of fuzzy queries is dealt with. The general forms of fuzzy aggregation queries are presented and the corresponding algorithms are also proposed. Weights are introduced into fuzzy aggregation queries. The calculations of these queries are illustrated by examples in detail.

You might also be interested in these eBooks

View Preview

Info:

Periodical:

Applied Mechanics and Materials (Volumes 40-41)

Pages:

195-200

DOI:

https://doi.org/10.4028/www.scientific.net/AMM.40-41.195

Citation:

Cite this paper

Online since:

November 2010

Authors:

Xiao Ling Ye, Hui Wang, Yi Fei Chen

Keywords:

Fuzzy Aggregation, Fuzzy Logic Conjunction, Relational Database, Weight

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] L.A. Zadeh，Fuzzy Sets [J]，Information and Control，1965. 8：338-353.

Google Scholar

[2] Patrick Bosc, Olivier Pivert. SQLf：A relational Database Language for Fuzzy Querying. IEEE Transactions on Fuzzy Systems . 1995, Vol. 3, No. 1: pp.1-17.

DOI: 10.1109/91.366566

Google Scholar

[3] Goncalves, M. Tineo, L. SQLf flexible querying language extension by means of the norm SQL2. 2001, IEEE International Fuzzy Systems Conference, Melbourne, Vic., Australia, 2001: pp.473-476.

DOI: 10.1109/fuzz.2001.1007351

Google Scholar

[4] Goncalves, M. Tineo, L SQLf3: an extension of SQLf with SQL3 features. 2001, IEEE International Fuzzy Systems Conference, Melbourne, Vic., Australia, 2001: pp.477-480.

DOI: 10.1109/fuzz.2001.1007352

Google Scholar

[5] Patrick Bosc, L. Lietard, Olivier Pivert. Quantified statements in a flexible relational query language Proceedings of the 1995 ACM symposium on Applied computing. Nashville, Tennessee, United States 1995: p.488 – 492.

DOI: 10.1145/315891.316073

Google Scholar

[6] Miguel Delgado, Daniel Sánchez, Maria Amparo Vila. Fuzzy cardinality based evaluation of quantified sentences. International Journal of Approximate Reasoning. 2000, 23(1): pp.23-66.

DOI: 10.1016/s0888-613x(99)00031-6

Google Scholar

[7] Chen Yifei, Zhang Yingchao, Ye Xiao-lin. Extended Fuzzy Grouping Queries in Relational Databases and the derivation rules, Computer Applications. 2008, 28(5): pp.1178-1179, 1193.

DOI: 10.3724/sp.j.1087.2008.01177

Google Scholar

[8] Zhang Yingchao, Chen Yifei, Ye Xiaoling, Zheng Jieliang. Weighted Fuzzy Queries in Relational Database, Lecture Notes in Artificial Intelligence . 2005, vol. 3614 : pp.430-440.

Google Scholar

[9] Ying-chao Zhang，Wang Hui，Xiao-ling Ye. Fuzzy Queries with Weights in SQL Based on Fuzzy Logic Conjunctions， Lecture Notes in GCIS2009, 2009. 5.

DOI: 10.1109/gcis.2009.337

Google Scholar