Alibaba Group Holding Limited
METHODS AND DEVICES FOR DYNAMIC FILTER PUSHDOWN FOR MASSIVE PARALLEL PROCESSING DATABASES ON CLOUD

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.