Method and system for look ahead query evaluation planning based on interesting partition properties

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 6345267
SERIAL NO

09517355

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

A relational data base management system includes a query processor that uses a query operator partition property to perform QEP pruning and to ensure that data input to a query operator is partitioned appropriately for the operation. The partition property indicates the group of network nodes across which a table is distributed. The query processor also makes use of partition classes that are designated 'interesting classes' to perform preoptimization planning and query pruning, and to perform look-ahead partitioning based on partition classes that are identified as being of interest to future operations, thereby more efficiently evaluating complex query statements in an MPP, shared-nothing environment.

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddress
INTERNATIONAL BUSINESS MACHINES CORPORATIONNEW ORCHARD ROAD ARMONK NY 10504

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Lohman, Guy Maring San Jose, CA 27 1932
Shekita, Eugene Jon San Jose, CA 16 1177
Simmen, David E San Jose, CA 26 1631
Urata, Monica Sachiye Saratoga, CA 11 1275

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation