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
Automatic analysis of finely divided solids
Multi-domain secure computer system
Apparatus and method for the detection and treatment of atrial fibrillation
Injecting a data error into a writeback path to memory
Mandatory integrity control
Shock electrode line
Wall panel
  Randomly Featured Patents
Method for producing lithium manganate
Soldering apparatus
MIMO channel estimation in presence of carrier frequency offset
Coater with a large-area assembly of rotatable magnetrons
Spinal cord stimulation to treat auditory dysfunction
Polymers of ethylene and, optionally, copolymerizable esters, films using such polymers and stretch hood packaging processes using such films
Optical fiber coupler of improved signal distribution characteristics
Motorcycle tire
Disinfecton formulations and methods using D-enantiomeric anti-microbial peptides
Synthetic resin material, particularly surface material for phonograph records with a photograph or picture