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
Data feed management
DKK1 oncogene as therapeutic target for cancer and a diagnosing marker
Printer driver, printer control method, and recording medium
Method for transmitting an electronic short message to multiple receivers
Plant disease control composition and its use
Compact bus bar assembly, switching device and power distribution system
  Randomly Featured Patents
Printing press with plate cylinder skew and throw off
Combination umbrella, support and method of use
Hafnium nitride gate dielectric
Polyarylene sulfide resin composition
Camera-supporting carrying case
Method and apparatus for an electronic collaborative education process model
Safety release for a trunk of a vehicle
Formulations containing coumarins and the use thereof in the pharmaceutical and cosmetic fields
Transmission of advanced-MAP information elements in mobile networks
Adaptation of automatic speech recognition acoustic models