research-article

Fuzzy query translation for relational database systems

Authors:

Shyi-Ming Chen,

Woei-Tzy JongAuthors Info & Claims

IEEE Transactions on Systems, Man, and Cybernetics, Part B: Cybernetics, Volume 27, Issue 4

Pages 714 - 721

https://doi.org/10.1109/3477.604117

Published: 01 August 1997 Publication History

Abstract

The paper presents a new method for fuzzy query translation based on the α-cuts operations of fuzzy numbers. This proposed method allows the retrieval conditions of SQL queries to be described by fuzzy terms represented by fuzzy numbers. It emphasizes friendliness and flexibility for inexperienced users. The authors have implemented a fuzzy query translator to translate user's fuzzy queries into precise queries for relational database systems. Because the proposed method allows the user to construct his fuzzy queries intuitively and to choose different retrieval threshold values for fuzzy query translation, the existing relational database systems will be more friendly and more flexible to the users

Cited By

View all

Yu YSun LWu QEmrouznejad AQian Z(2018)Fuzzy Query Model of the Business Resources Based on Cloud Service PlatformProceedings of the 2nd International Conference on Computer Science and Application Engineering10.1145/3207677.3278082(1-5)Online publication date: 22-Oct-2018
https://dl.acm.org/doi/10.1145/3207677.3278082
Liu JYan D(2016)Answering Approximate Queries Over XML DataIEEE Transactions on Fuzzy Systems10.1109/TFUZZ.2015.245316824:2(288-305)Online publication date: 1-Apr-2016
https://dl.acm.org/doi/10.1109/TFUZZ.2015.2453168
Xu CWang YGu YLin SYu G(2012)Efficient fuzzy ranking queries in uncertain databasesApplied Intelligence10.1007/s10489-011-0312-137:1(47-59)Online publication date: 1-Jul-2012
https://dl.acm.org/doi/10.1007/s10489-011-0312-1
Show More Cited By

Fuzzy query translation for relational database systems
1. Information systems
  1. Data management systems
2. Theory of computation
  1. Theory and algorithms for application domains
    1. Database theory

Recommendations

Generalization of strategies for fuzzy query translation in classical relational databases

Users of information systems would like to express flexible queries over the data possibly retrieving imperfect items when the perfect ones, which exactly match the selection conditions, are not available. Most commercial DBMSs are still based on the ...
Database Skeleton and Its Application to Fuzzy Query Translation

This paper treats the problem of fuzzy query translation using the concept of database skeleton. An imprecise, or fuzzy, query is represented by a query graph, which can be analyzed for translatability with respect to a given database skeleton. The ...
Fuzzy Database Query Languages and Their Relational Completeness Theorem

Two fuzzy database query languages are proposed. They are used to query fuzzy databases that are enhanced from relational databases in such a way that fuzzy sets are allowed in both attribute values and truth values. A fuzzy calculus query language is ...

Comments

Information & Contributors

Information

Published In

cover image IEEE Transactions on Systems, Man, and Cybernetics, Part B: Cybernetics

IEEE Transactions on Systems, Man, and Cybernetics, Part B: Cybernetics Volume 27, Issue 4

August 1997

179 pages

ISSN:1083-4419

Issue’s Table of Contents

Publisher

IEEE Press

Publication History

Published: 01 August 1997

Qualifiers

Research-article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

13
Total Citations
View Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 20 Feb 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Yu YSun LWu QEmrouznejad AQian Z(2018)Fuzzy Query Model of the Business Resources Based on Cloud Service PlatformProceedings of the 2nd International Conference on Computer Science and Application Engineering10.1145/3207677.3278082(1-5)Online publication date: 22-Oct-2018
https://dl.acm.org/doi/10.1145/3207677.3278082
Liu JYan D(2016)Answering Approximate Queries Over XML DataIEEE Transactions on Fuzzy Systems10.1109/TFUZZ.2015.245316824:2(288-305)Online publication date: 1-Apr-2016
https://dl.acm.org/doi/10.1109/TFUZZ.2015.2453168
Xu CWang YGu YLin SYu G(2012)Efficient fuzzy ranking queries in uncertain databasesApplied Intelligence10.1007/s10489-011-0312-137:1(47-59)Online publication date: 1-Jul-2012
https://dl.acm.org/doi/10.1007/s10489-011-0312-1
Cheng JMa ZYan L(2010)f-SPARQLProceedings of the 21st international conference on Database and expert systems applications: Part I10.5555/1881867.1881919(487-494)Online publication date: 30-Aug-2010
https://dl.acm.org/doi/10.5555/1881867.1881919
Xu CWang YLin SGu YQiao J(2010)Efficient fuzzy top-k query processing over uncertain objectsProceedings of the 21st international conference on Database and expert systems applications: Part I10.5555/1881867.1881883(167-182)Online publication date: 30-Aug-2010
https://dl.acm.org/doi/10.5555/1881867.1881883
Ma ZMeng X(2008)A Knowledge-Based Approach for Answering Fuzzy Queries over Relational DatabasesProceedings of the 12th international conference on Knowledge-Based Intelligent Information and Engineering Systems, Part II10.1007/978-3-540-85565-1_77(623-630)Online publication date: 3-Sep-2008
https://dl.acm.org/doi/10.1007/978-3-540-85565-1_77
Penzo W(2005)Rewriting Rules To Permeate Complex Similarity and Fuzzy Queries within a Relational Database SystemIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2005.3317:2(255-270)Online publication date: 1-Feb-2005
https://dl.acm.org/doi/10.1109/TKDE.2005.33
Zhang YChen YYe XZheng J(2005)Weighted fuzzy queries in relational databasesProceedings of the Second international conference on Fuzzy Systems and Knowledge Discovery - Volume Part II10.1007/11540007_53(430-441)Online publication date: 27-Aug-2005
https://dl.acm.org/doi/10.1007/11540007_53
Hu YTzeng GChen C(2004)Deriving two-stage learning sequences from knowledge in fuzzy sequential pattern miningInformation Sciences: an International Journal10.1016/S0020-0255(03)00190-7159:1-2(69-86)Online publication date: 20-Jan-2004
https://dl.acm.org/doi/10.1016/S0020-0255%2803%2900190-7
Hu YChen RTzeng GShieh J(2003)A fuzzy data mining algorithm for finding sequential patternsInternational Journal of Uncertainty, Fuzziness and Knowledge-Based Systems10.1142/S021848850300200411:2(173-193)Online publication date: 1-Apr-2003
https://dl.acm.org/doi/10.1142/S0218488503002004
Show More Cited By

Abstract

Cited By

Recommendations

Generalization of strategies for fuzzy query translation in classical relational databases

Database Skeleton and Its Application to Fuzzy Query Translation

Fuzzy Database Query Languages and Their Relational Completeness Theorem

Comments

Information

Published In

Publisher

Publication History

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

Share

Share this Publication link

Share on social media

Affiliations