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
Terminal for flat test probe
Container pack
Active gate drive circuit
Computer system for routing package deliveries
Automated measurement of concentration and/or amount in a biological sample
Method for playing digital media files with a digital media player using a plurality of playlists
Stain-blocking aqueous coating composition
  Randomly Featured Patents
Rear assembly for a motor home
Automatic ad group creation in a networked advertising environment
Barbecue grill cleaner
Process for producing aliphatic polyester carbonate
Flexible spine stabilization systems
Systems and methods for restoring email databases
Automobile exhaust gas purifying combustion catalysts
Device for increasing the stability of helicopters placed on board and set down, having a tricycle landing gear, and helicopter equipped with such a device
Surgical device
Reactive styrene polymers