Method, system, and program for accessing rows in one or more tables satisfying a search criteria
First Claim
1. A method for accessing rows of data from a base table satisfying a search criteria, comprising:
- receiving an initial request to access rows in the base table including the search criteria specifying predicates for one or more columns in the base table;
generating a data structure to include information on qualifying base table rows that satisfy the search criteria;
providing notification that the qualifying base table rows are accessible before information on all the qualifying base table rows is included in the data structure; and
receiving a request for one qualifying base table row;
determining whether the data structure includes information on the requested qualifying base table row; and
using the information in the data structure to provide access to the requested qualifying base table row.
1 Assignment
0 Petitions
Accused Products
Abstract
Provided is a method, system, and program for accessing rows of data from a base table satisfying a search criteria. An initial request to access rows in the base table is received, including the search criteria specifying predicates for one or more columns in the base table. A data structure is generated to include information on qualifying base table rows that satisfy the search criteria. Notification is provided that the qualifying base table rows are accessible before information on all the qualifying base table rows is included in the data structure. A request is then received for one qualifying base table row. A determination is made as to whether the data structure includes information on the requested qualifying base table row. If so, the information in the data structure is used to provide access to the requested qualifying base table row.
-
Citations
39 Claims
-
1. A method for accessing rows of data from a base table satisfying a search criteria, comprising:
-
receiving an initial request to access rows in the base table including the search criteria specifying predicates for one or more columns in the base table;
generating a data structure to include information on qualifying base table rows that satisfy the search criteria;
providing notification that the qualifying base table rows are accessible before information on all the qualifying base table rows is included in the data structure; and
receiving a request for one qualifying base table row;
determining whether the data structure includes information on the requested qualifying base table row; and
using the information in the data structure to provide access to the requested qualifying base table row. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39)
-
-
14. A system for accessing rows of data from a base table satisfying a search criteria, comprising:
-
means for receiving an initial request to access rows in the base table including the search criteria specifying predicates for one or more columns in the base table;
means for generating a data structure to include information on qualifying base table rows that satisfy the search criteria;
means for providing notification that the qualifying base table rows are accessible before information on all the qualifying base table rows is included in the data structure; and
means for receiving a request for one qualifying base table row;
means for determining whether the data structure includes information on the requested qualifying base table row; and
means for using the information in the data structure to provide access to the requested qualifying base table row.
-
-
27. A program for accessing rows of data from a base table satisfying a search criteria, wherein the program is comprised of code implemented in a computer readable medium that is capable of causing a processor to perform:
-
receiving an initial request to access rows in the base table including the search criteria specifying predicates for one or more columns in the base table;
generating a data structure to include information on qualifying base table rows that satisfy the search criteria;
providing notification that the qualifying base table rows are accessible before information on all the qualifying base table rows is included in the data structure; and
receiving a request for one qualifying base table row;
determining whether the data structure includes information on the requested qualifying base table row; and
using the information in the data structure to provide access to the requested qualifying base table row.
-
Specification