Gathering Index Statistics Using Sampling
AssigneeInternational Business Machines Corporation
InventorsScott D. Lashley, Bingjie Miao
Life of this patent
Estimating the term…
Abstract
An approach is provided in which a sample point system allocates sample point identifiers to a root node included an index tree that includes multiple leaf nodes. The sample point system distributes the sample point identifiers to the root node's child nodes, and recursively traverses through the index tree's hierarchical index levels and distributes the sample point identifiers from the child nodes to a subset of the index tree's leaf nodes. In turn, the sample point system collects sample data from the subset of the plurality of leaf nodes corresponding to the distributed sample point identifiers.
Claims10
A method comprising:
- allocating, by one or more processors, a plurality of sample point identifiers to a root node included in an index tree corresponding to a database, the index tree including a plurality of leaf nodes;
- distributing, by one or more of the processors, the plurality of sample point identifiers to a plurality of first nodes that are child nodes of the root node;
- recursively traversing, by one or more of the processors, through a plurality of hierarchical index levels included in the index tree and distributing the plurality of sample point identifiers from the plurality of first nodes to a subset of the plurality of leaf nodes;
- and
- collecting sample data, by one or more of the processors, from the subset of the plurality of leaf nodes corresponding to the distributed plurality of sample point identifiers.
Dependencies are inferred from the claim text.