Patent 10262027 was granted and assigned to Salesforce.com, Inc. on April, 2019 by the United States Patent and Trademark Office.
In a method, system, and computer-readable medium having instructions for executing a query in a database system, a query request is received with a query predicate to filter data returned in response to the query request and the query predicate has a formula, the query request is transformed to a transformed query request by preprocessing the formula in the query predicate, and the query request is optimized using the transformed query request.