Oracle International Corporation

Yuying Zhang

Mohamed Zait

Hong Su

Jiakun Li

Techniques are provided for gathering statistics in a database system. The techniques involve gathering some statistics using an 'on-the-fly' technique, some statistics through a “high-frequency” technique, and yet other statistics using a “prediction” technique. The technique used to gather each statistic is based, at least in part, on the overhead required to gather the statistic. For example, low-overhead statistics may be gathered “on-the-fly” using the same process that is performing the operation that affects the statistic, while statistics whose gathering incurs greater overhead may be gathered in the background, while the database is live, using the high-frequency technique. The prediction technique may be used for relatively-high overhead statistics that can be predicted based on historical data and the current value of predictor statistics.

Techniques for maintaining statistics in a database system

Techniques are provided for gathering statistics in a database system. The techniques involve gathering some statistics using an 'on-the-fly' technique, some statistics through a 'high-frequency' technique, and yet other statistics using a &#x201c;prediction&#x201d; technique. The technique used to gather each statistic is based, at least in part, on the overhead required to gather the statistic. For example, low-overhead statistics may be gathered &#x201c;on-the-fly&#x201d; using the same process that is performing the operation that affects the statistic, while statistics whose gathering incurs greater overhead may be gathered in the background, while the database is live, using the high-frequency technique. The prediction technique may be used for relatively-high overhead statistics that can be predicted based on historical data and the current value of predictor statistics.

Growing community of inventors

Foster City, CA, United States of America

Yuying Zhang