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."Parallelism is the most valuable feature."
"The most valuable feature is storage offloading."
"This product can noticeably enhance performance of contextual Oracle databases."
"We like the tool’s features like Smart Scan, Hybrid Columnar Compression, and the TFA."
"The technical support team are real professionals. I admire their technical skills and supports. Their supports are really admirable."
"Oracle has reliable solutions and this one is no different."
"Backup/Restore performance: Fast backups, fast restores (especially useful for creating clone environments)."
"Before using this machine, we took no less than two days to run a report. Now, we can do it within five hours. So, there is a lot of improvement."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"The most valuable feature for us is horizontal scaling."
"The loading speed is very good."
"It's super easy to deploy and it also supports different languages and analytics."
"Helps us to achieve large-scale analytics."
"Very fast for query processing."
"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."
"Pivotal Greenplum's shared-nothing architecture."
"Scalability is simple because it's an MPP database. If you need more processing power or you need more storage, you just add a few more nodes in the cluster. It works on common commodity hardware. You can use any type of server. You don't need to have proprietary hardware. It's fairly flexible."
"One small area for improvement in Oracle Exadata is integration, particularly at the consolidated application level."
"It would be nice to have a single click button to, say, migrate my VMware VM into the Oracle VM, or vice-versa."
"Since the product is an appliance, it is very costly."
"The initial setup process is very difficult and extremely complex."
"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."
"The integration with third-party applications regarding access management security could be better."
"We have experienced some issues with processing unstructured data on Exadata. This is an important requirement for our AIML based use case. Reactive analytics data can not be prepared easily in Oracle Exadata."
"There's room for improvement in terms of deployment, as it could be made faster and more user-friendly."
"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."
"They could improve the integration and some of the features in the cloud version."
"They could improve on customer service."
"It should provide a GUI interface for data management and tuning."
"It would be great if this were a managed service in AWS."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"I have found that coding support could be simplified."
"Tanzu Greenplum's compression for GPText could be made more efficient."
"One of the disadvantages, not a disadvantage with the product itself, but overall, is the expertise in the marketplace. It's not easy to find a Greenplum administrator in the market, compared to other products such as Oracle."
"Maintenance is time-consuming."
"We would like to see Greenplum maintain a closer relationship with and parity to features implemented in PostgreSQL."
"I saw some limitation with respect to the column store, and removing this would be an improvement."
"Extra filters would be helpful."
"The initial setup is somewhat complex and the out-of-the-box configuration requires optimization."
"If you have a user consuming a huge load of resources, it takes down the entire system."