摘要:
Methods and systems for computing algebraic equations are disclosed, with particular relevance to financial analytics. Analytic formulas may be represented as data, and the analytic system may be structured as a kind of an analytic interpretation engine in a database layer of a system. Because analytic formulas may be represented as data in some table or tables, analytics can be added, deleted or modified without having to make changes to the analytic engine's source code. The analytic engine may be implemented in some relational language, such as a dialect of SQL, to manipulate and compute the analytic formulas stored in the database.
摘要:
Methods and systems for computing algebraic equations are disclosed, with particular relevance to financial analytics. Analytic formulas may be represented as data, and the analytic system may be structured as a kind of an analytic interpretation engine in a database layer of a system. Because analytic formulas may be represented as data in some table or tables, analytics can be added, deleted or modified without having to make changes to the analytic engine's source code. The analytic engine may be implemented in some relational language, such as a dialect of SQL, to manipulate and compute the analytic formulas stored in the database.
摘要:
A method and a system for maintaining the history of database content when the database is modified by a sequence of events, where each event may be one of a load or a load retraction, is provided. The inventive system and method can reconstruct the state of a database as it existed at a discrete time between two successive historical events without repeating each event in the historical event sequence. A table containing deleted row information and a table containing historical information are maintained as the target table is updated to more quickly recreate historical states of the target table.