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
System and method for secure power systems infrastructure communications
Autobrake and decel control built-in test equipment
Method of making and using an alpha-glucanase composition to reduce or remove biofilm
Catalysts for polyurethane coating compounds
System and method for supporting fibre channel over ethernet communication
Attribute information providing system
Systems and methods for selective text to speech synthesis
  Randomly Featured Patents
Cylindrical piezoelectric unit and printer head having the same
High performance MTJ element for STT-RAM and method for making the same
Standby saver
Process and apparatus for making a leakproof plastic container by completely ejecting from a mold and transferring to a cap closing station
Method of selectively determining a fungal biomass
Mass storage system and method with emulation and management priorities
Crown molding cutting aid apparatus
Apparatus and method for operating a checkout system which has a number of payment devices for tendering payment during an assisted checkout transaction
Coffee maker