logo

For the Inventor, By the Inventor

The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.

The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.

Patent No.:

US 9569494 B1

PDFFull Text
Expired
Date of Patent:
Feb. 14, 2017

Filed:

Jun. 24, 2014

Avoidance of intermediate data skew in a massive parallel processing environment

Applicant:

International Business Machines Corporation, Armonk, NY (US);

Inventors:

Lukasz Gaza, Jankowice, PL;

Artur M. Gruszecki, Cracow, PL;

Tomasz Kazalski, Cracow, PL;

Grzegorz S. Milka, Janow, PL;

Konrad K. Skibski, Cracow, PL;

Tomasz Stradomski, Bedzin, PL;

Assignee:

International Business Machines Corporation, Armonk, NY (US);

Attorney:

Arnold B. Bangali

Primary Examiner:

Mahesh Dwivedi

Int. Cl.
CPC ...
G06F 17/30 (2006.01);
U.S. Cl.
CPC ...
G06F 17/30466 (2013.01); G06F 17/3033 (2013.01); G06F 17/30469 (2013.01); G06F 17/30498 (2013.01); G06F 17/30501 (2013.01);
Abstract

A computer-implemented method for minimizing join operation processing time within a database system based on estimated joined table spread of the database system has been provided. The computer-implemented method includes estimating value distribution of data in a joined table, wherein the joined table is a result of join operation between two instances of tables of a database system. The computer-implemented method further includes determining boundaries for partitioning at least one range of attributes of the estimated value distribution, wherein the boundaries for partitioning at least one range of attributes of the estimated value distribution corresponds to a same number of rows of the joined table. The computer-implemented method further includes determining at least one assignment of the determined partition of the at least one range of attributes to processing units of the database system.

Find Patent Forward Citations

Gaza, Lukasz. (2017). Avoidance of intermediate data skew in a massive parallel processing environment (U.S. Patent No. 9569494). U.S. Patent and Trademark Office. https://idiyas.com/patent/badge/9569494

Data source: USPTO (United States Patent and Trademark Office) public patent records. Weekly synchronization. How IDiyas builds this profile

Loading…