Text Analytics and Search

Text Analytics and Search

Greenplum Database offers two different methods for text search and analytics, Greenplum Database full text search and Tanzu Greenplum Text.

Greenplum Database Full Text Search

Greenplum Database text search is PostgreSQL text search ported to the Greenplum Database MPP platform. Greenplum Database text search is immediately available to you, with no need to install and maintain additional software. For full details on this topic, see Greenplum Database text search.

Tanzu Greenplum Text

For advanced text analysis applications, VMWare also offers Tanzu Greenplum Text, which integrates Greenplum Database with the Apache Solr text search platform. Tanzu Greenplum Text installs an Apache Solr cluster alongside your Greenplum Database cluster and provides Greenplum Database functions you can use to create Solr indexes, query them, and receive results in the database session.

Both of these systems provide powerful, enterprise-quality document indexing and searching services. Tanzu Greeenplum Text, with Solr, has many capabilities that are not available with Greenplum Database text search. In particular, Tanzu Greenplum Text is better for advanced text analysis applications. For a comparative between these methods, see Comparing Greenplum Database Text Search with Tanzu Greenplum Text.