IT Central Station is now PeerSpot: Here's why

MongoDB vs SingleStore comparison

Cancel
You must select at least 2 products to compare!
MongoDB Logo
5,668 views|4,283 comparisons
SingleStore Logo
3,198 views|2,247 comparisons
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
Buyer's Guide
NoSQL Databases
July 2022
Find out what your peers are saying about MongoDB, Cloudera, Apache and others in NoSQL Databases. Updated: July 2022.
621,327 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
"MongoDB is scalable and stable. The initial setup is very easy, and deployment and maintenance can be done by one person.""The clustering is very good. It allows us to have high availability.""like its performance and the stability. It's very stable and, performance-wise, it's really great.""The solution's most important aspect is its seamless database.""One of the most valuable features of MongoDB is it is Its open source.""The solution is user-friendly with a good object retrieval feature.""It stores historical data with ease. For example, if you are a healthcare member, then you will have multiple records of visits to the doctors. To store such data in Oracle Database, you have to create many records. You might also have duplication problems because your records are going in again and again, because of which the data warehouse and the maintenance cost will be huge. MongoDB is comparatively lightweight. It is a JSON extract. Once you define a schema and extract it, you can push all the relationships in any way you want. It is easier to define and get different types of transactions into MongoDB. It is also easier to set it up as compared to other solutions. MongoDB is a NoSQL database, which means it is a document DB in which you can store documents that you created in BSON. It is pretty fast in response. It is faster than relational databases because it does not define any primary keys, secondary keys, tertiary keys, and all those kinds of things.""It is easy to use."

More MongoDB Pros →

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

More SingleStore Pros →

Cons
"It would be much more useful if I have an admin user and a password.""A normal Oracle or database tester will take some time to gear up to MongoDB because the way of writing queries is different in MongoDB. There should be some kind of midway where a person who is coming from an Oracle background can write a query and get a response by using something like a select * statement or other such things. There should be some way for MongoDB to interpret these commands rather than making a person learn MongoDB commands and writing them. I struggled while writing these MongoDB commands. I had not seen such queries before. It was pretty difficult to get them. This is one of the areas where it would help from the improvement standpoint.""The performance can be improved.""MongoDB can improve large-size video or media frame operations. There are a lot of customers who want to upload media frames and video games but there is some difficulty. In MongoDB, we are looking out for solutions that are for large-size media files that can be saved and navigated efficiently.""We'd like information about client onboarding experience and success stories. It would help to have something to show to internal stakeholders.""The performance could be faster.""The solution should have better integration.""Our program developer finds it to be a little unstable, development-wise."

More MongoDB Cons →

"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
  • "We use the open-source version, which is available to use free of charge."
  • "I don't know, but I have heard from people who procure it that it is much cheaper than Oracle."
  • "MongoDB is not expensive."
  • "At the moment, all customers are using the community version."
  • "If you want support with the solution you will need to purchase a license and not use the open-source version. The license is a little expensive."
  • "It's a community edition, so we do not pay anything."
  • "Our customers pay for yearly licenses for MongoDB."
  • "It's open-source."
  • More MongoDB Pricing and Cost Advice →

  • "I would advise users to try the free 128GB version."
  • More SingleStore Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which NoSQL Databases solutions are best for your needs.
    621,327 professionals have used our research since 2012.
    Answers from the Community
    Morten Calisch
    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.

    Questions from the Community
    Top Answer:MongoDB is a very reliable and stable No-SQL engine. It's a document-based database, and use Javascript as its query language: depending on the developer expertise and skills, this could be an… more »
    Top Answer:It has visible benefits, actually, in terms of price of ownership if you compare it to, for example, Oracle.
    Top Answer:MongoDB is a free solution. We wanted to have high availability and the subscription cost was quite expensive because the basic one is free and then when you want to have some other replications or… more »
    Top Answer:MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short.
    Top Answer:I would advise users to try the free 128GB version. MemSQL also comes with "Cluster-in-a-box", which allows you to run it on a single instance. This is a great way to save money and get your hands… more »
    Top Answer:There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great. MySQL to MemSQL replication would be great. If it could replicate from MySQL… more »
    Ranking
    1st
    out of 16 in NoSQL Databases
    Views
    5,668
    Comparisons
    4,283
    Reviews
    32
    Average Words per Review
    395
    Rating
    8.2
    6th
    Views
    3,198
    Comparisons
    2,247
    Reviews
    1
    Average Words per Review
    1,087
    Rating
    10.0
    Comparisons
    Learn More
    Overview

    MongoDB is a popular data management solution with a NoSQL database that enables you to store and process structured and semi-structured data with ease. The solution is scalable and flexible, and is designed to overcome the relational databases approach and the limitations of other NoSQL solutions. In addition, MongoDB stands apart as the cloud database platform of choice for enterprise applications that require real-time analytics.

    MongoDB Features

    MongoDB has many valuable key features. Some of the most useful ones include:

    • Load balancing: MongoDB supports large-scale load balancing via horizontal scaling features like replication and sharding.
    • Ad-hoc queries: With this feature, developers are able to update ad-hoc queries in real time.
    • Sharding: With MongoDB, sharding allows for much greater horizontal scalability, with queries that are directed to the correct shard based on specific shard keys.
    • Indexing: MongoDB allows indexing to be created on demand, accommodating real-time, ever-changing query patterns and application requirements. They can also be declared on any field within any document, including those nested within arrays.
    • Replication: MongoDB’s replication feature enables you to deploy multiple servers for disaster recovery and backup, which helps increase data availability and stability.

    MongoDB Benefits

    There are many benefits to implementing MongoDB. Some of the biggest advantages the solution offers include:

    • Horizontal architecture: Because MongoDB is designed with horizontal architecture, it is easy to scale.
    • Developer-friendly: Being that MongoDB is a document data model with NoSQL, developers are able to work faster. In addition, MongoDB gives developers a number of useful out-of-the-box capabilities, whether you need to run privately on site or in the public cloud.
    • Cloud-based: Because MongoDB is a full cloud-based application data platform, you gain access to a collection of services that can integrate nicely with your database.
    • Powerful analytics: MongoDB is designed to make data easy to access, and also allows you to perform complex analytics and querying.
    • High performance: With MongoDB, information can be embedded inside a single document rather than relying on expensive join operations from traditional relational databases.
    • Easy to install: MongoDB has an intuitive UI, making it easy to install. You can install the community or enterprise version directly on a server, create your own container, or use a pre-built community one.
    • Cost-effective: MongoDB gives you the option to choose an instance size that fits your current needs to help you keep your costs at a minimum.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the MongoDB solution.

    PeerSpot user Deepak K., Managing Director at SimSol Technologies And Services Pvt Ltd., says, “The solution is a very dynamic product. It becomes extremely easy for us to support user requirements and we also make use of the simplicity of a cloud redeployment.” He goes on to add, “The solution is easy to deploy, and the product can scale quite well. The solution's most important aspect is its seamless database. The solution offers excellent documentation.”

    A Senior Associate at a financial services firm mentions, “The most valuable feature of the solution is the ability to easily store documentation regarding structures. We can easily connect to MongoDB and search without transformation, without joining. If we want to use a simple search it's really fast. The initial setup isn't really that complex. The solution is pretty stable overall.”

    Lenses is a simple and secure self service DataOps platform, to operate with confidence on Apache Kafka & Kubernetes.

    Offer
    Learn more about MongoDB
    Learn more about SingleStore
    Sample Customers
    Facebook, MetLife, City of Chicago, Expedia, eBay, Google
    Uber, Akamai, Dell EMC, Samsung, Comcast, Kellogg
    Top Industries
    REVIEWERS
    Financial Services Firm24%
    Computer Software Company24%
    Legal Firm5%
    Energy/Utilities Company5%
    VISITORS READING REVIEWS
    Comms Service Provider24%
    Computer Software Company18%
    Financial Services Firm10%
    Government7%
    VISITORS READING REVIEWS
    Computer Software Company24%
    Comms Service Provider17%
    Financial Services Firm15%
    Manufacturing Company6%
    Company Size
    REVIEWERS
    Small Business38%
    Midsize Enterprise17%
    Large Enterprise46%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise18%
    Large Enterprise63%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise69%
    Buyer's Guide
    NoSQL Databases
    July 2022
    Find out what your peers are saying about MongoDB, Cloudera, Apache and others in NoSQL Databases. Updated: July 2022.
    621,327 professionals have used our research since 2012.

    MongoDB is ranked 1st in NoSQL Databases with 34 reviews while SingleStore is ranked 6th in Database as a Service with 1 review. MongoDB is rated 8.2, while SingleStore is rated 10.0. The top reviewer of MongoDB writes "Good pricing and very fast but needs to showcase more use cases". On the other hand, the top reviewer of SingleStore writes "MySQL Big Brother with built-in data pipeline, high concurrency, and blazing fast analytical queries". MongoDB is most compared with Couchbase, InfluxDB, Cassandra, Oracle NoSQL and Scylla, whereas SingleStore is most compared with MySQL, CockroachDB, Cloudera Distribution for Hadoop, SQL Server and Oracle Database In-Memory.

    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.