System and method for storage and analysis of time-based data

A computer-implemented method of sensor data normalization, the computer-implemented method comprising:

• receiving a plurality of rows containing sensor data, the sensor data including a vehicle identification, a sensor identification, a time offset, and a sensor value, wherein the time offset represents a point in time;
• converting the plurality of rows into a temporal format by operation of one or more computer processors, by joining each row in the plurality of records with a respective, subsequent row having matching vehicle and sensor identifications and a next chronological time offset, wherein the converted plurality of rows is sorted chronologically based on a timespan of the joined rows, the timespan defined to contain the points in time represented by the time offsets of the rows being joined;
• and
• collapsing, in the sorted plurality of rows, consecutive rows having matching vehicle and sensor identifications but differing timespans into a single row having a containing timespan defined to contain the differing timespans, whereafter the sorted plurality of rows is output as normalized rows.

A non-transitory computer-readable medium containing instructions executable to perform an operation of sensor data normalization, the operation comprising:

• receiving a plurality of rows containing sensor data, the sensor data including a vehicle identification, a sensor identification, a time offset, and a sensor value, wherein the time offset represents a point in time;
• converting the plurality of rows into a temporal format by operation of one or more computer processors when executing the instructions, by joining each row in the plurality of records with a respective, subsequent row having matching vehicle and sensor identifications and a next chronological time offset, wherein the converted plurality of rows is sorted chronologically based on a timespan of the joined rows, the timespan defined to contain the points in time represented by the time offsets of the rows being joined;
• and
• collapsing, in the sorted plurality of rows, consecutive rows having matching vehicle and sensor identifications but differing timespans into a single row having a containing timespan defined to contain the differing timespans, whereafter the sorted plurality of rows is output as normalized rows.

A system of sensor data normalization, the system comprising:

• one or more computer processors;
• a memory containing a program executable by the one or more computer processors to perform an operation comprising:
• receiving a plurality of rows containing sensor data, the sensor data including a vehicle identification, a sensor identification, a time offset, and a sensor value, wherein the time offset represents a point in time;
• converting the plurality of rows into a temporal format, by joining each row in the plurality of records with a respective, subsequent row having matching vehicle and sensor identifications and a next chronological time offset, wherein the converted plurality of rows is sorted chronologically based on a timespan of the joined rows, the timespan defined to contain the points in time represented by the time offsets of the rows being joined;
• and
• collapsing, in the sorted plurality of rows, consecutive rows having matching vehicle and sensor identifications but differing timespans into a single row having a containing timespan defined to contain the differing timespans, whereafter the sorted plurality of rows is output as normalized rows.