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
Stretchable elastic laminate having increased CD elongation zones and method of production
Dynamic data filtering system and method
Method of providing user-tailored entertainment experience at hospitality location and hospitality media system thereof
Polypeptides and immunizing compositions containing gram positive polypeptides and methods of use
Lid for a container
System and method for video encoding
Method and device for determining processed image data about a surround field of a vehicle
  Randomly Featured Patents
Electric still camera
Low inductance high ESR capacitor
Printed circuit board
Use of bacteriophage outer membrane breaching proteins expressed in plants for the control of gram-negative bacteria
Method and system for analysis of software requirements
Ramp rate limiter to control stress during ramping
Absorbent article
Children's tricycle
Data providing system, data providing apparatus and method, data acquisition system and method, and program storage medium