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

Microsoft Azure Cosmos DB vs Pinecone comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Sep 29, 2024
 

Categories and Ranking

Microsoft Azure Cosmos DB
Ranking in Vector Databases
5th
Average Rating
8.2
Reviews Sentiment
7.3
Number of Reviews
75
Ranking in other categories
Database as a Service (DBaaS) (6th), NoSQL Databases (3rd), Managed NoSQL Databases (1st)
Pinecone
Ranking in Vector Databases
6th
Average Rating
8.0
Number of Reviews
6
Ranking in other categories
No ranking in other categories
 

Featured Reviews

Michael Calvin - PeerSpot reviewer
Easy to integrate, has a shallow learning curve, and scales dynamically
Azure Cosmos DB is quick to adopt with a shallow learning curve. The average user can be operational within hours or days, handling small to medium data volumes. However, optimizing for ultra-high throughput scenarios involves a steeper learning curve, requiring substantial knowledge to master Azure Cosmos DB. Nonetheless, most users can leverage it as their operational data store with minimal effort. Our platform boasts several extensive language model features, particularly around summarization capabilities. We use vector searching in Azure Cosmos DB to facilitate the retrieval of an augmented generation model with our LLM implementation. It's a standard RAG implementation using Azure Cosmos DB. Compared to other options, a key advantage of vector indexing in Azure Cosmos DB is the ability to query documents alongside vectors. This pinpoints the precise information required for RAG in our LLM solution, granting us greater flexibility than vector searching in other Azure services. We integrated the vector database with the Azure OpenAI service for our LLM solution. The Azure AI services were simple to integrate with the vector database. There was a slight learning curve, especially as we were on the private preview of vector searching. This led to some hiccups with our existing database configurations, specifically regarding continuous backup. We couldn't enable continuous backup and vector searching simultaneously. However, this was solely due to our participation in the preview, and I'm confident this issue won't persist in the general availability release. Azure Cosmos DB is fantastic for searching large amounts of data when the data is within a single partition. Over the last two weekends, we ingested over 400 gigabytes of data into our Azure Cosmos DB database and saw no change in querying performance compared to when our database was only 20 gigabytes in size. This is impressive and powerful, but the scope is limited to those partition queries. The first benefit we've seen is increased developer productivity. Azure Cosmos DB is an easy database to work with. Its schema-less nature allows us to iterate quickly on our platform, develop new features, and store the associated data in Azure. Developers find it easy to use, eliminating the need for object-relational mapping tools and other overhead. Geographic replication and the ability to scale geographically is another advantage. This is challenging with other databases, even other NoSQL databases, but Azure Cosmos DB makes it easy. Cost optimization is a major benefit as well. We've been able to run our platform at a fraction of the infrastructure cost our customers incur when integrating with us. This allows us to focus resources on feature development and platform building rather than infrastructure maintenance. Azure Cosmos DB helped reduce the total cost of ownership. We don't need DBAs, system administrators, or typical IT staff to run the infrastructure because we can use Azure Cosmos DB as a platform or a software-as-a-service data storage solution. This makes the total cost of ownership significantly lower than any comparable solution using relational databases or other NoSQL solutions like MongoDB. We enable auto-scaling on all of our Azure Cosmos DB resources, which helps us achieve cost optimizations.
Aakash Kushwaha - PeerSpot reviewer
Helps retrieve data, relatively cheaper, and provides useful documentation
Suppose I want to delete a vector from Pinecone or a multi-vector from a single document. Pinecone does not provide feedback on whether a document is deleted or not. In SQL and NoSQL databases, if we delete something, we get a response that it is deleted. The tool does not confirm whether a file is deleted or not. I have raised the issue with support. If we have 10,000 vectors in our index and do not use a metadata tag, it will take one to three seconds to complete a search. When I try to search using a metadata tag, the speed is still the same. The search speed must be much faster because I specify which vectors I need the data from.

Quotes from Members

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

Pros

"Cosmos DB is stable and easy to use."
"Cosmos DB makes life easier because if we want to use Mongo-type data, or Cassandra-type data, or maybe even just a simple cable storage-type data, then graph, there are multiple ways to do this."
"We love the ability to land data with Cosmos DB easily. Cosmos is native to Azure, so everything works seamlessly with it. You need good data to have good AI, and Cosmos makes it easy to land the data."
"We have both our SaaS app and the analytical side running without throttling issues."
"The most valuable aspect of Cosmos DB is its performance."
"Scaling the workloads is one of the key advantages of Cosmos, preventing the database from becoming a performance bottleneck."
"The availability and latency of Azure Cosmos DB are excellent."
"The biggest benefit it offers is scalability. It's easier to work with concurrency and updating data."
"The most valuable features of the solution are similarity search and maximal marginal relevance search for retrieval purposes."
"The semantic search capability is very good."
"We chose Pinecone because it covers most of the use cases."
"The best thing about Pinecone is its private local host feature. It displays all the maintenance parameters and lets us view the data sent to the database. We can also see the status of the CD and which application it corresponds to."
"The most valuable feature of Pinecone is its managed service aspect. There are many vector databases available, but Pinecone stands out in the market. It is very flexible, allowing us to input any kind of data dimensions into the platform. This makes it easy to use for both technical and non-technical users."
"The product's setup phase was easy."
 

Cons

"Azure Cosmos DB for NoSQL has a less developed interface and fewer SQL commands than MongoDB, and its community support is also smaller."
"The size of the continuation token in Azure Cosmos DB should be static rather than increasing with more data, as it can lead to application crashes."
"I have to say technical support is not very good as it takes too long. Sometimes it can take them two or three days to respond to your ticket."
"The one thing that I have been working on with Microsoft with regard to this is the ability to easily split partitions and have it do high-performance cross-partition queries. That is the only place where either our data size or our throughput has grown beyond one partition, so being able to do cross-partition queries efficiently would be my number one request."
"There are no specific areas I believe need improvement as I am happy with what I am getting currently. However, I am open to new features in future versions, like possibly integrating AI features natively into Cosmos DB. Any improvement would be beneficial."
"The biggest problem is the learning curve and other database services like RDS."
"Cosmos DB is expensive, and the RU-based pricing model is confusing."
"A further simple application is required for Brazil."
"For testing purposes, the product should offer support locally as it is one area where the tool has shortcomings."
"Pinecone can be made more budget-friendly."
"I want to suggest that Pinecone requires a login and API key, but I would prefer not to have a login system and to use the environment directly."
"The product fails to offer a serverless type of storage capacity."
"The tool does not confirm whether a file is deleted or not."
"Onboarding could be better and smoother."
 

Pricing and Cost Advice

"Right now, I have opted for the student subscription plan, for which Microsoft charges me around 100 USD. The pricing of the solution depends on the solution's usage."
"The tool is not expensive."
"When we've budgeted for our resources, it's one of the more expensive ones, but it's still not very expensive per month."
"It is cost-effective. They offer two pricing models. One is the serverless model and the other one is the vCore model that allows provisioning the resources as necessary. For our pilot projects, we can utilize the serverless model, monitor the usage, and adjust resources as needed."
"The solution is very expensive."
"From a startup point of view, it appears to be expensive. If I were to create my startup, it would not have the pricing appeal compared to the competition, such as Supabase. All those other databases are well-advertised by communities. I know there is a free tier with Azure Cosmos DB. It is just not well advertised."
"Microsoft Azure Cosmos DB's licensing costs are monthly."
"Cosmos should be cheaper. We actually intend to stop using it in the near future because the price is too high."
"Pinecone is not cheap; it's actually quite expensive. We find that using Pinecone can raise our budget significantly. On the other hand, using open-source options is more budget-friendly."
"I think Pinecone is cheaper to use than other options I've explored. However, I also remember that they offer a paid version."
"I have experience with the tool's free version."
"The solution is relatively cheaper than other vector DBs in the market."
report
Use our free recommendation engine to learn which Vector Databases solutions are best for your needs.
823,875 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
14%
Comms Service Provider
12%
Financial Services Firm
11%
Retailer
6%
Computer Software Company
17%
Financial Services Firm
10%
Educational Organization
8%
Comms Service Provider
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about Microsoft Azure Cosmos DB?
The initial setup is simple and straightforward. You can set up a Cosmos DB in a day, even configuring things like availability zones around the world.
What is your experience regarding pricing and costs for Microsoft Azure Cosmos DB?
The solution was a new product, so we didn't have a cost of ownership before. The cost has not surprised us. It's not been an issue. If we were doing multi-master replication globally, the cost wou...
What needs improvement with Microsoft Azure Cosmos DB?
Using it is easy. We are having trouble optimizing it. I'm not a technical person, so I couldn't explain why, but we're not getting the performance we were expecting. I'm sure it's probably an us p...
What do you like most about Pinecone?
We chose Pinecone because it covers most of the use cases.
What needs improvement with Pinecone?
I want to suggest that Pinecone requires a login and API key, but I would prefer not to have a login system and to use the environment directly.
What is your primary use case for Pinecone?
I've used Pinecone to streamline token generation for my chatbot's functionality. Specifically, I used it for the OpenNeeam Building.
 

Also Known As

Microsoft Azure DocumentDB, MS Azure Cosmos DB
No data available
 

Overview

 

Sample Customers

TomTom, KPMG Australia, Bosch, ASOS, Mercedes Benz, NBA, Zero Friction, Nederlandse Spoorwegen, Kinectify
1. Airbnb 2. DoorDash 3. Instacart 4. Lyft 5. Pinterest 6. Reddit 7. Slack 8. Snapchat 9. Spotify 10. TikTok 11. Twitter 12. Uber 13. Zoom 14. Adobe 15. Amazon 16. Apple 17. Facebook 18. Google 19. IBM 20. Microsoft 21. Netflix 22. Salesforce 23. Shopify 24. Square 25. Tesla 26. TikTok 27. Twitch 28. Uber Eats 29. WhatsApp 30. Yelp 31. Zillow 32. Zynga
Find out what your peers are saying about Microsoft Azure Cosmos DB vs. Pinecone and other solutions. Updated: October 2024.
823,875 professionals have used our research since 2012.