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

Database .................................................................................... 5 2. The SQL Language ......................................................................................... ......................... 26 II. The SQL Language ....................................................................................................... 27 4. SQL Syntax ............................. ....................................................................................... 759 26.1. SQL Dump .............................................................................................

a Database .............................................................................. 5 2. The SQL Language ......................................................................................... ............................ 24 II. The SQL Language ................................................................................................. 25 4. SQL Syntax ................................ Restore ...................................................................................... 724 26.1. SQL Dump ....................................................................................... 724 26

Database .................................................................................... 5 2. The SQL Language ......................................................................................... ......................... 26 II. The SQL Language ....................................................................................................... 27 4. SQL Syntax ............................. ....................................................................................... 823 25.1. SQL Dump .............................................................................................

a Database .............................................................................. 5 2. The SQL Language ......................................................................................... ............................ 24 II. The SQL Language ................................................................................................. 25 4. SQL Syntax ................................ Restore ...................................................................................... 780 25.1. SQL Dump ....................................................................................... 780 25

Database .................................................................................... 5 2. The SQL Language ......................................................................................... ......................... 26 II. The SQL Language ....................................................................................................... 27 4. SQL Syntax ............................. ....................................................................................... 798 26.1. SQL Dump .............................................................................................

a Database .............................................................................. 5 2. The SQL Language ......................................................................................... ............................ 24 II. The SQL Language ................................................................................................. 25 4. SQL Syntax ................................ Restore ...................................................................................... 758 26.1. SQL Dump ....................................................................................... 758 26

Database .................................................................................... 5 2. The SQL Language ......................................................................................... ......................... 26 II. The SQL Language ....................................................................................................... 27 4. SQL Syntax ............................. ....................................................................................... 771 26.1. SQL Dump .............................................................................................

a Database .............................................................................. 5 2. The SQL Language ......................................................................................... ............................ 24 II. The SQL Language ................................................................................................. 25 4. SQL Syntax ................................ Restore ...................................................................................... 734 26.1. SQL Dump ....................................................................................... 734 26

Database .................................................................................... 5 2. The SQL Language ......................................................................................... ......................... 26 II. The SQL Language ....................................................................................................... 27 4. SQL Syntax ............................. ....................................................................................... 737 25.1. SQL Dump .............................................................................................