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
Selecting content for storage in a multi-device cache
Efficiently emulating computer architecture condition code settings without executing branch instructions
Image forming apparatus
Look up table (LUT) structure supporting exclusive OR (XOR) circuitry configured to allow for generation of a result using quaternary adders
Thermochromic microparticles, dispersions thereof, and manufacturing method thereof, as well as light-modulating coatings, light-modulating films and light-modulating inks
TRPM8 antagonists and their use in treatments
  Randomly Featured Patents
Power assisted steering apparatus for automotive vehicle
Method and apparatus for mounting selectively orientable component
Radiation curable resin composition for lens sheet and lens sheet
Session-based target/LUN mapping for a storage area network and associated method
Aluminum/ceramic bonding substrate and method for producing same
Flexible and stackable semiconductor die packages having thin patterned conductive layers
Moving walkway
One trip seal latch system
Continuously variable transmission
Removal of volatile organic components from spent sulfite effluent