Abstract: A method and apparatus for creating a data set with pending results are described. In one embodiment, the method includes receiving a user request to process data and processing the user request to begin creating a final result set with at least one field being identified as a pending result field. The processing, in turn, includes creating a portion of an initial result set containing the pending result field before a final value for the pending result field is determined, and transforming the portion of the initial result set to create a portion of the final result set before a final value for the pending result field is determined. The method further includes continuing processing the user request while the final value remains undetermined, and updating the final result set with the final value of the pending result field once the final value is determined.

Abstract: A method and apparatus for processing data using multi-tier caching are described. In one embodiment, the method includes receiving a user request containing one or more data parameters and searching cache memories of multiple tiers until finding a parameterized result set associated with the data parameters. The multiple tiers correspond to stages in the transformation of data retrieved from one or more data sources according to the user request. Once the parameterized result set associated with the data parameters is found, it is used to create a final result set.