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
Systems and methods for economic retirement analysis
Multi-band dipole antenna
N-phenyl-(homo)piperazinyl-benzenesulfonyl or benzenesulfonamide compounds suitable for treating disorders that respond to the modulation of the serotonin 5-HT.sub.6 receptor
Semiconductor device and method of manufacturing the same
Methods and systems for presenting an inhalation experience
Analog to digital converter with increased sub-range resolution
Taste receptors of the T1R family from domestic cat
  Randomly Featured Patents
Solderless method for transferring high frequency, radio frequency signals between printed circuit boards
Methods and apparatus for rapid acoustic unit selection from a large speech corpus
Dichroic polarizing film and optical polarizer containing the film
Caller ID messaging device
Apparatus for improved contrast in a motor vehicle heads-up display
Liquid composition for treating photosensitive laminates having alcohol-soluble polyamide layer
Single power supply multiple image intensifier apparatus and method with independently adjustable low light gain and high light saturation level
Neuronal nicotinic acetylcholine receptor compositions
Sole for footwear
Method and apparatus for circuit design