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
For a given cell in a spreadsheet, evaluating an unlimited number of conditional formatting rules and applying multiple corresponding formats to the cell
Image reading apparatus
Semiconductor device and manufacturing method thereof
Self-service channel marketplace
Pre-distortion architecture for compensating non-linear effects
Spalling utilizing stressor layer portions
Hair care composition
  Randomly Featured Patents
Splice system for use in splicing coiled tubing having internal power cable
Core for a pipe that is to be bent
Apparatus including electrical contacts
Encapsulated MEMS device and method to form the same
Bifunctional alkali metal compounds, preparation and use thereof as polymerization initiators
Magnesium trisilicate suitable for preparation of medicament adsorbates of antitussives
Compact electrical machine
Expert system constant false alarm rate (CFAR) processor
FET logic gate circuits
Temperature monitoring of parallel-connected inverter modules