How do you model time-series data in a database? What design patterns and considerations apply?

Sample answer preview

Time-series data consists of measurements collected at regular or irregular intervals over time. Examples include sensor readings, stock prices, web traffic metrics, and system logs.