Parallel selection processing for financial processing in a relational database management system
AssigneeNCR Corporation
InventorBrian Jay Wasserman
Life of this patent
Estimating the term…
Abstract
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.
Claims11
A method of performing financial processing in a computer, comprising:
- (a) selecting accounts and events from a database through parallel processing of a selector function that uses one or more selection criteria to determine which accounts and events should be selected from the database, wherein the selector function dynamically generates Structured Query Language (SQL) statements to select the accounts and events from the database using the selection criteria, the selection criteria are grouped in order to combine them in the dynamically generated SQL statements, the grouped selection criteria are processed independently and in parallel to create temporary work tables, and the temporary work tables are combined to yield output tables comprising attributes of the accounts and events selected from the database;
- and
- (b) performing one or more profitability calculations in the computer using the attributes of the accounts and events selected from the database.
Dependencies are inferred from the claim text.