title: Recommendation for a large-scale data warehousing system
body: <p>I have a large amount of data I need to store, and be able to generate reports on - each one representing an event on a website (we're talking over 50 per second, so clearly older data will need to be aggregated).</p>
  
  <p>I'm evaluating approaches to implementing this, obviously it needs to be reliable, and should be as easy to scale as possible.  It should also be possible to generate reports from the data in a flexible and efficient way.</p>
  
  <p>I'm hoping that some SOers have experience of such software and can make a recommendation, and/or point out the pitfalls.</p>
  
  <p>Ideally I'd like to deploy this on EC2.</p>