Method and device for processing a query in a database management system
OwnerYou-Chin Fuh, Namik Hrleinventors
Life of this patent
Estimating the term…
Abstract
According to one aspect of the present invention, a method is provided for processing a query in a database management system that generates an access plan to retrieve desired data from computer storage in response to the query. An identification is derived from at least a portion of a received query or representation thereof. The access plan is generated in consideration of a hint associated with the identification, if such a hint is available from a repository of hints.
Claims33
A method of processing a query in a database management system that generates an access plan to retrieve desired data from computer storage in response to the query, the method comprising:
- deriving an identification from at least a portion of a received query or representation thereof;
- and
- generating the access plan in consideration of a hint associated with said identification, if such a hint is available from a repository of hints.
A device for processing a query in a database management system that generates an access plan to retrieve desired data from computer storage in response to the query, the device comprising:
- a deriving component for deriving an identification from at least a portion of a representation of a received query;
- and
- a generating component for generating the access plan in consideration of a hint associated with said identification, said hint found in a repository of hints.
A computer readable medium including program instructions for causing a computer to perform a method comprising:
- deriving an identification from at least a portion of a received predetermined representation of a query;
- accessing a repository of user-specified hints in order to find a hint associated with said identification;
- and
- generating the access plan in consideration of the user-specified hint, if a user-specified hint could be retrieved from said repository.
Dependencies are inferred from the claim text.