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
Managing resource allocation and configuration of model building components of data analysis applications
Lightweight robust thin flexible polymer coated glove
Shower head
Electrophoretic display driving approaches
Method for establishing a path, having a certain QOS-class and a related access multiplexer
Tunable laser source using intracavity laser light outcoupling and module containing the same
Vehicle rear upper bumper cover
  Randomly Featured Patents
Arrangement for producing spool packages used as feeding packages for twisting
Piping system for etch equipment
Buckling restrained brace for structural reinforcement and seismic energy dissipation
Servo drive for activating a tailgate of a motor vehicle
Coaxial connector for connecting two circuit boards
Classifying a work machine operation
Facilities for the examination of radioactive bodies
Volatile actives dispenser
Nitro pyrrols and their pharmaceutical use
Burst write in a non-volatile memory device