Cassandra vs SingleStore comparison

Cancel
You must select at least 2 products to compare!
Apache Logo
175 views|132 comparisons
SingleStore Logo
142 views|110 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Cassandra and SingleStore based on real PeerSpot user reviews.

Find out in this report how the two Vector Databases solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Cassandra vs. SingleStore Report (Updated: March 2024).
765,386 professionals have used our research since 2012.
Q&A Highlights
Question: Which is the best RDMBS solution for big data?
Answer: 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
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Can achieve continuous data without a single downtime because of node to node ring architecture.""The most valuable feature of Cassandra is its fast retrieval. Additionally, the solution can handle large amounts of data. It is the quickest application we use.""The solution's database capabilities are very good.""We can add almost one million columns to the solution.""The most valuable features of Cassandra are the NoSQL database, high performance, and zero-copy streaming.""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.""Some of the valued features of this solution are it has good performance and failover.""Cassandra is good. It's better than CouchDB, and we are using it in parallel with CouchDB. Cassandra looks better and is more user-friendly."

More Cassandra Pros →

"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short.""The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms.""The paramount advantage is the exceptional speed.""The product's initial setup phase was pretty straightforward, with no complex processes.""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 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."

More SingleStore Pros →

Cons
"There were challenges with the query language and the development interface. The query language, in particular, could be improved for better optimization. These challenges were encountered while using the Java SDK.""Cassandra can improve by adding more built-in tools. For example, if you want to do some maintenance activities in the cluster, we have to depend on third-party tools. Having these tools build-in would be e benefit.""Fine-tuning was a bit of a challenge.""Cassandra could be more user-friendly like MongoDB.""Interface is not user friendly.""There could be more integration, and it could be more user-friendly.""The solution is not easy to use because it is a big database and you have to learn the interface. This is the case though in most of these solutions.""The solution is limited to a linear performance."

More Cassandra Cons →

"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.""The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings.""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."

More SingleStore Cons →

Pricing and Cost Advice
  • "Cassandra is a free open source solution, but there is a commercial version available called DataStax Enterprise."
  • "There are licensing fees that must be paid, but I'm not sure if they are paid monthly or yearly."
  • "We are using the open-source version of Cassandra, the solution is free."
  • "We pay for a license."
  • "I don't have the specific numbers on pricing, but it was fairly priced."
  • More Cassandra Pricing and Cost Advice →

  • "I would advise users to try the free 128GB version."
  • "SingleStore is a bit expensive."
  • "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."
  • "The price of the product is okay compared to the other available solutions in the market. SingleStore is a reasonably priced product, considering the functions it offers."
  • "They have two main options: cloud installation and bare-metal installation, each with different pricing models."
  • More SingleStore Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Vector Databases solutions are best for your needs.
    765,386 professionals have used our research since 2012.
    Answers from the Community
    Anonymous User
    Yuval Klein - PeerSpot reviewerYuval 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.

    Tristan Bergh - PeerSpot reviewerTristan 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.

    Russell Rothstein - PeerSpot reviewerRussell Rothstein (PeerSpot)
    Vendor

    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.

    Questions from the Community
    Top Answer:The use of Cassandra in real-time data analytics has been pivotal for our e-commerce platform. As our platform operates 24/7, providing services to sellers and customers alike, the need for real-time… more »
    Top Answer:There were challenges with the query language and the development interface. The query language, in particular, could be improved for better optimization. These challenges were encountered while using… more »
    Top Answer:The paramount advantage is the exceptional speed.
    Top Answer: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… more »
    Top Answer: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… more »
    Ranking
    11th
    out of 17 in Vector Databases
    Views
    175
    Comparisons
    132
    Reviews
    9
    Average Words per Review
    319
    Rating
    7.9
    9th
    out of 17 in Vector Databases
    Views
    142
    Comparisons
    110
    Reviews
    6
    Average Words per Review
    607
    Rating
    8.7
    Comparisons
    Couchbase logo
    Compared 20% of the time.
    InfluxDB logo
    Compared 14% of the time.
    MongoDB logo
    Compared 11% of the time.
    ScyllaDB logo
    Compared 11% of the time.
    Oracle NoSQL logo
    Compared 8% of the time.
    SQL Server logo
    Compared 10% of the time.
    MySQL logo
    Compared 9% of the time.
    Oracle Database logo
    Compared 8% of the time.
    Teradata logo
    Compared 7% of the time.
    CockroachDB logo
    Compared 7% of the time.
    Learn More
    SingleStore
    Video Not Available
    Overview

    Cassandra is a distributed and scalable database management system used for real-time data processing. 

    It is highly valued for its ability to handle large amounts of data, scalability, high availability, fault tolerance, and flexible data model. 

    It is commonly used in finance, e-commerce, and social media industries.

    SingleStore is headquartered in San Francisco, California, and offers SingleStoreDB, which combines transactional, analytical, & vector data workloads in a real-time, unified, distributed SQL database that is MySQL and MongoDB wire protocol-compatible. SingleStoreDB Cloud is offered as a managed service on AWS, Google, and Azure and in private clouds including IBM Cloud Pak for Data and Red Hat OpenShift. Other partners (50+ in all) include HPE, Twingo, Data-Sleek, Datadog, and Arcion. SingleStoreDB Self-Managed runs on premise/containers/Kubernetes. SingleStore has offices in Sunnyvale, Seattle, Portland, Raleigh, Boston, London, Dublin, Lisbon, Kyiv, Hyderabad, and Singapore, with remote workers worldwide. It has hundreds of customers including 100+ Fortune 500, Forbes Global 2000, and Inc. 5000 brands across 37 verticals, with the top four being financial services and fintech; media, streaming, and telecommunications; adtech/martech/salestech; and retail/eCommerce. SingleStore platform features include Code Engine with WASM, Data API, dbt Connector, Limitless Point-in-Time Recovery, MongoDB API, Pipelines, Unlimited (Bottomless) Storage, and Workspaces.

    Sample Customers
    1. Apple 2. Netflix 3. Facebook 4. Instagram 5. Twitter 6. eBay 7. Spotify 8. Uber 9. Airbnb 10. Adobe 11. Cisco 12. IBM 13. Microsoft 14. Yahoo 15. Reddit 16. Pinterest 17. Salesforce 18. LinkedIn 19. Hulu 20. Airbnb 21. Walmart 22. Target 23. Sony 24. Intel 25. Cisco 26. HP 27. Oracle 28. SAP 29. GE 30. Siemens 31. Volkswagen 32. Toyota
    SingleStore has hundreds of customers including 100+ Fortune 500, Forbes Global 2000, and Inc. 5000 brands across 37 verticals, with the top four being financial services and fintech; media, streaming, and telecommunications; adtech/martech/salestech; and retail/eCommerce. Sample customers include: 6Sense Akamai Technologies Arcules Armis Security Canadian Tire CARFAX Cigna Cisco Systems Comcast dailyVest Dell Technologies Digital Asset Research (DAR) Directed Technologies DirectlyApply Factors.AI Fathom Analytics FirstEnergy GAMEFAM/Silicon Digital GE Goldman Sachs Heap Hulu IMAX impact.com Kakao Kellogg Kroger LiveRamp Lumana Millennium bcp MonitorBase NBC Universal Nyris Octane Outreach Palo Alto Networks PAN HOME Questrade Saudi Telecom Company Siemens AG SiriusXM Siteimprove SK Telecom SKAI Sony Interactive Entertainment Tata Communications Limited Western Digital Corporation ZoomInfo
    Top Industries
    REVIEWERS
    Comms Service Provider29%
    Computer Software Company14%
    University14%
    Financial Services Firm14%
    VISITORS READING REVIEWS
    Financial Services Firm20%
    Computer Software Company15%
    Comms Service Provider7%
    Healthcare Company6%
    VISITORS READING REVIEWS
    Financial Services Firm25%
    Computer Software Company14%
    Comms Service Provider6%
    Manufacturing Company6%
    Company Size
    REVIEWERS
    Small Business35%
    Large Enterprise65%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise13%
    Large Enterprise68%
    REVIEWERS
    Small Business57%
    Large Enterprise43%
    VISITORS READING REVIEWS
    Small Business22%
    Midsize Enterprise14%
    Large Enterprise64%
    Buyer's Guide
    Cassandra vs. SingleStore
    March 2024
    Find out what your peers are saying about Cassandra vs. SingleStore and other solutions. Updated: March 2024.
    765,386 professionals have used our research since 2012.

    Cassandra is ranked 11th in Vector Databases with 19 reviews while SingleStore is ranked 9th in Vector Databases with 7 reviews. Cassandra is rated 8.0, while SingleStore is rated 8.8. The top reviewer of Cassandra writes "Well-equipped to handle a massive influx of data and billions of requests". On the other hand, the top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". Cassandra is most compared with Couchbase, InfluxDB, MongoDB, ScyllaDB and Oracle NoSQL, whereas SingleStore is most compared with SQL Server, MySQL, Oracle Database, Teradata and CockroachDB. See our Cassandra vs. SingleStore report.

    See our list of best Vector Databases vendors.

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