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
Placental tissue grafts
Semiconductor apparatus
Food-grade flour from dry fractionated corn germ and collet composition and method for producing same
Triazine ring-containing polymer and film-forming composition comprising same
Light-emitting element, light-emitting device, and electronic device
Light source lighting device including a constant-current supply that is connected to a light source and supplies a constant current of a substantially constant magnitude to the light source,
Noise suppression in speech signals
  Randomly Featured Patents
Process and arrangement for producing an elongated closed duct within a hollow space of the vehicle body
Process for producing sinterable crystalline aluminum nitride powder
Device for allowing the use in an aircraft of radio communication means
Sublimation thermal transfer recording method and recording material therefor
Radio frequency identifiers in game tickets
System for cooling blades in a gas turbine
Lubricating oil additive composition and method of making the same
Method for producing magnesium metal from magnesium oxide
Process for producing light-weight oil from waste plastics containing phthalic polyester and/or polyvinyl chloride
System, decoder and method for transmitting, receiving and decoding high-speed digital data signals with reduced electromagnetic emissions