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
Reception circuit and signal reception method
Inhibitor of casein kinase 1delta and casein kinase 1E
Systems and methods for restoring images
Plants and seeds of hybrid corn variety CH450823
Automated synchronization of design features in disparate code components using type differencing
Dyes and methods of marking biological material
Integrating multimedia capabilities with circuit-switched calls
  Randomly Featured Patents
Method of controlling insects and mites with pulsed ultraviolet light
Ink jet ink, method for producing ink jet ink, ink jet recording method and ink cartridge
Crystalline aluminum oxide layers having increased energy band gap, charge trap layer devices including crystalline aluminum oxide layers, and methods of manufacturing the same
Shoe upper
Device for adjusting length of rod
Waterjet cutting tool interface apparatus and method
Combined processing station for use in an electrophotographic printing machine
Coal liquefaction process
Holster for a handgun
Water filter