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
Domestic soda-water preparing device
Compositions and methods using microspheres and non-ionic contrast agents
Push to release cover for a portable electronic device
Power or voltage oscillation damping in a power transmission system
Flat panel crystal display employing simultaneous charging of main and subsidiary pixel electrodes
Activated carbon cryogels and related methods
Multicyclic compounds and methods of use thereof
  Randomly Featured Patents
Active energy ray curable ink jet recording liquid composition and ink jet recording method using the same
Process for recovering and recycling coagulant present in water treatment sludges
Method and system of assigning a channel without paging
Light fixture
Beamforming in hearing aids
Image forming apparatus, sheet processing apparatus, and image forming system
Toy construction piece
Laser module and method for manufacturing the same
Thermochemical treatment system and process