Extended database engine providing versioning and embedded analytics

摘要

A system for calculating analytics uses a relational database to store inputs, calculates results, and stores them in cache. The system also includes an access layer that provides a unified view of the data in server. A dynamic access layer is generated at runtime to run an analytic to provide a flexible framework for creating business logic.

主权项

1. A method comprising:
storing in a database one or more tables including records with a plurality of fields; retrieving the records from the database and storing data from the records in a cache in order to perform a calculation, the records being rearranged so that each record has an identifier and at least for one record multiple versions of that record are stored in the cache, the different versions of the record including one or more variations in field values, wherein the records are stored in the database with groups of fields organized into at least two field groups with at least two fields each; and selectively retrieving from the database and storing in the cache one or more, but not all, field groups on an as-needed basis to perform a calculation.