International Business Machines Corporation

Gregory R E Wiley

Anthony Paul Scherk

Timothy G Shanahan

Timothy R Schwarzen

Charles Matula

Andrea C Martinez

David Henry Starke

The present invention provides a system and methods for managing large user selections in an application. An invertible collection software module solves the problem of managing a large number of user selections within an application. When not inverted, the invertible collection tracks what a user has selected. When inverted, the invertible collection tracks what a user has not selected thus saving memory. One method may comprise defining a specific context having a set of items available for user selection, representing, by an empty inverted invertible collection, the selection of all items within the specific context, tracking one or more items a user has deselected within the specific context depending upon whether the collection is inverted or not inverted and tracking one or more items a user has deselected.

Managing large user selections in an application

System, method and program product for generating a trigger program that updates an entry in a dependent column in a table in response to a request to update a corresponding entry in a parent column in the table. A trigger program template is provided. The trigger program template includes program steps which indicate a type of update to an entry in an unspecified parent column which triggers an update to a corresponding entry in an unspecified dependent column. The trigger program template also indicates a type of the unspecified dependent column to update upon the update to the entry in the unspecified parent column. The table is automatically scanned to identify one or more dependent columns of the type. In response to identification of the one or more dependent columns of the type, a name of a parent column, corresponding to the one or more dependent columns, is inserted in the trigger program template steps to identify the corresponding parent column as the unspecified parent column and identify the one or more dependent columns as the unspecified dependent columns. Names of the one or more dependent columns comprise the name of the specified parent column and respective suffixes indicating the types of the dependent columns.

System, method and program product for generating triggers for a relational database

Growing community of inventors

Wappingers Falls, NY, United States of America

Gregory R E Wiley