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 arranging and labeling cardiac episodes
Transaction finance processing system and approach
Video processing system and device with encoding and decoding modes and method for use therewith
Pre-colored methodology of multiple patterning
Removable storage device and method for identifying drive letter of the removable storage device
Nuclear fuel assembly bottom nozzle
Interposer having molded low CTE dielectric
  Randomly Featured Patents
Radiation image capturing device
Mechanical oscillator control electronics
Switch device
Illumination device and method for controlling a color temperature of irradiated light
Two-dimensional incident position detector device for light or radiation
Apparatus for forming a container curl with a generally V-shaped crushed portion
System and method for calibrating and controlling a fly-height actuator in a magnetic recording disk drive
Meat hook
Concealed spring marine gate latch
Corner locking and associated pivot means for extruded plastic sash windows