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
Etch resistant clearcoat
System for the secure management of digitally controlled locks, operating by means of crypto acoustic credentials
Error detection and recovery tool for logical volume management in a data storage system
Method and apparatus for band switching in wireless local access network
Behavioral fingerprint based authentication
System and method for providing security in browser-based access to smart cards
Apparatus and method of preventing signal delay in display device
  Randomly Featured Patents
System and method for preconcentrating, identifying, and quantifying chemical and biological substances
Microwave oven with microcomputer operated according to cooking programs stored in a memory
Synthesis of pyrrole-2-carbonitriles
Inhaler device
Variable displacement pump
Method of making acid contacted enhanced aluminum oxide adsorbent particle
Reflective Fabry-Perot interferometer
Synchronous dynamic random access memory semiconductor device having write-interrupt-write function
Wireless human interface device (HID) coordination
Bell-band drive connection for disc brake