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, device and method for transrating file based assets
Listing recommendation using generation of a user-specific query in a network-based commerce system
Satellite communication network
Method of manufacturing pipe with branch
Solar-powered roadway light
Image erasing apparatus and recording medium conveying method for image erasing apparatus
Image sensor with improved color crosstalk
  Randomly Featured Patents
Strain relief and support for electric motor wiring
Clutch-brake device
Dissolved air floatation system
Stacked integrated circuit structure
Indicated state changing pin and method of bending indicating pieces
Oxide magnetic recording layers for perpendicular recording media
Toilet bowl
Evaluating routing congestion based on average global edge congestion histograms
Web service discovery via data abstraction model
Stable antibacterial lyophilizates