EXECUTION OF DATABASE QUERIES INCLUDING FILTERING
First Claim
Patent Images
1. A method comprising:
- stabilizing a page of data that includes a record to be accessed in accordance with an access plan generated for executing a query, the query comprising a non-predicate filtering operation;
positioning a cursor on the record to be accessed;
applying the non-predicate filtering operation of the query to the record to determine whether the record is to be filtered under the non-predicate filtering operation while the page of data remains stabilized; and
in response to a determination that the record is to be filtered under the non-predicate filtering operation,repositioning the cursor on a next record included in the page of data that is to be accessed in accordance with the access plan generated for executing the query without releasing stabilization of the page of data, andapplying the non-predicate filtering operation of the query to the next record to determine whether the next record is to be filtered under the non-predicate filtering operation while the page of data remains stabilized.
1 Assignment
0 Petitions
Accused Products
Abstract
A query processing system has a query processor and a data manager. The query processor calls the data manager to carry out data access for a query including a filtering operation. The data manager accesses the data in a set of data and before returning the data, initiates a callback to the query processor to determine if the located data meets the filtering criteria. Where the data does not satisfy the filtering criteria, the data manager seeks additional data in the set of data, without having to return the first located data to the query processor.
24 Citations
18 Claims
-
1. A method comprising:
-
stabilizing a page of data that includes a record to be accessed in accordance with an access plan generated for executing a query, the query comprising a non-predicate filtering operation; positioning a cursor on the record to be accessed; applying the non-predicate filtering operation of the query to the record to determine whether the record is to be filtered under the non-predicate filtering operation while the page of data remains stabilized; and in response to a determination that the record is to be filtered under the non-predicate filtering operation, repositioning the cursor on a next record included in the page of data that is to be accessed in accordance with the access plan generated for executing the query without releasing stabilization of the page of data, and applying the non-predicate filtering operation of the query to the next record to determine whether the next record is to be filtered under the non-predicate filtering operation while the page of data remains stabilized. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A computer readable storage medium encoded with a computer program, the computer program comprising computer-executable instructions for:
-
stabilizing a page of data that includes a record to be accessed in accordance with an access plan generated for executing a query, the query comprising a non-predicate filtering operation; positioning a cursor on the record to be accessed; applying the non-predicate filtering operation of the query to the record to determine whether the record is to be filtered under the non-predicate filtering operation while the page of data remains stabilized; and in response to a determination that the record is to be filtered under the non-predicate filtering operation, repositioning the cursor on a next record included in the page of data that is to be accessed in accordance with the access plan generated for executing the query without releasing stabilization of the page of data, and applying the non-predicate filtering operation of the query to the next record to determine whether the next record is to be filtered under the non-predicate filtering operation while the page of data remains stabilized. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. A system comprising:
-
a data manager, the data manager stabilizing a page of data that includes a record to be accessed in accordance with an access plan generated for executing a query, the query comprising a non-predicate filtering operation, and positioning a cursor on the record to be accessed; and
a query manager in communication with the data manager, the query managerapplying the non-predicate filtering operation of the query to the record to determine whether the record is qualifies under the non-predicate filtering operation while the page of data remains stabilized, and indicating to the data manager that the record is to be filtered responsive to a determination that the record does not qualify under the non-predicate filtering operation, in response to receiving the indication from the query manager that the record is to be filtered, the data manager repositions the cursor on a next record included in the page of data that is to be accessed in accordance with the access plan generated for executing the query without releasing stabilization of the page of data, and calls the query manager to apply the non-predicate filtering operation of the query to the next record without releasing stabilization of the page of data. - View Dependent Claims (14, 15, 16, 17, 18)
-
Specification