OT: How to efficiently track and log activities in LMCE house ?

[bulek]

Hi,

since my research interest is ambiental intelligence, I'd like to use my new home powered by LMCE also for research work. I'd like to track all activities in house, log them and possibly explore them later for datamining, learning and graphical visualization purposes...

I'll make logs of all activities in mysql database, will also log certain informations (temperatures,etc..).

For a start, I'm looking for tools that would ease visualization of gathered data in some sort of different sorts of views (something similar to KMotion that represents motion events in calendar view).... I'm using RRD, but that is round robin type of database and is not meant for that kind of use...

I've found some starting info :
http://my.safaribooksonline.com/0596007221/smarthomehks-CHP-7-SECT-10
http://www.cg.tuwien.ac.at/~0025681/research.htm

I'm basically looking tools that would allow me to in the first phase:
- to present data in some visual manner (like calendar view)
- allow me to define different search/display criterias

Anyone spotted any free tool that would fit?

I'm currently thinking in more directions: Egroupware, maybe some interactive mysql visualization app, ....

Update: Have found something really interesting - wouldn't it be nice to have such insight into events &devices logs in LMCE home ?
http://simile.mit.edu/timeline/

Thanks in advance,

regards,

Bulek.

[hari]

such profiles would also be cool to analyze power consumption... I think i should get one of those Z-Wave plugs with integrated power meter :-)

best regards
Hari

[hari]

hehe, and we need those to train our new AI powered Scenari'O'Matic :-)

[bulek]

hehe, and we need those to train our new AI powered Scenari'O'Matic :-)

Is this one real ?

BTW, did manage to get TailDCERouter output to timeline (sort of), but now I cannot figure out how to parse TailDCERouter output (main problem is how to group lines to one event)....

Regards,

Bulek.