Greenplum Database 3.3 - Features

Greenplum Database is a software solution built to support the next generation of data warehousing and large-scale analytics processing. Supporting SQL and MapReduce parallel processing, Greenplum Database offers industry-leading performance at a low cost for companies managing Terabytes to Petabytes of data.

Shared-nothing MPP (massively parallel processing) architecture. Read more >
Greenplum Database's architecture provides automatic parallelization of data and queries – all data is automatically partitioned across all nodes of the system, and queries are planned and executed using all nodes working together in a highly coordinated fashion.

Multi-level fault tolerance. Read more >
Greenplum Database utilizes multiple levels of fault-tolerance and redundency that allow it to automatically continue operation in the face of hardware or software failures.

Online system expansion
Add servers to increase storage capacity, processing performance and loading performance. The database can remain online and fully available while the expansion process takes place in the background. Performance and capacity increases linearly as servers are added.

Workload management
Provides administrative control over system resources and their allocation to queries. Allows users to be assigned to resource queues that manages the inflow of work to the database. Also allows priority adjustment of running queries.

Petabyte-scale loading
High-performance loading utilizing MPP Scatter/Gather Streaming technology. Loading speeds scale with each additional node to greater than 4TB/hour.

Anywhere data access
Allows queries to be executed from the database against external data sources, returning data in parallel, regardless of their location, format, or storage medium.

In-database compression
Utilizes industry-leading compression technology to increase performance and dramatically reduce the space required to store data. Customers can expect to see a 3-10x disk space reduction with a corresponding increase in effective I/O performance.

Multi-level partitioning
Allows flexible partitioning of tables based on date, range or value. Partitioning is specified using DDL and allows an arbitrary number of levels. The query optimizer will automatically prune unneeded partitions from the query plan.

Centralized administration
Provides cluster-wide management tools and utilities that allow administrators to manage the database as if it was a single system.

SQL standard
Comprehensive SQL-92 and SQL-99 support with SQL 2003 OLAP extensions. All queries are parallelized and executed across the entire system.

MapReduce support. Read more >
MapReduce has been proven as a technique for high-scale data analysis by Internet leaders such as Google and Yahoo. Greenplum natively runs MapReduce programs within its parallel engine.

Programmable parallel analytics
Offers a new level of parallel analysis capabilities for mathematicians and statisticians, with support for R, linear algebra and machine learning primitives.

Greenplum Performance Monitor. Read more >
View the performance of your Greenplum Database system including system metrics and query details. The dashboard view allows you to monitor the system utilization during query runs. Drill down into a query’s detail and plan to understand its performance.

pgAdmin3 for GPDB
pgAdmin III is the most popular and feature rich Open Source administration and development platform for PostgreSQL. Greenplum Database 3.3 ships with an enhanced version of pgAdmin III that has been extended to work with Greenplum Database and provides full support for Greenplum-specific capabilities.

Support For Indexes
Greenplum supports a range of index types including B-Tree and Bitmap.

Industry standard interfaces
Supports standard database interfaces (SQL, ODBC, JDBC, DBI) and is interoperable with market-leading business intelligence (BI) and extract/transform/load (ETL) tools.