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
Poloxamer foamable pharmaceutical compositions with active agents and/or therapeutic cells and uses
Satellite fleet deployment
Continuous geospatial tracking system and method
Signal transfer apparatus
System for targeted delivery of therapeutic agents
Cellulose ester compositions having low birefringence and films made therefrom
TV wall mount
  Randomly Featured Patents
Assembling brush box sub-assemblies in electric motors
Method of using lectins for contraception and prophylaxis against diseases transmittable by sexual contact and condom containing lectins
Traction control system for motor vehicle
Chrominance signal playback system and method for video cassette recorders having noise suppression of the chrominance signal
Switching control apparatus for a communication terminal having a voice terminal device and a non-voice terminal device
Memory management unit architecture for switch fabric
Shell architecture software development
Device for the setting of the mutual positions of pivotable elements
Automatic variable creation for adaptive analytical models
Game racket handle