阿里云 AnalyticDB for PostgreSQL - 打造更简单易用的Cloud SQL Data Warehouse 个人介绍 缪长风 ⚫ 2010年初加入支付宝，负责Oracle RAC和Greenplum数据仓库 ⚫ 有幸参与了Oracle RAC到 Greenplum再到Hadoop以及最终到 ODPS的架构演进工作。 ⚫ 2012年起，转至阿里巴巴大数据团队，负责Hbase/OTS业务支 Greenplum发展史 @Alibaba 2. AnalyticDB for PostgreSQL产品介绍 3. AnalyticDB for PostgreSQL 典型场景 4. AnalyticDB for PostgreSQL 未来演进 Greenplum发展史@Alibaba rac1 rac2 rac3 rac n Oracle RAC 11G ODPS ETL建模 交互式分析 AnalyticDB 为什么要提供Greenplum云服务 弹性 托管 高可用 安全 监控 1. Greenplum发展史 @Alibaba 2. AnalyticDB for PostgreSQL产品介绍 3. AnalyticDB for PostgreSQL 典型场景 4. AnalyticDB for PostgreSQL 未来演进 AnalyticDB for PostgreSQL 在线MPP数据仓库服务

............................................................................................. iii 3. Conventions....................................................................................... ...................................................................................................3 2. The SQL Language .............................................................................. ...............................................................................................14 3. Advanced Features.................................................................................

PostgreSQL ....................................................................................... xxxii 3. Conventions ...................................................................................... ......................................... 3 1.1. Installation ............................................................................................. 3 1.2. Architectural Fundamentals .......... ............................................................. 3 1.3. Creating a Database ................................................................................. 4 1.4. Accessing a Database .

.............................................................................................xlvi 3. Conventions....................................................................................... Database .................................................................................................3 2. The SQL Language .............................................................................. ...............................................................................................13 3. Advanced Features.................................................................................

...............................................................................................xl 3. Conventions....................................................................................... ...................................................................................................3 2. The SQL Language .............................................................................. ...............................................................................................14 3. Advanced Features.................................................................................

.......................................................................................... xxxvii 3. Conventions....................................................................................... ...................................................................................................3 2. The SQL Language .............................................................................. ...............................................................................................14 3. Advanced Features.................................................................................

PostgreSQL ...................................................................................... xxxiv 3. Conventions ...................................................................................... ......................................... 3 1.1. Installation ............................................................................................. 3 1.2. Architectural Fundamentals .......... ............................................ 3 1.3. Creating a Database ................................................................................. 3 1.4. Accessing a Database ..................

PostgreSQL ...................................................................................... xxxiv 3. Conventions ...................................................................................... ......................................... 3 1.1. Installation ............................................................................................. 3 1.2. Architectural Fundamentals .......... ............................................ 3 1.3. Creating a Database ................................................................................. 3 1.4. Accessing a Database ..................

PostgreSQL ...................................................................................... xxxiv 3. Conventions ...................................................................................... ......................................... 3 1.1. Installation ............................................................................................. 3 1.2. Architectural Fundamentals .......... ............................................ 3 1.3. Creating a Database ................................................................................. 3 1.4. Accessing a Database ..................

PostgreSQL ...................................................................................... xxxiii 3. Conventions ...................................................................................... ......................................... 3 1.1. Installation ............................................................................................. 3 1.2. Architectural Fundamentals .......... ............................................ 3 1.3. Creating a Database ................................................................................. 3 1.4. Accessing a Database ..................