> I think you underestimate the complexity of a database that grows by 20 million records per month
Why does it need to grow per month? Create a new database each month and archive.
> So what, they should all hire data analysts? To understand their Spotify invoice??
There must be some misunderstanding here. The customer's invoice is for $10 per month regardless of invoice complexity. The record of accounting that goes to the artists is what's being discussed.
It seems very simple to provide a database to artists, then also provide an open source database analyzer that will verify your pay check is accurate.
Why does it need to grow per month? Create a new database each month and archive.
> So what, they should all hire data analysts? To understand their Spotify invoice??
There must be some misunderstanding here. The customer's invoice is for $10 per month regardless of invoice complexity. The record of accounting that goes to the artists is what's being discussed.
It seems very simple to provide a database to artists, then also provide an open source database analyzer that will verify your pay check is accurate.