公开(公告)号：CA2357639A1

公开(公告)日：2002-04-13

申请号：CA2357639

申请日：2001-09-24

Applicant: IBM

Inventor： LEE CHRISTINA MARIE ,  LEVISH DAVID L ,  HOLLINES ROBERT J III ,  PHOENIX SAN YU ,  SHADDUCK MICHAEL R

IPC: G06F3/00 ,  G06F17/30

Abstract: Provided is 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 ent ry 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 satisf y predicates in a query statement. The runtime component calls a manager component that access es 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 entrie s 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.

公开(公告)号：AU2003288393A1

公开(公告)日：2004-07-14

申请号：AU2003288393

申请日：2003-11-27

Applicant: IBM

Inventor： FRISKE CRAIG ALAN ,  GARTH JOHN MARLAND ,  LEE CHRISTINA MARIE ,  RUDDY JAMES ALAN

IPC: G06F17/30

Abstract: One or more indexes are built on data (concurrent with manipulation of data) wherein the index build operation is done without restricting the manipulation of data. The index is brought to consistency with the data based upon processing recovery log records to simulate index manipulations during data insert, update, or delete operations.