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
Communication system and data transmission method thereof
Method and apparatus for power management control of an embedded memory having sleep and shutdown features
Polypeptides having beta-glucosidase activity and beta-xylosidase activity and polynucleotides encoding same
Vehicle control apparatus
Automated pizza preparation and vending system
Electrode tab for secondary battery and secondary battery using the same
  Randomly Featured Patents
Nest and stack container
Process for converting waxy feeds into low haze heavy base oil
Blood loss detection for hemodialysis system
System for bus master changeover with a dummy cycle on a data bus
Steerable endovascular graft delivery system
Heat sink arrangement for electrical apparatus
Audio based human-interaction proof
Method and apparatus for piecing slivers in a spinning machine by throttling in a nozzle
Process for the preparation of polyaluminum compounds
General purpose memory compiler system and associated methods