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."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."
"The performance on the databases is good."
"This product can noticeably enhance performance of contextual Oracle databases."
"It offers a significant advantage for accommodating a large number of users."
"It has improved the performance, now we run with more performance cores with less CPU to attend all the database demands. Reducing Time to Market, increase our ability to face the competition with speed and low cost."
"Compression is a great feature, where one can really save a lot of storage."
"We can use virtualization on Exadata."
"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 Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"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."
"The performance is very good and the aggregate records are fast."
"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 is Vertica's performance and the ease of using the database."
"Partition and join back to node are easy and simple for DBAs."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"We have a little trepidation with the system as it does have a learning curve. Also changing to a binary logging format for us feels like retrograde motion, but sadly almost all Linux variants have moved in this direction."
"The initial setup process is very difficult and extremely complex."
"The solution takes a lot of time to clone the environment. I would like to see some improvement in the cloning support or the time it takes on the storage side."
"The customization can sometimes be difficult to achieve."
"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."
"Oracle Exadata could improve the monitoring system in the enterprise manager, it could be more user-friendly. In most Oracle tools there is a lot of functionality, and sometimes you need to do five or six clicks to find metrics, and sometimes it's a waste of time."
"Setting up Exadata is complex. You need an Oracle vendor or someone who is Oracle-certified to set it up."
"The performance could be improved."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"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."
"When it is about to reach the maximum storage capacity, it becomes slow."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"I believe the installation process could be streamlined."
"We faced some challenges when trying to use the temporary tables feature."
"Limitations in group by projections is where I would like to see an improvement."
"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."
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.