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
Heterogeneous language data typing without executable regeneration
Collaborative data redundancy for configuration tracking systems
Solid state lighting devices and associated methods of manufacturing
Thwarting keyloggers using proxies
System for programming domestic appliances and method for programming assembly-line programmable domestic appliances
Selective thermal treatment of medical instrument portions with thermal treatment system instrument holder
  Randomly Featured Patents
Phase-locked loop system and method for modifying an output transition time
Snap safe
N-(imidazolylalkyl)substituted cyclic amines as histamine-H.sub.3 agonists or antagonists
Method for inputting signals into and outputting signals out from subareas of the auxiliary signals of transport modules of a synchronous digital signal hierarchy
Microwaveable grilled cheese and meat sandwiches and method of preparation
Hand held loop cutter
Conducting material and a method of fabricating thereof
Addition of new images to an image database by clustering according to date/time and image content and representative image comparison
Keyhole barrier system and method
Vapour compression device and method of performing an associated transcritical cycle