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
Drug delivery system
Optical switching device and communications system
High-voltage AC light-emitting diode structure
Image processing apparatus, image registering method, program causing computer to execute image registering method, and recording medium in which program is recorded
Related news articles
Techniques for performing translation of messages
Direct connect single layer touch panel
  Randomly Featured Patents
Method and system of a head for a storage media
Synaptojanin isoform
Liquid metal contact reed relay with integrated electromagnetic actuator
Begonia plant named St. Helena
Bicycle shock absorber with elastic members closely fitted between first and second rotating members
Voltage switchable dielectric for die-level electrostatic discharge (ESD) protection
Plastics compatible detergent composition and method of cleaning plastics comprising reverse polyoxyalkylene block co-polymer
Mini-module with upwardly directed leads
Process for producing a lighting louver
Non-volatile memory with predictive programming