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
Authentication service
Integrated circuit with electromagnetic intrachip communication and methods for use therewith
Detection of code-based malware
Automatic pill dispenser
Systems, computer programs, and methods for controlling costs of a healthcare practice
Systems and methods to provide report part via a web service
Radio transmitter and radio receiver with channel condition assessment
  Randomly Featured Patents
Methods and apparatus for self-trim calibration of an oscillator
Home network name displaying methods and apparatus for multiple home networks
Control of electrode depth in electroslag remelting
Nucleic acid molecules that encode tassel seed 2(TS2), a protein involved in the control of flower development in plants
Method for inter-system inter-MSC handover to UMA
Method for producing hologram by pico-second laser
Boundary resolution improvement for a capacitive touch panel
Surgical tool having electrocautery energy supply conductor with inhibited current leakage
Device for the phase realignment of ATM cells optical ATM nodes
Application of different isolation schemes for logic and embedded memory