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
Account and customer creation in an on-line banking model
Front face of vehicle wheel
Method for determining a corrected variance representative of the condition of reception of signals representative of symbols
Powder pulverising device
Method and composition for improving skin barrier function
Method for correcting integrating cavity effect for calibration and/or characterization targets
Method and apparatus for supporting delivery, sale and billing of perishable and time-sensitive goods such as newspapers, periodicals and direct marketing and promotional materials
  Randomly Featured Patents
Delayed-release form for pharmaceutical active compounds
Coating hood
Image-forming device capable of positioning developing unit and developer cartridge precisely
Method for treating glaucoma with topical or systemic ACE inhibitor compositions
Method of manufacturing a seamless pipe
Load sensing proportioner with proportioner delay
Modularized permanent molding machine with multiple molds
Changing rod