Object-oriented representation of a generic profitability rule for financial processing in a relational database management system

• US 7,418,415 B1
• Filed: 08/26/2002
• Issued: 08/26/2008
• Est. Priority Date: 12/10/2001
• Status: Expired due to Fees

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: Teredata US, Inc.
• Inventors: Wasserman, Brian J.
• Primary Examiner(s): RUDY, ANDREW J
• Application Number:
  US10/228,031
• Time in Patent Office: 2,192 Days
• Field of Search: 707/102, 705/35, 705/36.R
• US Class Current: 705/35
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes

Abstract

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 each of the rules is represented as one or more objects in a hierarchy, the objects include one or more relations, criteria lists and criteria, each of the relations includes one or more of the criteria lists, and each of the criteria lists includes one or more of the criteria, and the criteria determine which accounts, products and events are processed in the profitability calculations.

Claims

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 process the account, product and event attributes accessed from the database;

(c) wherein each of the rules is represented as one or more objects in a hierarchy, the objects include one or more relations, criteria lists and criteria, each of the relations includes one or more of the criteria lists, and each of the criteria lists includes one or more of the criteria, and the criteria determine which of the account, product and event attributes are processed in the profitability calculations.

2. The method of claim 1, wherein the hierarchy includes a root node and the root node represents the rule.

3. The method of claim 1, wherein the criteria lists are selected from a group comprised of an account criteria list, product criteria list, and event criteria list.

4. The method of claim 1, wherein the criteria are selected from a group comprised of an account attribute criteria, product attribute criteria, and event attribute criteria.

5. The method of claim 1, wherein the criteria comprise one or more elements selected from a group comprising attributes, predicates, operators and functions.

6. The method of claim 1, wherein the criteria compare an attribute to another attribute, a literal value, or a result.

7. The method of claim 1, wherein each of the rules comprises at least one of the criteria lists and the criteria list comprises at least one of the criteria.

8. The method of claim 1, wherein the rules are selected from a group comprising Risk Provision (RP) Rules, Net Interest Revenue (NIR) Rules, Direct Expense (DE) Rules, Indirect Expense (IE) Rules, and Other Revenue (OR) Rules.

9. The method of claim 1, wherein the rules are selected from a group comprising Basic, Intermediate, Advanced, and Breakthrough Rules.

10. The method of claim 1, wherein the objects are stored in a relational database.

11. The method of claim 1, further comprising displaying the hierarchy.

12. The method of claim 1, wherein the objects include queries to load and save the objects.

13. The method of claim 1, wherein each of the relations corresponds to a combination of selection criteria that comprise account attributes, product attributes, and event attributes, as well as predicates, operations and functions operating thereon.

14. A system for financial processing, comprising:

(a) means, performed by a computer, for 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) means, performed by a computer, for performing one or more profitability calculations by applying one or more rules to process the account, product and event attributes accessed from the database;

(c) wherein each of the rules is represented as one or more objects in a hierarchy, the objects include one or more relations, criteria lists and criteria, each of the relations includes one or more of the criteria lists, and each of the criteria lists includes one or more of the criteria, and the criteria determine which of the account, product and event attributes are processed in the profitability calculations.

15. The system of claim 14, wherein the hierarchy includes a root node and the root node represents the rule.

16. The system of claim 14, wherein the criteria lists are selected from a group comprised of an account criteria list, product criteria list, and event criteria list.

17. The system of claim 14, wherein the criteria are selected from a group comprised of an account attribute criteria, product attribute criteria, and event attribute criteria.

18. The system of claim 14, wherein the criteria comprise one or more elements selected from a group comprising attributes, predicates, operators and functions.

19. The system of claim 14, wherein the criteria compare an attribute to another attribute, a literal value, or a result.

20. The system of claim 14, wherein each of the rules comprises at least one of the criteria lists and the criteria list comprises at least one of the criteria.

21. The system of claim 14, wherein the rules are selected from a group comprising Risk Provision (RP) Rules, Net Interest Revenue (NIR) Rules, Direct Expense (DE) Rules, Indirect Expense (IE) Rules, and Other Revenue (OR) Rules.

22. The system of claim 14, wherein the rules are selected from a group comprising Basic, Intermediate, Advanced, and Breathrough Rules.

23. The system of claim 14, wherein the objects are stored in a relational database.

24. The system of claim 14, further comprising means for displaying the hierarchy.

25. The system of claim 14, wherein the objects include queries to load and save the objects.

26. The system of claim 14, wherein each of the relations corresponds to a combination of selection criteria that comprise account attributes, product attributes, and event attributes, as well as predicates, operations and functions operating thereon.

27. 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 rates to process the account, product and event attributes accessed from the database;

(c) wherein each of the rules is represented as one or more objects in a hierarchy, the objects include one or more relations, criteria lists and criteria, each of the relations includes one or more of the criteria lists, and each of the criteria lists includes one or more of the criteria, and the criteria determine which of the account, product and event attributes are processed in the profitability calculations.

28. The article of manufacture of claim 27, wherein the hierarchy includes a root node and the root node represents the rule.

29. The article of manufacture of claim 27, wherein the criteria lists are selected from a group comprised of an account criteria list, product criteria list, and event criteria list.

30. The article of manufacture of claim 27, wherein the criteria are selected from a group comprised of an account attribute criteria, product attribute criteria, and event attribute criteria.

31. The article of manufacture of claim 27, wherein the criteria comprise one or more elements selected from a group comprising attributes, predicates, operators and functions.

32. The article of manufacture of claim 27, wherein the criteria compare an attribute to another attribute, a literal value, or a result.

33. The article of manufacture of claim 27, wherein each of the rules comprises at least one of the criteria lists and the criteria list comprises at least one of the criteria.

34. The article of manufacture of claim 27, wherein the rules are selected from a group comprising Risk Provision (RP) Rules, Net Interest Revenue (NIR) Rules, Direct Expense (DE) Rules, Indirect Expense (IE) Rules, and Other Revenue (OR) Rules.

35. The article of manufacture of claim 27, wherein the rules are selected from a group comprising Basic, Intermediate, Advanced, and Breakthrough Rules.

36. The article of manufacture of claim 27, wherein the objects are stored in a relational database.

37. The article of manufacture of claim 27, further comprising displaying the hierarchy.

38. The article of manufacture of claim 27, wherein the objects include queries to load and save the objects.

39. The article of manufacture of claim 27, wherein each of the relations corresponds to a combination of selection criteria that comprise account attributes, product attributes, and event attributes, as well as predicates, operations and functions operating thereon.