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
Persistent cacheable high volume manufacturing (HVM) initialization code
Systems and methods for remote testing of a flow switch
Light-emitting diode
Catalytic cracking catalyst compositions having improved bottoms conversion
Method of manufacturing bonded substrate, bonded substrate, method of manufacturing solid-state imaging apparatus, solid-state imaging apparatus, and camera
Welding arc termination method and system
Oil transfer tube and assembly
  Randomly Featured Patents
Link assembly for automotive suspension system
Decorative high-pressure laminate and a process for producing a surface layer thereon
Method of identifying activity modulators of a polycystin-2L1 taste receptor polypeptide
Swimming pool cover with multiple air compartments
Production of chlorofluorocarbon-free, urethane-containing moldings having a cellular core and a compacted peripheral zone
Driving circuit for and semiconductor device for driving laser diode
Apparatus for application of a magnetic field to a sample
Semiconductor memory device utilizing tunnel magneto resistive effects and method for manufacturing the same
Towel fabric processing device
Method and apparatus for leukoreduction of red blood cells