终到 ODPS的架构演进工作。 ⚫ 2012年起，转至阿里巴巴大数据团队，负责Hbase/OTS业务支 撑，期间多次负责阿里大数据双11架构和稳定性工作 ⚫ 2018年，在阿里云数据库负责OLAP产品管理团队。 1. Greenplum发展史 @Alibaba 2. AnalyticDB for PostgreSQL产品介绍 3. AnalyticDB for PostgreSQL 典型场景 应用易开发、适配 支持SQL 2003，部分兼容Oracle语法， 支持PL/SQL 存储过程，OLAP窗口函数，事务及数据库标准隔离级别 完备功能和生态，实现应用快速迁移或适配 • PB级数据秒级响应 MPP水平扩展架构，PB级数据查询秒级响应；向量化计算，及列存储智能索引，领先传统数据库引擎性能 3x； 新一代SQL优化器，实现复杂分析语句免调优 • 支持多模分析 通过PostGIS 未来演进 典型场景分析 数据分析场景 场景挑战 AnalyticDB for PostgreSQL 优势 ETL 批量处理 • 复杂 SQL 调优 • 海量数据关联聚合 • 支持标准SQL，OLAP窗口函数，存储过程 • 新一代Cascade框架 分布式SQL优化器，复杂查询免调优 • MPP多节点全并行计算，PB级数据秒级响应 • 基于列存储的高性能大表扫描，及高压缩比 在线数据探索

Postgres Conference China 2016 中国用户大会 What are your requirements? • Is the workload for OLTP, OLAP or is it mixed? • What percentage of transactions are read-only vs. write? • If using replicas, (Python) Postgres Conference China 2016 中国用户大会 Solutions – Postgres-XL • Scale-out RDBMS • MPP for OLAP • OLTP write and read scalability • Custer-wide ACID properties • Can also act as distributed Bidirectional Replication (BDR) extension – See earlier caveats Postgres Conference China 2016 中国用户大会 OLAP / Reporting PostgreSQL • Use PostgreSQL 9.6 Parallel Query • Use table inheritance to create subtables

roles T332 Extended roles T401 INSERT into a cursor T411 UPDATE statement: SET ROW option T431 OLAP Extended grouping capabilities T432 Nested and concatenated GROUPING SETS T433 Multiargument GROUPING Multiset-returning external SQL-invoked functions T601 Local cursor references T611 OLAP Elementary OLAP operations T612 Advanced OLAP operations T613 Sampling T621 Enhanced numeric functions T631 Core IN predicate

roles T332 Extended roles T401 INSERT into a cursor T411 UPDATE statement: SET ROW option T431 OLAP Extended grouping capabilities T432 Nested and concatenated GROUPING SETS T433 Multiargument GROUPING Multiset-returning external SQL-invoked functions T601 Local cursor references T611 OLAP Elementary OLAP operations T612 Advanced OLAP operations T613 Sampling T621 Enhanced numeric functions T631 Core IN predicate

roles T332 Extended roles T401 INSERT into a cursor T411 UPDATE statement: SET ROW option T431 OLAP Extended grouping capabilities T432 Nested and concatenated GROUPING SETS T433 Multiargument GROUPING Multiset-returning external SQL-invoked functions T601 Local cursor references T611 OLAP Elementary OLAP operations T612 Advanced OLAP operations T613 Sampling T621 Enhanced numeric functions T631 Core IN predicate lization 2060 Appendix J. Acronyms ODBC Open Database Connectivity31 OID Object Identifier OLAP Online Analytical Processing32 OLTP Online Transaction Processing33 ORDBMS Object-Relational

roles T332 Extended roles T401 INSERT into a cursor T411 UPDATE statement: SET ROW option T431 OLAP Extended grouping capabilities T432 Nested and concatenated GROUPING SETS T433 Multiargument GROUPING Multiset-returning external SQL-invoked functions T601 Local cursor references T611 OLAP Elementary OLAP operations T612 Advanced OLAP operations T613 Sampling 1470 Appendix D. SQL Conformance Identifier Package Control NLS National Language Support30 ODBC Open Database Connectivity31 OID Object Identifier OLAP Online Analytical Processing32 OLTP Online Transaction Processing33 21. http://git.postgresql

roles T332 Extended roles T401 INSERT into a cursor T411 UPDATE statement: SET ROW option T431 OLAP Extended grouping capabilities T432 Nested and concatenated GROUPING SETS T433 Multiargument GROUPING Multiset-returning external SQL-invoked functions T601 Local cursor references T611 OLAP Elementary OLAP operations T612 Advanced OLAP operations T613 Sampling T621 Enhanced numeric functions T631 Core IN predicate

roles T332 Extended roles T401 INSERT into a cursor T411 UPDATE statement: SET ROW option T431 OLAP Extended grouping capabilities T432 Nested and concatenated GROUPING SETS T433 Multiargument GROUPING Multiset-returning external SQL-invoked functions T601 Local cursor references T611 OLAP Elementary OLAP operations T612 Advanced OLAP operations T613 Sampling T621 Enhanced numeric functions T631 Core IN predicate

Qualified SQL parameter references T326 Table functions T331 Basic roles T332 Extended roles T431 OLAP Extended grouping capabilities T432 Nested and concatenated GROUPING SETS T433 Multiargument GROUPING SQL Conformance Identifier Package Description Comment T611 OLAP Elementary OLAP operations most forms supported T612 Advanced OLAP operations some forms supported T613 Sampling T616 Null treatment Control NLS National Language Support30 ODBC Open Database Connectivity31 OID Object Identifier OLAP Online Analytical Processing32 21. http://git.postgresql.org/gitweb?p=postgresql.git;a=blob;f=s

Qualified SQL parameter references T326 Table functions T331 Basic roles T332 Extended roles T431 OLAP Extended grouping capabilities T432 Nested and concatenated GROUPING SETS T433 Multiargument GROUPING external SQL-invoked functions T601 Local cursor references T611 OLAP Elementary OLAP operations most forms supported T612 Advanced OLAP operations some forms supported T613 Sampling T616 Null treatment Acronyms NLS National Language Support30 ODBC Open Database Connectivity31 OID Object Identifier OLAP Online Analytical Processing32 OLTP Online Transaction Processing33 ORDBMS Object-Relational