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
Point-of-sale cart
Method and apparatus of motion vector prediction with extended motion vector predictor
Load balancing for parallel tasks
System and method for testing an integrated circuit embedded in a system on a chip
Fusing device to prevent overheating of a heating member and image forming apparatus having the same
Systems and methods for authorizing, authenticating and accounting users having transparent computer access to a network using a gateway device
  Randomly Featured Patents
Alkyl ether amine conveyor lubricant
Method for multilevel programming of phase change memory cells using a percolation algorithm
Cylinder identifying apparatus for an internal-combustion engine
Projectile feeder for a gripper projectile weaving machine
Reduced computation system for wavelet transforms
Transaction-based storage system and method that uses variable sized objects to store data
Automatic safety syringe construction
Apparatus for mixing a chemical medium with a pulp suspension
Application of an improved damper to an intervertebral stabilization device
Spray nozzle