International Business Machines Corporation

Alibaba Group Holding Limited

Craig Stephen Aldrich

Mark John Anderson

Rafal Przemyslaw Konik

Roger Alan Mittelstadt

Scott Patrick Hanson

Jane Ann Vold

Stephanie A Burrichter

Brian Robert Muras

Kathryn Rose Steinbrink

Thomas James Schreiber

Randy Keith Rolfe

Steven Virgil Hoeschen

Jonathan Lee Triebenbach

Lynnette Elaine Carston

Theresa Renee Euler

Ritchie Lee Nyland

Donald F Zimmerman

Richard Donald Parrott

Kevin Robert Brettin

Renee Kristin Saxman

Russ Owen

Scott Joseph Heimer

Wayne Christopher Sadecki

Matthew A Neill

A method of controlling resynchronization of a source database and a target database may comprise detecting that a connection between the source database and the target database has been restored. Based on the detecting, the method may also comprise identifying a first edit flag for a first row in a first table on the source database. Based on the identifying, the method may also comprise sending the first row from the source database to the target database. Based on the sending, the method may also comprise clearing the first edit flag for the first row.

Per row database resynchronization

Disclosed aspects relate to transforming a user-defined table function (UDTF) to a derived table in a database management system (DBMS). It may be detected by the DBMS that a query indicates the UDTF. A derived table may be constructed from the UDTF. The derived table may be derived from a set of statements of the UDTF. The derived table may be introduced to the query to fulfill the UDTF. A query plan may be generated for the query by the DBMS. The query plan may be generated in response to introducing the derived table in the query.

Transforming a user-defined table function to a derived table in a database management system

A query optimizer improves the efficiency of a computer database system utilizing an input-output correlator used with a create function that indicates a correlation between an input to the function and an output of the function. In an example, the input-output correlator is an OR OUTPUT parameter of a create table function. The query optimizer determines whether it can pass a value of a query to the input of the function in response to the input-output correlator. Under appropriate conditions, the query optimizer passes the query value to the input of the function to significantly reduce the amount of data returned by the function thereby reducing the load on database resources.

Correlation of input and output parameters for a function in a database management system

Disclosed is an apparatus, method, and program product for performing efficient database access plan caching. Unlike prior art mechanism that automatically discard stored access plans whenever the need for a different access plans is detected, stored plans are intelligently retained despite the handling of one or more infrequent queries that call for the use of a different plan.

Data management system that provides intelligent access plan caching

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

Growing community of inventors

Rochester, MN, United States of America

Craig Stephen Aldrich