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."They just have a lot of products, and they work well together."
"Exadata's best features are its performance during redo logging and the elasticity of the database handling."
"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."
"The offloading of data to the SIM is a valuable feature."
"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."
"The performance on the databases is good."
"The most valuable feature is the time to solution."
"The most valuable feature of Oracle Exadata is the smart scan. We have large TB sessions of approximately 100 per second for each of our three instances. The smart scan allows us the obtain data in time in the enterprise manager."
"Its projections and encoding are excellent tools for tuning large volumes."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"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."
"Partition and join back to node are easy and simple for DBAs."
"It has improved my organization's functionality and performance."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"I like the projection feature, which increases query performance."
"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."
"The cost of the solution is high and can be improved."
"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 is one aspect to Exadata that I dislike, and that's the inconsistency with other databases. When you try to get Exadata to function with another type of database like SQL, or others, there should be reliable and consistent operation. When this is improved on, we should start to see more applications growing the market."
"It's too expensive per terabyte. It's complex."
"Sometimes it takes too long time to get help with technical issues."
"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 initial setup process is very difficult and extremely complex."
"It is difficult to evaluate return-on-investment because of the way billing is handled for the product. This should be improved by oracle."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Support is an area where it could get better."
"Documentation has become much better, but can always use some improvement."
"They could improve on customer service."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"It should provide a GUI interface for data management and tuning."
Oracle Exadata is ranked 2nd in Data Warehouse with 124 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. Oracle Exadata is rated 8.4, while Vertica is rated 8.4. The top reviewer of Oracle Exadata writes "Very fast, scalable, stable, and demonstrates good performance". 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.