Resources Contact Us Home
Query optimization system and method

Image Number 11 for United States Patent #6546381.

A query optimization system and method are particularly suitable for generating a least cost query plan expressible on a plurality of heterogeneous database schemas that are restructuring views of each other. The query optimization system receives a query against one of the tables and converts it to a plurality of alternate queries, each formatted for the particular schema of a different one of the plurality of heterogeneous tables. In generating the alternate queries, the system may utilize SchemaSQL view definitions and may employ restructuring operators expressing and capable of conducting a restructuring of a table into a restructuring view of the table. A middleware system involving a canonical schema and a virtual canonical table may also be employed to express a mapping between restructuring views for purposes of query conversion. The alternate queries may be costed and optimized and a query plan returned that has a least cost or service time involved.

  Recently Added Patents
Tungsten barrier and seed for copper filled TSV
Modified and stabilized GDF propeptides and uses thereof
Printing control method and printer for printing on a label
Method, system and program for securing redundancy in parallel computing system
Selection of a suitable node to host a virtual machine in an environment containing a large number of nodes
Real-image zoom viewfinder and imaging apparatus
Nickel-cobalt-manganese multi-element lithium ion battery cathode material with dopants and its methods of preparation
  Randomly Featured Patents
Magnifying glass
Replaceable inkjet ink solvent application system
Information processing apparatus, input operation determination method, and input operation determination program
Liquid modified epoxy resins and their preparation
Polymers, resist compositions and patterning process
Reagent containment and delivery tray and method of use
Titanium-based alloys having improved inspection characteristics for ultrasonic examination, and related processes
Self laminating clean release card
Radiation shielding device for nuclear facilities