Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureMedium
A global logistics company wants to track the location of its 50,000 delivery vehicles in real-time. They need to store this location data, which includes latitude, longitude, speed, and timestamp, for up to one year for historical analysis and route optimization. The data arrives continuously at a high velocity. Which type of database is MOST suitable for this scenario?
- ARelational database
- BTime-series database
- CDocument database
- DKey-value store
Show answer & explanationAnswer & explanation
Correct answer: B. Time-series database
Time-series databases are optimized for storing and querying data points that are indexed by time, making them ideal for high-velocity, continuous data streams like vehicle telemetry. They efficiently handle large volumes of time-stamped data and enable fast analytical queries over time ranges.
Why the other options are wrong
- A. Relational databases can store time-series data but typically struggle with the high ingest rates and query performance for large volumes of time-indexed data compared to specialized time-series solutions.
- C. Document databases handle semi-structured data well but are not specialized for the time-indexed, high-volume, sequential nature of time-series data.
- D. Key-value stores are good for simple, fast lookups but not optimized for time-indexed data or complex analytical queries over time.
Time-Series Database
A database optimized for storing and retrieving data points that are indexed by time, making it ideal for monitoring, IoT, and analytics.
- Designed for high ingest rates of time-stamped data.
- Efficiently stores sequential data points over time.
- Optimized for time-based queries and aggregations.
Memory trick: Remember, if it's about 'when' events happen, time is key!