Try our new research platform with insights from 80,000+ expert users

OpenText Analytics Database (Vertica) vs kdb+ comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Categories and Ranking

kdb+
Average Rating
9.0
Number of Reviews
1
Ranking in other categories
Relational Databases Tools (25th)
OpenText Analytics Database...
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Data Warehouse (7th), Cloud Data Warehouse (11th)
 

Mindshare comparison

kdb+ and OpenText Analytics Database (Vertica) aren’t in the same category and serve different purposes. kdb+ is designed for Relational Databases Tools and holds a mindshare of 0.5%, up 0.2% compared to last year.
OpenText Analytics Database (Vertica), on the other hand, focuses on Data Warehouse, holds 6.9% mindshare, down 9.2% since last year.
Relational Databases Tools Market Share Distribution
ProductMarket Share (%)
kdb+0.5%
SQL Server15.5%
Oracle Database12.6%
Other71.4%
Relational Databases Tools
Data Warehouse Market Share Distribution
ProductMarket Share (%)
OpenText Analytics Database (Vertica)6.9%
Oracle Exadata14.2%
Snowflake12.5%
Other66.4%
Data Warehouse
 

Featured Reviews

Nitin Garg - PeerSpot reviewer
An easy-to-deploy solution that can be used for data ingestion and usage
I work for a fintech company where we create several strategies generally built on finance data, which are like one-time series data. We deal with huge bulk data on a daily basis, and we use kdb+ for data ingestion and usage The most valuable feature of kdb+ is the speed at which it returns the…
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…

Quotes from Members

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

Pros

"The solution returns data quickly, and data retrieval is fast in kdb+."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"The initial setup was straightforward."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"Partition and join back to node are easy and simple for DBAs."
"The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company"
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. ​"
"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."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
 

Cons

"The solution should have a more user-friendly user interface."
"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."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"I have found that coding support could be simplified."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"It needs integration with multiple clouds."
"Documentation has become much better, but can always use some improvement."
 

Pricing and Cost Advice

Information not available
"Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).​"
"The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
"I am aware that we have licensed it, but I have no knowledge of its cost."
"It is fast to purchase through the AWS Marketplace."
"Vertica is an expensive tool."
"It's free up to three nodes and 1TB, and then get in contact with their sales guys."
"The pricing and licensing depend on the size of your environment and the zone where you want to implement."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
869,771 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
43%
Retailer
7%
Energy/Utilities Company
7%
Computer Software Company
7%
Financial Services Firm
18%
Computer Software Company
16%
Manufacturing Company
8%
Comms Service Provider
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business29
Midsize Enterprise23
Large Enterprise38
 

Questions from the Community

What do you like most about kdb+?
The solution returns data quickly, and data retrieval is fast in kdb+.
What needs improvement with kdb+?
The solution should have a more user-friendly user interface.
What is your primary use case for kdb+?
I work for a fintech company where we create several strategies generally built on finance data, which are like one-time series data. We deal with huge bulk data on a daily basis, and we use kdb+ f...
What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.
 

Also Known As

No data available
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

UniCredit, AIRBUS
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools. Updated: September 2025.
869,771 professionals have used our research since 2012.