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
Train car for proppant containers
Flat display panel and method for forming the same
Methods, devices and computer program products providing for establishing a model for emulating a physical quantity which depends on at least one input parameter, and use thereof
Virtual multi-cluster clouds
Control unit including a computing device and a peripheral module which are interconnected via a serial multiwire bus
Light emitting device
Instantaneous single click perpetual date mechanism
  Randomly Featured Patents
Polyamide-poly-carbonate block copolymers
Method to improve final bleached pulp strength properties by adjusting the CI02:03 ration within a single (D/Z) stage of the bleaching process
Very thin achromatic quarter wave film laminate for transflective LCD and method for producing the same
Thermoform bottom with placement and leaf
Thermal detector, thermal detection device, electronic instrument, and thermal detector manufacturing method
Automobile sunroof deflector assembly
Photolithography system and method of monitoring the same
Biodegradable golf tee
Front combination lamp for an automobile
Weft thread-storage apparatus for a loom, especially a gripper loom