[isf-wifidog] question about stats
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.
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
More information about the WiFiDog