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."The most valuable feature of the solution is its compatibility with IBM Power Systems."
"The most valuable features are with the industrial side."
"Scales well enough for a relational database."
"When you submit a ticket the response time is quick."
"I have found the most valuable feature to be its availability."
"Your iOS, your throughputs, your performance cycles, you cannot touch it with Microsoft or with Oracle scalability-wise. That is far and away the most scalable systems and the highest performing systems of the set of them."
"We are dealing with millions of transactions a month and the performance is very good."
"It's very secure."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"The most valuable feature of Vertica is the unmatchable database 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."
"The extensibility and efficiency provided by their C++ SDK."
"The product's initial setup phase is extremely simple."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"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 licensing fees can be reduced."
"IBM Db2 Database could improve in the steps it takes for upgrades. It is not an easy process. The process of upgrading the version is lengthy and requires a lot of time. To make it more efficient, I suggest implementing some automation on the solution side. This will greatly reduce the time required for the upgrade."
"There could be better integration with some cloud solutions."
"The GUI interface is not particularly friendly for those who do not have experience with the product."
"The technical support team is not very good when compared to the efficiency of Oracle's support."
"We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment."
"IBM's products tend to be quite costly, especially given the availability of free, open-source alternatives."
"The solution's UI hasn't been upgraded. The solution’s UI is an area to improve because the solution was developed long ago."
"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."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"Support is an area where it could get better."
"Very bad support, I would rate it two out of 10."
"The integration of this solution with ODI could be improved."
"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."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"We faced some challenges when trying to use the temporary tables feature."
IBM Db2 Database is ranked 6th in Relational Databases Tools with 67 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. IBM Db2 Database is rated 8.2, while Vertica is rated 8.2. 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 BigQuery.
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.