normalizing spatial-temporal database?
June 2, 2011 10:23 AM Subscribe
Relational database normalization of spatio-temporal data?
I am looking at relational database design, but can not find a certain type of what is likely a less common problem. Maybe I am just not using the right language in my searches.
Say you have many points in space that have several attributes that change as a function of time. For example monitoring stations that take a temperature, humidity, and pressure sample every 60 seconds. Rather than having a table for each of these three attributes (with rows for the points and columns for each time step), what is a more optimized (normalized) solution? Are there several ways to do this?
If anyone has any short answers or references to tutorials (examples in MS Access would be best) I would much appreciate it!