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
Compound containing a carbon or an oxygen isotope, preparation and use thereof, and composition comprising thereof
Print control server, print controlling method, and print control program
Integrated analyses of breast and colorectal cancers
Selected alert delivery in a distributed processing system
Controller with screen
Preserving user applied markings made to a hardcopy original document
Device for producing a connection grid with an integrated fuse
  Randomly Featured Patents
Method for repairing memory cell
Power transmission belt and method of manufacture
Compositions and methods for inducing apoptosis in tumor cells
Energetic rehydration fluid composition in particular for young animals no longer able to digest milk normally
Eave trough flushing system
Anti-coking bushing assembly for an exhaust recirculation control valve
Method and system for tracking a cumulative number of identifiable visitors to different objects
Microscope drape and method of making same
Melting pot
Magnetic head with lateral shielding limbs and a common contact face