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 video encoding
Computer server capable of supporting CPU virtualization
Dynamic data caches, decoders and decoding methods
Strap-hook ring
Touch sensing technology
Method and laser receiver for acoustically indicating a laser beam
  Randomly Featured Patents
Method and arrangement for calculating correlation
Remote engine starter system
Ink jet recording apparatus and recovery method therefor
Portable device for sensing cardiac function and automatically delivering electrical therapy
Rider transaxle having hydrostatic transmission
Sensor network managing apparatus and method thereof
Vehicle body
Image data encryption method, image data transform method, apparatus for the methods, computer program, and computer-readable storage medium
Research plot harvester with unconventional grain flow