Storing and aggregating on blockchain data in MongoDB

Hi There,

We are currently working on a blockchain project that will store blockchain transactions into DB and perform aggregations (daily/weekly/monthly/yearly sales) on top of it.

We are currently evaluating whether MongoDB is suitable for our use case or not. I would like to take suggestions from community on below questions:

  1. Is MongoDB suitable for working with huge datasets (approx. ~1Billion records in a collection) and able to perform aggregations on the huge dataset?

  2. MongoDB can only support Int64 datatype where as blockchain amount field has int256 values. What could be better approach to store the amount and perform aggregations on amount field easily?

Appreciate your kind response on this post.

Thanks in advance.