statistical analysis alfresco and docs

[jpsegret]

Hello everybody, this is my first post in this forum  as  a newbie of alfresco. Foremost excuse me if this post is misplaced

I post today, so you can help me in my development .
Well i had to developp a small statistical tools ( i thought of a php page)  about the use of the GED:

- Number of doc everywhere
- Increase of the this number on a period
-Number of download group by documents/user
…

I 've been thinking to do some MySQL queries to have access to these parameter and then to mannipulate them by graphical PhP library  ( jpGraph)

However as a new member of the alfresco world lol, i tried to study the different table and database on my server Mysql but its some "chinese talk" for me i don't see the parameters which i need.

I would need your help in my project, please.

Thanks

[jayjayecl]

As a common piece of advice : don't try to query Alfresco DB entries.

I had quite the same functionnality to implement, and I decided to create a custom aspect (search alfresco wiki for "content modelling" or "custom aspects" ) that would store, for each space,
- the number of content items as its direct children
- the total amount of content items as its children (direct children and children of its subspaces and so on …)
- the number of subspaces as its direct children
- the total amount of subspaces
- the memory size