How Piwik manage its database?

Hi,

I would like to understand how Piwik summarize and archive visits…
I’m working on extracting data from piwik to summarize visit per categories and sub categories and more, but need to understand how piwik manage to archive some data… As far as can tell Piwik create two tables for each month… I don’t know what is the process behind that exactly.

Could someone explain it to me?
Thanks

Hi zzarbi,

maybe this can help a little:

http://dev.piwik.org/trac/wiki/DatabaseSchema

Kind regards
Michael