International Business Machines Corporation

San Yu Phoenix

Kalpana Shyam

Julie Ann Watts

James Zu-Chia Teng

Jay A Yothers

Christina Marie Lee

Christopher John Crone

David L Levish

Charles Roy Bonner

Karelle Lynne Cornwell

Michael R Shadduck

Margaret Ann Bernal

Stephen Walter Turnbaugh

Robert J Hollines, Iii

Claire Louise McFeely

Richard Vincent Becraft, Jr

Robert William Engles, Deceased

Traditional update semantics are provided when updates change the location of records in a database. The system detects that an update to a record will cause the record to change locations in a database from an original location to an updated location. The system selectively prevents activity in the database between the original location and update location until the updated record has changed locations in the database from the original location to the updated location.

Providing traditional update semantics when updates change the location of data records

Provided is a method, system, program, and data structures for making data available to an application program. A result table is generated including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause. The result table includes, for each row, a location identifier of the corresponding row in the base table and a column for each column in a query select list. The result table is accessed to return requested data from the base table to the application program.

Method, system, and program for processing a fetch request for a target row in a table that precedes as current row

Method, system, and program for processing a fetch request for a target row at an absolute position from a first entry in a table

Method, system, and program for processing modifications to data in tables in a database system

A method, system and program for accessing records in a database object, such as an index or table. A cursor is maintained that points to a start entry in the database object. The database object has rows and columns of values. A runtime component receives a command to return a kth entry in the object having column values that satisfy predicates in a query statement. The runtime component calls a manager component that accesses entries in the database object to return the kth entry in the object having column values that satisfy the predicates. The manager component moves the cursor through sequential entries in the database object, in either the forward or reverse direction, until a kth entry that satisfies the predicates from the start entry is reached. The manager component positions the cursor to an entry that is the kth entry that satisfies the predicates from the start entry and returns data from the kth entry pointed to by the cursor to the runtime component.

Method, system and program for scrolling index scans

Method, system, and program for using control data structures when performing operations with respect to a database

A method, apparatus, and article of manufacture for a computer implemented data manager. A statement is executed in a computer. The statement being performed by the computer to access data from a database stored on a data storage device connected to the computer. A determination is made as to whether to defer referential integrity checking when executing the statement. When it is determined that referential integrity checking is to be deferred, each record is processed that is specified in the statement. Keys for select records are stored as each record is processed. Then, after executing the statement, referential integrity checking is performed on the stored keys.

Deferred referential integrity checking based on determining whether row

Growing community of inventors

Morgan Hill, CA, United States of America

San Yu Phoenix