2

I am building a platform where users can rate a musicians song. I have been using AWS mobile which only builds in dynamodb but no relational databases.

I am just wondering whether is is possible to use a nosql database for the song rating purpose.

I can see that i would have a table for songs and for each song I could have a large number of votes but then how would I go about giving ownership of that vote to the user.

Thanks

Community
  • 1
  • 1
Nicholas Muir
  • 2,897
  • 8
  • 39
  • 89
  • please describe you queries you are going to use. specify your table (desired) scheme , etc.. – Eyal Ch May 17 '16 at 11:00
  • Hi @Eyal Ch, The schema I wrote out was for a relational database. Basically the most important queries would be for users (sum of ratings/number of ratings given). For the song it would be the same (sum of the ratings for song divided by the number number or ratings). I was thinking that I could have a ratings databse and use a lamda function once every couple of hours to update the overall rating. – Nicholas Muir May 17 '16 at 11:18
  • so something like: tbl_song (id, name, sum_rate, num_rate) ?? – Eyal Ch May 17 '16 at 12:01
  • Yep basically thats it – Nicholas Muir May 17 '16 at 12:17

0 Answers0