title: What is the best way to store and export click stream data in almost real time
body: <p>Let us say I have a website which is getting lots of hits. I need to store the click data in some database so that it can be used for reporting and monitoring purposes. The click data will contain information like who is referring the users to this site, where users are coming from, what time do they come etc. 
  Is there a way to store and then analyze this data in lets say 10 minute intervals so that you can get an overview of how the site is performing every 10 minutes. What type of database will be best suited for this purpose and what kind of analyzing tools can quickly generate meaningful information from this data. One option for analysis I am thinking of is using some variation of map-reduce to run the queries on this data.</p>