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
Autonomous adaptation of transmit power
Pickup device and method for manufacturing the same
Apparatus and method for sterilizing vessel with electron beam
Image forming apparatus
Device, information processing method, and computer-readable storage medium
Routing of data including multimedia between electronic devices
Image scanner and image forming apparatus
  Randomly Featured Patents
Method of forming a bond pad
Managing multiple languages in a data language
Drum type washing machine
Thermal realtime clock
Computer hardware insert device for software authorization
Crimping and decapping press
Laser diode module with a built-in high-frequency modulation IC
Sleeve type of coreless motor with reduced starting current
Fluid-flow control devices particularly useful as dripper nozzles in trickle irrigation
Beverage cup lid