The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Apr. 30, 2002
Filed:
Mar. 24, 1999
Gustav Per-Åke Larson, Redmond, WA (US);
Weiye Zhang, Redmond, WA (US);
Microsoft Corporation, Redmond, WA (US);
Abstract
A system and method for modifying or converting predicates involving a comparison with a string constant in a query is provided so that the predicates can be evaluated by an external or remote source that uses a different collating sequence, thereby effectively reducing the amount of data sent over a network. Techniques for predicate simplification are also provided for complex predicates. Although it is desirable that the converted predicate precisely match the original predicate, it is not necessary; an imprecise predicate that selects a superset of the target rows is sufficient. Thus, techniques for imprecise conversion are also provided. For an imprecise conversion, the original query is further evaluated against the obtained superset to obtain the final result, whereas for a precise conversion, the returned set is the required set, and no further evaluation is needed.