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
Memory access monitoring method and device
Schottky diode and method of manufacture
Method for computing an energy efficient route
Direct connect single layer touch panel
Compositions and methods using microspheres and non-ionic contrast agents
Herbal composition for the treatment of wound healing, a regenerative medicine
Prevention and treatment of osteoarthritis
  Randomly Featured Patents
Controlling well operations based on monitored parameters of cement health
Contoured insulation window for evacuated solar collector
Power transmission chain
Dynamic random access memory circuit and methods therefor
Container door
API evaluation system in embedded device
On-line directory service through the internet
Method for manufacturing an active matrix substrate
Color image forming apparatus and method
Membrane coupling in a compact design