Patent ID: 8862539

Claim:
A method of statistical application in an online transaction processing (OLTP) environment, the method comprising: determining whether a statistical record exists in a cache of an application server prior to querying a database; when the statistical record exists in the cache, checking a time element of the statistical record to determine whether the statistical record in the cache has expired; when the statistical record exists in the cache and the statistical record in the cache has not expired, sending the statistical record to an inquirer; and when the statistical record does not exist in the cache or the statistical record in the cache has expired, querying the database containing the statistical table to determine whether the statistical record exists in the database; when the statistical record exists in the database and the statistical record in the database has not expired, sending the statistical record in the database to the inquirer; and when the statistical record does not exist in the database or the statistical record in the database has expired, invoking a statement of the programming language to compute the statistical record.