Skip to main content
SpringerLink
Log in

A study of SQL query processing using soft computing techniques: a hybrid vague logic approach

  • Original Research
  • Published:
International Journal of Information Technology Aims and scope Submit manuscript

Abstract

As we know that in this new era, the availability of modern data sets is massive. It is very difficult to find the variation and appropriate class for a data set. So, this paper introduces a comparison between fuzzy and vague sets for handling Structured Query Language (SQL) processing problems. This paper proposed a new method to convert crisp set into vague set with help of Positive Ordered Transformation formula (POTF). Further, vague sets are converted into fuzzy sets with help of Transforming Vague Set into Fuzzy Set method proposed by Liu et al. (Trans Comput Sci II LNCS 5152:133–144, 2008). Further the similarity measures have been used to obtain similar tuple for classical fuzzy, vague and converted fuzzy sets based on SQL query processing. This proposed system diverse a resultant as a set based on supply limit/α-cut for fuzzy/vagueness/unclear information. After testing through many cases, this paper discussed a very good finding about proposed method for SQL query processing problems.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3

Similar content being viewed by others

References

  1. Codd EF (1990) The relational model for database management. Addison Wesley, Boston

    MATH  Google Scholar 

  2. Elmasri R, Navathe SB (2010) Fundamentals of database systems, 6th edn. Pearson, London

    MATH  Google Scholar 

  3. Codd EF (1970) A relational model for large shared data banks. Commun ACM 13(6):377–387

    Article  MATH  Google Scholar 

  4. Date CJ (2004) An introduction to data base systems, 8th edn. Addison Wesley, Boston

    Google Scholar 

  5. Zadeh LA (1965) Fuzzy sets. Inf Control 8(3):338–353

    Article  MATH  Google Scholar 

  6. Buckles PB, Petry FE (1982) A fuzzy representation of data for relational databases. Fuzzy Sets Syst 7(3):213–226

    Article  MATH  Google Scholar 

  7. Raju KVSVN, Majumdar AK (1988) Fuzzy functional dependencies and lossless join decomposition of fuzzy relational database system. ACM Trans Database Syst 13(2):129–166

    Article  Google Scholar 

  8. Ma ZM, Mili F (2002) Handling fuzzy information in extended possibility-based fuzzy relational databases. Int J Intell Syst 17(10):925–942

    Article  MATH  Google Scholar 

  9. Intan R, Mukaidono M (2000) Fuzzy functional dependency and its application to approximate data querying. In: Proceeding of international database engineering and applications symposium, pp 47–54

  10. Takahashi Y (1993) Fuzzy database query languages and their relational completeness theorem. IEEE Trans Knowl Data Eng 5(3):122–125

    Article  Google Scholar 

  11. Bosc P, Pivert O (1995) SQLF: a relational database language for fuzzy querying. IEEE Trans Fuzzy Syst 3(1):1–17

    Article  Google Scholar 

  12. Nakajima H, Sogoh T, Arao M (1993) Fuzzy database language and library-fuzzy extension to SQL. In: Second IEEE international conference on fuzzy systems, vol 1, pp 477–482

  13. Lu A, Ng W (2005) vague sets or intuitionistic fuzzy sets for handling vague data: which one is better? Lect Notes Comput Sci 3716:401–416

    Article  Google Scholar 

  14. Zhao F, Ma ZM (2009) Vague query based on vague relational model, vol 61. AISC. Springer, Berlin, pp 229–238

    Google Scholar 

  15. Gau WL, Buehrer DJ (1993) Vague sets. IEEE Trans Syst Man Cybern 23(2):610–614

    Article  MATH  Google Scholar 

  16. Kaur N, Aggarwal H (2018) Query based approach for referrer field analysis of log data using web mining techniques for ontology improvement. Int J Inf Technol 10(1):99–110

    Google Scholar 

  17. Kaur N, Aggarwal H (2017) Evaluation of information retrieval based ontology development editors for semantic web. Int J Mod Educ Comput Sci 9(7):63–73

    Article  Google Scholar 

  18. Dwivedi S, Kumar S (2017) Query processing and interlinking of fuzzy object-oriented database. Am J Eng Res 6(2):36–41

    Google Scholar 

  19. Yadav RS (2018) Application of hybrid clustering methods for student performance evaluation. Int J Inf Technol 10(2):1–8

    Google Scholar 

  20. Zadeh LA (1992) Fuzzy logic: advanced concepts and structures. IEEE Piscataway, New York

    Google Scholar 

  21. Zadeh LA (1972) A new approach to system analysis. Man and computer. North-Holland, Amsterdam, pp 55–94

    Google Scholar 

  22. Cheeseman P (1986) Probabilistic versus fuzzy reasoning. Uncertainty in artificial intelligence. Elsevier Science Publishers, Amsterdam, pp 72–85

    Google Scholar 

  23. Kosko B (1993) Fuzzy thinking: the new science of fuzzy logic. Art House, Helsinki, pp 122–130

    Google Scholar 

  24. Guxin L, Hong-Xu W, Chengyi Z (2010) Constructing vague environment. Fuzzy Inf Eng AISC 78:711–715

    MATH  Google Scholar 

  25. Liu Y, Wang G, Feng L (2008) A general method for transferring vague sets into fuzzy sets. Trans Comput Sci II LNCS 5152:133–144

    Article  MATH  Google Scholar 

  26. Chen SM (1997) Similarity measure between vague sets and between elements. IEEE Trans Syst Man Cybern 27(1):153–158

    Article  Google Scholar 

  27. Hong DH, Kim C (1999) A note on similarity measures between vague sets and between elements. Inf Sci 115:83–96

    Article  MathSciNet  MATH  Google Scholar 

  28. Li F, Xu Z (2001) Measures of similarity between vague sets. J Softw 12(6):922–927

    Google Scholar 

  29. Lu A, Ng W (2004) Managing merged data by vague functional dependencies, vol 3288. LNCS. Springer, Berlin, pp 259–272

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computer Science and Engineering, Ashoka Institute of Technology and Management, Engineering Chauraha, Paharia, Sarnath, Varanasi, Uttar Pradesh, 221007, India

    Ramjeet Singh Yadav

Authors
  1. Ramjeet Singh Yadav
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Ramjeet Singh Yadav.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Yadav, R.S. A study of SQL query processing using soft computing techniques: a hybrid vague logic approach. Int. j. inf. tecnol. 11, 393–405 (2019). https://doi.org/10.1007/s41870-018-0256-3

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s41870-018-0256-3

Keywords

Search

Navigation