QuestionQ57

VerifiedPlanning and implementing a cloud solution

The core business of your company is to rent out construction equipment at large scale. All the equipment that is being rented out has been equipped with multiple sensors that send event information every few seconds. These signals can vary from engine status, distance traveled, fuel level, and more. Customers are billed based on the consumption monitored by these sensors. You expect high throughput – up to thousands of events per hour per device – and need to retrieve consistent data based on the time of the event. Storing and retrieving individual signals should be atomic. What should you do?

Explanation

Bigtable is purpose-built for high-throughput, time-series data with atomic read/write semantics. Row keys based on event timestamps enable efficient retrieval of data within specific time windows. In practice, prefix the timestamp with the device ID (for example device#timestamp) to avoid hotspotting while still allowing time-range scans per device. Cloud Storage, Filestore, and Cloud SQL cannot match Bigtable's throughput requirements (thousands of events per hour per device) or provide the same atomic operation guarantees.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!