CompTIA Data+ (DA0-002)Data Concepts and EnvironmentsMedium
A data engineer is designing a system to store streaming sensor data from thousands of IoT devices. Each device sends a timestamp, device ID, and several numerical readings (e.g., temperature, pressure) every few seconds. The primary access pattern will be querying data for a specific device over a time range, and performing aggregations over time. Which database type is MOST optimized for this use case?
- ARelational database
- BTime-series database
- CDocument database
- DGraph database
Show answer & explanationAnswer & explanation
Correct answer: B. Time-series database
Time-series databases are purpose-built for handling data points indexed by time, making them highly efficient for storing, retrieving, and performing aggregations on data from IoT devices over specific time ranges.
Why the other options are wrong
- A. While possible, relational databases are not optimized for the high ingest rates and time-range queries common with time-series data, leading to performance issues at scale.
- C. Document databases are flexible but not specifically optimized for time-indexed data or efficient time-range aggregations.
- D. Graph databases are used for highly interconnected data and relationships, not for sequential, time-stamped sensor readings.
Time-Series Database (TSDB)
A database optimized for storing and retrieving time-stamped data points, ideal for metrics, events, and sensor data.
- Optimized for time-indexed data
- High write throughput for sequential data
- Efficient time-range queries and aggregations
- Often includes data retention policies
Memory trick: Time-series is the T-rue S-olution for T-ime-stamped S-ensors.