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
LED lighting module
Drive coil, measurement probe comprising the drive coil and methods utilizing the measurement probe
Flash drive
Virtual billboards
Method and system for dynamically representing distributed information
System and method for measuring an analyte in a sample
Managing deduplication density
  Randomly Featured Patents
Method and apparatus for acquiring and reconstructing magnified specimen images from a computer-controlled microscope
In situ calibration of inductively coupled plasma-atomic emission and mass spectroscopy
Fuel management system for very high efficiency flex fuel engines powered by methanol and gasoline
Method for fabricating a liquid crystal display device including irradiating first and second ion beams onto inclined and flat surfaces of the TFT substrate
Motor vehicle chassis subassembly
Optical interconnect for high speed processor
Synthetic pheromone 8-methyl-2-decanol propanoate
Systems for adjusting and evaluating positional relationship between light-receiving element and optical fiber
Key distribution
Self-alignment insulation structure