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
Passive charge cord release system for an electric vehicle
Taste receptors of the T1R family from domestic cat
Monitoring heap in real-time by a mobile agent to assess performance of virtual machine
In-vehicle communication system and method of operation
Obviation of recovery of data store consistency for application I/O errors
Transmitting a synchronizing signal in a packet network
Post-processing including median filtering of noise suppression gains
  Randomly Featured Patents
Process and apparatus for creasing folded edges of paper products
Aqueous pigmented yellow inkjet ink composition
Picture encoding method and picture encoding device
Medical patch
Means to guide the motion of a pair of weft carrying grippers inside the shed of weaving looms
Apparatus for coating fasteners
Self-venting drain value assembly
Semiconductor device and method for fabricating same
Method of making heat sealed produce bags
Bandages comprising compressed cellulose