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
Rule-based stimulation program search
Information processing apparatus and power supply controlling method
Control of protein activity using a conducting polymer
Multibranched polymer and method for producing the same
Stabilization of dicarbonate diesters with protonic acids
Radio transmitter and radio receiver with channel condition assessment
Methods and systems for presenting an inhalation experience
  Randomly Featured Patents
Encryption key setting system, access point, encryption key setting method, and authentication code setting system
Noise tone avoidance in optical networks
Audio and video processing apparatus
Coaxial transmission line microstructures and methods of formation thereof
Pixel conversion apparatus
System, method and computer program product for documents retrieval
Circular zig-zag scan video format
Method and apparatus for optimizing the output of a harmonic generator
Foster care monitoring and verification device, method and system
Reinforced tread assembly