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
Vapor phase decarbonylation process
Image surveillance system and method of detecting whether object is left behind or taken away
Efficient implementation of hash algorithm on a processor
Method, apparatus, computer program, and computer readable storage media for controlling the insertion of tab sheets into a print job
Method and device for generating low-jitter clock
Charging seat having cleaning member
Automatic misalignment balancing scheme for multi-patterning technology
  Randomly Featured Patents
Method and apparatus for stir-frying
Method of producing sintered silicon nitrides
Process for manufacturing chocolate compositions containing water
Reusable ultrasonic surgical instrument with removable outer sheath
Process for improving probertite concentration in probertite containing ore
System and method for making incisions for scleral eye implants
System for storing and managing plural logical volumes in each of several physical volumes including automatically creating logical volumes in peripheral data storage subsystem
Arrangement for transferring workpieces through a succession of machining stations
Replacement retaining ring
Integrated circuit device