Method and apparatus for associating logical conditions with...

Details Method and apparatus for associating logical conditions with... Method and apparatus for associating logical conditions with...

2005-03-30

2008-11-25

Truong, Cam-Y (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07457797

ABSTRACT:
A query facility for database queries saves and re-uses query execution strategies, and automatically determines whether a strategy can be re-used when an imported variable changes. The query facility automatically saves one or more logical conditions associated with the one or more imported variables in the query. When the query is reused, the logical conditions are evaluated using the imported variable values, and the previously saved execution strategy is used only if the condition or conditions are met. Preferably, the logical conditions express a range of imported variable values which are included in a database subset data structure used by the saved query execution strategy, such as a materialized query table or partitioned table. Logical conditions are preferably generated by negating the predicates from a logical expression defining the applicability of the execution strategy, inserting the negated predicates into the query, and performing a transitive closure.

REFERENCES:
patent: 6112209 (2000-08-01), Gusack
patent: 6466931 (2002-10-01), Attaluri et al.
patent: 6898588 (2005-05-01), Kosciuszko et al.
patent: 2004/0006563 (2004-01-01), Zwiegincew et al.
patent: 2004/0093332 (2004-05-01), Hrle
U.S. Appl. No. 10/688,951, “Method and System for Reducing Host Variable Impact On Access Path Selection,” filed Oct. 21, 2003 by Namik Hrle.
U.S. Appl. No. 10/955,737, “Method and Apparatus for Re-Evaluating Execution Strategy for a Database Query,” filed Sep. 30, 2004 by Paul R. Day et al.

Affiliated with

Also associated with

Rating

Method and apparatus for associating logical conditions with... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for associating logical conditions with..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for associating logical conditions with... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4028310