Ncr Corporation

Teradata Us, Inc.

Teradota Us, Inc.

Paul H Phibbs

Linette Draper

Thomas Kevin Ryan

George Robert Hood

Marianne Ruegsegger

Brian Jay Wasserman

Graphical User Interfaces for custom lists and labels are provided. A database includes fields that define views when processed by an application server on behalf of a user. At least one view permits the user to supply criteria for custom defining lists or sets of labels, which are also retrieved from the database by the application server.

Graphical user interfaces for custom lists and labels

Techniques for data store list generation and management are provided. A user supplies criteria for a list via a graphical user interface tool. The criteria are used to generate a query, and the query when executed against a data store produces results representing the list. The list may then be used for a variety of purposes.

Data store list generation and management

Techniques for using database metric results are provided. Structure Query Language (SQL) statements are parsed for multiple metric calculations. Each metric calculation is dynamically processed against a database to obtain combined results. The combined results are fed to remaining portions of the SQL statements as a source for or a driver to the remaining portions of the SQL statements.

Techniques for using database metric results

Techniques for database rule ordering and processing are provided. Structured Query Language (SQL) statements are iterated to identify processing dependencies and a processing order is generated. The SQL statements are automatically modified to enforce the processing order and the modified SQL statements are executed against a database.

Techniques for database rule ordering and processing

A Value Analyzer system is a data-driven computer-facilitated financial model that provides accurate and consistent profitability calculations using account, product and event attributes stored in a relational database managed by a relational database management system (RDBMS). Profitability calculations are performed in the computer by applying one or more rules to the account, product and event attributes accessed from the database, wherein the profitability calculations include setup, generation and execution of structured query language (SQL) statements by the RDBMS. The present invention also monitors the profitability calculations by monitoring the setup, generation and execution of the SQL statements by the RDBMS, in order to provide bypass, logging, user restartability, or status (BLURS) functions for the profitability calculations.

Application code generation and execution with bypass, logging, user restartability and status functionality

A financial processing system that accesses account, event and organization attributes from a relational database management database, wherein: (1) the account attributes comprise data about accounts being measured, (2) the event attributes comprise data about account-related transactions, and (3) the organization attributes comprise data about the organization's financial status. Profitability calculations are performed using the account, event and organization attributes accessed from the relational database management system, as well as one or more profit factors and one or more rules. The profitability calculations include the following: In this calculation, the Net Interest Revenue (NIR) comprises: 

Basic and intermediate net interest revenue implementations for financial processing in a relational database management system

A financial processing system that accesses account, event and organization attributes from a relational database management database, wherein: (1) the account attributes comprise data about accounts being measured, (2) the event attributes comprise data about account-related transactions, and (3) the organization attributes comprise data about the organization's financial status. Profitability calculations are performed using the account, event and organization attributes accessed from the relational database management system, as well as one or more profit factors and one or more rules. The profitability calculations include the following:  In this calculation, the Net Income Revenue (NIR) comprises: 

Advanced and breakthrough net interest revenue implementation for financial processing in a relational database management system

A financial processing system that accesses account, event and organization attributes from a relational database management database, wherein: (1) the account attributes comprise data about accounts being measured, (2) the event attributes comprise data about account-related transactions, and (3) the organization attributes comprise data about the organization's financial status. Profitability calculations are performed using the account, event and organization attributes accessed from the relational database management system, as well as one or more profit factors and one or more rules. The profitability calculations include the following: In this calculation, the Net Interest Revenue (NIR) comprises: The Net Interest Revenue (NIR) is calculated as: The Cost of Funds includes Allocated Balances that are used to assign balance sheet amounts that are not actual account balances to the accounts for the calculated Net Interest Revenue (NIR).

Allocated balances in a net interest revenue implementation for financial processing in a relational database management system

A financial processing system that accesses account, event and organization attributes from a relational database management database, wherein: (1) the account attributes comprise data about accounts being measured, (2) the event attributes comprise data about account-related transactions, and (3) the organization attributes comprise data about the organization's financial status. Profitability calculations are performed using the account, event and organization attributes accessed from the relational database management system, as well as one or more profit factors and one or more rules. The profitability calculations include the following: In this calculation, the Net Interest Revenue (NIR) comprises: The Earnings on Allocated Equity includes an identification of how much equity to allocate to the accounts, and one or more rates used in the calculation of the NIR due to the allocation.

Growing community of inventors

Escondido, CA, United States of America

Paul H Phibbs