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
System and method for deposition in high aspect ratio magnetic writer heads
Image forming apparatus
Transducer displacement protection
Dihydronaphthyridinyl(organo)methanone analogs as positive allosteric mGluR5 modulators
Optical input device
Early kill removal graphics processing system and method
Apparatus and method for noise removal by spectral smoothing
  Randomly Featured Patents
Ship or boat construction having three hulls
Method for compensating for boresight error in missiles with composite radomes and guidance section with boresight error compensation
Process for discontinuous coating of a web by periodic deflection thereof against a fluid coating
Browser on test equipment
Developing fault model from service procedures
Image processing method and apparatus for adjusting the tone density of pixels based upon differences between the tone density of a center pixel and tone densities of peripheral pixels
Interlocking seal for insulated panels
Child resistant package
Reactor for processing gaseous media
Apparatus and method for providing, retrieving, and using data guide information supplied in a digital vestigial sideband signal