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."The performance on the databases is good."
"The performance of the data is the most important part."
"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."
"Backup/Restore performance: Fast backups, fast restores (especially useful for creating clone environments)."
"Oracle is easy to use for peripheral things, such as the data vault and the data firewall, data sync, and partitions. These are the features that give an edge to other databases."
"The new Exadata x9m has an even higher speed of 100GBps connectivity."
"Exadata with the In-Memory option is several levels about SAP HANA."
"The business intelligence is very good."
"The performance is very good and the aggregate records are fast."
"Its projections and encoding are excellent tools for tuning large volumes."
"The product's initial setup phase is extremely simple."
"Speed and resiliency are probably the best parts of this product."
"I have found the solution to be scalable."
"The most valuable feature of Vertica is the unmatchable database performance."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Partition and join back to node are easy and simple for DBAs."
"There is room for improvement with the handling of the Temp IO, which is often used for JOIN statements."
"There is a feature for security, but it is not included in the first purchase of this solution. That means if you need to increase the security, you need to buy the security feature which doesn't come by default on these solutions."
"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."
"License or upgrade management can be difficult and time consuming because it requires login to a separate console."
"The customization can sometimes be difficult to achieve."
"The initial setup process is very difficult and extremely complex."
"The management monitoring tools are quite important and an area that needs some improvement."
"The setup is a little bit complex. We would like to see the installation part get easier."
"Limitations in group by projections is where I would like to see an improvement."
"It needs integration with multiple clouds."
"Suboptimal projection design causes queries to not scale linearly."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"Very bad support, I would rate it two out of 10."
"The geospatial functionality could be designed better."
"They could improve on customer service."
"Fact-to-fact joins on multi-billion record tables perform poorly."
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 "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.