We performed a comparison between Oracle Exadata, Teradata, 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 storage capacity and the performance of Oracle Exadata are good. When comparing the performance to other technologies it is very good. I am satisfied with the management of the solution."
"Regarding features, there are so many that we can offer to customers. When we sell Exadata Cloud, there are many options to choose from, especially when it comes to enterprise database options. In my experience, the main features that are appreciated are various ones like GPS and the assortment of security options."
"It offers a significant advantage for accommodating a large number of users."
"We have used this solution for a long period of time so it has become easy for us to query any kind of data from Oracle Exadata which has been valuable."
"Compression is a great feature, where one can really save a lot of storage."
"The new Exadata x9m has an even higher speed of 100GBps connectivity."
"The business intelligence is very good."
"The performance of the data is the most important part."
"The key advantages are Performance when processing Terabytes of data and scalability."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"The most valuable features of Teradata are that it is a massively parallel platform and I can receive a lot of data and get the queries out correctly, especially if it's been appropriately designed. The native features make it very suitable for multiple large data tasks in a structured data environment. Additionally, the automation is very good."
"Teradata's best feature is its speed with historical data."
"Teradata is a great, industry-leading data warehousing product that has MPP architecture."
"There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems."
"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."
"Very fast for query processing."
"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."
"The loading speed is very good."
"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."
"Tanzu Greenplum's most valuable features include the integration of modern data science approaches across an MPP platform."
"Pivotal Greenplum's shared-nothing architecture."
"It's super easy to deploy and it also supports different languages and analytics."
"The customization can sometimes be difficult to achieve."
"Tech support sometimes takes some time to identify and rectify issues."
"The initial setup process is very difficult and extremely complex."
"I liked Spark, but it was discontinued when Exadata L6 came back. I loved it, and I wish they would bring back Spark integration."
"The handling of temp space has room for improvement."
"We had issues with system restoration."
"It would be good if Exadata made some new features available regarding data retrieval and speed capacity functions."
"We used the support from Oracle Exadata to complete the implementation."
"The current operational approach needs improvement."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"Teradata's UI could be improved."
"It could use some more advanced analytics relating to structured and semi-structured data."
"We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."
"There is some improvement required on OLTP level and some analytical function is missing."
"I saw some limitation with respect to the column store, and removing this would be an improvement."
"Extra filters would be helpful."
"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."
"We would like to see Greenplum maintain a closer relationship with and parity to features implemented in PostgreSQL."
"Maintenance is time-consuming."
"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."
"The installation is difficult and should be made easier."