We performed a comparison between Oracle Exadata, Vertica, and VMware Tanzu Greenplum based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."The ease of setup is an eight out of ten."
"The most valuable feature is the time to solution."
"The business intelligence is very good."
"The most valuable feature of Oracle Exadata is the integration with other solutions, such as SAN storage and shared VLAN network."
"The most valuable feature is storage offloading."
"Oracle is known to be the number one in their industry; the help and support, the features they are giving the clients comparing to other databases, the new technology, the provide a good solution."
"Exadata is a fantastic machine. Two features stand out. The first is the resource input/output management tool that allows you to manage the resources to the neck on the Exadata box."
"Oracle is easy to use for peripheral things, such as the data vault and the data firewall, data sync, and partitions. These are the features that give an edge to other databases."
"The most valuable feature of Vertica is the unmatchable database performance."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"The performance is very good and the aggregate records are fast."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"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."
"Helps us to achieve large-scale analytics."
"The most valuable feature for us is horizontal scaling."
"Pivotal Greenplum's shared-nothing architecture."
"The loading speed is very good."
"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."
"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."
"Very fast for query processing."
"The management monitoring tools are quite important and an area that needs some improvement."
"The performance could be improved."
"I would like to see more database features and maybe more archiving features, because we need to do data archiving."
"Tech support sometimes takes some time to identify and rectify issues."
"Oracle Exadata could improve the monitoring system in the enterprise manager, it could be more user-friendly. In most Oracle tools there is a lot of functionality, and sometimes you need to do five or six clicks to find metrics, and sometimes it's a waste of time."
"Oracle Exadata could improve by having faster data retrieval. We receive data at four or five seconds and want to reduce that number to one second."
"Oracle Exadata compatibility with the analytics could be better and the OBIEE could improve. Oracle BI to Exadata needs to be improved. Even if the full analytics practice for Oracle should be improved and when compared with other solutions it is weak."
"The improvement could be made on the hardware level as the habit in the industry is to go better and faster and larger with every iteration."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"The integration with AI has room for improvement."
"Support is an area where it could get better."
"We faced some challenges when trying to use the temporary tables feature."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"It needs integration with multiple clouds."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"They should add more analytics. Their documentation could also be improved so that I don't have to bother my co-workers and tech support so often."
"If you have a user consuming a huge load of resources, it takes down the entire system."
"Extra filters would be helpful."
"Implementation takes a long time."
"VMware Tanzu Greenplum needs improvement in the memory area and improved methods for quick access to the disc. So, one of the quick goals of Greenplum must work on enhancing access to the disc by adding hints in the database."
"I saw some limitation with respect to the column store, and removing this would be an improvement."
"Initial setup is a little complex. It took around two weeks to deploy."
"We would like to see Greenplum maintain a closer relationship with and parity to features implemented in PostgreSQL."