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
Light emitted diode
Medical imaging probe with rotary encoder
Identifying conceptually related terms in search query results
Identification wristband
Method for producing male sterile plants using plant beclin 1/ATG6 expression
Methods circuits apparatuses and systems for facilitating access to online content
Semiconductor device comprising a Fin and method for manufacturing the same
  Randomly Featured Patents
Method for controlling fouling deposit formation in a liquid hydrocarbonaceous medium
Method of tagging with color-coded microparticles
Gas blow-off attenuator
Substrate conveying device and method of controlling the same
Pyrimidyl thioureas useful for the treatment of hypertension and hyperlipidemia
V-ribbed power transmission belt
Power wing support merchandiser
Device for forming groups of cigarettes
Wear plate retainer with magnetically retained, replaceable wear plate
Stacking strength carton with an easy opening feature