Massively Parallel PostgreSQL
All The Reasons to Choose Greenplum
Rapidly create and deploy models for complex applications in cybersecurity, predictive maintenance, risk management, fraud detection, and many other areas.
Based on PostgreSQL, Greenplum provides you with more control over the software you deploy, reducing vendor lock-in, and allowing open influence on product direction.
Power at Scale
Petabyte-Scale Data Volumes
With its unique cost-based query optimizer designed for large-scale data workloads, Greenplum scales interactive and batch-mode analytics to large datasets in the petabytes without degrading query performance and throughput.
From BI to AI
Greenplum reduces data silos by providing you with a single, scale-out environment for converging analytic and operational workloads, like streaming ingestion.
Avoid Proprietary Vendor Lock-in
All major Greenplum contributions are part of the Greenplum Database project and share the same database core, including the MPP architecture, analytical interfaces, and security capabilities.
Top Features of Greenplum Database®
All major Greenplum contributions share the same database core, including the MPP architecture, analytical interfaces, and security capabilities.
Federated Data Access
Query external data sources with the Greenplum optimizer and query processing engine, including Hadoop, Cloud Storage, ORC, AVRO, Parquet and other Polyglot data stores.
Polymorphic Data Storage
Fully control the configuration for your table and partition storage, execution, and compression. You can choose row or column-oriented storage and processing for any table or partition.
Integrated In-Database Analytics
Tackle data science from experimentation to massive deployment with Apache MADlib, the open-source library of in-cluster machine learning functions for the PostgreSQL family of databases.
Innovation in Query Optimization
Using the first open source cost-based query optimizer to scale interactive and batch mode analytics of large datasets in the petabytes without degrading query performance and throughput.
Commercial Greenplum Features
Easy Handling of Streaming Data
Get fast event processing and integrate cloud data by querying Amazon S3 objects in place. VMware Greenplum includes Kafka integration certified by Confluent.
Security and Disaster Recovery
Address regulatory requirements with security and authentication features, plus high availability, intelligent fault detection, backup and disaster recovery.
Use Dell Greenplum Reference Architecture for optimal on-premises deployment. Or use HP- or Cisco-certified configurations or your own commodity hardware.
Author | Nihal Jain Troubleshooting and identifying supportability issues in a complex database system can be...
Authors | Kevin Yeap & Brent Doil Introduction Greenplum Upgrade (gpupgrade) is a utility that allows...