Patents by Inventor Illong A. HUANG

Illong A. HUANG has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Multiple versions of triggers in a database system
    Patent number: 10970262
    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. The database system also 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. Upon receiving a command to set the current version of the trigger to the second version, the database system sets the second version as the current version of the trigger. When the triggering event of the trigger occurs, the database system determines that the second version is the current version of the trigger, retrieves the second set of actions in the second version, and executes the second set of actions.
    Type: Grant
    Filed: November 27, 2018
    Date of Patent: April 6, 2021
    Assignee: International Business Machines Corporation
    Inventors: Tammie Dang, Illong A. Huang, David J. Kuang, Fen-Ling Lin, Claire W. McFeely, Maryela E. Weihrauch, Binghui Zhong
  • MULTIPLE VERSIONS OF TRIGGERS IN A DATABASE SYSTEM
    Publication number: 20190095386
    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. The database system also 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. Upon receiving a command to set the current version of the trigger to the second version, the database system sets the second version as the current version of the trigger. When the triggering event of the trigger occurs, the database system determines that the second version is the current version of the trigger, retrieves the second set of actions in the second version, and executes the second set of actions.
    Type: Application
    Filed: November 27, 2018
    Publication date: March 28, 2019
    Inventors: Tammie DANG, Illong A. HUANG, David J. KUANG, Fen-Ling LIN, Claire W. MCFEELY, Maryela E. WEIHRAUCH, Binghui ZHONG
  • Multiple versions of triggers in a database system
    Patent number: 10216774
    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.
    Type: Grant
    Filed: June 24, 2016
    Date of Patent: February 26, 2019
    Assignee: International Business Machines Corporation
    Inventors: Tammie Dang, Illong A. Huang, David J. Kuang, Fen-Ling Lin, Claire W. McFeely, Maryela E. Weihrauch, Binghui Zhong
  • MULTIPLE VERSIONS OF TRIGGERS IN A DATABASE SYSTEM
    Publication number: 20170371905
    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.
    Type: Application
    Filed: June 24, 2016
    Publication date: December 28, 2017
    Inventors: Tammie DANG, Illong A. HUANG, David J. KUANG, Fen-Ling LIN, Claire W. MCFEELY, Maryela E. WEIHRAUCH, Binghui ZHONG