A Deep-Dive on PolarDB Parallel Scanning Technology

1. Background

2. How Parallel Queries Work

3. Select Tables for Parallel Scanning

SELECT c.c_name, sum(o.o_totalprice) as s
FROM customer c, orders o
WHERE c.c_custkey = o.o_custkey
AND o_orderdate >= '1996-01-01'
AND o_orderdate <= '1996-12-31'
GROUP BY c.c_name
ORDER BY s DESC
LIMIT 10;

4. Join Multiple Tables Selected for Parallel Scanning

SELECT o.o_custkey, sum(l.l_extendedprice) as s
FROM orders o, lineitem l
WHERE o.o_custkey = l.l_orderkey
GROUP BY o.o_custkey
ORDER BY s
LIMIT 10;

5. Parallel Execution of Complex Operators in Statistical Analysis

6. Linear Acceleration of Parallel Query Engines for TPC-H Queries

7. Summary

About Us

First-hand & in-depth information about Alibaba's tech innovation in Artificial Intelligence, Big Data & Computer Engineering. Follow us on Facebook!