Abstract: An index advice record engine generates and stores index advice records. An index advice policy mechanism allows a user to define an index advice policy that specifies criteria for autonomic index creation. An autonomic index creation mechanism reads the index advice records, compares this information with the criteria in the user-defined index advice policies, and determines whether an index should be created based on the information in the index advice records and the index advice policies. By automating the process of creating indexes according to user-defined policies, the preferred embodiments alleviate human users from most of the work of manually creating indexes.

Abstract: Disclosed is an apparatus, method, and program product for performing efficient database access plan caching. Unlike prior art mechanism that automatically discard stored access plans whenever the need for a different access plans is detected, stored plans are intelligently retained despite the handling of one or more infrequent queries that call for the use of a different plan.

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: Disclosed is an apparatus, method, and program product for performing efficient database access plan caching. Unlike prior art mechanism that automatically discard stored access plans whenever the need for a different access plans is detected, stored plans are intelligently retained despite the handling of one or more infrequent queries that call for the use of a different plan.

Abstract: Methods, systems, data structures and articles of manufacture are provided for maintaining a list/tally of columns that are modified by an I/O operation. The list allows for determining which triggers, both row and column oriented, should be activated upon the operation. In addition, a tracking mechanism is provided to track modifications to additional columns that occur because of the triggers being executed. In another embodiment, management of modifications to existing database objects (i.e., table definitions) is automated. Modifications to the table definition include, for example, changing the number of columns and the data type definitions. Accordingly, in one embodiment, if a column is added or removed from a database table, the database management system automatically updates and manages the tracking mechanism so the actual number of columns that exist in the database table is accurately reflected. In this manner, the integrity of the DBMS is maintained.

Abstract: Methods, systems, data structures and articles of manufacture are provided for monitoring access to a database. In one embodiment, a data access trigger, or read trigger, is adapted to monitor accesses to a database. In general, a data access trigger is invoked when predefined events occur. Specifically, a data access trigger is executed to take some action due to any attempt to access a database. When a specified access attempt is determined, the trigger can instruct the system to take any number of actions, such as modify the data being requested. In one embodiment, a log is provided in which accesses to the database are recorded. The log may subsequently reviewed to ascertain whether a particular record was accessed and by whom. In addition, the particular information accessed and/or modified can be contained in the log.

Abstract: Methods, systems, data structures and articles of manufacture are provided for maintaining a list/tally of columns that are modified by an I/O operation. The list allows for determining which triggers, both row and column oriented, should be activated upon the operation. In addition, a tracking mechanism is provided to track modifications to additional columns that occur because of the triggers being executed.

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: Methods, systems, data structures and articles of manufacture are provided for monitoring access to a database. In one embodiment, a data access trigger, or read trigger, is adapted to monitor accesses to a database. In general, a data access trigger is invoked when predefined events occur. Specifically, a data access trigger is executed to take some action due to any attempt to access a database. When a specified access attempt is determined, the trigger can instruct the system to take any number of actions, such as modify the data being requested.

Abstract: A method and computer program product are provided for implementing translatable text in user modifiable standard query language (SQL) scripts. A set of multiple queries are generated including comments and associated delimited names. The comments and associated delimited names are translated into multiple language versions. A user selected national language is identified. The user selected national language version of the translated comments and associated delimited names are utilized for generating a query. In accordance with features of the invention, the user is given the option to view the query and to make any desired modifications.

Abstract: A method and computer program product are provided for processing system files. An associated trigger program is attached to each respective system file. The associated trigger program is utilized for pre-processing the respective system file to identify predetermined information. The identified predetermined information is stored in an internal structure. The internal structure is utilized to access the predetermined information when required to perform a query.