Self-optimizing value range synopsis in analytical databases
AssigneeInternational Business Machines Corporation
InventorsFelix O. Beier, Andreas Brodt, Namik Hrle, Oliver Schiller
Life of this patent
Estimating the term…
Loading patent…
AssigneeInternational Business Machines Corporation
InventorsFelix O. Beier, Andreas Brodt, Namik Hrle, Oliver Schiller
Estimating the term…
A method, a computer program product and a computer system are provided. Attribute value information contains at least a minimum value representing a smallest value of a first attribute and a maximum value representing a largest value of the first attribute, thereby defining a first range of values of the first attribute. A received query against a data table requests one or more values of at least the first attribute that are covered by the first range of values. The attribute value information may be used for selecting a data block of the data table as a candidate potentially including at least part of the requested one or more values and scanning the data block. In response to determining that the data block does not include the one or more requested values, the attribute value information may be updated accordingly.
A computer implemented method for updating attribute value information of at least one data block of a data table, where the data table includes a plurality of records and involves at least a first attribute, the attribute value information including at least a minimum value representing a smallest value of the first attribute and a maximum value representing a largest value of the first attribute, thereby defining a first range of values of the first attribute, the method comprising:
Dependencies are inferred from the claim text.