International Business Machines Corporation

Beth Rivenes Moore

Balakrishna Raghavendra Iyer

Kalpana Shyam

Bryan Frederick Smith

Tammie Dang

Karelle Lynne Cornwell

Yao Ching Stephen Chen

Peter Hoa

Provided is a method, system, and program for implementing a database trigger. Upon detecting a trigger event, a determination is made of at least one row in a base table affected by the trigger event. For each column in the base table of a data type that is referenced in a triggered action associated with the trigger event, a reference is generated referencing the data of the data type. The reference is inserted in a transition table column including data of the data type from the affected row in the base table referenced in the triggered action. The reference is used to access the data of the data type when performing the triggered action.

Method, system, and program for implementing a database trigger

A method, apparatus, and article of manufacture for a computer implemented groupby aggregation system. Groupby aggregation is performed when a statement is executed in a database stored on a data storage device, which is connected to a computer. Initially, data elements are input into a tournament tree from an input sequence. Then, a winner of a tournament in the tournament tree is identified. The winner is recycled into the tournament tree.

Efficient groupby aggregation in tournament tree sort

Growing community of inventors

Morgan Hill, CA, United States of America

Beth Rivenes Moore