Selector function for life-time value financial processing in a relational database management system

• US 7,752,100 B1
• Filed: 08/20/2003
• Issued: 07/06/2010
• Est. Priority Date: 06/29/2000
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: Terodata US Incorporated
• Inventors: Schwarz, Richard C., Ryan, Thomas K., Wasserman, Brian J.
• Primary Examiner(s): Karmis; Stefanos
• Assistant Examiner(s): LEMIEUX, JESSICA
• Application Number:
  US10/644,422
• Time in Patent Office: 2,512 Days
• Field of Search: 705/35
• US Class Current: 705/35
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03

Abstract

A Life-Time Value system is a data-driven computer-facilitated financial model that provides accurate and consistent profitability projections using current period account level profitability data stored in a Relational Database Management System. The Life-Time Value system performs Net Present Value and Future Value calculations using accounts, amounts and rates retrieved from the Relational Database Management System by a Selector function using selection criteria specified by one or more rules. The results from the Net Present Value and Future Value calculations are integrated to provide a Life-Time Value of one or more customers.

Claims

1. A method of performing financial processing in one or more computers, comprising:

(a) selecting, in the one or more computers, accounts, forecast amounts, and attrition and propensity rates from a database through parallel processing of a selector function, wherein the selector function uses selection criteria specified by rules to select the accounts, forecast amounts, and attrition and propensity rates from the database, the selector function dynamically generates Structured Query Language (SQL) statements using the selection criteria, the selection criteria are grouped in order to combine them in the dynamically generated SQL statements, and the grouped selection criteria are processed independently and in parallel to yield output tables comprising the accounts, forecast amounts, and attrition and propensity rates selected from the database;

(b) performing, in the one or more computers, one or more Net Present Value (NPV) and Future Value (FV) calculations on the selected accounts using the selected forecast amounts and attrition and propensity rates, wherein results from the NPV and FV calculations are integrated to provide a Life-Time Value (LTV) of one or more customers for presentation to a user; and

(c) providing, by the one or more computers, the LTV to the user.

2. The method of claim 1, wherein the NPV is a net present profitability value.

3. The method of claim 1, wherein the FV is a possible future profitability value.

4. The method of claim 1, wherein the accounts comprise current profitability values of accounts for the customers.

5. The method of claim 1, wherein the NPV and FV calculations are based on the rules.

6. The method of claim 1, wherein the grouped selection criteria comprise similar selection criteria.

7. The method of claim 1, wherein the statements are generated from one or more object-oriented parameterized templates.

8. The method of claim 1, wherein the statements are optimized so that the statements are executed in parallel by the database management system.

9. The method of claim 1, wherein the statements include one or more macros.

10. A system for performing financial processing by one or more computers comprising:

(a) the one or more computers configured to select accounts, forecast amounts, and attrition and propensity rates from a database through parallel processing of a selector function, wherein the selector function uses selection criteria specified by rules to select the accounts, forecast amounts, and attrition and propensity rates from the database, the selector function dynamically generates Structured Query Language (SQL) statements using the selection criteria, the selection criteria are grouped in order to combine them in the dynamically generated SQL statements, and the grouped selection criteria are processed independently and in parallel to yield output tables comprising the accounts, forecast amounts, and attrition and propensity rates selected from the database;

(b) the one or more computers configured to perform, one or more Net Present Value (NPV) and Future Value (FV) calculations on the selected accounts using the selected forecast amounts and attrition and propensity rates, wherein results from the NPV and FV calculations are integrated to provide a Life-Time Value (LTV) of one or more customers for presentation to a use; and

(c) the one or more computers configured to provide the LTV to the user.

11. The system of claim 10, wherein the NPV is a net present profitability value.

12. The system of claim 10, wherein the FV is a possible future profitability value.

13. The system of claim 10, wherein the accounts comprise current profitability values of accounts for the customers.

14. The system of claim 10, wherein the NPV and FV calculations are based on the rules.

15. The system of claim 10, wherein the grouped selection criteria comprise similar selection criteria.

16. The system of claim 10, wherein the statements are generated from one or more object-oriented parameterized templates.

17. The system of claim 10, wherein the statements are optimized so that the statements are executed in parallel by the database management system.

18. The system of claim 10, wherein the statements include one or more macros.

19. An article of manufacture embodying instructions that, when read and executed by one or more computers, results in the one or more computers performing a method of financial processing, the method comprising:

(a) selecting, in the one or more computers, accounts, forecast amounts, and attrition and propensity rates from a database through parallel processing of a selector function, wherein the selector function uses selection criteria specified by rules to select the accounts, forecast amounts, and attrition and propensity rates from the database, the selector function dynamically generates Structured Query Language (SQL) statements using the selection criteria, the selection criteria are grouped in order to combine them in the dynamically generated SQL statements, and the grouped selection criteria are processed independently and in parallel to yield output tables comprising the accounts, forecast amounts, and attrition and propensity rates selected from the database;

(b) performing, in the one or more computers, one or more Net Present Value (NPV) and Future Value (FV) calculations on the selected accounts using the selected forecast amounts and attrition and propensity rates, wherein results from the NPV and FV calculations are integrated to provide a Life-Time Value (LTV) of one or more customers for presentation to a user; and

(c) providing, by the one or more computers, the LTV to the user.

20. The article of claim 19, wherein the NPV is a net present profitability value.

21. The article of claim 19, wherein the FV is a possible future profitability value.

22. The article of claim 19, wherein the accounts comprise current profitability values of accounts for the customers.

23. The article of claim 19, wherein the NPV and FV calculations are based on the rules.

24. The article of claim 19, wherein the grouped selection criteria comprise similar selection criteria.

25. The article of claim 19, wherein the statements are generated from one or more object-oriented parameterized templates.

26. The article of claim 19, wherein the statements are optimized so that the statements are executed in parallel by the database management system.

27. The article of claim 19, wherein the statements include one or more macros.