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 like the tool’s features like Smart Scan, Hybrid Columnar Compression, and the TFA."
"Complete management occurs from one single address instead of different servers."
"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."
"Backup/Restore performance: Fast backups, fast restores (especially useful for creating clone environments)."
"It is a scalable solution."
"The most valuable feature of Oracle Exadata is its capabilities for storing and processing data. It is very good for our domain."
"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."
"Exadata with the In-Memory option is several levels about SAP HANA."
"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."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"Its projections and encoding are excellent tools for tuning large volumes."
"The solution is quick, has good compression data, and is not expensive."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"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. "
"The most valuable feature of Vertica is the unmatchable database performance."
"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."
"Patching must be simplified."
"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 performance could be improved."
"The setup is a little bit complex. We would like to see the installation part get easier."
"The handling of temp space has room for improvement."
"The customization can sometimes be difficult to achieve."
"It would be nice to have a single click button to, say, migrate my VMware VM into the Oracle VM, or vice-versa."
"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."
"The geospatial functionality could be designed better."
"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."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Suboptimal projection design causes queries to not scale linearly."
"We faced some challenges when trying to use the temporary tables feature."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"When it is about to reach the maximum storage capacity, it becomes slow."
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.