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

OpenText Analytics Database (Vertica) vs SingleStore 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

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)
SingleStore
Average Rating
8.8
Reviews Sentiment
7.4
Number of Reviews
6
Ranking in other categories
Database as a Service (DBaaS) (12th), Vector Databases (15th)
 

Mindshare comparison

OpenText Analytics Database (Vertica) and SingleStore aren’t in the same category and serve different purposes. OpenText Analytics Database (Vertica) is designed for Data Warehouse and holds a mindshare of 6.9%, down 9.1% compared to last year.
SingleStore, on the other hand, focuses on Database as a Service (DBaaS), holds 2.6% mindshare, up 0.9% since last year.
Data Warehouse Market Share Distribution
ProductMarket Share (%)
OpenText Analytics Database (Vertica)6.9%
Oracle Exadata14.1%
Teradata13.2%
Other65.8%
Data Warehouse
Database as a Service (DBaaS) Market Share Distribution
ProductMarket Share (%)
SingleStore2.6%
Amazon RDS20.1%
MongoDB Atlas13.9%
Other63.4%
Database as a Service (DBaaS)
 

Q&A Highlights

it_user1272297 - PeerSpot reviewer
Apr 19, 2020
 

Featured Reviews

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…
Yasin Sarı - PeerSpot reviewer
High-speed data processing, seamless scalability, and excellent high availability making it an optimal choice for those prioritizing performance and efficiency in a database solution
There's a noteworthy consideration when it comes to collecting massive amounts of data. It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks. Attempting to use it for direct extraction, for instance, might lead to memory-related challenges. While MySQL version five might lack extensive SQL capabilities, SingleStore also has its constraints, requiring simpler SQL writing. This becomes evident when seeking advanced functionalities like window functions or JSON functions, where SingleStore doesn't offer an extensive toolkit, necessitating a more straightforward approach to SQL.

Quotes from Members

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

Pros

"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"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."
"Partition and join back to node are easy and simple for DBAs."
"I enjoy the cybersecurity and backup features."
"Speed and resiliency are probably the best parts of this product."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"I like the projection feature, which increases query performance."
"The initial setup was straightforward."
"It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The paramount advantage is the exceptional speed."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
 

Cons

"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."
"They could improve on customer service."
"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."
"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."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"Support is an area where it could get better."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"We don't get good discounts in Pakistan."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."
 

Pricing and Cost Advice

"The price could be cheaper and it is best to negotiate the price."
"The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation."
"It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."
"The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
"I am aware that we have licensed it, but I have no knowledge of its cost."
"I think it's starting to get a little expensive. Open source products are starting to get more robust, so I think that's something that they need to start looking at in terms of licensing."
"Vertica is an expensive tool."
"It's an expensive product"
"I would advise users to try the free 128GB version."
"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."
"SingleStore is a bit expensive."
"They have two main options: cloud installation and bare-metal installation, each with different pricing models."
"The product's licensing is not expensive. It is comparable."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
867,826 professionals have used our research since 2012.
 

Answers from the Community

it_user1272297 - PeerSpot reviewer
Apr 19, 2020
Apr 19, 2020
I haven't used SQream personally. However, if you are only considering GPU based rdbms's please check the following https://hackernoon.com/which-gpu-database-is-right-for-me-6ceef6a17505
2 out of 4 answers
Russell Rothstein - PeerSpot reviewer
Jan 27, 2020
Morten, the most popular comparisons of SQream can be found here: https://www.itcentralstation.com/products/sqream-db-alternatives-and-competitors The top ones include Cassandra, MemSQL, MongoDB, and Vertica.
reviewer1219965 - PeerSpot reviewer
Jan 27, 2020
I haven't used SQream personally. However, if you are only considering GPU based rdbms's please check the following https://hackernoon.com/which-gpu-database-is-right-for-me-6ceef6a17505
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
16%
Manufacturing Company
8%
Comms Service Provider
5%
Financial Services Firm
32%
Computer Software Company
12%
Comms Service Provider
6%
University
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business29
Midsize Enterprise23
Large Enterprise38
By reviewers
Company SizeCount
Small Business4
Large Enterprise3
 

Questions from the Community

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.
What do you like most about SingleStore DB?
The paramount advantage is the exceptional speed.
What is your experience regarding pricing and costs for SingleStore DB?
Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure. While building an on-premise cluster incurs an initial cost for servers with ample RAM...
What needs improvement with SingleStore DB?
There's a noteworthy consideration when it comes to collecting massive amounts of data. It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation...
 

Also Known As

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

Overview

 

Sample Customers

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
400+ customers including: 6sense, Adobe, Akamai, Ant Money, Arcules, CARFAX, Cigna, Cisco, Comcast, DELL, DBS Bank, Dentsu, DirectlyApply, EY, Factors.AI, Fathom Analytics, FirstEnergy, GE, Goldman Sachs, Heap, Hulu, IMAX, impact.com, Kroger, LG, LiveRamp, Lumana, Nvidia, OpenDialog, Outreach, Palo Alto Networks, PicPay, RBC, Samsung, SegMetrics, Siemens, SiteImprove, SiriusXM, SK Telecom, SKAI, SONY, STC, SunRun, TATA, Thorn, ZoomInfo.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: August 2025.
867,826 professionals have used our research since 2012.