Back to results
US 9,753,975 B2Granted
Intelligently utilizing non-matching weighted indexes
AssigneeInternational Business Machines Corporation
InventorsRoger A. Mittelstadt, Brian R. Muras
Life of this patent
Estimating the term…
Abstract
System, method, and computer program product to intelligently utilize non-matching weighted objects, by determining that a sort sequence of a query does not match a sort sequence of a shared weight object of a database, modifying the query based on the sort sequence of the query, and executing the modified query to obtain a result set, wherein the result set does not include a set of rows that would have been returned using the shared weight object to process the unmodified query.
Claims13
A system, comprising:
- one or more computer processors;
- and
- a memory containing a program which when executed by the one or more computer processors performs an operation, the operation comprising:
- receiving a query specifying to access data in a first column of a shared weight object of a database based on a first selection predicate applied to the first column;
- determining that a sort sequence of the first selection predicate of the query does not match a shared weight sort sequence of the first column of the shared weight object, wherein the first column of the shared weight object includes shared weight data values;
- modifying the query by adding a second selection predicate to the query based on the sort sequence of the first selection predicate of the query and the shared weight sort sequence of the first column of the shared weight object, wherein the second selection predicate is applied to the first column of the shared weight object, wherein the second selection predicate, when executed, excludes a first row that would have been returned using the shared weight object to process the unmodified query, wherein the first column of the first row comprises a shared weight data value;
- and
- executing the modified query by using the second selection predicate as a key selection against the first column in the shared weight object to return a result set, wherein the result set does not include the shared weight data value of the first column of the first row that would have been returned using the shared weight object to process the unmodified query without the second selection predicate.
5 more elements
A computer program product, comprising:
- a non-transitory computer-readable storage medium having computer-readable program code embodied therewith, the computer-readable program code executable by a processor to perform an operation comprising:
- receiving a query specifying to access data in a first column of a shared weight object of a database based on a first selection predicate applied to the first column;
- determining that a sort sequence of the first selection predicate of the query does not match a shared weight sort sequence of the first column of the shared weight object, wherein the first column of the shared weight object includes shared weight data values;
- modifying the query by adding a second selection predicate to the query based on the sort sequence of the first selection predicate of the query and the shared weight sort sequence of the first column of the shared weight object, wherein the second selection predicate is applied to the first column of the shared weight object, wherein the second selection predicate, when executed, excludes a first row that would have been returned using the shared weight object to process the unmodified query, wherein the first column of the first row comprises a shared weight data value;
- and
- executing the modified query by using the second selection predicate as a key selection against the first column in the shared weight object to return a result set, wherein the result set does not include the shared weight data value of the first column of the first row that would have been returned using the shared weight object to process the unmodified query without the second selection predicate.
3 more elements
Dependencies are inferred from the claim text.