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
Blocky hydroxyethylcellulose, derivatives thereof, process of making and uses thereof
Web-based royalty system and user interface
Can seam inspection
Triple-trim reference voltage generator
Memory circuit and method of forming the same using reduced mask steps
Method of creating exercise routes for a user and related personal navigation device
  Randomly Featured Patents
Semiconductor laser and method therefor
Device for protection against the sun and application of substance to the skin
Rapid starter switch for a fluorescent lamp
Method and system for improving personalization of advertising for mobile devices using peer rating
Multi-layer coating method based on differential spectral reflectance
Methods and systems involving return torque
Method of dressing grinding wheels in grinding machines
Coatings containing polycationic peptides for cardiovascular therapy
Acylated furanyl and thienyl acrylic acids
Wine bottle stand