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
Methods and devices for creating, compressing and searching binary tree
Image display device and method of changing first EDID with second EDID wherein the second EDID information is compatible with image display device
Encoder that optically detects positional information of a moving body from different optical paths lengths
Manufacturing method power semiconductor device
Adaptive flow for thermal cooling of devices
Method and system for scaling usage of a social based application on an online social network
Methods and systems to accomplish variable width data input
  Randomly Featured Patents
Ice skating rink
Method of detecting image information by photoelectric device
System and method for selection of important attributes
Personal exercise device
Method and system using pathnames to specify and access audio data at fidelity levels other than the level at which the data is stored
Variable pressure system for controlling pressure exerted on a transport belt
Apparatus and methods for recouping scrap dough material
Transmission control system with gear shift failure detection
Multiprocessor system with global data replication and two levels of address translation units
Method of wirelessly accessing network