Resources Contact Us Home
Plan-per-tuple optimizing of database queries with user-defined functions

Image Number 3 for United States Patent #6353818.

A method, apparatus, and article of manufacture for executing a database query in a database management system. The method comprises the steps of generating a plurality of query plans for the database query, evaluating the plurality of query plans using a measured value for the resource metric, selecting a query plan from the evaluated query plans based on the measured resource metric, and executing the selected query plan. The apparatus comprises a query plan generator for generating a plurality of query plans, each query plan optimized with respect to at least one resource metric, and a query plan evaluator, communicatively coupled to a resource object and a database management system node, the evaluator selecting a query plan from the optimized query plan according to a measured resource metric obtained from the global resource object. The article of manufacture comprises a program storage device tangibly embodying one or more programs of instructions executable by the computer to perform the method steps of executing a database query in a database management system, the method steps comprising the method steps above.

  Recently Added Patents
Gaze tracking password input method and device utilizing the same
Pyridazine compounds for controlling invertebrate pests
Transfer device and image forming apparatus including regulation member
Front cover of an electronic device
Contact lens material
Toy track intersection component
Handheld electronic communication device having sliding display
  Randomly Featured Patents
Methods of high consistency oxygen delignification using a low consistency alkali pretreatment
Method for fabricating semiconductor device with improved tolerance to wet cleaning process
Method and apparatus for obtaining alternate delivery instructions for a fax document
Miniature rose plant Dohhawk
Method and apparatus for use of porous implants
Preprocessed applications suitable for network streaming applications and method for producing same
Database management system and method
Segmented fiber optic sensor and method
Fuel cell power generation system
Process for the autothermal reforming of a hydrocarbon feedstock containing higher hydrocarbons