and Related Constructs.........................................................................211 11. Indexes ......................................................................................... ...........................................................................................1322 E.11. Release 8.1.1 ................................................................................... ..............................................................................................99 8-11. Time Input ......................................................................................

有幸参与了Oracle RAC到 Greenplum再到Hadoop以及最终到 ODPS的架构演进工作。 ⚫ 2012年起，转至阿里巴巴大数据团队，负责Hbase/OTS业务支 撑，期间多次负责阿里大数据双11架构和稳定性工作 ⚫ 2018年，在阿里云数据库负责OLAP产品管理团队。 1. Greenplum发展史 @Alibaba 2. AnalyticDB for PostgreSQL产品介绍 PostgreSQL 典型场景 4. AnalyticDB for PostgreSQL 未来演进 Greenplum发展史@Alibaba rac1 rac2 rac3 rac n Oracle RAC 11G ODPS ETL建模 交互式分析 AnalyticDB for MySQL 实时数仓 ⚫ All In One数仓去O ⚫ 交互式分析 ⚫ 中小规模实时数仓 小烟枪在阿里的场景裂变 计算组（Compute Groups） • 全并行分析计算 • 数据双副本存储 • 定期自动备份 OSS • 数据并行加载 • 水平扩展：Share-Nothing 架构水平扩展，海量数据在线分析 • 行/列存储模型：行存储支持高并发在线分析，列存储支持全表数据高性能关联聚合 • 高可靠架构：支持分布式事务及ACID，双副本、主备切换透明，支持服务高可用 分 区 分 区 分 区 分

and Related Constructs.........................................................................210 11. Indexes ......................................................................................... .....................................................................................1343 xxiv E.11. Release 7.4.5 ................................................................................... ..............................................................................................99 8-11. Time Input ......................................................................................

CASE, and ARRAY Constructs...................................................................186 11. Indexes ......................................................................................... ...........................................................................................1168 E.11. Release 7.3.6 ................................................................................... ..............................................................................................87 8-11. Time Input ......................................................................................

and ARRAY Constructs..........................................................................196 11. Indexes ......................................................................................... ...........................................................................................1249 E.11. Release 7.3.6 ................................................................................... ..............................................................................................92 8-11. Time Input ......................................................................................

Joins Between Tables ............................................................................. 11 2.7. Aggregate Functions ......................................................................... 10.6. SELECT Output Columns .................................................................... 377 11. Indexes ......................................................................................... Release 11.13 .................................................................................. 2404 E.11. Release 11.12 .................................................................................. 2409

SELECT Output Columns ......................................................................... 397 11. Indexes ......................................................................................... 13 ........................................................................................ 2535 E.11. Release 11.12 ................................................................................... ............................................................................... 2589 E.23. Release 11 ............................................................................................ 2591 E

and Related Constructs.........................................................................222 11. Indexes ......................................................................................... ...........................................................................................1421 E.11. Release 8.2.3 ................................................................................... .............................................................................................102 8-11. Time Input ......................................................................................

and Related Constructs.........................................................................222 11. Indexes ......................................................................................... ...........................................................................................1423 E.11. Release 8.2.12 .................................................................................. .............................................................................................102 8-11. Time Input ......................................................................................

Functions.................................................................................................11 2.8. Updates...................................................................................... CASE, and Related Constructs..................................................................348 11. Indexes ......................................................................................... ...........................................................................................2226 E.11. Release 9.5.15 ..................................................................................