Method and system for query directives and access plan hints

Details Method and system for query directives and access plan hints Method and system for query directives and access plan hints

2004-05-05

2008-10-21

Robinson, Greta L (Department: 2168)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07440935

ABSTRACT:
A query plan modification system and method relates to a database system that includes a cost-based optimizer for generating access plans. The database system also permits a user to view an access plan that has been generated by a particular SQL query and modify the access plan if desired. The user specifies customizations that are associated with the access plan so that when that plan is executed, the customizations are executed as well. Exemplary customizations include specifying an initialization file specific to a query, specifying different implementation methods than those in the original access plan, prohibiting rebuilding of an access plan, and over-riding or ignoring a clause within the query that is used to generate the access plan.

REFERENCES:
patent: 5335345 (1994-08-01), Frieder et al.
patent: 5600831 (1997-02-01), Levy et al.
patent: 5822748 (1998-10-01), Cohen et al.
patent: 6353826 (2002-03-01), Seputis
patent: 6516310 (2003-02-01), Paulley
patent: 6754652 (2004-06-01), Bestgen et al.
patent: 6813617 (2004-11-01), Wong et al.
patent: 7031958 (2006-04-01), Santosuosso
patent: 7308437 (2007-12-01), Day et al.
patent: 2003/0078909 (2003-04-01), Pham et al.
patent: 2003/0200204 (2003-10-01), Limoges et al.
patent: 2004/0006561 (2004-01-01), Nica
patent: 2004/0220923 (2004-11-01), Nica
Ambite et al., Flexible and Scalable Query Access Planning Using an Al Planner, Knowledgement and Database Engineering Exchange Workshop, 1997. Proceddings, Nov. 4, 1997, pp. 132-139.
Ng et al., On Reconfiguring Query Execution Plans in Distributed Object-Relational DBMS, Parallel and Distributed Systems, 1998. Proceedings., 1998 International Conference on, Dec. 14-16, 1998, pp. 59-66, Digital Object Identifier 10.1109/ICPADS.1998.741020.

Affiliated with

Also associated with

Rating

Method and system for query directives and access plan hints 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 query directives and access plan hints, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for query directives and access plan hints will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3994290