International Business Machines Corporation

Theresa Renee Euler

Mark John Anderson

Jonathan Lee Triebenbach

Richard Donald Parrott

Russ Owen

John Matthew Santosuosso

Eric L Barsness

Gary Ross Ricard

Daniel Beuch

Timothy Joseph Torzewski

Kathryn Rose Steinbrink

Michael Alan Venz

Craig Stephen Aldrich

Paul S Nelsestuen

Randy Keith Rolfe

Jane Ann Vold

Steven Virgil Hoeschen

Ritchie Lee Nyland

Kevin Robert Brettin

Renee Kristin Saxman

Scott Joseph Heimer

Kathy Lynn Passe

Wayne Christopher Sadecki

A deterministic UDF processing mechanism processes user-defined functions (UDFs) using multiple hash tables. Data access patterns for a UDF are collected, and an appropriate hash table set is then determined for the UDF from the data access patterns. If a UDF accesses some similar columns and some disjoint columns, the similar columns are grouped together, and one or more hash tables are allocated to the similar columns. Disjoint columns are allocated their own hash tables. In addition, the allocation of hash tables may be adjusted based on historical access patterns collected over time. By dynamically allocating and adjusting sets of hash tables to a deterministic UDF, the performance of the UDF is greatly increased.

Processing of deterministic user-defined functions using multiple corresponding hash tables

Method and system for activating column triggers in a database management system

Method and system for monitoring and securing data access in a database system

A method and system of journal bundling that provides improved performance. In the preferred embodiment, a journal controller starts a timer to expire at a predetermined maximum time-to-wait. The journal controller then accumulates journal records in a bundle and transmits the bundle to the journal. The journal controller determines the number-of-journal-records accumulated in the bundle based on an adjustable preferred-bundle-size, which it calculates from an average-bundle-size over a history interval. If the timer expires, the journal controller writes the bundle to the journal even if the preferred-bundle-size has not been reached. By basing the preferred-bundle-size on an average-bundle-size over a history interval, the journal controller prevents rapid changes in the journal traffic-rate, which increases journal performance.

Adaptive time-based journal bundling

Growing community of inventors

Oronoco, MN, United States of America

Theresa Renee Euler