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
Method of operating an electromechanical converter, a controller and a computer program product
Synthetic refrigeration oil composition for HFC applications
Cell transport system comprising a homogeneous mixture of agarose and agarase
Segmented display panel and camera with segmented display
Acrylic pressure-sensitive adhesive composition, acrylic pressure-sensitive adhesive layer, and acrylic pressure-sensitive adhesive tape
Method for remotely measuring fluctuations in the optical index of refraction of a medium
  Randomly Featured Patents
Finger ring display holder
Stroke adjusting apparatus for a punching press
Blind, slat for blinds, and method of producing the same and forming machine therefor
Stabilized halogen containing polymer compositions
Automatic gain control apparatus determining echo return loss
Impatiens plant named `96-009-18`
Thermoplastic elastomer blends
Light-weight wheel assembly for wheelchairs
Swivel elbow for a patient interface
Resistance welding electrode and method of manufacturing same