← Back to Projects

IKEBANA Algorithm : ESS Dimensions Reduction For Plan Bouquet

In SQL Query language we define an error-prone predicate as that whose estimation of selectivity is different from that returned by the query. Selectivity is the measure of percentage of columns returned for that predicate from the base relation. This selectivity is used by Database optimizers to choose effective plans to execute queries. If the selectivity estimation is incorrect sometimes the plan execution cost (time taken to execute query) can grow in terms of order of magnitude greater than the optimal query plan

Selectivity of predicates in an SQL query can be done in several statistical ways (for example maintaining histograms, sampling, sketches, wavelets, parametric curve fitting etc.) and has been a well reserached field for the last decade. The DSL lab in IISc recently produced a paper Plan Bouquet which eschews compile time estimation process and the actual selectivity is discovered incrementally at run time by executing a series of cost limited plans. This requires the accurate identification of error prone predicates and thier impact on the cost of the plan. We propose and implement some methods to achieve this.

This project has concluded. The detailed report and the presentation are available on the links indicated.
The code is available for inspection on my github repo https://github.com/adarshpatil/ESS-Reduction

Get Notified About My Newest Freebies & Upcoming Themes!

I do make some awesome freebies for you to use... All of them are FREE and pixel perfect!

Thanks for showing me the support by subscribing, and I'll try not to disappoint you...

Follow me on twitter

Subscribe to my newsletter

Thanks for that!