Compare Cassandra vs. SingleStore DB

Cancel
You must select at least 2 products to compare!
Cassandra Logo
4,041 views|3,225 comparisons
SingleStore DB Logo
2,942 views|2,617 comparisons
Most Helpful Review
Find out what your peers are saying about MongoDB, Cloudera, Apache and others in NoSQL Databases. Updated: February 2021.
465,623 professionals have used our research since 2012.
Quotes From Members

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

Pros
"The technical evaluation is very good.""The most valuable features are the counter features and the NoSQL schema. It also has good scalability. You can scale Cassandra to any finite level.""The solution's database capabilities are very good.""The time series data was one of the best features along with auto publishing."

More Cassandra Pros »

"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."

More SingleStore DB Pros »

Cons
"Interface is not user friendly.""Fine-tuning was a bit of a challenge.""The disc space is lacking. You need to free it up as you are working.""The solution doesn't have joins between tables so you need other tools for that."

More Cassandra Cons »

"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."

More SingleStore DB Cons »

Pricing and Cost Advice
Information Not Available
"I would advise users to try the free 128GB version."

More SingleStore DB Pricing and Cost Advice »

report
Use our free recommendation engine to learn which NoSQL Databases solutions are best for your needs.
465,623 professionals have used our research since 2012.
Answers from the Community
Morten Calisch
author avatarC Dove
Real User

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

author avatarYuval Klein
Real User

SQreamDB is a GPU DB. It is not suitable for real-time oltp of course.

Cassandra is best suited for OLTP database use cases, when you need a scalable database (instead of SQL server, Postgres)
SQream is a GPU database suited for OLAP purposes. It's the best suite for a very large data warehouse, very large queries needed mass parallel activity since GPU is great in massive parallel workload.

Also, SQream is quite cheap since we need only one server with a GPU card, the best GPU card the better since we will have more CPU activity. It's only for a very big data warehouse, not for small ones.

author avatarTristan Bergh
Real User

Your best DB for 40+ TB is Apache Spark, Drill and the Hadoop stack, in the cloud.

Use the public cloud provider's elastic store (S3, Azure BLOB, google drive) and then stand up Apache Spark on a cluster sized to run your queries within 20 minutes. Based on my experience (Azure BLOB store, Databricks, PySpark) you may need around 500 32GB nodes for reading 40 TB of data.

Costs can be contained by running your own clusters but Databricks manage clusters for you.

I would recommend optimizing your 40TB data store into the Databricks delta format after an initial parse.

Questions from the Community
Top Answer: SQreamDB is a GPU DB. It is not suitable for real-time oltp of course. Cassandra is best suited for OLTP database use cases, when you need a scalable database (instead of SQL server, Postgres)… more »
Ask a question

Earn 20 points

Ranking
3rd
out of 16 in NoSQL Databases
Views
4,041
Comparisons
3,225
Reviews
4
Average Words per Review
446
Rating
8.5
10th
Views
2,942
Comparisons
2,617
Reviews
1
Average Words per Review
1,087
Rating
10.0
Popular Comparisons
Learn More
SingleStore
Video Not Available
Overview
A scalable multi-master database with no single points of failure. Scalability & high availability without compromising performance.

MemSQL is The No Limits Database™, powering modern applications and analytical systems with a cloud-native, massively scalable architecture for maximum ingest and query performance with the highest concurrency. MemSQL envisions a world where every business can make decisions in real time and every experience is optimized through data. Global enterprises use the MemSQL distributed database to easily ingest, process, analyze, and act on data in order to thrive in today’s insight-driven economy. MemSQL is optimized to run on any public cloud or on-premises with commodity hardware. To learn more, visit our Product page - https://msql.co/2xUDAqL. To use MemSQL, get started with a free trial - https://msql.co/2NZOAy9.

Headquartered in San Francisco, CA with offices in Seattle, WA and Portland OR, MemSQL has raised $110M from top investors including GV, Accel Partners, and Khosla Ventures, among others. MemSQL is trusted by customers including Uber, Akamai, Dell EMC, Samsung, Comcast, Kellogg, and more.

If you want to work at a company that celebrates diversity, innovation, leadership, and creativity every day, check out our openings on our Careers page - https://msql.co/2RoTZgn.

Offer
Learn more about Cassandra
Learn more about SingleStore DB
Sample Customers
Apple, BazaarVoice, Best Buy, eBay, Netflix
Uber, Akamai, Dell EMC, Samsung, Comcast, Kellogg
Top Industries
VISITORS READING REVIEWS
Computer Software Company28%
Comms Service Provider23%
Media Company7%
Financial Services Firm6%
VISITORS READING REVIEWS
Computer Software Company25%
Comms Service Provider18%
Financial Services Firm14%
Healthcare Company7%
Find out what your peers are saying about MongoDB, Cloudera, Apache and others in NoSQL Databases. Updated: February 2021.
465,623 professionals have used our research since 2012.

Cassandra is ranked 3rd in NoSQL Databases with 4 reviews while SingleStore DB is ranked 10th in Relational Databases with 1 review. Cassandra is rated 8.6, while SingleStore DB is rated 10.0. The top reviewer of Cassandra writes "Great time series data feature but it requires third parties to join tables". On the other hand, the top reviewer of SingleStore DB writes "MySQL Big Brother with built-in data pipeline, high concurrency, and blazing fast analytical queries". Cassandra is most compared with InfluxDB, Couchbase, Accumulo, Cloudera Distribution for Hadoop and Scylla, whereas SingleStore DB is most compared with CockroachDB, MySQL, SQL Server, Oracle Database In-Memory and Apache HBase.

See our list of .

We monitor all NoSQL Databases 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.