International Business Machines Corporation

Michael Alan Venz

Mark William Theuer

Rafal Przemyslaw Konik

Mark John Anderson

Jane Ann Vold

Jonathan Lee Triebenbach

Richard Donald Parrott

Kathy Lynn Passe

Kyle Gilbertson

Kathryn Rose Steinbrink

Randy Keith Rolfe

Theresa Renee Euler

Ritchie Lee Nyland

Russell Edward Bruhnke

Kevin Robert Brettin

Renee Kristin Saxman

Russ Owen

John David Bohush

Susan Liisa Romano

Christine Rose Rand

Michael Allen Rothschild

A method, apparatus and program product modify the behavior of a database trigger. An attribute desired by a user for a database trigger may be received. The attribute may relate to a change in the functionality of the trigger, such as a restriction on trigger behavior. An object that includes the attribute may be generated. The attribute may be associated with and applied to the trigger. In this manner, the attribute may be selectively applied to multiple triggers.

Database trigger modification system and method

In an embodiment, a first row of data is stored in a database. The first row of data is hidden until a current date is later than a hidden expiration date. An indication is returned, to a requestor, that the first row does not exist in response to a query from the requestor that specifies a key that identifies the first row if the current date is before the hidden expiration date. The first row is returned, to the requestor, in response to the query if the current date is after the hidden expiration date.

Displaying hidden rows in a database after an expiration date

In an embodiment, a constraint is created for a database table. The constraint specifies a condition for a first column in the database table and an action. The action specifies whether data that violates the condition is allowed to be stored in the first column. A value and a specification of a second column in the database table are received from a data source. If the second column is identical to the first column, the value violates the condition, and the action specifies that data that violates the condition is allowed to be stored, the value is stored in a row in the database, the row is marked as hidden, and an identification of the constraint that was violated is stored in the row. A query does not return the row that is marked as hidden.

Constraints with hidden rows in a database

An apparatus, program product and method protect data in a database table from unauthorized access through the combination of scrambling the data in the rows and columns of a database table and encrypting the data in different rows and/or columns using different encryption keys. A complementary descrambling and decryption process may then be used by an authorized party to recover the data stored in the scrambled and encrypted table.

Data scrambling and encryption of database tables

A method, system and computer-readable medium for managing the building of indexes are presented. In one embodiment, the method includes the steps of: initiating an index rebuilding process in a computer; detecting a 'Power down' command for the computer; evaluating a progress level of the index rebuilding process; in response to the index rebuilding process exceeding a predetermined completion level, delaying the 'Power down' command until the index rebuilding process is completed; and in response to the index rebuilding process being less than the predetermined completion level, aborting the index rebuilding process and executing the &#x201c;Power down&#x201d; command.

Determining optimal power down of a system while indexes are being rebuilt

Embodiments of the invention provide techniques for processing database triggers having delay attributes. In general, delay attributes may selectively introduce a delay between the firing of a trigger and the execution of the triggered action. The delay may be based on waiting for a specified time interval, waiting until a specified time, or reaching a predetermined threshold of a measure of system performance. The use of delay attributes may enable greater control over the timing of the execution of the triggered action, resulting in reduced impact on the performance of an underlying system.

Affecting database file performance by allowing delayed query language trigger firing

Dependent object processing for triggers

Method and system for activating column triggers in a database management system

Growing community of inventors

Rochester, MN, United States of America

Michael Alan Venz