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
Flexible lighting devices
Maintenance guidance display device, maintenance guidance display method, and maintenance guidance display program
Method and system for providing cloud based network security services
Local access to data while roaming with a mobile telephony device
Battery comprising circuitry for charge and discharge control, and method of operating a battery
Formation of a masking layer on a dielectric region to facilitate formation of a capping layer on electrically conductive regions separated by the dielectric region
Triazolylphenyl sulfonamides as serine/threonine kinase inhibitors
  Randomly Featured Patents
Non toxic activators for adhesive compositions
Image processing in accordance with position of member
One-component polyurethane adhesive compositions
Systems for shaping the casting region in a twin-belt continuous casting machine for improving heat transfer and product uniformity and enhanced machine performance
Schedule management support system
Vertical GaN-based LED and method of manufacturing the same
Tag holder profile or a mother profile for fastening a removable tag holder
Integrated tool with automated calibration system and interchangeable wet processing components for processing microfeature workpieces
Container with rotating lid
Dynamic radial capillary seal