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
Flash multi-level threshold distribution scheme
Systems and methods for picture based communication
Analysis of methylation using nucleic acid arrays
Unified feedback frame for supporting a plurality of feedback modes and a multiple-input multiple-output (MIMO) communication system using the unified feedback frame
Variety corn line KDC7040
Link establishment in a wireless communication environment
Method and apparatus for power management control of an embedded memory having sleep and shutdown features
  Randomly Featured Patents
Conduit couplings
Method and apparatus for sealing a gabled container
Wireless tag determination method, wireless tag determination system, reader control device, and storage medium
Method and apparatus for controlling paper pickup in image forming system
Coating material for a grafted ignition wire
Product authentication indicia concealed in magnetomechanical EAS marker
Process for reducing the benzine content of petrols
Pyrimidine derivatives and processes for the preparation thereof
Radio system for cordless subscriber line interface
Encoder alternator