Method and system for reducing host variable impact on...

Details Method and system for reducing host variable impact on... Method and system for reducing host variable impact on...

2007-09-25

2007-09-25

Nguyen, Cam Linh (Department: 2161)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

10688951

ABSTRACT:
The present invention proposes enhancing the access path selection process by storing the relevant frequency distribution and the host variables values used for selecting the access path together with the corresponding access path executable. This way, the host variables impact to the access path can be inexpensively assessed and the re-optimization triggered only if necessary.

REFERENCES:
patent: 4956774 (1990-09-01), Shibamiya et al.
patent: 5948108 (1999-09-01), Lu et al.
patent: 6006220 (1999-12-01), Haderle et al.
patent: 6219660 (2001-04-01), Haderle et al.
Anthony Klug, “Access Paths in the “abe” Statistical Query Facility”, 1982, ACM, pp. 161-173.

Affiliated with

Also associated with

Rating

Method and system for reducing host variable impact on... 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 system for reducing host variable impact on..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for reducing host variable impact on... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3733641