Monetdb in the cloud, scalability, amazon s3

Question

I recently opened MonetDB, and I am evaluating it for an internal project, so probably my questions are really newbies. Perhaps someone can point me to a website and / or document where I could find more information (I have not found too much googling)

regarding scalability, please correct me, if I am mistaken, but I understand that if I need to scale, I would run more server instances and find them from the node control, right? Is there a limit on the number of servers?

otherwise, it is about storage, is it possible to use Amazon S3 to return to read-only MonetDB instances?

update we will need to store a huge number of records of detailed information about calls from different sources, read-only. We collected / shortened this data for daily work, gaining access to large tables only when a complete part is required. We would also store historical data for long-term analysis. My main concern is memory, disk storage will not be the problem I think of; if the hot dataset participating in the report / analysis consumes all the memory space (requires a fast response time, and not sure how the memory exchange will affect), I would like to know if I can scale somehow and not rewrite the report process / analysis (maybe I'm inclined to scale horizontally :-))

thanks!

Answer 1

You can easily find the advantages of monetdb on the net, so let me highlight some of the disadvantages
1. In monetdb, deleting rows does not free up space Solution: copy the data to another table, cancel the existing table and rename another table
2. Joins are a little slower 3. We cannot specify a table name as a dynamic variable
For example: if you have a table name stored in one main table, you cannot make a query like "for each (select tablename from mytable) select data from tablename)" sql You cannot create functions with the table name as a variable argument.

But he is still cursed quickly and can store a large amount of data.