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
Apparatus and method for providing vehicle data for testing product
Concentration measuring apparatus for hydrogen sulfide in gas flow, and method for determining sulfide ion
Apparatus with a local timing circuit that generates a multi-phase timing signal for a digital signal processing circuit
Rate controlled first in first out (FIFO) queues for clock domain crossing
Strap-hook ring
TV wall mount
Leg stretching device
  Randomly Featured Patents
Lens driving device with piezoelectric actuator
Cutting board
Methods for using inhibitors of vascular endothelial growth factor activity
Contact fixture for hot glass
Recorder with circuit line tamper indicating system
Laundry detergent containing polyethyleneimine suds collapser
Zoom lens, optical apparatus and manufacturing method
Method and disk drive for improving data storage capacity of data tracks using push-down wedges
Printing apparatus and color adjusting method
Image readout method and device