Patent ID: 7430562

Claim:
A computer-implemented system for retrieval and processing of a data set from one or more data sources comprising: a query structure assembly module for defining a query structure based upon a plurality of query assembly rules and a desired data set, wherein the plurality of query assembly rules are being used by the query structure assembly module to evaluate the desired data set; a syntax assembly module for defining at least one query language statement based upon the defined query structure; a process optimization module for evaluating processing options based upon a database schema associated with the data source, the process optimization module including an intermediate data processing method module for evaluating a plurality of methods for generating intermediate data sets within the data source(s) to determine a method for generating intermediate data sets within the data source(s) for calculating the desired data result set; and whereby at least one query language statement is assembled and run against the data source(s) to return the desired data result set.