Account selection for financial processing in a relational database management system

• US 7,693,761 B1
• Filed: 12/10/2001
• Issued: 04/06/2010
• Est. Priority Date: 06/29/2000
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Wasserman, Brian Jay
• Primary Examiner(s): Rudy; Andrew Joseph
• Application Number:
  US10/013,422
• Time in Patent Office: 3,039 Days
• Field of Search: 705/36, 705/1, 705/8, 705/30, 705/35, 705/36.R, 705/38, 706/1, 706/10, 706/102
• US Class Current: 705/35
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: Y10S 707/95 Financial
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

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.

Claims

1. A method of performing financial processing in a 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 accounts and events should be selected from the database and the selection criteria compare an account attribute to another account attribute, a literal value, or a domain value; and

(b) performing one or more profitability calculations in the computer using the accounts and events selected from the database;

(c) wherein the selector function groups the selection criteria together, when the selection criteria are similar, and processes the grouped selection criteria in parallel in the database.

2. The method of claim 1, wherein the selection criteria are selected from a group comprising attributes, predicates, operators and functions.

3. The method of claim 1, wherein a group of the accounts that satisfy the selection criteria comprise partitions.

4. The method of claim 1, wherein the selector function groups the selection criteria when dynamically generating Structured Query Language (SQL) statements to select the accounts from the database using the selection criteria.

5. The method of claim 4, wherein the grouped selection criteria are applied to the accounts at a similar level.

6. The method of claim 4, wherein the grouped selection criteria access similar account attributes.

7. The method of claim 1, wherein the grouped selection criteria access similar tables.