The MPP element is crucial, so far as it allows us to query millions of rows at a time, at speed.
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.
What is most valuable?
How has it helped my organization?
The previous data warehouse was built in Oracle. One of the things which has improved in GreenPlum is that we can query millions of rows at speed, without creating lags. We’ve also built far more views; slowly changing dimensions can instantaneously update without creating the issue of having to rebuild tables to reflect new hierarchies, for example.
What needs improvement?
We found some issues with larger tables that have daily data appended, where after a while this seems to create lag in the query speed. This might just have to do with local knowledge rather than the product itself.
We have a table which is currently contains 27.6m rows and has a daily delta added to it of roughly 16.5k rows per day. While this isn’t particularly large, we have noticed the table begins to perform poorly when queried, in spite of having set up a VACUUM process to be performed weekly. It may be that the VACUUM process needs to be performed more frequently (like daily), but we’ve not yet found the optimal way of maintaining this particular table.
It’s worth saying that this is one table out of over 400 perfectly well performant tables and views in the same database. Hope that helps,
For how long have I used the solution?
I have used for approximately 30 months.
Buyer's Guide
VMware Tanzu Data Solutions
October 2024
Learn what your peers think about VMware Tanzu Data Solutions. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
816,636 professionals have used our research since 2012.
What was my experience with deployment of the solution?
I have not encountered any deployment, stability or scalability issues.
How are customer service and support?
I have not raised any service issues/tech queries, so I can’t really say.
Which solution did I use previously and why did I switch?
We used Oracle previously. We based our choice on expertise in our US operation, where we have a GreenPlum expert who provided some amazing use case examples to help us in our selection process.
What about the implementation team?
Implementation was done in-house.
What was our ROI?
Not within my area I’m afraid, but I understand that this was a very good fit from an ROI point of view
What other advice do I have?
Investigate whether this solution works for you. It is worth creating a rating matrix to compare other similar products, and it is very useful to look deeply at whether the third-generation MPP software might be a good fit.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
IT Software Engineer at a financial services firm with 10,001+ employees
Its valuable because of its high performance, integration with Spring Framework, easy installation, and configuration
What is most valuable?
- High performance
- Integration with Spring Framework
- Easy installation and configuration
How has it helped my organization?
We have been using GemFire for a Telco project, which we need process network data in real time and meanwhile access some reference data. GemFire has done a great job, as we have managed to process over 200,000 messages per second.
What needs improvement?
In build monitoring, the interface could be improved.
For how long have I used the solution?
18 months.
What do I think about the stability of the solution?
With version 8.1, we had some issues while we were querying data from memory, but it has been fixed in version 8.2, and after that we have never had problems.
What do I think about the scalability of the solution?
No, even when we had serious network problems, GemFire managed to recover.
How are customer service and technical support?
A nine out of 10.
Which solution did I use previously and why did I switch?
No, GemFire was always good enough for us.
How was the initial setup?
Initial setup was easy. In older versions, the user interface was not helpful, but it's improved lately.
What's my experience with pricing, setup cost, and licensing?
As a developer, I was never a part of this pricing decision. That's why I have no advice.
Which other solutions did I evaluate?
No, because we've started to use GemFire as part of a real-time intelligence platform.
What other advice do I have?
Trust GemFire and use the benefits of their strong documentation.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
VMware Tanzu Data Solutions
October 2024
Learn what your peers think about VMware Tanzu Data Solutions. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
816,636 professionals have used our research since 2012.
IT Consultant at a retailer with 10,001+ employees
There are many valuable features, such as parallel loading and the solution's scalability.
What is most valuable?
There are many valuable features, such as parallel loading and the solution's scalability.
How has it helped my organization?
It's allowed us to do a lot of data analytics with it that we weren't able to do before.
What needs improvement?
The performance needs to be improved.
For how long have I used the solution?
As a whole, two years on multiple versions.
What was my experience with deployment of the solution?
We've had no issues with deployment.
What do I think about the stability of the solution?
It's stable, but slowness is an issue.
What do I think about the scalability of the solution?
It's scaled find for us.
How are customer service and technical support?
Customer Service:
Customer service is OK.
Technical Support:Technical support is OK.
Which solution did I use previously and why did I switch?
No solution was used previously.
What about the implementation team?
Implementation was done by a vendor team.
What's my experience with pricing, setup cost, and licensing?
Pricing is pretty much OK compared to others.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Technical Lead with 1,001-5,000 employees
Needs more stability in terms of query results but we have improved our query response time.
What is most valuable?
External tables to load the data from flat files.
How has it helped my organization?
It helped us in loading millions of data in quick time & improved query response.
What needs improvement?
More stability in terms of query result.
For how long have I used the solution?
Five years - DCA V2.0 EMC & Greenplum Database
What was my experience with deployment of the solution?
No.
What do I think about the stability of the solution?
Not usually, but sometimes we do.
What do I think about the scalability of the solution?
No issues encountered.
How are customer service and technical support?
Customer Service:
Excellent.
Technical Support:Excellent.
Which solution did I use previously and why did I switch?
We applied MPP Appliance for the first time earlier we were running on SMP’s.
How was the initial setup?
It was straightforward.
What about the implementation team?
Vendor- they had good expertise.
What was our ROI?
Good.
Which other solutions did I evaluate?
We also looked at Teradata.
What other advice do I have?
Very good and cost effective with very good customer support.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Sr. Software Engineer at a financial services firm with 1,001-5,000 employees
It provides file loaders to reduce dependency on Informatica.
Valuable Features
- Distributed data for performance
- File loaders to reduce dependency on Informatica
Improvements to My Organization
Batch processing times have dramatically decreased from over 12 hours to under three hours. Much of this is converting off of Informatica and using distributed processing. Reporting performance also improved greatly.
Room for Improvement
Since we are upgrading to a new version at this time, it’s hard to say. But we seem to be replacing a disk on the appliance every week.
Use of Solution
I've used it for six years.
Deployment Issues
There's no issues, although we are currently in the middle of an upgrade to v4.3.5.
Stability Issues
It seems like we are replacing a disk on the appliance every week. Not a noticeable issue for users and batch processing is not adversely impacted.
Customer Service and Technical Support
Very good. Response times are good for service calls.
Initial Setup
I believe the set-up was straightforward. I don’t remember any issues.
Implementation Team
We used a vendor team. My advice is that the planning is critical. When converting processing jobs, convert them to PostgreSQL for better performance. Yes they could work as written previously, but you benefit using the features of the product immediately if you adjust the processing to match appliance. Use the bulk processing to your advantage.
Other Solutions Considered
We evaluated other solutions. Not sure of the reasons why this product was chosen.
Other Advice
It’s a good product. We moved from Oracle and I don’t want to go back.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Technical Lead at Interface Fintech Ltd
Fairly secured, quite robust, and stable but their support is lacking
Pros and Cons
- "The security is great."
- "Their implementation is quite tricky. It's not that easy to implement RabbitMQ as a cluster."
What is most valuable?
The security is great. The interface is nothing special. The support hasn't been that great. You need to go online yourself, to the developer community for support. But apart from that, I think it's fairly secured, quite robust, and stable so far.
What needs improvement?
Their implementation is quite tricky. It's not that easy to implement RabbitMQ as a cluster. It would be great if they could improve that.
For how long have I used the solution?
I have been using RabbitMQ for three years.
What do I think about the stability of the solution?
It's quite stable.
What do I think about the scalability of the solution?
It is very scalable. I have a team of 10 developers who are using it and I have some of our clients using it in our Cloud cluster. We have about 10 banks running on the platform now.
How are customer service and technical support?
I would rate their support as a five out of ten. It has room for major improvement.
How was the initial setup?
The initial setup is quite straightforward. It can be done within a few hours.
What other advice do I have?
I would recommend it, but I think there should be a proof of concept for the developer team to get their hands around it and have full control of it before they go into production.
I would rate RabbitMQ a seven out of ten.
In the next release, I would like for them to improve the UI.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
President, Applications and Security Architect at a tech services company with 51-200 employees
The most valuable features for us are speed and persistent messaging.
What is most valuable?
The most valuable features for us are speed and persistent messaging.
How has it helped my organization?
We are now able to leverage real time applications and event driven architecture.
What needs improvement?
The documentation needs to be improved. There's a learning curve on setting it up and there are issues arising from slower networks that they lack documentation on.
For how long have I used the solution?
We have been using the product for three years.
What do I think about the stability of the solution?
Stability issues experienced were only due to a slow network at the client.
What do I think about the scalability of the solution?
We did not encounter any scalability issues.
How are customer service and technical support?
I never used the technical support.
Which solution did I use previously and why did I switch?
I am not aware of any previous solutions.
How was the initial setup?
We are a container shop and the only issues during setup were around proper clustering and configuring the application to use it.
Which other solutions did I evaluate?
We evaluated Apache Kafka also.
What other advice do I have?
I would advise potential customers to use something to wrap their interaction, like Spring for Java.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Technical Engineer at a tech company with 1,001-5,000 employees
The loaders – their methods, insert, update and merge – were most valuable.
What is most valuable?
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
How has it helped my organization?
A lot of customers use Greenplum and for their ETL use cases they use Informatica PWX for Greenplum, which helps them achieve transfer of data from a number of data sources into Greenplum. We can help customers to load data effortlessly and quickly.
What needs improvement?
It would be best if Greenplum would support array writes through ODBC drivers . Currently through Data Direct Greenplum drivers we can have single row inserts into Greenplum only. It would help if array loading is supported.
For how long have I used the solution?
I have been using Greenplum loaders to load data into GreenPlum for three years.
What was my experience with deployment of the solution?
There were no issues in deploying it.
What do I think about the stability of the solution?
The external table feature helps to make this a stable solution.
What do I think about the scalability of the solution?
It scales to our and our customers needs as required.
How are customer service and technical support?
The ongoing response from their support on certain technical issues has been slow. It would help if we can have a faster turn-around here.
Which solution did I use previously and why did I switch?
There was no other solution used previously.
How was the initial setup?
The installation and configuration is straightforward.
What about the implementation team?
We implemented through a in-house team . The overall solution will be useful and is not complex
What other advice do I have?
If the use case is going to be requiring a huge data transfer and big data analytics. This is a good product to use.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free VMware Tanzu Data Solutions Report and get advice and tips from experienced pros
sharing their opinions.
Updated: October 2024
Product Categories
Data Warehouse Database Development and Management Relational Databases Tools Message Queue (MQ) SoftwarePopular Comparisons
Oracle Exadata
Apache Hadoop
SAP BW4HANA
IBM Netezza Performance Server
Oracle Database Appliance
Microsoft Parallel Data Warehouse
Buyer's Guide
Download our free VMware Tanzu Data Solutions Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Looking for advice on how to migrate from Oracle Exadata to VMware Tanzu Greenplum
- What is the biggest difference between ActiveMQ and RabbitMQ?
- What is the biggest difference between IBM MQ and RabbitMQ?
- How does IBM MQ compare with VMware RabbitMQ?
- Oracle Exadata vs. HPE Vertica vs. EMC GreenPlum vs. IBM Netezza
- When evaluating Data Warehouse solutions, what aspect do you think is the most important to look for?
- At what point does a business typically invest in building a data warehouse?
- Is a data warehouse the best option to consolidate data into one location?
- What are the main differences between Data Lake and Data Warehouse?
- Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?
Regarding the performance of few large tables, just a suggestion you can also try implementing the partitioning. By doing partitioning you can leverage the "swap partiton" while doing an insert and select the data for reporting based on your partitioning key.
Hope this helps