We performed a comparison between Oracle Exadata and Vertica based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Exadata's best features are its performance during redo logging and the elasticity of the database handling."
"Oracle Exadata has very good hardware."
"We can use virtualization on Exadata."
"Oracle Exadata's performance is one of its best features. We very satisfied with it."
"Oracle has reliable solutions and this one is no different."
"They just have a lot of products, and they work well together."
"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."
"Exadata is also a very stable environment. Their Smart Scan feature is great for every banking environment and financial institutions willing to implement it."
"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. "
"Partition and join back to node are easy and simple for DBAs."
"I like the projection feature, which increases query performance."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"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."
"Speed and resiliency are probably the best parts of this product."
"There is room for improvement with the handling of the Temp IO, which is often used for JOIN statements."
"We had issues with system restoration."
"The initial setup process is very difficult and extremely complex."
"The cost of the solution is high and can be improved."
"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 management monitoring tools are quite important and an area that needs some improvement."
"Exadata would be improved with single dashboard visibility."
"The technical support is in need of improvement."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"Suboptimal projection design causes queries to not scale linearly."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"They could improve on customer service."
"It would be great if this were a managed service in AWS."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"Limitations in group by projections is where I would like to see an improvement."
"I believe the installation process could be streamlined."
Oracle Exadata is ranked 2nd in Data Warehouse with 124 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. Oracle Exadata is rated 8.4, while Vertica is rated 8.2. The top reviewer of Oracle Exadata writes "Offers a variety of valuable features". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Oracle Exadata is most compared with Oracle Database Appliance, Teradata, Oracle Autonomous Data Warehouse, Snowflake and Apache Hadoop, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and BigQuery. See our Oracle Exadata vs. Vertica report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.