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
Detection of procedural deficiency across multiple business applications
Inkjet ink
Washing-up bowl
IR(voltage) drop analysis in integrated circuit timing
Polyurethane resin, toner for developing electrostatic charge image, electrostatic charge image developer, toner cartridge, process cartridge, image forming apparatus, and image forming method
Social network user data advertising
  Randomly Featured Patents
Portable display system
Process and an apparatus for loading a disposable camera with a photographic roll film, and a disposable camera loaded with a photographic roll film
Sound image localization control apparatus
Batt of refractory material
System apparatus and method for applying voice mail short codes in a broadcast message system
Nipple for feeding liquids to fowl and/or small animals
Resist composition for electron beam or EUV
Sealable toner recovery box for an image forming machine
System and method for providing alternate AC voltage
Antibiotic 27,706 RP and salt thereof