Pre-Grant Publication Number: 20100250518
Flexible query hints in a relational database
Please help the USPTO examine the application by evaluating the relevance of the publicly submitted prior art to the patent application. Peer To Patent forwards the Top 10 most relevant prior art submissions and their annotations to the USPTO.

Review this prior art and click on the thumbs up (or down) to indicate whether this submission should be forwarded to the USPTO.
If you login then you can add an annotation by typing in the box at the bottom of the screen to comment on the relevance of the prior art to the claims of the patent application.
Prior Art Detail
Annotations(0)
#627'Oracle® Database Performance Tuning Guide': Using Optimizer Hints
Applies to Claims 1,14
Submitted by: Diane WillisLast updated: over 2 years ago
0 thumbs up 0 thumbs down
Summary / Description
Summary / Description'Optimizer hints can be used with SQL statements to alter execution plans.'
 
Basic Information
Type of Prior ArtOnline Publication
 
URLhttp://download.oracle.com/docs...
 
Author/CreatorOracle
 
TitleOracle® Database Performance Tuning Guide
 
Publication DateMarch 2008
 
PublisherOracle
 
Directions to Document Locationlocation of the .pdf: http://download.oracle.com/docs/cd/B19306_01/server.102/b14211.pdf
 
Additional InformationSelecting 'View PDF' shows the title page of the document, and the publication date of March 2008.
 
Notes / To Do
NotesPrior art provided by Guogen (Gene) Zhang, IBM, and posted by Diane Willis.
 
Excerpt
Excerpt
16.1 Understanding Optimizer Hints Hints let you make decisions usually made by the optimizer. As an application designer, you might know information about your data that the optimizer does not know. Hints provide a mechanism to instruct the optimizer to choose a certain query execution plan based on the specific criteria.
 
Relevance
Claims
1
A method implemented on a general-purpose computing device for discovering and expressing query hints in a database management system, comprising:using the general-purpose computing device to perform the following:input a query having an initial query execution plan;computing a direct acyclic graph for the query;constraining the query using a power hints query language expression;computing candidate matches for each operator in the initial execution plan;extracting a revised query execution plan having a lowest cost as determined by a query optimizer cost model that satisfies constraints of the power hints query language expression;displaying the revised query execution plan in a graphical manner to a user; andallowing the user to change the revised query execution plan if the user is not satisfied with the revised query execution plan.
Relevance
See the Excerpt, and additional details in the document.
See the Excerpt, and additional details in the document.
Claim Chart
Some
14
A computer-implemented method for revising an initial query execution plan for a query in a database management system on the computer, comprising:using the computer to perform the following:computing a direct acyclic graph for the query;defining a power hints language where expressions in the power hints language are tree patterns in the acyclic graph annotated with constraints;constraining the query using a power hints language expression;enumerating each of the possible query execution plans in the direct acyclic graph;filtering out the possible query execution plans that do not match the power hints language expression; andfinding a matching query execution plan have a lowest estimated cost to determine a revised query execution plan, which is a revision of the initial query execution plan for the query.
Relevance
See the Excerpt, and additional details in the document.
See the Excerpt, and additional details in the document.
Claim Chart
Some
0 days left
Activity
Application
Discussion (3)
Prior Art (3)
Research (0)
Subscribe to this Community
Invite a Reviewer
HOW TO USE PEER TO PATENT
Peer To Patent Videos