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
In-store marketing sign
Compounds for nonsense suppression and methods for their use
Segmentation of a product markup image based on color and color differences
Cycloalkylamine substituted isoquinoline derivatives
Transparent zebrafish and preparation method thereof
Bi-level switching with power packs
  Randomly Featured Patents
Coating method and associated coating device
Portion of a light-emitting diode lamp
Wastewater purifying apparatus
Method, system, and computer program product for improved round robin for time series data
Filter-cooler combination for liquids, especially for the lubricating oil of a motor vehicle internal combustion engine
Heating apparatus
Methods and apparatus for providing access to content
Lossless data compression system and method
Sheathing device for after use protection from a syringe needle
Refrigerant compressor