I want to build a system similar to Google Analytics (only used for internal use, less traffic and less feature), and mainly focus on
Real time counting of unique URI visit/PV by different dimensions of user demographic information, e.g. User Agent, OS, Country etc
Real time calculation of average user session length (if the different between two request from the same IP is less than 1 minute)
Are there any good database store enable this kind of query in real time?
p.s. I am currently testing InfiDB.