title: Storing and analysis of historical data - What kind of Database?
body: <p>I'm currently designing a system that watches the ranks / views of youtube videos. of LOTS of youtube videos (> 500.000 and growing) on a daily basis.</p>
  
  <p>I'm currently considering storing this in a MySQL database, but what disturbs me, is that the table would grow into billions and trillions of rows, which I don't think would perform well.</p>
  
  <p>I need to analyse this data, for example:</p>
  
  <ul>
  <li>Which videos grew a lot in the time between X and Y</li>
  <li>Plot the clicks per day</li>
  <li>Plot the clicks per week ...</li>
  <li>some more things I don't know yet about</li>
  </ul>
  
  <p>So, what came into my web 2.0 mind was, is there a way a NoSQL database could handle this better? I didn't quite learn these (almost) new databases and don't know what they are capable of.</p>
  
  <p>What would your advice be, what type of database to use?
  Relational or not? If not, which NoSQL database?</p>
  
  <p>PS: first priority is the fast evaluation and insertion of the results, second is high availability (or just replication)</p>