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
Horizontal card holder
Advanced joint detection in a TD-SCDMA system
Liquid crystal display and method of driving the same
Dental plier
Liquid crystal display
Measuring current and resistance using combined diodes/resistor structure to monitor integrated circuit manufacturing process variations
System and methods for obstacle mapping and navigation
  Randomly Featured Patents
Turbo-compressor having air cooled bearing
Vulcanizable rubber composition for the manufacture of a tire, and a tire, the tread of which comprises such a composition
Parallelized redo-only logging and recovery for highly available main memory database systems
Filtration monitoring and control system
Methods for elevating neurotrophic agents
Nuclear reactor heat transport system component low friction support system
Circuit and method for providing temperature stability in an FM quadrature detector
Simulcast transmission system having phase-locked remote transmitters
Connector apparatus for IC packs
Vehicle glass with angled edge