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

Amazon Timestream vs Microsoft Azure Cosmos DB comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Sep 29, 2024
 

Categories and Ranking

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

Mindshare comparison

As of December 2024, in the Managed NoSQL Databases category, the mindshare of Amazon Timestream is 11.2%, up from 9.8% compared to the previous year. The mindshare of Microsoft Azure Cosmos DB is 17.8%, down from 19.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Managed NoSQL Databases
 

Featured Reviews

Sushil Pandey - PeerSpot reviewer
It is helpful to get telemetry data from the devices in real-time
It is an easily scalable solution. When it comes to the retention period, if someone wants to change, they have to define it at the start. Later on, if users want to change it again, like, or increase the retention policy, then they have to create the table again and do so, and if it is not done, then we face problems. It will increase the retention, but when you try to insert a record or an older record that is not included in the range of your retention period, then you can face some problems and, like, it will throw some errors. The tool is scalable, but it should be defined at the start as to how much retention you want. For scalability, I rate the tool a six or seven out of ten.
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.

Quotes from Members

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

Pros

"What I like best is that the tool is easy to collect and store data and is fast and scalable. The fully managed database is easy to understand."
"If you drop a message, the solution's technical support will definitely reply."
"The best things about Amazon Timestream are it's maintenance-free, customizable, and has no lag issues. It's always real-time."
"You can quickly aggregate data from the last ten years with Amazon Timestream."
"Using Amazon Timestream has been seamless due to its integration within the AWS ecosystem and ease of use for the engineering team."
"It's highly scalable and supports consistency, security, and multiple security options."
"Cosmos DB is a document database that stores data in JSON format for faster retrieval of unstructured data. I personally appreciate the speed, which is significantly better for unstructured data, especially since Cosmos DB had JSON as a data type early on."
"We have both our SaaS app and the analytical side running without throttling issues."
"The most valuable features include the global write capability, which allows customers to read and write across different regions simultaneously, enhancing performance and availability."
"As a NoSQL database, it offers schema flexibility which simplifies design and reduces initial engineering overhead."
"Cosmos DB is effective at handling large queries."
"Microsoft Azure Cosmos DB is fast, and its performance is good compared to normal SQL DB."
"The graphical representation of data is the most valuable feature of the solution."
 

Cons

"The tool could be improved by increasing the batch size from one hundred records to five hundred or a thousand to speed up indexing."
"There are disadvantages when it comes to time series databases since you can't delete anything from Amazon Timestream data."
"The solution could be improved by making it easier for new graduates like me to use. Better explanations of queries and how to use them with other AWS services would help."
"Arranging the database schema is a bit challenging."
"There are certain features that we would like to see added and we are collaborating with the product teams on these areas."
"One of our biggest pain points is the backup and restore functionality needs improvement. They've gotten a little better in this area. SQL Server's long-term retention is amazing, and you can restore data from years ago. You need to open a support Microsoft ticket to restore your Cosmos DB backup, and it comes in on a different Cosmos account. It's just kind of a headache to restore data."
"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. They should use a static key size."
"I hope they improve the service. Before last year, improvements on Cosmos DB were very slow."
"An improvement could include increasing the document size or providing a method to manage larger sets efficiently. If they want to keep a 2 MB limit, they should provide a way to chain multiple documents in a systematic way so that developers do not have to figure out what to do when a document is larger than 2 MB."
"The tool's pricing is expensive."
"The query is a little complex. SQL server should have more options. But the query should be better."
"The biggest problem is the learning curve and other database services like RDS."
"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."
 

Pricing and Cost Advice

"We pay over $10 million a year to Amazon."
"Amazon Timestream's pricing seems manageable to me."
"For 1GB of data, the solution charges $ 0.01 in the US region."
"We don't see high costs with Amazon Timestream, which may vary by company."
"The price of Microsoft Azure Cosmos DB could be a bit lower."
"Pricing is mid- to high-end."
"The licensing is a mess and needs sorting out. I am not really concerned about the pricing because I only make recommendations, not buying decisions."
"Microsoft Azure Cosmos DB is moderately priced, where it is neither expensive nor cheap."
"Its price is very good for the basic stuff. When you go to a more complicated use case, especially when you need replication and availability zones, it gets a little costly."
"The cost is the biggest limitation of this solution."
"The RU's use case determines our license fees."
"Cosmos DB is a highly cost-optimized solution when used correctly."
report
Use our free recommendation engine to learn which Managed NoSQL Databases solutions are best for your needs.
824,168 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
22%
Financial Services Firm
13%
Manufacturing Company
9%
Construction Company
7%
Computer Software Company
14%
Comms Service Provider
12%
Financial Services Firm
11%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What needs improvement with Amazon Timestream?
We are working on a few open change requests with the engineering teams on AWS's side. There are certain features that we would like to see added and we are collaborating with the product teams on ...
What is your primary use case for Amazon Timestream?
We use Amazon Timestream as a data historian for IT data. It stores all individual measurements of our customers' IoT devices for a certain period of time, allowing them to perform time-series-base...
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...
 

Also Known As

No data available
Microsoft Azure DocumentDB, MS Azure Cosmos DB
 

Overview

 

Sample Customers

Expedia, Intuit, Royal Dutch Shell, Brooks Brothers
TomTom, KPMG Australia, Bosch, ASOS, Mercedes Benz, NBA, Zero Friction, Nederlandse Spoorwegen, Kinectify
Find out what your peers are saying about Amazon Timestream vs. Microsoft Azure Cosmos DB and other solutions. Updated: December 2024.
824,168 professionals have used our research since 2012.