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
System and method for managing investment funds
Methods of making a diagnostic device by interweaving hydrophobic and hydrophilic fibers, and diagnostic device therefrom
Maesa japonica extracts and methods of use
Medicament container
IR(voltage) drop analysis in integrated circuit timing
Aqueous flowable concentrate compositions of a microencapsulated dinitroaniline herbicide
Termite tubing preventative for non-wood materials
  Randomly Featured Patents
Borosiloxane polymers and a method for producing the same
Full/selector output from one of plural flag generation count outputs
Collapsible skateboard
Saddle type vehicle
Process for the maintenance and proliferation of defective non-infectious virus genomes in proliferating plant materials
Window component extrusion
Fuel injection device for internal combustion engines
Image printing method and device
Blank guided forming