Patent ID: 9626397
Date: 2017-04-18
CPC Classifications: G06F

Claim:
1. A computer-implemented method comprising: arranging, by a relational engine, data from a data source into columnar data points in a columnar table format; receiving one or more respective tabular data sets containing data points representing a discounted operation forecast of future values; receiving instructions to perform an iterative calculation on the data points; analyzing, by a database optimizer, the iterative calculation to identify at least one invariant function, the invariant function being a loop invariant function unaffected by input values; pre-calculating results of the at least one invariant function to create columnar data having data points representing the invariant function; and a parallel calculation engine assigning portions of the pre-calculated results to a parallel processing system and applying respective structured query language operator sets to the pre-calculated results and to respective multiple tabular data sets to calculate, in parallel, respective results of the iterative calculation.