Hello,
I have a process that is logging data from vehicles. I'm looking for
thoughts on the pros and cons of different approaches to storing this data -
and retrieving it. Different vehicles report different types of data. The
current process stores the data in a multi-dimensional array.
eg, insert into logtable values ( 'vehicle123', now(),
{{'voltage','13'},{'rpm','600'}};
However, I am not sure how I can write a query - for example to read all
records where the voltage field is less than 13. Performance in this case is
not a real significant issue.
Would I be better off redesigning and having a master / detail kind of
structure? Where the master table would have the vehicle id, timestamp and a
key to the detail table. The detail table would then have the key, the type
of measurement and then the value.
I guess a third approach would be to just have the detail table with
duplication on the vehicle id and time - for each data type recorded.
Thanks,
Bryan.
