We performed a comparison between Oracle Database In-Memory and SingleStore based on real PeerSpot user reviews.
Find out what your peers are saying about SAP, Oracle, Firebird and others in Embedded Database."The solution's ROI is excellent."
"I like Oracle because it is a backward-compatible solution."
"Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads."
"The product offers high scalability."
"The solution is very fast."
"It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity."
"The on-premise version is stable. We have different teams and resources for the server side, for admin, and for development. We can easily take care of all the services and applications."
"Normally, every database server uses hard disks. In-Memory has a feature, apart from their database, which is very good. When we start our server, all your data needs loading memory. We can use that. It's a very good feature. I think they added this feature in 2019. We can mount memory in the partition, create partitions in there, and create table space from that spot to share. It's a really good feature. We use it a lot."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"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."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The paramount advantage is the exceptional speed."
"The product could be more economical."
"I would like Oracle Database In-Memory to include a data replication feature."
"They should lower the price. My customers think that it's too expensive."
"They should improve the solution's scalability for large databases."
"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 pricing could be improved. It would ideal if it was more reasonable."
"We often have to find solutions on our own through the support site, so there's room for improvement in this regard."
"We don't get good discounts in Pakistan."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"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."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"Having the ability to migrate servers using a single command would be extremely beneficial."
Oracle Database In-Memory is ranked 2nd in Embedded Database with 27 reviews while SingleStore is ranked 6th in Database as a Service with 7 reviews. Oracle Database In-Memory is rated 8.8, while SingleStore is rated 8.8. The top reviewer of Oracle Database In-Memory writes "User friendly with great scalability but needs to move toward intelligent AI". On the other hand, the top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". Oracle Database In-Memory is most compared with SAP HANA, IBM Db2 Database, Progress OpenEdge RDBMS, SQL Server and SAP Adaptive Server Enterprise, whereas SingleStore is most compared with SQL Server, MySQL, Teradata, CockroachDB and Oracle Database.
We monitor all Embedded Database 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.