[isf-wifidog] question about stats

Proulx François fproulx at edito.qc.ca
Lun 14 Nov 07:55:44 EST 2005

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 ... ),  
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

More information about the WiFiDog mailing list