阿里云 AnalyticDB for PostgreSQL - 打造更简单易用的Cloud SQL Data Warehouse 个人介绍 缪长风 ⚫ 2010年初加入支付宝，负责Oracle RAC和Greenplum数据仓库 ⚫ 有幸参与了Oracle RAC到 Greenplum再到Hadoop以及最终到 ODPS的架构演进工作。 ⚫ 2012年起，转至阿里巴巴大数据团队，负责Hbase/OTS业务支 构筑在线企业数据仓库。 • 应用易开发、适配 支持SQL 2003，部分兼容Oracle语法， 支持PL/SQL 存储过程，OLAP窗口函数，事务及数据库标准隔离级别 完备功能和生态，实现应用快速迁移或适配 • PB级数据秒级响应 MPP水平扩展架构，PB级数据查询秒级响应；向量化计算，及列存储智能索引，领先传统数据库引擎性能 3x； 新一代SQL优化器，实现复杂分析语句免调优 • 支持多模分析 库内置100+ 机器学习算法库，实现数据智能探索；高性 能向量检索算法，支持视频/图像检索 以图搜图 AnalyticDB for PostgreSQL 产品架构 协调节点 OSS 分布式云存储服务 SQL Client/BI Tools 协调节点（Master Node） • 接收请求，制定分布式执行计划 计算组（Compute Groups） • 全并行分析计算 • 数据双副本存储 • 定期自动备份

Notice PostgreSQL is Copyright © 1996-2013 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below. Postgres95 is Copyright ........................................................................................3 2. The SQL Language ......................................................................................... ..................19 II. The SQL Language......................................................................................................................21 4. SQL Syntax.......................

Notice PostgreSQL is Copyright © 1996-2013 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below. Postgres95 is Copyright ........................................................................................3 2. The SQL Language ......................................................................................... ..............21 II. The SQL Language.............................................................................................................................22 4. SQL Syntax....................

Notice PostgreSQL is Copyright © 1996-2014 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below. Postgres95 is Copyright ........................................................................................3 2. The SQL Language ......................................................................................... ..................21 II. The SQL Language......................................................................................................................22 4. SQL Syntax.......................

a Database .............................................................................. 5 2. The SQL Language ......................................................................................... ............................ 24 II. The SQL Language ................................................................................................. 25 4. SQL Syntax ................................ ................. 494 15. Parallel Query .............................................................................................. 496 15.1. How Parallel Query Works .............................

a Database .............................................................................. 5 2. The SQL Language ......................................................................................... ............................ 24 II. The SQL Language ................................................................................................. 25 4. SQL Syntax ................................ ................. 509 15. Parallel Query .............................................................................................. 510 15.1. How Parallel Query Works .............................

Notice PostgreSQL is Copyright © 1996-2014 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below. Postgres95 is Copyright ........................................................................................3 2. The SQL Language ......................................................................................... ..............24 II. The SQL Language.............................................................................................................................25 4. SQL Syntax....................

Database .................................................................................... 5 2. The SQL Language ......................................................................................... ......................... 26 II. The SQL Language ....................................................................................................... 27 4. SQL Syntax ............................. ............... 522 15. Parallel Query ................................................................................................... 524 15.1. How Parallel Query Works ..........................

Database .................................................................................... 5 2. The SQL Language ......................................................................................... ......................... 26 II. The SQL Language ....................................................................................................... 27 4. SQL Syntax ............................. ............... 536 15. Parallel Query ................................................................................................... 538 15.1. How Parallel Query Works ..........................

a Database .............................................................................. 5 2. The SQL Language ......................................................................................... ............................ 24 II. The SQL Language ................................................................................................. 25 4. SQL Syntax ................................ ................. 523 15. Parallel Query .............................................................................................. 524 15.1. How Parallel Query Works .............................