Abstract: A universal jig/work holding fixture for precision manual reaming of valve bores within a transmission valve body, or other work piece is disclosed. The universal jig/work holding fixture includes a tool holder (i.e. jig) having universal swiveling movement in all axes, which allows precise axial alignment of a reaming tool to the longitudinal axis of a valve bore. The universal jig is contained within a work holding fixture whereon the valve body or other work piece is clamped during the reaming operation. The work holding fixture is constructed to accommodate vertical and lateral adjustment of the tool holder relative to the work holding fixture to permit precise alignment of the reaming tool and provides mechanisms to lock the tool holder and work piece in a desired position. The universal jig/work holding fixture allows a service technician in a transmission shop environment to achieve a precision repair using only manual tools.

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