We performed a comparison between IBM Db2 Database and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."Scalability-wise, I rate the solution a nine out of ten."
"The solution's initial setup is straightforward."
"Reliable, robust with great features."
"it is very stable and runs smoothly once it is deployed and it is almost maintenance-free."
"Some of the most valuable features are the scaling from a small very cheap installation to a very large enterprise installation. In addition, the backups and assistance are good."
"I believe that because the support is good, they jump in and assist us in determining the root cause."
"The most valuable features of this solution are security and stability."
"The self-management and optimization features are probably the best on the market"
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"Eighty percent of the ETL operations have improved since implementing this solution."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"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. "
"Allows us to take volumes and process them at a very high speed."
"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."
"Some of the internal rearrangement in the administration is not as straightforward as it is in competing products."
"I would like to see some artificial intelligence brought into the solution."
"The product needs to improve its configuration and storage."
"The technical support team is not very good when compared to the efficiency of Oracle's support."
"There could be better integration with some cloud solutions."
"The queries can be difficult for beginners because there are so many. I would like to see more use cases for flow analysis that enable us to correlate the flow with events. Adding this feature in a QI format would be good for beginners."
"IBM Db2 Database is not ACID compliant, which would improve it. Db2 lacks Isolation, so when two people are trying to update the same field at the same time it can become stuck. Other newer databases do not have this issue, such as Microsoft SQL, Oracle DB, PostgreSQL, and SAP HANA."
"The user interface is not user-friendly."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"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."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"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."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"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."
"The integration with AI has room for improvement."
IBM Db2 Database is ranked 6th in Relational Databases Tools with 66 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. IBM Db2 Database is rated 8.2, while Vertica is rated 8.4. The top reviewer of IBM Db2 Database writes "Very scalable with high availability and excellent technical support". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". IBM Db2 Database is most compared with SQL Server, Oracle Database, SAP HANA, Teradata and MySQL, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata.
We monitor all Relational Databases Tools 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.