WIPO logo
Mobile | Deutsch | Español | Français | 日本語 | 한국어 | Português | Русский | 中文 | العربية |
PATENTSCOPE

Search International and National Patent Collections
World Intellectual Property Organization
Search
 
Browse
 
Translate
 
Options
 
News
 
Login
 
Help
 
Machine translation
1. (WO2018052519) N-WAY HASH JOIN
Latest bibliographic data on file with the International Bureau    Submit observation

Pub. No.:    WO/2018/052519    International Application No.:    PCT/US2017/042319
Publication Date: 22.03.2018 International Filing Date: 17.07.2017
IPC:
G06F 17/30 (2006.01)
Applicants: ORACLE INTERNATIONAL CORPORATION [US/US]; 500 Oracle Parkway, Mail Stop 50P7 Redwood Shores, California 94065 (US)
Inventors: AMOR, Angela; (US).
WITKOWSKI, Andrew; (US).
BONDALAPATI, Srikanth; (US).
SUBRAMANIAN, Sankar; (US)
Agent: MEIKLE, Tammy L.; (US).
BINGHAM, Marcel K.; (US).
PAPANYAN, Khachatur V.; (US).
MADRAK, Jeffrey R.; (US).
HICKMAN, Brian D.; (US).
PATHIYAL, Sanjay; (US).
STONE, Adam C.; (US).
PALERMO, Christopher J.; (US).
LEDESMA, Daniel D.; (US).
BECKER, Edward A.; (US).
BARATZ, Justin R.; (US).
KULCZYCKA, Malgorzata A.; (US).
BAJWA, Sanjeev S.; (US).
GELBLUM, Michael; (US).
MCGUIRE, John; (US).
CHEN, Duo; (US).
KANZAKI, Kim; (US).
BAGGALEY, Nicholas; (US).
CHENG, Charles; (US).
MILLER, Brian; (US).
PARKER, Daniel W.; (US).
HUTCHINS, Eric; (US).
KOCIALSKI, Molly; (US).
NICHOLES, Chris; (US).
SUTTON, Eric; (US).
WEBER, Rick; (US).
HALE, Fred T.; (US).
WAN, Tiffany; (US).
LIU, Agatha; (US).
ORICH, Christine E.; (US).
MEEHAN, Michael J.; (US)
Priority Data:
15/266,751 15.09.2016 US
Title (EN) N-WAY HASH JOIN
(FR) JOINTURE DE HACHAGE À N VOIES
Abstract: front page image
(EN)Techniques are described herein for processing queries comprising joins specifying a plurality of tables. The techniques involve partitioning the tables by assigning rows to partitions. One or more partition maps may be generated to indicate the partitions. Subsequent tables may be partitioned based on the generated partition maps. The partitions may be used to determine results for the joins.
(FR)L'invention concerne des techniques de traitement d'interrogations comprenant des jointures spécifiant une pluralité de tables. Les techniques consistent à partitionner les tables en attribuant des rangées à des partitions. Une ou plusieurs cartes de partition peuvent être générées pour indiquer les partitions. Des tables subséquentes peuvent être partitionnées sur la base des cartes de partition générées. Les partitions peuvent être utilisées pour déterminer des résultats pour les jointures.
Designated States: AE, AG, AL, AM, AO, AT, AU, AZ, BA, BB, BG, BH, BN, BR, BW, BY, BZ, CA, CH, CL, CN, CO, CR, CU, CZ, DE, DJ, DK, DM, DO, DZ, EC, EE, EG, ES, FI, GB, GD, GE, GH, GM, GT, HN, HR, HU, ID, IL, IN, IR, IS, JO, JP, KE, KG, KH, KN, KP, KR, KW, KZ, LA, LC, LK, LR, LS, LU, LY, MA, MD, ME, MG, MK, MN, MW, MX, MY, MZ, NA, NG, NI, NO, NZ, OM, PA, PE, PG, PH, PL, PT, QA, RO, RS, RU, RW, SA, SC, SD, SE, SG, SK, SL, SM, ST, SV, SY, TH, TJ, TM, TN, TR, TT, TZ, UA, UG, US, UZ, VC, VN, ZA, ZM, ZW.
African Regional Intellectual Property Organization (BW, GH, GM, KE, LR, LS, MW, MZ, NA, RW, SD, SL, ST, SZ, TZ, UG, ZM, ZW)
Eurasian Patent Organization (AM, AZ, BY, KG, KZ, RU, TJ, TM)
European Patent Office (AL, AT, BE, BG, CH, CY, CZ, DE, DK, EE, ES, FI, FR, GB, GR, HR, HU, IE, IS, IT, LT, LU, LV, MC, MK, MT, NL, NO, PL, PT, RO, RS, SE, SI, SK, SM, TR)
African Intellectual Property Organization (BF, BJ, CF, CG, CI, CM, GA, GN, GQ, GW, KM, ML, MR, NE, SN, TD, TG).
Publication Language: English (EN)
Filing Language: English (EN)