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 and system for remote delivery of email
Method and system for network configuration for virtual machines
Image forming apparatus
Modified continuous phase modulation communications system and related methods
Nuclear fission reactor, a vented nuclear fission fuel module, methods therefor and a vented nuclear fission fuel module system
Battery power management system and method
Voltage level shift circuits and methods
  Randomly Featured Patents
Spray tip for a caulking tube
Training a support vector machine with process constraints
Perforating string with longitudinal shock de-coupler
Encoding and decoding data arrays
Vaporization and ionization of metals for use in semiconductor processing
Stabilized anaerobic adhesives
Electric arc welding system
Multi-purpose retractable tractor toolbar device
Drive system having a common control-pressure connection
Method and system for determining connection states of straight short vectors representing figure in curve fitting