Summarizing statistical data for database systems and/or environments
AssigneeTeradata Corporation
InventorsCongnan Luo, Heng Yuan, Guillian Wang
Life of this patent
Estimating the term…
Abstract
Database values and their associated indicators can be arranged in multiple “buckets.” Adjacent buckets can be combined into a single bucket successively based one or more criteria associated with the indicators to effectively reduce the number of buckets until a desired number is reached.
Claims20
A method of storing database values and their associated indicator values in a summarized form, wherein the method is implemented at least partly by a device, and wherein the method comprises:
- arranging database values of a database in multiple buckets in accordance with an order in an arrangement, wherein each one of the database values is associated with an indicator value, and wherein each one of the multiple buckets includes only one of the database values with its associated indicator value;
- determining whether to reduce the number of buckets;
- combining two adjacent buckets in the arrangement into a combined bucket based one or more criteria associated with the indicator values when the determining determines to reduce the number of buckets;
- and
- repeating the combining for yet another two adjacent buckets until the determining determines not to further reduce the number of buckets.
An apparatus that includes one or more processors operable to store database values and their associated indicator values in a summarized form, by performing at least the following:
- arranging database values of a database in multiple buckets in accordance with an order in an arrangement, wherein each one of the database values is associated with an indicator value, and wherein each one of the multiple buckets includes only one of the database values with its associated indicator value;
- determining whether to reduce the number of buckets;
- combining two adjacent buckets in the arrangement into a combined bucket based one or more criteria associated with the indicator values when the determining determines to reduce the number of buckets;
- and
- repeating the combining for yet another two adjacent buckets until the determining determines not to further reduce the number of buckets.
A non-transitory computer readable storage medium storing at least computer code that when execute stores database values and their associated indicator values in a summarized form by at least:
- arranging database values of a database in multiple buckets in accordance with an order in an arrangement, wherein each one of the database values is associated with an indicator value, and wherein each one of the multiple buckets includes only one of the database values with its associated indicator value;
- determining whether to reduce the number of buckets;
- combining two adjacent buckets in the arrangement into a combined bucket based one or more criteria associated with the indicator values when the determining determines to reduce the number of buckets;
- and
- repeating the combining for yet another two adjacent buckets until the determining determines not to further reduce the number of buckets.
Dependencies are inferred from the claim text.