Closed-loop predicate analysis

Details Closed-loop predicate analysis Closed-loop predicate analysis

2006-01-10

2010-12-28

Hayes, John W (Department: 3628)

Data processing: database and file management or data structures

Database and file access

Query optimization

C705S001100, C705S400000, C707S793000

Reexamination Certificate

active

07860858

ABSTRACT:
Processing of a request is optimized. The request has one or more predicates. A list of the one or more predicates in the request is created and predicates for which an actual cost has not been stored or for which a cost cannot be estimated are pruned from the list. An access path for the each of the predicates is selected. The request is processed using the selected access paths producing one or more actual predicate costs. The one or more actual predicate costs are stored.

REFERENCES:
patent: 5734884 (1998-03-01), Eberhard et al.
patent: 6026391 (2000-02-01), Osborn et al.
patent: 6330552 (2001-12-01), Farrar et al.
patent: 6493700 (2002-12-01), Couch et al.
patent: 6801905 (2004-10-01), Andrei
patent: 6983275 (2006-01-01), Koo et al.
patent: 2002/0198867 (2002-12-01), Lohman et al.
patent: 2004/0220923 (2004-11-01), Nica
patent: 2006/0041599 (2006-02-01), Tsuchida et al.
Selinger et al., “Access Path Selection In a Relational Database”, 1979, IBM Research Division, pp. 23-34.
Mackert et al., “R* Optimizer Validation and Performance Evaluation for Local Queries”, IBM Almaden Research Center, 1986, pp. 84-95.
He et al., “Self-Tuning Modeling of User-Defined Functions in an Object-Relational DBMS”, Sep. 2005, ACM Transactions on Database Systems, vol. 30, No. 3, pp. 812-853.

Affiliated with

Also associated with

Rating

Closed-loop predicate analysis does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Closed-loop predicate analysis, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Closed-loop predicate analysis will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4224765