 阿里云能够提供一站式的分析解决方案  PostgreSQL的生态发展迅猛  大数据发展势头放缓  数据库更简单易用 为什么要提供Greenplum云服务 弹性 托管 高可用 安全 监控 1. Greenplum发展史 @Alibaba 2. AnalyticDB for PostgreSQL产品介绍 3. AnalyticDB for PostgreSQL 典型场景 全并行执行架构，其单计算节点定位为“计算 组”，一个集群实例由多个计算组组成。 ⚫ 多种规格、满足不同场景需求 -交互式分析 -ETL数据清洗 增强的企业级特性-安全  -数据的备份&恢复  -SQL访问安全审计 增强的企业级特性-高可用  -Master HA切换  -故障自动恢复  -监控服务 云管控高可用 1. 阿里云分析型数据库产品介绍 2. AnalyticDB 在线数据仓库 数据 查询 数据集成 批量同步 1 3 4 2 云化在线数仓 ： 简化、敏捷、一栈式构筑数据仓库 • 一键实现 十分钟 集群创建部署 • 图形化实例管理及自动监控报警 实例SQL安全审计 实例实时监控 实例配置信息 • 云上多种生态工具配套： DTS数据传输 QuickBI DataV 数据集成 阿里云数据工 具服务 阿里云第三方 服务 … … Kettel

c-slave… c-master.. c-slaveN c-masterN MCluster Zk1 Zk… ZkN Monitor + Alert 如何保证数据的安全性 Kafka利用冗余、持久化、偏移量和校验、消息反馈 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 逻辑复制特点

of the left table. When outputting a left-table row for which there is no right-table match, empty (null) values are substituted for the right-table columns. Exercise: There are also right outer joins real, elevation int -- (in ft) ); CREATE TABLE capitals ( state char(2) UNIQUE NOT NULL ) INHERITS (cities); In this case, a row of capitals inherits all columns (name, population, and Constraints ............................................................................... 61 5.4.2. Not-Null Constraints ............................................................................ 63 5.4.3

of the left table. When outputting a left-table row for which there is no right-table match, empty (null) values are substituted for the right-table columns. Exercise: There are also right outer joins real, elevation int -- (in ft) ); CREATE TABLE capitals ( state char(2) UNIQUE NOT NULL ) INHERITS (cities); In this case, a row of capitals inherits all columns (name, population, and ................................................................................... 65 5.4.2. Not-Null Constraints ................................................................................. 68 5

of the left table. When outputting a left-table row for which there is no right-table match, empty (null) values are substituted for the right-table columns. Exercise: There are also right outer joins real, elevation int -- (in ft) ); CREATE TABLE capitals ( state char(2) UNIQUE NOT NULL ) INHERITS (cities); In this case, a row of capitals inherits all columns (name, population, and Constraints ............................................................................... 64 5.5.2. Not-Null Constraints ............................................................................ 66 5.5.3

of the left table. When outputting a left-table row for which there is no right-table match, empty (null) values are substituted for the right-table columns. Exercise: There are also right outer joins real, elevation int -- (in ft) ); CREATE TABLE capitals ( state char(2) UNIQUE NOT NULL ) INHERITS (cities); In this case, a row of capitals inherits all columns (name, population, and ................................................................................... 69 5.5.2. Not-Null Constraints ................................................................................. 71 5

....................................................................................42 5.3.2. Not-Null Constraints...................................................................................... of the left table. When outputting a left-table row for which there is no right-table match, empty (null) values are substituted for the right-table columns. Exercise: There are also right outer joins and modulo + - left addition, subtraction IS IS TRUE, IS FALSE, IS UNKNOWN, IS NULL ISNULL test for null NOTNULL test for not null (any other) left all other native and user-defined operators IN set membership

of the left table. When outputting a left-table row for which there is no right-table match, empty (null) values are substituted for the right-table columns. Exercise: There are also right outer joins real, elevation int -- (in ft) ); CREATE TABLE capitals ( state char(2) UNIQUE NOT NULL ) INHERITS (cities); In this case, a row of capitals inherits all columns (name, population, and Constraints ............................................................................... 62 5.4.2. Not-Null Constraints ............................................................................ 65 5.4.3

of the left table. When outputting a left-table row for which there is no right-table match, empty (null) values are substituted for the right-table columns. Exercise: There are also right outer joins real, elevation int -- (in ft) ); CREATE TABLE capitals ( state char(2) UNIQUE NOT NULL ) INHERITS (cities); In this case, a row of capitals inherits all columns (name, population, and ................................................................................... 67 5.4.2. Not-Null Constraints ................................................................................. 69 5

....................................................................................42 5.3.2. Not-Null Constraints...................................................................................... of the left table. When outputting a left-table row for which there is no right-table match, empty (null) values are substituted for the right-table columns. 11 Chapter 2. The SQL Language Exercise: There modulo + - left addition, subtraction IS IS TRUE, IS FALSE, IS UNKNOWN, IS NULL ISNULL test for null NOTNULL test for not null (any other) left all other native and user-defined operators IN set membership