2017.thegiac.com ## Greenplum 机器学习工具集 PL/X：各种语言实现自定义函数（存储过程） - MADLib: 数据挖掘、统计分析、图（Graph）等算法 • GPText: 文本检索和分析 • GeoSpatial: 地理信息数据分析 • Image: 图像数据分析 ## Pivotal ## Greenplum Procedure Language PLPython

Solr and GPDB ## Upcoming Roadmap • GPText 2.0 GA • Solr Cloud based high availability and Solr mirroring • Gptext-recover • Gptext-expand • Gptext-backup • Gptext-restore previous index ## Command party components, eg: compression PI/Containers G2C (Greenplum Gemfire connector) WLM GPCC • GPText ## Greenplum Community • Since open source from 2015/10/27 – GPDB: 1652 stars, 472 fork, 299 watch

要按照 API 接口开发，无需对 PG 重新编译。PG 中 contrib 目录下的各个第三方模块，在 GP 中的 postgis 空间数据库、R、Madlib、pgcrypto 各类加密算法、gptext 全文检索都是通过这种方式实现功能扩展的。 4) 在诸如 ACID 事物处理、数据强一致性保证、数据类型支持、独特的 MVCC 带来高效数据更新能力等还有很多方面，Postgresql 似乎在这些 都是 Postgresql 没有提供的： · 外部表并行数据加载 · 可更新数据压缩表 · 行、列混合存储 · 数据表多级分区 •Bitmap 索引 • Hadoop 外部表 • Gptext 全文检索 · 并行查询计划优化器和 Orca 优化器 • Primary/Mirror 镜像保护机制 ·资源队列管理 · WEB/Brower 监控 # 3. Greenplum 的艺术 In-Database的方式来处理，你将获得意想不到的性能和方便性；例如我们在某客户实现的数据转码、数据脱敏等，只需要简单的改写原有代码后部署到GP中，通过并行计算获得数十倍性能提高。 另外，GPTEXT（lucent全文检索）、Apache Madlib（开源挖掘算法）、SAS algorithm、R都是通过UDF方式实现在Greenplum集群中分布式部署，从而获得库内计算的并行能力。这里可

description,d.score from people a,transactions b,location c, (SELECT w.id, q.score FROM people w, gptext.search(TABLE(SELECT 1 SCATTER BY 1), 'gpadmin.public.people', 'Pivotal', null) q) description,d.score from people a,transactions b,location c, (SELECT w.id, q.score FROM people w, gptext.search(TABLE(SELECT 1 SCATTER BY 1), 'gpadmin.public.people', 'Pivotal', null) q)

using VMware Greenplum Command Center - Support for full text search and text analysis using VMware GPText - Greenplum backup plugin for DD Boost - Backup/restore storage plugin API ## Server Documentation Features Greenplum Database 6.11.2 includes these changes: - Pivotal GPText version 3.4.5 is included, which includes bug fixes. See the GPText 3.4.5 Release Notes for more information. - Pivotal Greenplum-Spark Greenplum 6 is supported via gpupgrade. For more information, see the gpupgrade documentation. - MADlib, GPText, and PostGIS are not yet provided for installation on Ubuntu systems. The following table lists

Tanzu Greenplum Command Center - Support for full text search and text analysis using VMware Tanzu GPText - Greenplum backup plugin for DD Boost - Backup/restore storage plugin API ## Server Documentation Features Greenplum Database 6.11.2 includes these changes: - Pivotal GPText version 3.4.5 is included, which includes bug fixes. See the GPText 3.4.5 Release Notes for more information. - Pivotal Greenplum-Spark Greenplum 6 is supported via gpupgrade. For more information, see the gpupgrade documentation. - MADlib, GPText, and PostGIS are not yet provided for installation on Ubuntu systems. The following table lists

Tanzu Greenplum Command Center Support for full text search and text analysis using VMware Tanzu GPText Greenplum backup plugin for DD Boost Backup/restore storage plugin API Server Documentation Tanzu Features Greenplum Database 6.11.2 includes these changes: Pivotal GPText version 3.4.5 is included, which includes bug fixes. See the GPText 3.4.5 Release Notes for more information. Pivotal Greenplum-Spark Greenplum 6 is supported via gpupgrade. For more information, see the gpupgrade documentation. MADlib, GPText, and PostGIS are not yet provided for installation on Ubuntu systems. The following table lists key

Tanzu Greenplum Command Center Support for full text search and text analysis using VMware Tanzu GPText Greenplum backup plugin for DD Boost Backup/restore storage plugin API Server Documentation Tanzu Features Greenplum Database 6.11.2 includes these changes: Pivotal GPText version 3.4.5 is included, which includes bug fixes. See the GPText 3.4.5 Release Notes for more information. Pivotal Greenplum-Spark Greenplum 6 is supported via gpupgrade. For more information, see the gpupgrade documentation. MADlib, GPText, and PostGIS are not yet provided for installation on Ubuntu systems. The following table lists key

Tanzu Greenplum Command Center Support for full text search and text analysis using VMware Tanzu GPText Greenplum backup plugin for DD Boost Backup/restore storage plugin API Server Documentation Tanzu Features Greenplum Database 6.11.2 includes these changes: Pivotal GPText version 3.4.5 is included, which includes bug fixes. See the GPText 3.4.5 Release Notes for more information. Pivotal Greenplum-Spark Greenplum 6 is supported via gpupgrade. For more information, see the gpupgrade documentation. MADlib, GPText, and PostGIS are not yet provided for installation on Ubuntu systems. The following table lists key

Utility (gpcopy) for copying or migrating objects between Greenplum systems VMware Greenplum Text (gptext) for full text search and text analysis VMware Greenplum 7 also bundles or packages these open source Features Greenplum Database 6.11.2 includes these changes: - Pivotal GPText version 3.4.5 is included, which includes bug fixes. See the GPText 3.4.5 Release Notes for more information. - Pivotal Greenplum-Spark Greenplum 6 is supported via gpupgrade. For more information, see the gpupgrade documentation. - MADlib, GPText, and PostGIS are not yet provided for installation on Ubuntu systems. The following table lists