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
Programmable computer mouse
Liquid-filled protein-phosphatidic acid capsule dispersions
Camera with monitor
Protein kinase C inhibitors and uses thereof
Compounds, compositions and methods for reducing lipid levels
Nonvolatile semiconductor memory device and method of manufacturing the same
  Randomly Featured Patents
Apparatus for winding wire on a spool
Least recently used block replacement for four block cache logic system
Component interconnect apparatus
Behind the ear hearing aid system
In-vehicle electric storage device
Protective control system for watercraft
Laser protractor
Automatic cyclic fluid delivery device and associated process
Tunneling magnetic sensing element having free layer containing CoFe alloy
Method of reducing glial scar formation and promoting axon and blood vessel growth and/or regeneration through the use of activated immature astrocytes