Vague Query Based on Vague Relational Model

Although the relational model for databases provides a great range of advantages over other data models, it lacks a comprehensive way to handle imprecise and uncertain data. Vague set, as a generalized fuzzy set, has more powerful ability to process fuzzy information than fuzzy set. In this paper, based on the vague set, a kind of vague relational model is proposed. Incorporating the notion of vague sets in relations, we describe Vague SQL, which is an extension of SQL for the vague relational model, and show that Vague SQL combines the capabilities of a standard SQL with the power of manipulating vague relations. Although Vague SQL is a minimal extension to illustrate its usages, VSQL allows users to formulate a wide range of queries between vague data and queries.

[1]  W.-L. Gau,et al.  Vague sets , 1993, IEEE Trans. Syst. Man Cybern..

[2]  Lois M. L. Delcambre Conceptual Modeling - ER 2005, 24th International Conference on Conceptual Modeling, Klagenfurt, Austria, October 24-28, 2005, Proceedings , 2005, ER.

[3]  B. Buckles,et al.  A fuzzy representation of data for relational databases , 1982 .

[4]  Lotfi A. Zadeh,et al.  Fuzzy Sets , 1996, Inf. Control..

[5]  Wilfred Ng,et al.  Vague Sets or Intuitionistic Fuzzy Sets for Handling Vague Data: Which One Is Better? , 2005, ER.

[6]  Patrick Bosc,et al.  SQLf: a relational database language for fuzzy querying , 1995, IEEE Trans. Fuzzy Syst..

[7]  Shyi-Ming Chen,et al.  Measures of similarity between vague sets , 1995, Fuzzy Sets Syst..

[8]  Yoshikane Takahashi Fuzzy Database Query Languages and Their Relational Completeness Theorem , 1993, IEEE Trans. Knowl. Data Eng..

[9]  Dug Hun Hong,et al.  A Note on Similarity Measures between Vague Sets and between Elements , 1999, Inf. Sci..

[10]  Patrick Bosc,et al.  Fuzzy databases : principles and applications , 1996 .

[11]  Arun K. Majumdar,et al.  Fuzzy Functional Dependencies and Lossless Join Decomposition of Fuzzy Relational Database Systems , 1988, ACM Trans. Database Syst..

[12]  Patrick Bosc,et al.  Some approaches for relational databases flexible querying , 1992, Journal of Intelligent Information Systems.

[13]  Zongmin Ma Fuzzy Database Modeling with XML , 2005, Advances in Database Systems.

[14]  Zongmin Ma,et al.  Handling fuzzy information in extended possibility‐based fuzzy relational databases , 2002, Int. J. Intell. Syst..

[15]  Witold Lipski,et al.  On semantic issues connected with incomplete information databases , 1979, ACM Trans. Database Syst..

[16]  Krassimir T. Atanassov,et al.  Intuitionistic fuzzy sets , 1986 .

[17]  Shyi-Ming Chen,et al.  Similarity measures between vague sets and between elements , 1997, IEEE Trans. Syst. Man Cybern. Part B.