Abstract
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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Zadeh, L.A.: Fuzzy sets. Information and Control 8, 338–353 (1965)
Buckles, B.P., Petry, F.E.: A Fuzzy Representation of Data for Relational Databases. Fuzzy Sets and Systems 7, 213–226 (1982)
Raju, K.V.S.V.N., Majumdar, A.K.: Fuzzy Functional Dependencies and Lossless Join Decomposition of Fuzzy Relational Database Systems. ACM Transactions on Database Systems 13, 129–166 (1988)
Ma, Z.M., Mili, F.: Handling Fuzzy Information in Extended Possibility-Based Fuzzy Relational Databases. International Journal of Intelligent Systems 17, 925–942 (2002)
Bosc, P., Pivert, O.: SQLf: A Relational Database Language for Fuzzy Querying. IEEE Transactions on Fuzzy Systems 3, 1–17 (1995)
Takahashi, Y.: Fuzzy Database Query Languages and Their Relational Completeness Theorem. IEEE Transactions on Knowledge and Data Engineering 5, 122–125 (1993)
Petry, F.E.: Fuzzy Databases: Principles and Applications. Kluwer Academic Publisher, Dordrecht (1996)
Ma, Z.M.: Fuzzy Database Modeling with XML. Springer, Heidelberg (2005)
Gau, W.L., Buehrer, D.J.: Vague Sets. IEEE trans. Syst., Man, Cybern. 23, 610–614 (1993)
Atanassov, K.: Intuitionistic fuzzy sets. Fuzzy Sets and Systems 20, 87–96 (1986)
Lu, A., Ng, W.: Vague sets or intuitionistic fuzzy sets for handling vague data: Which one is better? In: Delcambre, L.M.L., Kop, C., Mayr, H.C., Mylopoulos, J., Pastor, Ó. (eds.) ER 2005. LNCS, vol. 3716, pp. 401–416. Springer, Heidelberg (2005)
Chen, S.M.: Measures of Similarity between Vague Sets. Fuzzy Sets and Systems 74, 217–223 (1995)
Chen, S.M.: Similarity Measure between Vague Sets and between Elements. IEEE Trans. Syst. Man, Cybern. 27, 153–158 (1997)
Hong, D.H., Kim, C.: A Note on Similarity Measures between Vague Sets and between Elements. Information Sciences 115, 83–96 (1999)
Bosc, P., Pivert, O.: Some Approaches for Relational Databases Flexible Querying. Journal of Intelligent Information Systems 1, 323–354 (1992)
Lipski, W.: On Semantic Issues Connected with Incomplete Information Databases. ACM Transactions on Database Systems 4, 262–296 (1979)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Zhao, F., Ma, Z.M. (2009). Vague Query Based on Vague Relational Model. In: Yu, W., Sanchez, E.N. (eds) Advances in Computational Intelligence. Advances in Intelligent and Soft Computing, vol 116. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-03156-4_23
Download citation
DOI: https://doi.org/10.1007/978-3-642-03156-4_23
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-03155-7
Online ISBN: 978-3-642-03156-4
eBook Packages: EngineeringEngineering (R0)