Inventors:
Mark John Anderson - Oronoco MN
Theresa Renee Euler - Oronoco MN
Russ Owen - Rochester MN
Richard Donald Parrott - Rochester MN
Kathy Lynn Passe - Oronoco MN
Jonathan Lee Triebenbach - Rochester MN
Michael Alan Venz - Rochester MN
Jane Ann Vold - Byron MN
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 1700
US Classification:
707102, 707 2, 707 10, 707100, 707101, 707103, 707104
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.