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
Transparent conductive structure
Flood protection apparatus and container data center including the same
Glycosyltransferase promoter
Communication terminal, communication system, server apparatus, and communication connecting method
Gas flow indicator
Sensing during magnetic resonance imaging
Terminal device, system and computer readable medium
  Randomly Featured Patents
Method and apparatus for laser return characterization in a countermeasures system
Process for the preparation of finely divided solid polymers in polyol
Organic electroluminescence device and anthracene derivative
Display substrate and method of manufacturing the same
Method of filling an opening in a material layer with an insulating material
Reducing vibration using QR decomposition and unconstrained optimization for a multi-rotor aircraft
Method for fabricating diodes for electrostatic discharge protection and voltage references
Antifungal formulation
Process for the continuous production of fermentation alcohol