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
Denial of service (DoS) attack prevention through random access channel resource reallocation
Potato cultivar F10
Floor relief for dot improvement
Imidazolidine-2,4-dione derivatives, and use thereof as a cancer drug
Motor vehicle, toy and/or replica
Image capture and identification system and process
  Randomly Featured Patents
Grate assembly
Production method of composite silver nanoparticle
Anti-human influenza virus antibody
Method, system, and program for monitoring a device with a computer using user selected monitoring settings
Casting core for an intake pipe assembly for an internal combustion engine
Apparatus for applying pressure in a vertical direction
Method and apparatus for dynamically switching display drivers in mobile device operating system
Method and device for entering test mode in an integrated circuit for use in a floppy disk drive, and a floppy disk drive apparatus incorporating the method
Multilayer assembly with a central electrically conductive layer for use as an inductive sensor element
Dry shaver