US 7,430,562 B1
System and method for efficient date retrieval and processing
Jeffrey A. Bedell, Arlington, Va. (US); Michael Codini, Herndon, Va. (US); William Hurwood, Washington, D.C. (US); Ashutosh K. Jhaveri, San Francisco, Calif. (US); Benjamin Z. Li, Great Falls, Va. (US); Fabrice Martin, Washington, D.C. (US); Sadanand Sahasrabudhe, Great Falls, Va. (US); and Jun Yuan, Sterling, Va. (US)
Assigned to Microstrategy, Incorporated, McLean, Va. (US)
Filed on Jun. 19, 2001, as Appl. No. 9/883,499.
Int. Cl. G06F 17/00 (2006.01)
U.S. Cl. 707—102  [707/101; 707/10; 707/1; 707/2; 707/3] 23 Claims
OG exemplary drawing
 
1. 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.