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
Disk drive with a subset of sectors with reduced write-to-read gap
Light-emitting diode devices
Vending machine
Light-emitting device package and method of manufacturing the same
Carbon blacks having low PAH amounts and methods of making same
Landscape post for solar and other light fixtures
Methods and systems for flicker correction
  Randomly Featured Patents
Audio data transmitting apparatus for webcasting and audio regulating methods therefor
Cable support for an electrically-operated portable handheld work apparatus
Net-reinforced film structure with modified strand profile
Combined disc player, radio receiver and tape recorder
Graphic material registration apparatus and method
Angled cap member for simulated cedar shake construction
Single-panel color image display apparatus and scrolling method
Device for handling at least one tensioning frame, especially for mounting vehicle shells
Loader frame and bolt-on track drive
Sodium thallium type crystal on crystalline layer