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
Single well reservoir characterization apparatus and methods
Semiconductor device and manufacturing method thereof
Disc shaped high density recording medium
Expression of dirigent gene EG261 and its orthologs and paralogs enhances pathogen resistance in plants
Sublingual coated tablet of fentanyl
Method and apparatus for editing a program on an optical disc
Mobile terminal including stellar body watching hookup communications function
  Randomly Featured Patents
Cyclic compound having pyrimidinylalkylthio group
Method and apparatus for detecting pin-holes in a passivation layer
Cache line reservations
Silver halide light-sensitive material
Electrical connections between printed circuit boards and integrated circuits surface mounted thereon
Image forming device
Semiconductor device
Mounting device and bearing cap for a shaft carrying wound-up material
Apparatus and method of generating charged particles
Frequency modulation system