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
Implantable medical devices including elongated conductor bodies that facilitate device and lead configuration variants
Clusterin antisense therapy for treatment of cancer
Change management automation tool
Method for transforming a single reactor line
Incrementally increasing deployment of gateways
Method and apparatus for sensing an input object relative to a sensing region of an ultrasound sensor device
  Randomly Featured Patents
Method for controlling a switching converter and control device for a switching converter
Method of improving developed flat field uniformity
Knitted fabric construction for an industrially launderable soft hand knitted garment
Thallium germanate, tellurite, and antimonite glasses
Plug changer for plug mill
Compliant tibial tray assembly
Aromatic diamines and polyurethanes cured thereby
Lawn striping assembly cover
Process for the production of substituted thiazolin-dioxetan substrates and use thereof
Filtering system utilizing rotational flow and dual chambers