- Patent Title: Efficient determination of join paths via cardinality estimation
-
Application No.: US16179802Application Date: 2018-11-02
-
Publication No.: US10831759B2Publication Date: 2020-11-10
- Inventor: Anurag Windlass Gupta , Timothy Andrew Rath , Srinivasan Sundar Raghavan , Santosh Kalki
- Applicant: Amazon Technologies, Inc.
- Applicant Address: US WA Seattle
- Assignee: Amazon Technologies, Inc.
- Current Assignee: Amazon Technologies, Inc.
- Current Assignee Address: US WA Seattle
- Agency: Davis Wright Tremaine LLP
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F16/2455 ; G06F16/27

Abstract:
A probabilistic counting structure such as a hyperloglog may be formed during a table scan for each of a selected set of columns. The columns may be selected based on an initial estimate of relatedness, which may be based on data types of the respective columns. An estimated cardinality of an intersection or union of columns may be formed based on an intersection of the probabilistic data structures. A join path may be determined based on the estimated cardinality of an intersection or union of the columns.
Public/Granted literature
- US20190073398A1 EFFICIENT DETERMINATION OF JOIN PATHS VIA CARDINALITY ESTIMATION Public/Granted day:2019-03-07
Information query