Query directives and access plan hints

Details Query directives and access plan hints Query directives and access plan hints

2008-07-17

2009-12-08

Robinson, Greta L (Department: 2169)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07630958

ABSTRACT:
A query plan modification system and method relate 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: 6738756 (2004-05-01), Brown et al.
patent: 6754652 (2004-06-01), Bestgen et al.
patent: 6813617 (2004-11-01), Wong et al.
patent: 7031958 (2006-04-01), Santosuosso
patent: 7099863 (2006-08-01), Bird et al.
patent: 7308437 (2007-12-01), Day et al.
patent: 7356526 (2008-04-01), Gao et al.
patent: 7440935 (2008-10-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/0093332 (2004-05-01), Hrle
patent: 2004/0205053 (2004-10-01), Bird et al.
patent: 2004/0220923 (2004-11-01), Nica
Amsaleg et al., Scrambling Query to Cope with Unexpected Delays, Parallel and Distributed Information Systems, 1996, Fourth International Conferenece on, Dec. 18-20, 1996, pp. 208-219.
Ambite et al., Flexible and Scalable Query Access Planning Using an Al Planner, Knowledgement and Database Engineering Exchange Workshop, 1997. Proceedings, 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

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4079813