Rank Based Query Optimization for RDBMS Using Genetic Algorithm

Omkar Singh, S. K. Singh, Hiteshri Rajput, Rajni Chandwani

Abstract


Rank based query optimization in SQL, is a system that provides a systematic framework to support efficient evaluations of ranking queries in relational database systems (RDBMS), by extending relational algebra and query optimization. Previously, query processing is studied in the middleware scenario or in RDBMS in a piecemeal fashion, i.e., focusing on specific operator or sitting outside the core of query engines. In contrast, we aim to support ranking as a first-class database construct. As a key insight, the new ranking relationship can be viewed as another logical property of data, parallel to the membership property of relational data model. While membership is essentially supported in RDBMS, the same support for ranking is clearly lacking. We address the fundamental integration of ranking in RDBMS in a way similar to how membership, i.e., Boolean filtering, is supported.

Full Text:

PDF

References


Richa Garg & Saurabh mittal, Optimization by Genetic Algorithm,International Journal of Advanced Research in Computer Science and Software Engineering,Volume 4, Issue 4, April 2014, ISSN: 2277 128X

Pushpendra Kumar Yadav & Dr.N.L.Prajapati, An Overview of Genetic Algorithm and Modeling,International Journal of Scientific and Research Publications, Volume 2, Issue 9, September 2012, ISSN 2250-3153

Matthias Jarke & Jurgen Koch, Query Optimization in Database Systems

Dhaval Patel & Pratik Patel, A Review Paper on Different Approaches for Query Optimization using Schema Object base View, International Journal of Computer Applications, Volume 114, Issue 4, March 2015, ISSN 0975 – 8887




DOI: https://doi.org/10.23956/ijarcsse.v8i11.905

Refbacks

  • There are currently no refbacks.




© International Journals of Advanced Research in Computer Science and Software Engineering (IJARCSSE)| All Rights Reserved | Powered by Advance Academic Publisher.