Selection processing 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 and event data stored in a relational database managed by a relational database management system (RDBMS), wherein the account data comprises attributes of the accounts being measured and the event data comprises attributes of account-related transactions. A selector function uses selection criteria to select accounts and events from the relational database in order to generate a number of inputs for profitability calculations.
1. A computer-implemented method of performing financial processing, comprising:
(a) selecting accounts and events from a database through a selector function performed by a computer, wherein the selector function is programmed to use event thresholding to select the accounts from the database based on a threshold test for related events selected from the database; and
(b) performing one or more profitability calculations in the computer using attributes of the accounts and events selected from the database.
2. The method of claim 1 , wherein the event thresholding uses a specified number of a specified combination of attributes of the events to select the accounts.
3. The method of claim 2 , wherein the specified number comprises an amount of the attributes.
4. The method of claim 2 , wherein the specified number comprises a count of the attributes.
5. The method of claim 2 , wherein the accounts are selected when the specified number exceeds a specified threshold.
6. A system for performing financial processing, comprising:
one or more computers;
logic, performed by the computers, for:
(a) selecting accounts and events from a database through a selector function, wherein the selector function is programmed to use event thresholding to select the accounts from the database based on a threshold test for related events selected from the database; and
(b) performing one or more profitability calculations using attributes of the accounts and events selected from the database.
7. The system of claim 6 , wherein the event thresholding uses a specified number of a specified combination of attributes of the events to select the accounts.
8. The system of claim 7 , wherein the specified number comprises an amount of the attributes.
9. The system of claim 7 , wherein the specified number comprises a count of the attributes.
10. The system of claim 7 , wherein the accounts are selected when the specified number exceeds a specified threshold.
11. An article of manufacture comprising a storage device embodying instructions that, when read and executed by a computer, result in the computer performing a method of financial processing, comprising:
(a) selecting accounts and events from a database through a selector function performed by a computer, wherein the selector function is programmed to use event thresholding to select the accounts from the database based on a threshold test for related events selected from the database; and
(b) performing one or more profitability calculations in the computer using attributes of the accounts and events selected from the database.
12. The article of manufacture of claim 11 , wherein the event thresholding uses a specified number of a specified combination of attributes of the events to select the accounts.
13. The article of manufacture of claim 12 , wherein the specified number comprises an amount of the attributes.
14. The article of manufacture of claim 12 , wherein the specified number comprises a count of the attributes.
15. The article of manufacture of claim 12 , wherein the accounts are selected when the specified number exceeds a specified threshold.