阿里云 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） • 全并行分析计算 • 数据双副本存储 • 定期自动备份

........................................................................................3 2. The SQL Language ......................................................................................... .............................................................................10 2.7. Aggregate Functions................................................................................................ ..............21 II. The SQL Language.............................................................................................................................22 4. SQL Syntax....................

........................................................................................3 2. The SQL Language ......................................................................................... .............................................................................10 2.7. Aggregate Functions................................................................................................ ..............21 II. The SQL Language.............................................................................................................................22 4. SQL Syntax....................

........................................................................................3 2. The SQL Language ......................................................................................... .............................................................................10 2.7. Aggregate Functions................................................................................................ ..................19 II. The SQL Language......................................................................................................................21 4. SQL Syntax.......................

........................................................................................3 2. The SQL Language ......................................................................................... .............................................................................10 2.7. Aggregate Functions................................................................................................ ..............21 II. The SQL Language.............................................................................................................................22 4. SQL Syntax....................

Database .................................................................................... 5 2. The SQL Language ......................................................................................... ............................................................................ 12 2.7. Aggregate Functions .................................................................................... 14 2.8. Updates ............................................................................... 19 3.5. Window Functions ...................................................................................... 21 3.6. Inheritance

........................................................................................3 2. The SQL Language ......................................................................................... .............................................................................10 2.7. Aggregate Functions................................................................................................ ..............21 II. The SQL Language.............................................................................................................................22 4. SQL Syntax....................

........................................................................................3 2. The SQL Language ......................................................................................... .............................................................................10 2.7. Aggregate Functions................................................................................................ ................................................................................17 3.5. Window Functions................................................................................................

a Database .............................................................................. 5 2. The SQL Language ......................................................................................... ............................................................................ 11 2.7. Aggregate Functions .............................................................................. 13 2.8. Updates ............................................................................... 18 3.5. Window Functions ................................................................................. 20 3.6. Inheritance

Database .................................................................................... 5 2. The SQL Language ......................................................................................... ............................................................................ 11 2.7. Aggregate Functions .................................................................................... 13 2.8. Updates ............................................................................... 17 3.5. Window Functions ...................................................................................... 19 3.6. Inheritance