Patent Document ID: 8744994
Application ID: 12343021
Patent Flag: 1

Claim One:
1. A computer-implemented method for use with an ETL (Extract, Transform, Load) process, comprising: operating a computer processor to optimize a predicate expression to select a subset of data; extracting the subset of data; filtering the subset of data; transforming the subset of data; loading the subset of data to a target; evaluating the predicate expression, depicted as a tree with a plurality of nodes, during the filtering of the subset of data at a time that occurs after the extracting of the subset of data, after the transforming of the subset of data, and before the loading of the subset of data to a target; storing, in each of the plurality of nodes, execution statistics of a plurality of child nodes of each of the plurality of nodes; adjusting an order of execution of the predicate expression after every n records, with n being a predetermined number of records, based on a recent execution statistic of the plurality of child nodes of the plurality of nodes and whether each of the plurality of nodes is an OR node or an AND node; and adjusting the order of execution of the predicate expression such that a child node of the plurality of child nodes with a lowest true rate is executed first, wherein the true rate corresponds to a percentage of time at which one of the plurality of nodes evaluates to true, wherein the execution statistics include the true rate.