Processing formulae in rules for profitability calculations for financial processing in a relational database management system
A Value Analyzer system is a data-driven computer-facilitated financial model that provides accurate and consistent profitability calculations using account, product and event attributes stored in a relational database managed by a relational database management system (RDBMS). Profitability calculations are performed in the computer by applying one or more rules to the account, product and event attributes accessed from the database, wherein at least one of the rules contains one or more formulae that is reconstructed and dynamically interpreted when the rule is being performed.
1 . A method of performing financial processing in one or more computers, comprising:
(a) accessing account, product and event attributes from a database, wherein: (1) the account attributes comprise data about accounts being measured, (2) the product attributes comprise data about products being purchased, and (3) the event attributes comprise data about account-related and product-related transactions; and
(b) performing one or more profitability calculations by applying one or more rules to the account, product and event attributes accessed from the database;
(c) wherein at least one of the rules contains one or more formulae that is reconstructed and dynamically interpreted when the rule is being performed.
2 . The method of claim 1 , wherein the formulae is comprised of component elements that are mapped from the database.
3 . The method of claim 2 , wherein the component elements are comprised of operators, attributes, previous rule results, or global constants.
4 . The method of claim 3 , wherein the component elements are stored as types and ids.
5 . The method of claim 4 , wherein the type identifies a table and the id is a key into the table.
6 . The method of claim 2 , wherein the component elements are updated without changing the formula.
7 . The method of claim 1 , wherein the formula is translated into one or more text strings for SQL generation.
8 . An apparatus for financial processing, comprising:
(a) a computer,
(b) logic, performed by a computer, for
(1) accessing account, product and event attributes from a database, wherein: (1) the account attributes comprise data about accounts being measured, (2) the product attributes comprise data about products being purchased, and (3) the event attributes comprise data about account-related and product-related transactions; and
(2) performing one or more profitability calculations by applying one or more rules to the account, product and event attributes accessed from the database;
(3) wherein at least one of the rules contains one or more formulae that is reconstructed and dynamically interpreted when the rule is being performed.
9 . The apparatus of claim 8 , wherein the formulae is comprised of component elements that are mapped from the database.
10 . The apparatus of claim 9 , wherein the component elements are comprised of operators, attributes, previous rule results, or global constants.
11 . The apparatus of claim 10 , wherein the component elements are stored as types and ids.
12 . The apparatus of claim 11 , wherein the type identifies a table and the id is a key into the table.
13 . The apparatus of claim 9 , wherein the component elements are updated without changing the formula.
14 . The apparatus of claim 8 , wherein the formula is translated into one or more text strings for SQL generation.
15 . An article of manufacture embodying logic for performing financial processing in a computer, the logic comprising:
(a) accessing account, product and event attributes from a database, wherein: (1) the account attributes comprise data about accounts being measured, (2) the product attributes comprise data about products being purchased, and (3) the event attributes comprise data about account-related and product-related transactions; and
(b) performing one or more profitability calculations by applying one or more rules to the account, product and event attributes accessed from the database;
(c) wherein at least one of the rules contains one or more formulae that is reconstructed and dynamically interpreted when the rule is being performed.
16 . The article of claim 15 , wherein the formulae is comprised of component elements that are mapped from the database.
17 . The article of claim 16 , wherein the component elements are comprised of operators, attributes, previous rule results, or global constants.
18 . The article of claim 17 , wherein the component elements are stored as types and ids.
19 . The article of claim 18 , wherein the type identifies a table and the id is a key into the table.
20 . The article of claim 16 , wherein the component elements are updated without changing the formula.
21 . The article of claim 15 , wherein the formula is translated into one or more text strings for SQL generation.