Row hash match scan join using summary contexts for a partitioned database system
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Sep 26, 2006
Issued Date -
N/A
app pub date -
Mar 26, 2002
filing date -
Dec 20, 2001
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
A method, computer system, and computer program are claimed for selecting rows from first and second tables each having rows containing values in columns. In at least the first table, the rows are divided into partitions at least one of which is populated by one or more rows. The method, computer system, and computer program include creating a plurality of partition contexts, each partition context corresponding to a populated partition and storing at least a first value associated with a row. The lowest first value stored by the partition context is determined. Rows with a particular first value are identified by reading the partition contexts, creating a temporary file context corresponding to one of the partition contexts, the temporary file context including location data for a data block of rows in memory, and reading rows in memory.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully