Method, system, and program for collecting statistics of data stored in a database
First Claim
1. A data processing system implemented method of collecting statistics associated with data stored in a database, the database operatively coupled to a data processing system, the data processing system implemented method comprising:
- determining a likelihood that currently computed statistics associated with the data have changed; and
collecting updated statistics for the data in response to the determined likelihood.
5 Assignments
0 Petitions
Accused Products
Abstract
The present invention relates to collecting statistics automatically for data in a database. There is provided a method for automated statistics collection comprising determining a likelihood that statistics for data have changed; and collecting statistics for data in response to the likelihood. Indicators of the likelihood that statistics have changed may be useful to trigger automated statistics collection. Tables having statistics that change significantly may be collected more often than statistics of tables that are stable. A preferred model is provided to facilitate the collection of statistics that are more relevant: a table is scheduled for collection in accordance with observed patterns of table activity; a table is considered for collection if it meets a threshold level of activity; and a table is sampled to predict whether the statistics to be collected have changed. When collecting statistics, throttling and lock contention can minimize impact on a database user'"'"'s response experience.
53 Citations
26 Claims
-
1. A data processing system implemented method of collecting statistics associated with data stored in a database, the database operatively coupled to a data processing system, the data processing system implemented method comprising:
-
determining a likelihood that currently computed statistics associated with the data have changed; and
collecting updated statistics for the data in response to the determined likelihood. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A data processing system for collecting statistics associated with data stored in a database, the database operatively coupled to the data processing system, the data processing system comprising:
-
a determining module for determining a likelihood that currently computed statistics associated with the data have changed; and
a collecting module for collecting updated statistics for the data in response to the determined likelihood. - View Dependent Claims (13, 14, 15, 16)
-
-
17. An article of manufacture for directing a data processing system to collect statistics associated with data stored in a database, the database operatively coupled to the data processing system, the article of manufacture comprising:
a program usable medium embodying one or more instructions executable by the data processing system, the one or more instructions comprising;
data processing system executable instructions for determining a likelihood that currently computed statistics associated with the data have changed; and
data processing system executable instructions for collecting updated statistics for the data in response to the determined likelihood. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24, 25, 26)
Specification