Invention Grant
- Patent Title: Methods and devices for dynamic filter pushdown for massive parallel processing databases on cloud
-
Application No.: US16414218Application Date: 2019-05-16
-
Publication No.: US11625399B2Publication Date: 2023-04-11
- Inventor: Huaizhi Li , Congnan Luo , Ruiping Li , Xiaowei Zhu
- Applicant: ALIBABA GROUP HOLDING LIMITED
- Applicant Address: KY Grand Cayman
- Assignee: ALIBABA GROUP HOLDING LIMITED
- Current Assignee: ALIBABA GROUP HOLDING LIMITED
- Current Assignee Address: KY Grand Cayman
- Agency: Finnegan, Henderson, Farabow, Garrett & Dunner, LLP
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2453 ; G06F16/2458 ; G06F16/22 ; G06F16/9035 ; G06F16/9536
Abstract:
A method for dynamic filter pushdown for massive parallel processing databases on the cloud, including acquiring one or more filters corresponding to a query, acquiring statistics information of one or more database tables, determining a selectivity of the one or more database tables based on the statistics information, determining whether the selectivity satisfies a threshold condition, and pushing down the one or more filters to the one or more database tables based on the determination of whether the selectivity satisfies a threshold condition.
Information query
