A system and method includes a data sensor providing sensor data. A database is configured to store the sensor data over time in rows of a table. A processor is configured to convert the table into a temporal format and collapse the rows in a temporal table. The temporal data can be normalized, and the normalized temporal data can be natively analyzed over normalized time periods, e.g., to improve an efficiency and/or accuracy of the analysis. The systems and methods can also be used to efficiently inter-operate with non-temporal data as needed.