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

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 5.3%, down 8.6% compared to last year.
SingleStore, on the other hand, focuses on Database as a Service (DBaaS), holds 2.9% mindshare, up 1.6% since last year.
Data Warehouse Market Share Distribution
ProductMarket Share (%)
OpenText Analytics Database (Vertica)5.3%
Snowflake10.1%
Teradata9.4%
Other75.2%
Data Warehouse
Database as a Service (DBaaS) Market Share Distribution
ProductMarket Share (%)
SingleStore2.9%
Amazon RDS13.5%
MongoDB Atlas12.3%
Other71.3%
Database as a Service (DBaaS)
 

Q&A Highlights

it_user1272297 - PeerSpot reviewer
Special Adviser Strategy at a university with 501-1,000 employees
Apr 19, 2020
 

Featured Reviews

T Venkatesh - PeerSpot reviewer
Deputy Manager at ICICIBANK Ltd
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…
VK
Solution Architect at Wipro Limited
An excellent choice for diverse data processing needs with exceptional in-memory capabilities, robust failover mechanisms, easy scalability and high performance
Scalability is its key strength. Adding servers for scalability is a straightforward process involving simply incorporating a few additional servers and recycling the cluster triggers automatic repartitioning and redistribution of data. For instance, if the initial database creation involved a hundred servers and later, four more servers are added, specific commands can be executed to increase the partitions to one hundred twenty. The data is then efficiently redistributed across the expanded partitions without the need for manual data movement, ensuring a seamless and efficient scalability process. In my current organization, approximately three projects involve the usage of SingleStore, with a team size ranging from ten to twenty individuals.

Quotes from Members

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

Pros

"Eighty percent of the ETL operations have improved since implementing this solution."
"Initiate on one node, and the RPM propagates automatically to all other nodes. ​"
"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."
"The solution is quick, has good compression data, and is not expensive."
"Allows us to take volumes and process them at a very high speed."
"The initial setup was straightforward."
"Speed and resiliency are probably the best parts of this product."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"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 ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The paramount advantage is the exceptional speed."
 

Cons

"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"The biggest problem is the cost of cloud deployment."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"They could improve on customer service."
"Pricing could be more competitive."
"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."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"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."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
 

Pricing and Cost Advice

"I am aware that we have licensed it, but I have no knowledge of its cost."
"The price could be cheaper and it is best to negotiate the price."
"It is fast to purchase through the AWS Marketplace."
"Read the fine print carefully."
"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."
"The pricing could improve, it is a little expensive."
"Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or even free."
"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."
"They have two main options: cloud installation and bare-metal installation, each with different pricing models."
"SingleStore is a bit expensive."
"I would advise users to try the free 128GB version."
"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.
881,707 professionals have used our research since 2012.
 

Answers from the Community

it_user1272297 - PeerSpot reviewer
Special Adviser Strategy at a university with 501-1,000 employees
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
CEO at PeerSpot
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
Data Architect at a tech services company with 201-500 employees
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
17%
Computer Software Company
14%
Manufacturing Company
8%
Comms Service Provider
5%
Financial Services Firm
30%
Computer Software Company
10%
Comms Service Provider
8%
Retailer
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.
Ask a question
Earn 20 points
 

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: January 2026.
881,707 professionals have used our research since 2012.