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
Monitoring device for monitoring a display device
Digital fine delay processing
Sitagliptin intermediate compounds, preparation methods and uses thereof
Maintenance guidance display device, maintenance guidance display method, and maintenance guidance display program
Method for switching between virtualized and non-virtualized system operation
Tie down strap hook
Resistor and manufacturing method thereof
  Randomly Featured Patents
Control apparatus for hybrid vehicle
Apparatus and method for reducing X-ray dosage during a fluoroscopic procedure
Protective cover system including a corrosion inhibitor and method of inhibiting corrosion of a metallic object
Data storage cartridge having a case with recesses accommodating flanges of tape reels and a drive roller
Outboard jet drive for watercraft
Method and system of accessing and operating a voice message system
Ultra wideband system-on-package
Link analysis mapping program risk management
Multi-directional internal distraction osteogenesis device
Apparatus for manufacturing optical information recording medium