阿里云 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 ......................................................................................... ..................21 II. The SQL Language......................................................................................................................22 4. SQL Syntax....................... via the Configuration File.....................................516 19.1.3. Parameter Interaction via SQL.................................................................517 19.1.4. Parameter Interaction via

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.......................

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

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

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

a Database .............................................................................. 5 2. The SQL Language ......................................................................................... ............................ 22 II. The SQL Language ................................................................................................. 23 4. SQL Syntax ................................ Restore ...................................................................................... 628 25.1. SQL Dump ....................................................................................... 628 25

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.......................

........................................................................................3 2. The SQL Language ......................................................................................... ..............24 II. The SQL Language.............................................................................................................................25 4. SQL Syntax.................... Configuration File............................................545 19.1.3. Parameter Interaction via SQL........................................................................546 19.1.4. Parameter Interaction