Sample Header Ad - 728x90

Are there better alternatives to a time series databases for managing financial transactions?

2 votes
1 answer
133 views
We are considering using AWS Timestream to store financial transactions from various sources for users. Any solution needs to be able to support ~4k transactions per user per year for 1 million users. Some of the important requirements are: - Be able to update transaction amount for three months in the past - Calculate daily, weekly and monthly balances by tallying up amounts in real time - Balances need to reflect edited transaction amounts, so we'd need to recalculate these in real time often. Is a time series database a good fit for something like this in terms of real time AND historical record availability? A few things that worry me about timestream: - Can't delete records at all. If bad data enters your system, its going to be extremely difficult to clean it. - No backups offered by AWS, we'd have to write something custom for this. Are there perhaps better time series databases I should consider? Thanks!
Asked by Moin (21 rep)
Sep 2, 2022, 06:28 PM
Last activity: Sep 4, 2022, 09:40 PM