International Business Machines Corporation

Chunyang Xia

Fatma Ozcan

Andrey Balmin

Vuk Ercegovac

Marcel Kutsch

Jesse E Jackson

Konstantinos Karanasos

In one embodiment, a computer-implemented method includes selecting one or more sub-expressions of a query during compile time. One or more pilot runs are performed by one or more computer processors. The one or more pilot runs include a pilot run associated with each of one or more of the selected sub-expressions, and each pilot run includes at least partial execution of the associated selected sub-expression. The pilot runs are performed during execution time. Statistics are collected on the one or more pilot runs during performance of the one or more pilot runs. The query is optimized based at least in part on the statistics collected during the one or more pilot runs, where the optimization includes basing cardinality and cost estimates on the statistics collected during the pilot runs.

Growing community of inventors

San Jose, CA, United States of America

Chunyang Xia