vendredi 6 mars 2015

Radio playlist airtime data in sql or nosql


Let say I have a website with a lot of radio playlist data. We store the name of songs being played on the radio. The database will have around 3 million rows (1 every 5 minutes for every radio station for years) and will keep growing.


So these are the characteristics:



  • Songs can have one or more titles

  • Songs can have one or more artists

  • Artists can have one or more names

  • Songs have multiple airtimes (played at x time on radio x)


The most queries are based on radio and time. E.g. get the last 50 songs played on radio x. Searching for all the airtimes of a given artist (or song) is also important.


I hope I don't get an answer with "it depends" ;-)





Aucun commentaire:

Enregistrer un commentaire