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
Laser marking of a card
Piezoelectric quasi-resonance linear motors based on acoustic standing waves with combined resonator
Process for shaping polymeric articles
Undercabinet plug-in mount
Imaging lens having five lens elements, and electronic apparatus having the same
Method of forming solderable side-surface terminals of quad no-lead frame (QFN) integrated circuit packages
Automated measurement of concentration and/or amount in a biological sample
  Randomly Featured Patents
Fishing lure
Power translation device
5-HT7 receptor antagonists
Behavior control device of vehicle based upon double checking of yaw rate deviation
Beta-triazolyl oximes agents containing them for influencing the growth of plants and their use
Electrochemical detection of nucleic acid hybridization
Cosmetic container
1H-indole-3-glyoxylamide sPLA2 inhibitors
Allocating hardware resources for high-level language code sequences
Composite recycling type fluidized bed boiler