Modeling Sensor Data and the Limit of 1600 columns
What's your suggestion on the schema required for storing Sensor data? Say we have 5000 sensors, and all of them send data each 5 minutes. One approach is simply store data in a table with time_id, sensor_id and sensor_value columns. However, some queries such as those required for correlation analysis gets challenging. The desired structure for such queries is to have one column in the table per sensor, but then we have the limit of 1600 columns.