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
Plants and seeds of corn variety CV577261
Redundant parallel operation of motor vehicle electrical system generators
Image forming system, printing control method, and program
Tap initialization of equalizer based on estimated channel impulse response
Method for processing an algae medium containing algae microorganisms to produce algal oil and by-products
Hydrothermal synthesis of nanocubes of sillenite type compounds for photovoltaic applications and solar energy conversion of carbon dioxide to fuels
Method and assembly for determining the temperature of a test sensor
  Randomly Featured Patents
Device for transfering data between an unconscious capture device and another device
Impression cylinder device of sheet-fed printing press with turn-over mechanism
Devices of the turnstile kind for controlling passages requiring authorization
Lens structure
Wellhead casing hanger assembly
Brush head with a shaped bottom plate
Method of producing an abrasive product containing cubic boron nitride
Kneeling board
Method for producing thermoplastic resin sheet or filler-containing resin sheet
Support stand with intermediate connecting assembly