完整的事务+ACID+标准SQL支持 • 支持上千个节点的部署 • 支持PB级文件 • 丰富的ETL和外部组件 • 支持Python/R/Java直接访问处理数据库数据 • https://github.com/greenplum-db/gpdb GPDB GPDB的数据安全 用户 • 连接数据库 • 运行业务 DBA • 管理数据库 • 业务审计 System Admin pgcypto Postgresql社区提供的一款简单加密插件 • https://www.postgresql.org/docs/13/pgcrypto.html • https://github.com/greenplum-db/gpdb/tree/master/contrib/pgcrypto 现有解决方案 数据加载 Planer Data (plain) Data (plain • https://github.com/greenplum-db/gpdb Recall pgcypto的问题 一款开源的HTAP数据库: • MPP架构 • 完整的事务+ACID+标准SQL支持 • 支持上千个节点的部署 • 支持PB级文件 • 丰富的ETL和外部组件 • 支持Python/R/Java直接访问处理数据库数据 • https://github.com/greenplum-db/gpdb

开源社区最新源代码 6X_STABLE 分支： https://github.com/greenplum-db/gpdb​，内核代码基于 PostgreSQL 9.4。目前（2019/04/23) 主 干分支的代码基于 PostgreSQL 9.4。合并到 PostgreSQL 9.5 的工作也已经开始，有关最新工作 进展请参见：​https://github.com/greenplum-db/gpdb-postgres-merge​。 Redhat/Centos 系统上编译 本小节以 RHEL7 为例介绍如何编译Greenplum。 首先下载 Greenplum 源代码 $ git clone https​:​//github.com/greenplum-db/gpdb Greenplum Database 编译和运行依赖于各种系统库和Python库。需要先安装这些依赖： $ sudo ​yum groupinstall 很直观的看到正在执行的代码片段，以及函数中变量的值。对于学习 和调试Greenplum非常有帮助。 5. 问题讨论 如果遇到问题无法解决，优先建议到 gpdb-dev 邮件列表讨论，或者在github上面报告Issues (​https://github.com/greenplum-db/gpdb/issues​). 欢迎加入 Greenplum 中文社区， https://greenplum.cn/​ 主页底部有 QQ

2016 – Open source code contribution growing – 1417 commits to the github repo of Greenplum in 2016 – 111 unique contributors on github repo of Greenplum in 2016 – Major Greenplum 5.0 release planned early Postgres Conference China 2016 中国用户大会 Scalable, In-Database Machine Learning • Open source https://github.com/apache/incubator‐madlib • Downloads and docs http://madlib.incubator.apache.org/ • Wiki https://cwiki

⽅法三：创建新表，导⼊数据 CREATE TABLE...AS SELECT 命令把该表拷⻉为⼀个新表，新建的表将不会出现膨胀现象。然后删除原始表并且重命名拷⻉的表。 参考： https://gp-docs-cn.github.io/docs/best_practices/bloat.html https://docs.ucloud.cn/udw/developer?id=_43-%e9%80%89%e6%8b%a9 其中，每个Slice对应的模块，可以⾃由拖拽位置和⼤⼩，并保存整个Dashboard的布局。 关于superset的更多信息请参考： http://airbnb.io/superset/ https://github.com/airbnb/superset 接⼊第三⽅ BI ⼯具 Greenplum数据仓库 UDW Copyright © 2012-2021 UCloud 优刻得 176/206 UDW ，kafka-node的git地址：https://github.com/SOHU-Co/kafka-node 下⾯是通过copy的⽅式把从Kafka中消费的数据导⼊到UDW，为了加快数据插⼊UDW的速度，强烈建议⽤copy的⽅式导⼊数据到UDW。nodejs的copy数据到postgresql的使⽤⽅法请 参考：https://github.com/brianc/node-pg-copy-streams。

openEuler DB SIG。下面对工作内容做简要的介绍： 1. Greenplum 社区上游(Github)发布包引入 此次参与欧拉操作系统构建和发布的包来自 Greenplum 社区发布包(6.17.0-src-full.tar.gz)，链接如下： https://github.com/greenplum-db/gpdb/releases/tag/6.17.0 包引入和提交到欧拉开源社区的

available in Greenplum Database as an extension, based on the PostgreSQL orafce project at https://github.com/orafce/orafce. Instead of executing a SQL script to install the compatibility functions in a of the Greenplum Backup and Restore utilities, available to download from VMware Tanzu Network or github. If you intend to install Greenplum Database 6 on the same hardware as your 4.3 system, you will release of the backup and restore utilities, available for download from VMware Tanzu Network or github. Important Make sure that you have a complete backup of all data in the Greenplum Database 4.3

available in Greenplum Database as an extension, based on the PostgreSQL orafce project at https://github.com/orafce/orafce. Instead of executing a SQL script to install the compatibility functions in a of the Greenplum Backup and Restore utilities, available to download from VMware Tanzu Network or github. VMware Tanzu Greenplum 6 Documentation VMware, Inc 462 If you intend to install Greenplum Database release of the backup and restore utilities, available for download from VMware Tanzu Network or github. Important: Make sure that you have a complete backup of all data in the Greenplum Database 4.3

available in Greenplum Database as an extension, based on the PostgreSQL orafce project at https://github.com/orafce/orafce. Instead of executing a SQL script to install the compatibility functions in a of the Greenplum Backup and Restore utilities, available to download from VMware Tanzu Network or github. If you intend to install Greenplum Database 6 on the same hardware as your 4.3 system, you will release of the backup and restore utilities, available for download from VMware Tanzu Network or github. Important Make sure that you have a complete backup of all data in the Greenplum Database 4.3

of the Greenplum Backup and Restore utilities, available to download from VMware Tanzu Network or github. 2. Run the gpbackup utility to back up the data from your Greenplum 6 cluster to an external data must handle that, too. The foreign-data wrappers included in the Greenplum Database open source github repository are good references when trying to write your own. You may want to examine the source located in the gpdb/src/include/ directory (when developing against the Greenplum Database open source github repository), or installed in the $GPHOME/include/postgresql/server/ directory (when developing against

available in Greenplum Database as an extension, based on the PostgreSQL orafce project at https://github.com/orafce/orafce. Instead of executing a SQL script to install the compatibility functions in a of the Greenplum Backup and Restore utilities, available to download from VMware Tanzu Network or github. If you intend to install Greenplum Database 6 on the same hardware as your 4.3 system, you will release of the backup and restore utilities, available for download from VMware Tanzu Network or github. Important Make sure that you have a complete backup of all data in the Greenplum Database 4.3