Compare IBM Db2 Database vs. Vertica

Cancel
You must select at least 2 products to compare!
IBM Db2 Database Logo
12,518 views|9,611 comparisons
Vertica Logo
14,969 views|8,575 comparisons
Most Helpful Review
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases. Updated: October 2020.
442,517 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
"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.""The most valuable feature of this solution is the integration with other IBM products.""The scalability and availability of this solution are the most valuable features.""The most valuable features of this solution are security and stability.""The solution is very stable, in both hardware and database.""The self-management and optimization features are probably the best on the market""We had a crash of the backup system and the IBM DB2 was always up and consistent. It's robust, and for us, it was always up and running.""When you submit a ticket the response time is quick."

More IBM Db2 Database Pros »

"It maximize cloud economics for mission-critical big data analytical initiatives.""It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands.""Eighty percent of the ETL operations have improved since implementing this solution.""The performance is very good and the aggregate records are fast.""Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.""Allows us to take volumes and process them at a very high speed.""For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments.""Speed and resiliency are probably the best parts of this product."

More Vertica Pros »

Cons
"The initial set up was complex.""I would like to see better support for advanced analytics.""It would be helpful to have more querying tools and more development tools for us to work easily with Microsoft.""End-to-end encryption specifically is something the solution needs to have in the next release.""The ease of use, or ease of management, could be improved.""The licensing fees can be reduced.""The price should be lower.""In terms of improvements, IBM Db2 can improve its interface and its functionality. Also, the embedded functions should be much richer than the current ones - the functions which are embedded in the engine itself."

More IBM Db2 Database Cons »

"It needs integration with multiple clouds.""Fact-to-fact joins on multi-billion record tables perform poorly.""When it is about to reach the maximum storage capacity, it becomes slow.""Support is an area where it could get better.""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.""Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint.""The geospatial functionality could be designed better."

More Vertica Cons »

Pricing and Cost Advice
"Licensing fees are on a yearly basis.""We don't see what the specific price of the DB2 license is because we pay for the backup license as a package.""I think that everyone knows that with IBM the standard price is higher than the others.""Db2 is less expensive than Oracle."

More IBM Db2 Database Pricing and Cost Advice »

"It is fast to purchase through the AWS Marketplace.""The pricing and licensing depend on the size of your environment and the zone where you want to implement.""From a cost perspective, the software is less than most of its competitors."

More Vertica Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
442,517 professionals have used our research since 2012.
Questions from the Community
Top Answer: Per all previous posts "it depends". Platform, type of use and ability to be stable for the work-load are the concerns. Finding Oracle skills vs DB2 skills in the mainframe world is an area where… more »
Top Answer: Very good for performance and scalability.
Top Answer: 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… more »
Top Answer: SQreamDB is a GPU DB. It is not suitable for real-time oltp of course. Cassandra is best suited for OLTP database use cases, when you need a scalable database (instead of SQL server, Postgres)… more »
Top Answer: The performance is very good and the aggregate records are fast.
Top Answer: When it is about to reach the maximum storage capacity, it becomes slow.
Ranking
5th
Views
12,518
Comparisons
9,611
Reviews
14
Average Words per Review
488
Avg. Rating
7.7
3rd
out of 30 in Data Warehouse
Views
14,969
Comparisons
8,575
Reviews
5
Average Words per Review
446
Avg. Rating
9.0
Popular Comparisons
Compared 31% of the time.
Compared 25% of the time.
Compared 12% of the time.
Compared 6% of the time.
Compared 24% of the time.
Compared 11% of the time.
Compared 10% of the time.
Compared 9% of the time.
Compared 8% of the time.
Also Known As
DB2Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Learn
IBM
Micro Focus
Overview
DB2 Enterprise for Linux, UNIX, and Windows is the ideal data server for the most demanding workloads. New XML support is designed to help firms minimize the time and effort it takes to persist and use their XML data reducing development costs and improving business agility.

Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.

To learn more about Micro Focus Vertica Advanced Analytics, visit our website.

Offer
Learn more about IBM Db2 Database
Learn more about Vertica
Sample Customers
Knorr-Bremse, Mizuho Bank Ltd., Australian Government Department of Defence, SCHWENK Zement, Friedhelm Loh Group, YAZAKI Europe Limited, Ekornes ASA, Baldor Electric, VSN Systemen BV, Lion Brewery (Ceylon) PLC, PLANSEE Group, TE Connectivity, Hansgrohe SE, Openmatics, University of TorontoCerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Top Industries
REVIEWERS
Financial Services Firm44%
Insurance Company19%
University13%
Pharma/Biotech Company6%
VISITORS READING REVIEWS
Computer Software Company36%
Comms Service Provider11%
Insurance Company8%
Financial Services Firm8%
REVIEWERS
Media Company20%
Computer Software Company20%
Marketing Services Firm17%
Comms Service Provider13%
VISITORS READING REVIEWS
Computer Software Company40%
Comms Service Provider13%
Media Company9%
Financial Services Firm7%
Company Size
REVIEWERS
Small Business25%
Midsize Enterprise13%
Large Enterprise63%
REVIEWERS
Small Business30%
Midsize Enterprise24%
Large Enterprise46%
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases. Updated: October 2020.
442,517 professionals have used our research since 2012.
IBM Db2 Database is ranked 5th in Relational Databases with 14 reviews while Vertica is ranked 3rd in Data Warehouse with 6 reviews. IBM Db2 Database is rated 7.8, while Vertica is rated 9.0. The top reviewer of IBM Db2 Database writes "Almost maintenance-free and less expensive, but lacking in the area of development tools and resources". On the other hand, the top reviewer of Vertica writes "Superior performance in speed and resilience makes this a very good warehousing solution". IBM Db2 Database is most compared with Oracle Database, SQL Server, MySQL, SAP HANA and SAP Adaptive Server Enterprise, whereas Vertica is most compared with Snowflake, Apache Hadoop, Teradata, Amazon Redshift and SQL Server.

See our list of .

We monitor all Relational Databases 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.