Abstract: 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.

Abstract: 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 “Power down” command.

Abstract: A method, computer program product or computer system for dynamically controlling the firing of a trigger for a DELETE CASECADE referential constraint in a database management system, which includes defining a DELETE CASCADE Trigger Fire Attribute (DCTFA) for each dependent file of the DELETE CASCADE referential constraint in a database, initializing each DCTFA with a value corresponding to enabling trigger firing or disabling trigger firing, and firing the trigger according to the value of the DCTFA of each dependent file during the DELETE CASCADE.

Abstract: 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.

Abstract: 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.

Abstract: Embodiments of the invention provide techniques for managing database records rejected due to referential constraints. In one embodiment, such rejected records may be processed automatically. More specifically, the foreign key value included in a rejected record may be automatically added to a parent table, and the rejected record may then be re-inserted into the destination table. In another embodiment, rejected records may be stored in a rejection queue. The rejected records may be presented to a user in a graphical user interface (GUI). The GUI may be configured to enable the user to update the parent table to include the missing foreign key value. Additionally, the GUI may be configured to enable the user to select specific records to be inserted into their respective destination tables.

Abstract: 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.

Abstract: A method, system and computer-readable medium for creating and using perishable code are presented. In a preferred embodiment, the method includes the steps of determining if a unit of code is perishable; and in response to determining that the unit of code is perishable, disabling the unit of code, either by deleting the unit of code or by disabling it.

Abstract: 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 “Power down” command.

Abstract: A collating table containing user-defined sort criteria in ranked order is employed in sorting electronic mail messages for display to the user. Entries within the collating table prioritize unread and/or previously viewed messages based upon the address of the sender or similar attributes, and may each contain a specific username and domain address, a domain of user addresses, or a plurality of addresses of either type. Entries within the collating table may be fixed or dynamic, with dynamic entries automatically updated based on historical statistics relating to the frequency and/or speed of response by the user to messages previously received from the sender, speed of opening or deleting prior messages from the sender, or some user-specified combination of such attributes. Addresses within the dynamic entries may percolate up or down the ranking of the collating table, with aging employed in removing addresses from the collating table.

Abstract: Methods, systems and articles of manufacture are provided for setting a state of triggers between operative and inoperative. In an operative state the trigger may be called during triggering I/O operations such as Insert, Update and Delete. The inoperative state indicates that the system has detected a condition requiring user intervention. In a particular embodiment, a database management system (DBMS) will analyze the function being performed on a table (such as a rename of the table) and with dependent object data, the DBMS will determine if the trigger is self-referencing. If so, the trigger made inoperative. Making the trigger inoperative and requiring user intervention prevents the system from potentially producing undesired results. In another embodiment, a determination of dependency is made upon receiving a database command to affect an object. According to the type of command, the object and its dependents are either affected or unaffected.

Abstract: A collating table containing user-defined sort criteria in ranked order is employed in sorting electronic mail messages for display to the user. Entries within the collating table prioritize unread and/or previously viewed messages based upon the address of the sender or similar attributes, and may each contain a specific username and domain address, a domain of user addresses, or a plurality of addresses of either type. Entries within the collating table may be fixed or dynamic, with dynamic entries automatically updated based on historical statistics relating to the frequency and/or speed of response by the user to messages previously received from the sender, speed of opening or deleting prior messages from the sender, or some user-specified combination of such attributes. Addresses within the dynamic entries may percolate up or down the ranking of the collating table, with aging employed in removing addresses from the collating table.

Abstract: Methods, systems and articles of manufacture are provided for setting a state of triggers between operative and inoperative. In an operative state the trigger may be called during triggering I/O operations such as Insert, Update and Delete. The inoperative state indicates that the system has detected a condition requiring user intervention. In a particular embodiment, a database management system (DBMS) will analyze the function being performed on a table (such as a rename of the table) and with dependent object data, the DBMS will determine if the trigger is self-referencing. If so, the trigger made inoperative. Making the trigger inoperative and requiring user intervention prevents the system from potentially producing undesired results.

Abstract: A method and apparatus are provided for self-programmable temperature and usage control for a hot water heater. A plurality of user entered selections are received. Idle periods of a set time duration are detected and stored. Responsive to an idle period start time, a control temperature is set to a lower than normal temperature. Responsive to an idle period end time, the control temperature is set to a normal temperature. A sleep mode is automatically started responsive to idle times, and a vacation mode is automatically started responsive to an identified number of days of no water usage. In the sleep mode, the control temperature is set to a lower than normal temperature. In the vacation mode, the control temperature is set to a substantially lower than normal temperature or the water heater is turned off. The user entered selections can include a normal temperature, a sleep temperature for the idle periods, and a vacation temperature.

Abstract: The disclosure is directed to fiber blends of melamine resin fibers and aramid fibers.