Spool file for optimizing hash join operations in a relational database system
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Jul 14, 2020
Grant Date -
Jan 4, 2018
app pub date -
Jun 23, 2017
filing date -
Jun 24, 2016
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
A method for spooling data for use in joining a small table with a large table in a relational database system. The method analyzes a join condition for combining records from the small and large tables, selects qualified rows from the large table, and writes the qualified rows to a spool file. The spool file includes a first partition containing hash values of all bind terms for the join condition; a second partition including a join column with a best selective bind term; and at least one additional partition including additional join columns used in bind terms. The partitions are grouped together within a container row in the spool file, and multiple container rows are written together within a super-container row in the spool file.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
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