VMware Tanzu Greenplum Valuable Features

Jayanta Datta - PeerSpot reviewer
Executive Director at Morgan Stanley

The optimizer of the product is very efficient and the solution has a good data retention policy. Greenplum has good data analytics features and provides good monitoring tools. 

View full review »
MG
Director of IT Operations at a financial services firm with 10,001+ employees

Its most valuable feature is the ability to quickly run through data. It has a good processing speed as well.

View full review »
Nasir Niamat - PeerSpot reviewer
Principal Software Engineer - Db Ops at i2c Inc.

The latest version is better than the older ones. The solution updates very fast. The loading speed is very good.

View full review »
Buyer's Guide
VMware Tanzu Greenplum
March 2024
Learn what your peers think about VMware Tanzu Greenplum. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
Alvaro Fuentes - PeerSpot reviewer
Architect Projects at T-Systems International GmbH

In general, I think this is a very good platform, particularly as it's open source. It fits very well with use cases for public institutions or universities, where there is not always a big budget.

View full review »
BR
Data Engineer at Broadridge Financial Solutions

I've found that the data compression and ETL are the most valuable features for us.

In 4.3.8.1 Pivotal confirmed that even restoring schema level backup is possible from a DB backup.

- restoring schema from a DB level backup has been tested and working fine .

ORCA - the Pivotal Optimizer does a good query plan but does not works with all business logics. This needs to be tested based on your requirement.


View full review »
GB
Senior Data Engineer at a financial services firm with 10,001+ employees

The parallel load features mean that Greenplum is capable of high-volume data loading in parallel to all of the cluster segments, which is really valuable.

The service management capabilities are good.

The external data integration with Parquet, Avro, CSV, and unstructured JSON works well.

It has an advanced query optimizer.

View full review »
AK
Consultant at a government with 10,001+ employees

Tanzu Greenplum's most valuable features include: the integration of modern data science approaches across an MPP platform, including the ability to massively denormalize data and spread it across your MPP segments; the ability to index data and make it searchable, which significantly reduces the need for ETL; its fast performance. Tanzu Greenplum is also very active in providing additional functionalities and software when needed, like GPText indexing of JSON events.

View full review »
BR
Data Engineer at Broadridge Financial Solutions

I've found that the database warehouse, data compression, and ETL to be the most valuable features for us.

View full review »
BR
Data Engineer at Broadridge Financial Solutions

Strong integration with Greenplum Servers.

View full review »
it_user373128 - PeerSpot reviewer
Data Architect & ETL Lead at a financial services firm with 1,001-5,000 employees

Processing speed of queries used for ‘Reporting’ solutions is the most valuable feature.

View full review »
it_user371898 - PeerSpot reviewer
Sr ETL Developer at a financial services firm with 1,001-5,000 employees
  • Parallel processing
  • Takes minutes to process millions of records
View full review »
it_user264192 - PeerSpot reviewer
Senior Enterprise Technical Architect at a computer software company with 10,001+ employees

Of particular value to our environment and applications are the following Greenplum capabilities:

  1. Scalable (Massive) Parallel Processing (MPP) – The ability to bring to bear large amounts of compute against large data sets with Greenplum and the EMC DCA has proven itself to be very effective.
  2. Fast load of data into Greenplum – We experience performance of approximately 1TB per hour loading data to Greenplum without the use of specialized hardware.
  3. MADlib (madlib.net) – There are a number of statistical and analytical functions available within MADlib upon which we rely. Among these are linear regression, logistic regression, apriori, k-means, principle component analysis, etc.
  4. User Defined Functions in Python (UDFs in PL/Python) – Where MADlib does not provide a direct solution to an application problem, the ability to quickly prototype and deploy user defined functions with Python has been effective.
View full review »
it_user1127370 - PeerSpot reviewer
Co-Founder, Chief of Operations with 10,001+ employees

We chose Greenplum because of the architecture in terms of clustering databases and being able to have, or at least utilize the resources that are sitting on a database.

View full review »
MB
Statistician at a financial services firm with 1,001-5,000 employees

Greenplum is an MPP architecture database. Data can be distributed across multiple nodes and strong distribution will allow queries to execute on all segments at once, which is very powerful. As long as we have good SQL knowledge, we can start playing in the platform. Greenplum uses Postgres and ANSI Standard SQL. Also, it supports many other procedural languages, such as Python, C++, and Pearl.

View full review »
GM
Subdirector of Support for Production at a financial services firm with 51-200 employees

With VMware Tanzu Greenplum, one can make a huge database table and analyze the queries by adding in the SQL command. Some hint or command for the query goes over the multi-parallel execution. Also, queries can be sent quickly to other database systems.

View full review »
it_user488589 - PeerSpot reviewer
Technology Architect at Broadridge Financial Solutions

Append Only tables, data compression and bulk load and extraction using External Tables are very valuable features for us.

View full review »
it_user555939 - PeerSpot reviewer
Information Architecture Specialist (TOGAF Certified) at a comms service provider
  • It's one of the fastest databases in the market.
  • It's easy to use.
  • From a maintenance perspective it's a good product.
  • The segmentation, or architecture of the product is different than other databases such as Oracle. So even in 10 years, the data distribution for such segments will not affect other segments.
  • The query performance of the product, for complex queries, is very good.
  • It has good integration with Hadoop and Big Data.
View full review »
it_user369321 - PeerSpot reviewer
Senior Director & Global Lead, Big Data Center of Excellence at a pharma/biotech company with 10,001+ employees

Processing speed – especially loading and transformation of large data sets.

View full review »
it_user374715 - PeerSpot reviewer
BI Data Engineer at a tech vendor with 51-200 employees
  • Parallel Processing and Data Distribution based architecture.
  • HA built-in with mirroring.
  • Highly configurable and lots of tuning features.
View full review »
it_user371805 - PeerSpot reviewer
Senior Business Intelligence Developer at a tech services company with 501-1,000 employees

The most valuable feature of Greenplum is the Massively Parallel Processing (MPP).

View full review »
it_user422625 - PeerSpot reviewer
Technical Lead at a tech services company with 1,001-5,000 employees

We can integrate the Hadoop with DCA V2. This will be huge development in the big data technologies.

View full review »
it_user145740 - PeerSpot reviewer
Consultant at a financial services firm with 5,001-10,000 employees

The MPP element is crucial, so far as it allows us to query millions of rows at a time, at speed.

View full review »
it_user371457 - PeerSpot reviewer
IT Consultant at a retailer with 10,001+ employees

There are many valuable features, such as parallel loading and the solution's scalability.

View full review »
it_user203334 - PeerSpot reviewer
Technical Lead with 1,001-5,000 employees

External tables to load the data from flat files.

View full review »
it_user372360 - PeerSpot reviewer
Sr. Software Engineer at a financial services firm with 1,001-5,000 employees
  • Distributed data for performance
  • File loaders to reduce dependency on Informatica
View full review »
it_user372336 - PeerSpot reviewer
Senior Technical Engineer at a tech company with 1,001-5,000 employees

The Greenplum loaders – their methods, insert, update and merge – were most valuable. The external table feature within Greenplum was also very valuable in achieving performance and scalability

View full review »
RA
Site Manager at a tech services company with 51-200 employees

The most valuable feature for us is horizontal scaling.

View full review »
it_user776835 - PeerSpot reviewer
Senior Data Warehouse Developer at a comms service provider with 51-200 employees
  • Very fast for query processing
  • Parallel load
  • Polymorphic storage
View full review »
it_user371766 - PeerSpot reviewer
Sr. Data Operation Engineer at a marketing services firm with 501-1,000 employees

MPP (Massive Parallel Processing); processing large amount of data.

View full review »
it_user1256802 - PeerSpot reviewer
Consultant/Architect with 51-200 employees

In terms of most valuable features, I'd say Pivotal Greenplum's shared-nothing architecture.

View full review »
CZ
Solutions Engineer at VST-ECS Philippines Inc.

It's super easy to deploy and it also supports different languages and analytics.

View full review »
it_user374739 - PeerSpot reviewer
Data Warehouse Specialist at a comms service provider with 1,001-5,000 employees

The most valuable features are MPP and that it's polymorphic.

View full review »
it_user371724 - PeerSpot reviewer
DB Manager at a marketing services firm with 501-1,000 employees

The MPP – fast aggregation and that I still reuse the PL/SQL code.

View full review »
it_user259983 - PeerSpot reviewer
Lead Consultant with 501-1,000 employees

The performance is the most valuable.

View full review »
DO
President of the Board at a tech services company with 51-200 employees

It's a good core database. Scalability and performance are very good. I also like the fact the solution is open-source, so you can use it free of charge.

View full review »
Buyer's Guide
VMware Tanzu Greenplum
March 2024
Learn what your peers think about VMware Tanzu Greenplum. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.