Seyed Mohammad Amin Kamali

Vincent Corvinelli

Ning Wang

Brandon Lewis Frendo

Vasiliki Kantere

Calisto Zuzarte

Aspects of the disclosure include hybrid cost model-based techniques for evaluating query execution plans. A non-limiting example method includes inputting, to a plurality of base cost models including one or more learned cost models and a classic cost model, a query and a search space including a plurality of candidate query execution plans. Each base cost model outputs a predicted execution time or cost for each plan of the plurality of candidate query execution plans and a real execution time for each plan is determined. The method includes generating a training label including the query and a model of the base cost models having a highest correlation between the predicted and real execution times and training a query classifier on training data including the training label to predict which base cost model of the plurality of base cost models is a most suitable cost model for planning a given query.

Growing community of inventors

Orleans, Canada

Seyed Mohammad Amin Kamali