An Approach for Augmenting Selection Operators of SQL Queries using Skyline and Fuzzy-Logic Operators

Abstract In this work, expressivity two operators fuzzy and skyline is primarily focused upon. Stated two known operators have been used here for augmenting selection operator of SQL. Since SQL is unable to understand linguistic concepts of natural language there is essence of a preference based solution so as to return answers according to user preferences. Both these operators can return a different answer to the same query. Additionally in this paper, performance of fuzzy and skyline processing time and the number of returned answers by means of an experimental study is analyzed.

[1]  Yin Yang,et al.  Skyline Processing on Distributed Vertical Decompositions , 2013, IEEE Transactions on Knowledge and Data Engineering.

[2]  Miroslav Hudec.  Fuzzy improvement of the SQL , 2011 .

[3]  Tao Li,et al.  A Learning Approach to SQL Query Results Ranking Using Skyline and Users' Current Navigational Behavior , 2013, IEEE Transactions on Knowledge and Data Engineering.

[4]  Donald Kossmann,et al.  The Skyline operator , 2001, Proceedings 17th International Conference on Data Engineering.

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

[6]  Qinbao Song,et al.  A Fast Clustering-Based Feature Subset Selection Algorithm for High-Dimensional Data , 2013, IEEE Transactions on Knowledge and Data Engineering.

[7]  Hesham A. Hefny,et al.  Flexible Querying of Relational Databases: Fuzzy Set Based Approach , 2014, AMLTA.

[8]  Zheng Pei,et al.  Application of fuzzy query based on relation database , 2007 .

[9]  Harsh Kumar Verma,et al.  Skyline Computation Algorithms - A Study , 2014 .

[10]  Srdjan Skrbic,et al.  An Interpreter for Priority Fuzzy Logic Enriched SQL , 2009, 2009 Fourth Balkan Conference in Informatics.

[11]  Ge-Ming Chiu,et al.  Close Dominance Graph: An Efficient Framework for Answering Continuous Top- $k$ Dominating Queries , 2014, IEEE Transactions on Knowledge and Data Engineering.