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
Deflection device for a scanner with Lissajous scanning
Case for electronic device
Method and system for dynamically representing distributed information
Pet fish burial pod
Machine tool with an electrical generator for passive power generation
Multichannel device utilizing a centralized out-of-band authentication system (COBAS)
Location estimation of wireless terminals through pattern matching of deduced signal strengths
  Randomly Featured Patents
Use of certain bridged ketones in augmenting or enhancing the organoleptic properties of smoking tobacco
Liquid crystal display device of in-plane switching mode
Adjustable railing bracket
Devices and methods for orthotic customization
Method and system of measuring characteristics of an organ
Wired suspension assembly in disk storage device method for assembly head suspension assembly
Methods and compositions for promoting protein folding
Process for the recovery of a fermentation product
Inflatable air bag for motor vehicles