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

Cassandra vs MongoDB vs OpenText Analytics Database (Vertica) 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:
 

Mindshare comparison

NoSQL Databases
NoSQL Databases
Data Warehouse
 

Q&A Highlights

it_user1272297 - PeerSpot reviewer
Apr 19, 2020
 

Featured Reviews

Himanshu Amodwala - PeerSpot reviewer
Well-equipped to handle a massive influx of data and billions of requests
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 updates is paramount. For instance, when a customer leaves comments or feedback on an image, they anticipate an immediate reflection of these changes on the portal. Similarly, sellers altering product attributes or updating images expect instant visibility of these modifications. Handling large data volumes with Cassandra has been an excellent experience. Despite challenges related to the influx, these were not attributed to Cassandra itself but rather to middle-layer issues. Generally, it demonstrated scalability with workloads, thanks to its horizontal scaling capabilities. We could easily add new nodes to the system as needed, ensuring the platform coped well with increasing loads. The tool's most beneficial feature for scalability is its entire architecture. The absence of a single point of failure or a leader within the ecosystem contributes to its robust scalability. This key aspect influenced our decision to opt for the Cassandra ecosystem. In terms of performance, it demonstrated the ability to handle approximately 1.6 billion requests per day. This was achieved on AWS using EC2 instances, and it was during a period about four to five years ago.
Uzair Faruqi - PeerSpot reviewer
Transforms data flow with adaptable schema and smooth public cloud deployment
One of our business units uses MongoDB, and we developed an ETL pipeline that extracts data from MongoDB and transfers it into our data warehouse MongoDB is a NoSQL database that is similar to a document database. It offers flexibility in schema adaptation, allowing us to change the schema and…
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…

Quotes from Members

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

Pros

"The time series data was one of the best features along with auto publishing."
"Cassandra has some features that are more useful for specific use cases where you have time series where you have huge amounts of writes. That should be quick, but not specifically the reads. We needed to have quicker reads and writes and this is why we are using Cassandra right now."
"Cassandra offers high availability and fault tolerance, making it suitable for large-scale data storage and real-time processing."
"I'd rate the solution ten out of ten."
"Since I haven't had years of experience with it, it's still new to me. One valuable feature is its distribution, so I can run it partly in the cloud and part on-prem. That's a feature I'd like to use but haven't yet because we're trying to move to Azure. I don't know if or when that will happen. Ideally, we'd have it distributed over the cloud and on-prem simultaneously, so if something happens to our on-prem, we can keep going in the cloud, like a pay-as-you-go model with Azure."
"The most valuable features of this solution are its speed and distributed nature."
"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."
"Can achieve continuous data without a single downtime because of node to node ring architecture."
"The aggregation framework is very powerful when elaborating on data."
"Easier to maintain the data with its document-based storage."
"My impression is that the initial setup is straightforward."
"One of the first things I noticed when I had my first experience with MongoDB was how easy it was to use. I was expecting more difficulties or at least some challenges, but it was very, very easy to use. It's great technology, performs well, and is very convenient."
"like its performance and the stability. It's very stable and, performance-wise, it's really great."
"The most valuable features of MongoDB are the variety of translations available and the ability to deploy it on the cloud is useful. The cloud users can access the data, work on the data, and if they want to import or manipulate some data they can."
"MongoDB's dashboards offer more functionalities and allow you to create a dashboard with MongoDB database data."
"The integration capabilities of MongoDB are fine for the solutions that we use in our company."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. ​"
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"The most valuable feature is Vertica's performance and the ease of using the database."
 

Cons

"I want Cassandra to update its open-source version more quickly. It's already feature-rich, but I'd appreciate better integration with other NoSQL databases like MariaDB or MongoDB. If I ever need to work with customers or vendors using different NoSQL databases, having native integration in Cassandra would make managing and interacting with their databases much easier."
"It can be difficult to analyze what's going on inside of the database relative to other databases. It can also be difficult to troubleshoot sometimes."
"We found some issues with the batch inserts when the data volume is large."
"Batching bulk data can cause performance issues."
"Fine-tuning was a bit of a challenge."
"The disc space is lacking. You need to free it up as you are working."
"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."
"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."
"It would help if MongoDB offered a light solution for small projects."
"I rate the support from MongoDB a four out of five."
"There was a need for integrating relational database capabilities, however, MongoDB has introduced a relational converter that allows conversion between SQL and NoSQL."
"People coming from RDBMS should have the flexibility to write queries in SQL that can be converted into JSON queries."
"I have found the solution difficult to operate as an administrator."
"There are some problems with bugs appearing in sharding when the data is too high."
"Data encryption is possible using third-party tools but they should have their own encryption capability built-in to this solution."
"The solution can be a bit tough to set up if you don't have knowledge about how the database works."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"In our company, we have faced difficulties in scaling the solution for certain use cases."
"The geospatial functionality could be designed better."
"I have found that coding support could be simplified."
"Vertica's native cloud support could be improved, and its installation could be made easier."
 

Pricing and Cost Advice

"I use the tool's open-source version."
"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."
"Cassandra is a free open source solution, but there is a commercial version available called DataStax Enterprise."
"I don't have the specific numbers on pricing, but it was fairly priced."
"We pay for a license."
"MongoDB's pricing is reasonable."
"MongoDB is an open-source product."
"You only have to pay for the paid version, not the open-source version."
"I believe that MongoDB is free."
"The product is affordable."
"There are different licenses available to be purchased, such as individual, premium, or enterprise."
"I only used the open-source version."
"MongoDB has a free version. You can also buy the enterprise edition, which is cheaper than Oracle."
"It is fast to purchase through the AWS Marketplace."
"From a cost perspective, the software is less than most of its competitors."
"It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."
"The pricing for this solution is very reasonable compared to other vendors."
"Read the fine print carefully."
"The price could be cheaper and it is best to negotiate the price."
"The price of Vertica is less expensive than some competitors, such as Teradata."
"The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
report
Use our free recommendation engine to learn which NoSQL Databases solutions are best for your needs.
862,543 professionals have used our research since 2012.
 

Answers from the Community

it_user1272297 - PeerSpot reviewer
Apr 19, 2020
Apr 19, 2020
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
2 out of 4 answers
Russell Rothstein - PeerSpot reviewer
Jan 27, 2020
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.
reviewer1219965 - PeerSpot reviewer
Jan 27, 2020
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
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Computer Software Company
14%
Comms Service Provider
7%
Retailer
6%
Financial Services Firm
16%
Computer Software Company
13%
University
8%
Manufacturing Company
8%
Financial Services Firm
18%
Computer Software Company
17%
Manufacturing Company
9%
Comms Service Provider
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Cassandra?
The use of Cassandra in real-time data analytics has been pivotal for our e-commerce platform. As our platform operat...
What needs improvement with Cassandra?
While Cassandra can handle NoSQL, I think there should be more flexibility for whole schema design when data is store...
What do you like most about MongoDB?
MongoDB's approach to handling data in documents rather than traditional tables has been particularly beneficial.
What is your experience regarding pricing and costs for MongoDB?
We pay approximately 2,000 euros per month for MongoDB.
What needs improvement with MongoDB?
I'm not sure about the documentation or the knowledge bases available for MongoDB because I don't interact with it at...
What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compet...
 

Also Known As

No data available
No data available
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

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
Facebook, MetLife, City of Chicago, Expedia, eBay, Google
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about MongoDB, ScyllaDB, InfluxData and others in NoSQL Databases. Updated: July 2025.
862,543 professionals have used our research since 2012.