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

MongoDB vs Vertica comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Oct 8, 2024
 

Categories and Ranking

MongoDB
Average Rating
8.2
Reviews Sentiment
6.9
Number of Reviews
76
Ranking in other categories
Open Source Databases (5th), NoSQL Databases (1st), Managed NoSQL Databases (7th)
Vertica
Average Rating
8.2
Reviews Sentiment
7.6
Number of Reviews
86
Ranking in other categories
Data Warehouse (4th), Cloud Data Warehouse (7th)
 

Q&A Highlights

it_user1272297 - PeerSpot reviewer
Apr 19, 2020
 

Featured Reviews

Hamidul Islam - PeerSpot reviewer
Lightweight with good flexibility and very fast performance for searching data
I used the solution in the production level to search data and create education-based tutorials for a project. We had 30 managers, senior architects, tech leads, and software engineers working on the project.  Currently, I use the solution for my personal work.  The solution has good flexibility…
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

"It's easy to add and remove things in MongoDB. You can alter the tables. MongoDB is faster at reading, slower at writings."
"I like the document storage feature. It's pretty simple."
"Easier to maintain the data with its document-based storage."
"MongoDB's approach to handling data in documents rather than traditional tables has been particularly beneficial."
"It is convenient to use because we can do manipulations with the JSON data that we get. There are also a lot of joins and associations with MongoDB, which makes it easy to use for us."
"The installation is very easy to do and understand."
"We've found the product to be scalable."
"The most valuable feature is that you can store unstructured data, which is helpful when you don't know what the best structure should be and you cannot use a relational database because of that."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. ​"
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"Its projections and encoding are excellent tools for tuning large volumes."
"Eighty percent of the ETL operations have improved since implementing this solution."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
 

Cons

"The performance of the solution could be improved."
"It could be more stable. It would be better if it were more user-friendly like Oracle, which is very easy. For example, creating an index is simple in Oracle. In MongoDB, it's quite challenging to do that. Performance could be better. It's fast and good, but you cannot put every application that you would like to in MongoDB."
"They could provide more documentation and examples for adding pipeline stages."
"It isn't easy to recognize entities with MongoDB."
"We'd like information about client onboarding experience and success stories. It would help to have something to show to internal stakeholders."
"The product's data consistency could be more efficient than traditional SQLs."
"There can be stability issues."
"It would be good to have scalability for clusters. For example, if we have three clusters, we should be able to increase to five clusters if required. I am not sure if such a feature is currently there. I hope there is good documentation for this."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"It would be great if this were a managed service in AWS."
"The integration of this solution with ODI could be improved."
"Very bad support, I would rate it two out of 10."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"Fact-to-fact joins on multi-billion record tables perform poorly."
 

Pricing and Cost Advice

"MongoDB's pricing is reasonable."
"The pricing is normal. Price-wise, the product is not too much expensive."
"I believe that MongoDB is free."
"Our customers pay for yearly licenses for MongoDB."
"We use the open-source version, which is available to use free of charge."
"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 other features you will need to pay money. Overall the solution is expensive."
"I only used the open-source 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."
"Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).​"
"The price could be cheaper and it is best to negotiate the price."
"Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or even free."
"The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
"The pricing for this solution is very reasonable compared to other vendors."
"The price of Vertica is less expensive than some competitors, such as Teradata."
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
"The solution is relatively cost-effective."
report
Use our free recommendation engine to learn which NoSQL Databases solutions are best for your needs.
816,406 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
17%
Computer Software Company
14%
Manufacturing Company
7%
University
6%
Computer Software Company
18%
Financial Services Firm
18%
Manufacturing Company
8%
University
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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?
MongoDB is free of charge. that said, there is also a paid version. We use both free and paid versions.
What needs improvement with MongoDB?
The free tools, like MongoDB Compass, could be enhanced. This is especially relevant for the IDEs or similar tools.
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 compete with other databases.
 

Comparisons

 

Also Known As

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

Learn More

 

Overview

 

Sample Customers

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 vs. Vertica and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.