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
Multi-domain dynamic group virtual private networks
Verifiable service policy implementation for intermediate networking devices
System and method for providing an extended platform for an operating system
Switching device, switch control method, and storage system
Image stabilization apparatus and image pickup apparatus
Hemostatic devices and methods of making same
Adaptive frame scanning scheme for pulsed X-ray imaging
  Randomly Featured Patents
Real-time scrolling drive-trace display for a vehicle engine analyzer
Method of preparing a molded sealing composition for sealing against permeation of carbon dioxide gas
Handle hub
Light emitting tooth brush having whitening and sterilizing effects
High pressure sealing means for longitudinally movable parts of deep-well drilling tools
Method and apparatus for sorting particles
System and method for securing workpieces to a worktable of a CNC machining system utilizing a low level vacuum source
Knock-down containers, container fastening system and elements thereof
Self-extraction panel hinge
Method and apparatus for providing thread-specific computer system parameters