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 aspect of this solution is its stability. We have never had any problems and have never had to contact technical support."
"The most valuable feature of IBM Db2 Database is its ability to perform automatic self-management, reducing the need for manual tasks such as managing logs and folders."
"The solution is easy to install and simple to maintain. The most valuable aspect of the solution is its general user-friendliness for users of all kinds."
"Its robustness, scalability, availability, and performance are valuable. All these are the major attributes of a relational database for supporting a very high-volume business, and Db2 is very good in all those areas and in all those attributes."
"Very good for performance and scalability."
"The solution is very stable, in both hardware and database."
"IBM Db2 was much cheaper as a package than using other products. This is because IBM supplied a package with its product. It's an application. So it was much more efficient and a stronger competitor in that regard."
"The most valuable features of this solution are security and stability."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"I enjoy the cybersecurity and backup features."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"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."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"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 tool is not easy to use. It needs to improve scale computing so that the tool can be scaled vertically. The product needs to enhance pre-engine optimization and it needs to be more efficient in completing queries. The documentation should be updated to include different scenarios of deployment."
"The application development requires a Java developer and not every company has these resources."
"When I look at Microsoft SQL Server, SQL Server provides me with better tools for database management."
"The initial setup could be improved."
"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."
"The backup solution lacks flexibility."
"The command line part of this solution could be much better."
"We need some time to improve the performance. We have to perform a weekly REORG, or else RUNSTATS for the databases."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"Support is an area where it could get better."
"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."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"It should provide a GUI interface for data management and tuning."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"The geospatial functionality could be designed better."
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.