[isf-wifidog] question about stats

[Proulx François]

It's pretty simple, the data consists of users, connections and  
nodes. Since the database tables are fully normalized (3rd normal  
form), it's pretty straightfoward to mix the data.

Here are some of the data fields.
users data fields (interesting for stats) are : a unique user id  
(hash based), account status (validated, not validated, denied ... ),  
username
nodes data fields : node id, name, last heartime timestamp, creation  
date, longitude, latitude
connections : connection id (unique hash-based), node id, user id,  
start timestamp, end timestamp, incoming bytes, outgoing bytes

Of course, we store some more data for management purposes, but  
that's what might interested researchers.

Feel free to ask more questions about it ...

On 14-Nov-2005, at 1:01 , Michael Lenczner wrote:

> can someone give me some information on how our data is stored?
>
> I'm trying to talk to some researchers to get them to analyze our data
> over the last 2 1/2 years.  But they want to "see a sample of our
> data".  I asked some of the developpers this individually and was told
> that the question was too vague.  Can someone explain to me what is
> too vague about it?  I would like to do  (ie research our data and
> write a paper or three) about this eventually - instead of sit on all
> these great statistics.
>
> sincerely,
> Mike
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog