Pivotal greenPLUM MANAGED SERVICE

 

Pivotal Greenplum Managed Service database is a flexible, managed & scalable ‘Database as a Service’ (DBaaS). Pivotal Greenplum Managed Service takes the risk & complexity out of deploying and managing a data warehouse platform.

Pivotal Greenplum Managed Service leverages Greenplum, the world’s first open source ‘Massively Parallel Processing’ (MPP) database to deliver enterprise-grade resilience, security and scalability.

 

Pivotal Greenplum Managed Service Features

✔ MPP for Data Warehousing

Pivotal Greenplum Managed Service takes advantage of the Greenplum MPP architecture to deliver fast query performance at any dataset size, from gigabytes (GB) to petabytes (PB).

Unlike general purpose SMP databases, MPP databases are optimised for analytics and automatically execute all SQL queries in parallel across all CPUs in the database cluster.

Extra Pivotal Greenplum Managed Service query performance is delivered by adding more CPUs to the cluster. General purpose databases simply can’t compete on performance with the parallel query processing that defines the MPP architecture.


✔ Flexible

Pivotal Greenplum Managed Service can be deployed on virtually any compute infrastructure that supports Linux.

Supported platforms include:

  • public cloud (AWS, Azure, Google)

  • private cloud (VMWare, Xen)

  • third party managed servers

  • on premises (‘on-prem’) using your preferred server/storage hardware


✔ Managed

Pivotal Greenplum Managed Service removes the need to hire system or database administrators.

Leveraging VLDB’s decades of technical expertise, Pivotal Greenplum Managed Service includes system or database administration options:

  • Bronze — monitoring, backup, patching, upgrades

  • Silver — bronze plus 8x5 DBA

  • Gold — bronze plus 24x7 DBA


✔ Affordable

There are no hardware or software costs incurred with Pivotal Greenplum Managed Service. Simply pay a usage fee based on the level of management required (bronze, silver or gold) and the number of nodes in the database cluster.

For each Pivotal Greenplum Managed Service production cluster, a single node development environment will be included free of charge with the same management level.


✔ Scalable

Pivotal Greenplum Managed Service is deployed as a parallel processing database cluster consisting of multiple nodes or servers. The compute power and database storage available to Pivotal Greenplum Managed Service SQL queries is the aggregate of all of the CPUs and storage across all of the nodes in the Pivotal Greenplum Managed Service database cluster.

Unlike with traditional databases, scaling Pivotal Greenplum Managed Service compute power or database storage is simply a case of adding nodes to the Pivotal Greenplum Managed Service database cluster. The Pivotal Greenplum Managed Service database software always takes advantage of all resources in the Pivotal Greenplum Managed Service database cluster.


✔ Storage Options

Pivotal Greenplum Managed Service offers a choice of either hard disk drives (HDD) or solid state drives (SSD) to store database tables. Capacity or performance — the choice is yours.

Additionally, Pivotal Greenplum Managed Service offers a variety of instance types, currently: D2, I3 or R5.

An R5 instance ensures persistent storage, meaning there is no data loss as a result of a system re-boot or power loss, whether accidental or intentional. It can be powered down when not needed, safe in the knowledge that your valuable data will still be available within the database exactly as it was when the system was last used.


✔ Secure

Pivotal Greenplum Managed Service supports custom Linux images, OS customisation, verification and security hardening. Access to each of the nodes in the cluster is supported via SSH.

Optionally, data can be encrypted at rest within the Pivotal Greenplum Managed Service cluster.


✔ Compatible

Pivotal Greenplum Managed Service supports ANSI standard SQL. ETL and BI tool connectivity is supported by JDBC and ODBC. No re-tooling is required.

PostgreSQL tools such as PGAdmin and psql are fully supported.


✔ Proven

Pivotal Greenplum Managed Service DBaaS leverages the power of the open source Greenplum database (GPDB), which has been deployed since the early 2000s in demanding enterprise environments.

GPDB is itself derived from open source PostgreSQL which dates back to the mid-1980s.

The scalability of the MPP architecture has been relied upon by many of the world’s largest organisations from the 1980s until the present day.


✔ Pivotal Greenplum Managed Service Database Features

Pivotal Greenplum Managed Service supports the following database features:

  • multi-column distribution keys

  • data encryption

  • table partitions

  • data compression

  • 'append only' (AO) tables

  • row-based & columnar storage

  • web-based management interface

  • workload management (WLM)

Subject to the Pivotal Greenplum Managed Service Terms of Use


CONTACT VLDB