Abstract: A method, apparatus, and program product restore database data having dependencies or ordering sensitivities, or that incorporates a database index. Unresolved dependencies are identified in response to an attempt to restore data in a computer. The data restoration is deferred and the data is cached when it has an unresolved dependency. After the dependency is resolved, the data restoration is completed. The unresolved dependency may be based-on data that must be restored or created prior to completing restoration. Deferred data is cached in memory and tracked in a deferred operation table. Data that is deferred may be accessed so long as operations that access the underlying based-on data are denied.

Abstract: A method, apparatus, and program product restore database data having dependencies or ordering sensitivities, or that incorporates a database index. Unresolved dependencies are identified in response to an attempt to restore data in a computer. The data restoration is deferred and the data is cached when it has an unresolved dependency. After the dependency is resolved, the data restoration is completed. The unresolved dependency may be based-on data that must be restored or created prior to completing restoration. Deferred data is cached in memory and tracked in a deferred operation table. Data that is deferred may be accessed so long as operations that access the underlying based-on data are denied.

Abstract: Systems and methods are provided for handling synchronous requests from a requesting entity. Illustratively, the requesting entity is in a database management system and the requests are made to a catalog server. The catalog server is configured to respond to the requests by accessing a catalog database. An interface is provided between an application and a catalog server. The interface is configured to determine whether the catalog server is available to handle requests. If the catalog server is unavailable and if the request is a synchronous request, the interface determines whether the request may be processed asynchronously.

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: 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 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: Systems and methods are provided for handling synchronous requests from a requesting entity. Illustratively, the requesting entity is in a database management system and the requests are made to a catalog server. The catalog server is configured to respond to the requests by accessing a catalog database. An interface is provided between an application and a catalog server. The interface is configured to determine whether the catalog server is available to handle requests. If the catalog server is unavailable and if the request is a synchronous request, the interface determines whether the request may be processed asynchronously.