Invention Grant
- Patent Title: Multiple versions of triggers in a database system
-
Application No.: US15192343Application Date: 2016-06-24
-
Publication No.: US10216774B2Publication Date: 2019-02-26
- Inventor: Tammie Dang , Illong A. Huang , David J. Kuang , Fen-Ling Lin , Claire W. McFeely , Maryela E. Weihrauch , Binghui Zhong
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: North Shore Patents, P.C.
- Agent Michele Liu Baillie
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
In managing multiple versions of triggers, a database system creates a first version of a trigger to apply a first set of actions in response to a first triggering event, which includes: creating a first package for the first version of the trigger to include the first set of actions; linking the first package to the database object; and setting the first package as a current version of the trigger. The database system creates a second version of the trigger to apply a second set of actions to the database object in response to a second triggering event, which includes: creating a second package for the second version of the trigger to include the second set of actions; and linking the second package to the database object. In response to a command, the database system sets the current version of the trigger to the second package.
Public/Granted literature
- US20170371905A1 MULTIPLE VERSIONS OF TRIGGERS IN A DATABASE SYSTEM Public/Granted day:2017-12-28
Information query