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

Oracle Database In-Memory 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

Oracle Database In-Memory
Average Rating
8.8
Reviews Sentiment
7.1
Number of Reviews
33
Ranking in other categories
Embedded Database (4th), Relational Databases Tools (10th)
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

While both are Databases solutions, they serve different purposes. Oracle Database In-Memory is designed for Embedded Database and holds a mindshare of 10.5%, up 7.8% 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.
Embedded Database Market Share Distribution
ProductMarket Share (%)
Oracle Database In-Memory10.5%
SQLite21.6%
Firebird SQL16.6%
Other51.3%
Embedded Database
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)
 

Featured Reviews

Hosney Osman - PeerSpot reviewer
Technical Solution Architect at Vodafone
Real-time analytics have transformed response times and support huge data volumes with compression
I do not have any comment related to the improvement of the solution; for sure, it needs improvement, but for my use cases, it is very sufficient, and I think for the biggest companies, it needs a very powerful infrastructure. The area where improvement is required the most in the product is the UI. The problem with the UI is that it is not complex for understanding, but it needs some training to know what each button does, how it works, and the many variables needed.
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

"The scalability is very good."
"Security is the most valuable feature."
"We have recently deployed our database on cloud with Oracle Database In-Memory; we have a single standby on cloud, and on contingency occasions, we switch over to cloud and use it for four to five months."
"The most valuable aspects of this solution are the fast caching and improved performance to the database"
"I like Oracle because it is a backward-compatible solution."
"The solution's ROI is excellent."
"We use the tool for real-time data transfer for risk management purposes. In a trading system, conversions happen fast. We use the product to handle fast transactions with low latency."
"It efficiently handles low-code data and supports read-and-write operations for clustering."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"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."
"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 paramount advantage is the exceptional speed."
 

Cons

"We use some partitions in In-Memory. We have a very large table and a low dose. It is very expensive in data to load all of them into In-Memory. It takes up more memory slots in the server, as well as a lot of RAM. We use last partitions on the table. We always need to create a script and make a schedule that can load a last partition in In-Memory. Oracle doesn't have features to do this automatically. I would like them to allow us to load last partitions, as well as other table partitions, in In-Memory. I think a good feature would do that automatically, letting you see a table, load a large partition, and monitor loading memory. It's quite a good feature."
"The high cost of the product is an area of concern where improvements are required."
"The product could benefit from enhancements in its graphical user interface."
"They should improve the solution's scalability for large databases."
"Lacks sufficient integration with other tools."
"The pricing could be improved. It would ideal if it was more reasonable."
"The dashboard requires some refreshment or configuration improvements."
"They should lower the price. My customers think that it's too expensive."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"We don't get good discounts in Pakistan."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"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."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
 

Pricing and Cost Advice

"There is a need to make a yearly payment towards the licensing costs, after which there is any to pay towards the support cost attached to the solution."
"The platform's licensing cost needs improvement."
"The solution's pricing is high."
"The pricing is pretty good so I rate it an eight out of ten."
"Database In-Memory is priced a bit higher than its competitors like Microsoft."
"Oracle Database In-Memory is expensive."
"It's quite costly and it comes with a fixed price."
"I rate the pricing a zero out of ten because Database In-Memory is too costly."
"The product's licensing is not expensive. It is comparable."
"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."
"SingleStore is a bit expensive."
"I would advise users to try the free 128GB version."
"They have two main options: cloud installation and bare-metal installation, each with different pricing models."
report
Use our free recommendation engine to learn which Embedded Database solutions are best for your needs.
882,103 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
16%
Comms Service Provider
8%
Marketing Services Firm
8%
Manufacturing Company
6%
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 Business6
Midsize Enterprise4
Large Enterprise23
By reviewers
Company SizeCount
Small Business4
Large Enterprise3
 

Questions from the Community

What do you like most about Oracle Database In-Memory?
We can integrate it with any data sources as well.
What needs improvement with Oracle Database In-Memory?
I do not have any comment related to the improvement of the solution; for sure, it needs improvement, but for my use cases, it is very sufficient, and I think for the biggest companies, it needs a ...
Ask a question
Earn 20 points
 

Overview

 

Sample Customers

Shanghai Customs
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 SQLite, SAP, Firebird and others in Embedded Database. Updated: January 2026.
882,103 professionals have used our research since 2012.