We performed a comparison between Oracle Exadata, Teradata, and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."The most valuable feature is that you have the same familiar environment of an Oracle database but with the additional performance you get from this architecture."
"What I found most valuable in Oracle Exadata is its newer technology that gives better performance. It has more recent hardware and significant changes in the architecture, so it's better than older solutions."
"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."
"Backup/Restore performance: Fast backups, fast restores (especially useful for creating clone environments)."
"The performance of the data is the most important part."
"The performance on the databases is good."
"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."
"The business intelligence is very good."
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"It has reduced a lot of reworking on maintaining indexes, partitions, etc."
"It's the same as your visual database. I like the fast load feature for data, the BTQ solution is very good, and storage procedures are very fast."
"We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
"The key advantages are Performance when processing Terabytes of data and scalability."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"The most valuable feature of Teradata is the quick processing of large data."
"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."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. "
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"Its projections and encoding are excellent tools for tuning large volumes."
"The most valuable feature is Vertica's performance and the ease of using the database."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"The solution could always be more stable and more reliable."
"The cost of the solution is high and can be improved."
"There is room for improvement with the handling of the Temp IO, which is often used for JOIN statements."
"A room for improvement in Oracle Exadata is that it's not very easy to use in a microservices environment. It's not easy to split databases, and if this was easier to do in Oracle Exadata, it would make the solution better. What I'd like to see in the next release of Oracle Exadata is for it to become more modular, so you can use it in a context where the data layer is spread between many independent services."
"The technical support is in need of improvement."
"I believe Oracle must improve its procedure to support the clients. The customer Ready Service must provide more use cases and benchmarks of their infrastructure to support client design decisions. Oracle must audit their partners regularly to guarantee they provide quality service even after been passed on partnership examination."
"We need a monitoring tool which can in one place, where we can manage, monitor the entire Exadata components."
"Exadata would be improved with single dashboard visibility."
"Teradata can improve the way it handles big data and unstructured data."
"I would like to see an improved Knowledge Base on the web."
"The following could be better: licensing, architecture openness, integration with other tools."
"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."
"Teradata's UI could be more user-friendly."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"Teradata is an expensive tool. Like, if you're already using Microsoft products like Windows, they'll market all their products together. And with the rise of cloud technologies, companies will adopt solutions that offer them some privileges or facilities. Similar to how SAP does it in the market, so do Microsoft and other companies. Even Oracle and other such tools are quite commonly seen compared to Teradata's competitors in everyday solutions."
"Needs compatibility with more Big Data platforms."
"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."
"I have found that coding support could be simplified."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"Suboptimal projection design causes queries to not scale linearly."
"Support is an area where it could get better."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."