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 hybrid corn variety CH450823
System and method for operating an electric power converter
Summarization of short comments
Three-dimensional holographic display using active shutter
Scalable packet processing systems and methods
Determination and presentation of package pricing offers in response to customer interest in a product
Embedded bonding pad for image sensors
  Randomly Featured Patents
Process for partitioning of proteins
Treatment of process gases containing halogenous compounds
Genes encoding a nystatin polyketide synthase and their manipulation and utility
Fish shaped wall hook
Apparatus for the reduction of tobacco smoke
Semiconductor light-emitting element
Manufacturing method of secondary battery, restraining jig for secondary battery, charging/discharging device for secondary battery, and charging device for secondary battery
Foldable film winding crank for camera
Method for preparing a nonwoven web containing antimicrobial siloxane quaternary ammonium salts
Manual turbobrush