Driver amount and count selection processing for financial processing in a relational database management system
AssigneeTeradata US, Inc.
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.
Claims14
A method of performing financial processing in computer, comprising:
- (a) selecting accounts and events from a database through a selector function, wherein the selector function uses one or more selection criteria to determine which account and event attributes are selected from the database, similar ones of the selection criteria are grouped together to dynamically generate structured query language statements that are processed in parallel to create temporary work tables, and the temporary work tables are combined to yield output tables comprising the account and event attributes selected from the database;
- and (b) performing one or more profitability calculations in the computer using the accounts and events attributes selected from the database, wherein the profitability calculations use one or more rules applied to the attributes, each rule is comprised of source, target and driver components, and each of the source, target and driver components have selection criteria.
The method of cairn 5, wherein the specification of the amount, combined with the selection criteria, requires that the selector function dynamically select proper sets of the accounts and events, and aggregate the amounts.
Dependencies are inferred from the claim text.