Patent ID: 6598041
Filing Date: 2003-07-22
Classification: G06F,Y10S

Abstract:
A method for making data available to an application program, comprising:generating a result table 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, wherein the result table includes, for each row, a location identifier identifying the corresponding row in the base table and a column for each column in a query select list; receiving a fetch request to fetch a specified row in the result table; determining whether to use the location identifier for the specified row to return data to the fetch request; if the location identifier is determined to be used, then using the location identifier to access the row in the base table corresponding to the specified row in the result table to return requested data from the corresponding row in the base table to the fetch request; and if the location identifier is determined to not be used, then returning data from the specified row in the result table to the fetch request.