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
Implicit certificate scheme
Analysis device and an analysis apparatus using the analysis device
Method for driving bistable display device
Polyester resin for toner, electrostatic charge image developing toner, electrostatic charge image developer, toner cartridge, process cartridge, image forming apparatus, and image forming met
Method and system for dynamic digital rights bundling
Adaptive non-positive inductor current detector (ANPICD)
Systems and methods for excluding undesirable network transactions
  Randomly Featured Patents
Method for the production of endosseous implants
Venting of cryogenic storage tanks
Electrochromic material and method of making an electrochromic material
Control device of a high voltage circuit breaker equipped with closing resistors
Method for detection of Cushing's syndrome in domestic animals
Radiometric measuring of thin fluid films
Spiral tractor apparatus and method
Poly(diallylamine)-based bile acid sequestrants
Separator with longitudinal and transverse ribs for use in accumulators
Process for producing polyvinyl alcohol multifilament yarn