Jump to content

The ultimate community for Ruby on Rails developers.


Photo

How to design DB for statistics service?

database-design

  • Please log in to reply
No replies to this topic

#1 mphilippov

mphilippov

    Passenger

  • Members
  • 1 posts

Posted 17 September 2013 - 03:00 PM

I'm going to create statistics on RoR. I have 3 models: User, Project and Channel. User owns Projects, whereas Projects have many Channels. Now I'm designing all these models using MySQL.

The goal of the service is to provide user the variation in time of different parameters of each Channel. E.g.: Channel Google Adwords has 1000 show/day, 100 clicks/day and 2 people which came from Google Adwords bought something that day. So I could have just stored all the information in columns, like: Channel "Google Adwords", shows: 1000, clicks: 100, buyings: 2. But I need to make distribution by days, please, give me an advice how to design such database? Maybe I should use another solution, maybe NoSQL?






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users