Product join dynamic partition elimination for multilevel partitioning

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 8396862
APP PUB NO 20090037365A1
SERIAL NO

11830000

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

A method of searching a multilevel partitioned database includes receiving a query data from the multilevel partitioned database. At least for one level partitions are dynamically included. For some levels, partitions may also be statically included for execution of the query. The query is the executed over the partitions that are both dynamically and statically included. In one example, the cost of joining two tables in a multilevel partitioned database includes determining level partitions that can be statically included, estimating level partitions that will be dynamically considered for the join, and determining a cost as a function of the estimated statically included level partitions and estimated dynamically included level partitions.

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

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddress
TERADATA US INC17095 VIA DEL CAMPO SAN DIEGO CA 92127

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Luo, Xiaorong Bellevue, US 14 138
Sinclair, Paul Manhattan Beach, US 15 288
Sirek, Mark San Diego, US 4 46

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation