In this section, we will take a deep dive into all the components and modules of Greenplum UAP.
Greenplum Database is a collection of several PostgreSQL database instances acting as one interconnected database using highly-tuned optimizer. It is an MPP shared nothing database that involves more than one node to cooperate to execute one operation. Every node has its own disk, memory, and operating system. Greenplum uses this high-performance system architecture to distribute the load of large volume of data warehouses and is able to use all of the system resources in parallel to process a query.

Greenplum Database is based on PostgreSQL 8.2.15 and is very similar with respect to SQL support, features, configuration options, and so on (additionally, features from PostsgreSQL 8.3 and 9.0 have been included). The internals of PostgreSQL have been modified or supplemented to support the parallel structure of Greenplum DB. The interconnect component enables...