Data Management System Enhancements

[TeachMeTW]

The current data management looks like this:

Background

We have sensor data with time series readings (ts, device, co, humidity, light, lpg, motion, smoke, temp). The current UI and exploration capabilities don't effectively showcase this IoT data structure.

Current State

• Basic table view of sensor readings
• Limited to 100 records
• No time-based analysis
• No sensor-specific insights
• Confusing two-dropdown interface

Required Enhancements

1. Unified Interface Layout

• Convert to tabbed interface:
• "Overview Dashboard"
• "Detailed Data Explorer"
• "Upload New Data"

2. Overview Dashboard Features

• Latest readings per device
• Min/max/avg for each sensor type:
• Temperature ranges
• Humidity levels
• CO/LPG/Smoke readings
• Light levels
• Motion detection frequency
• Simple alerts for out-of-range values

3. Enhanced Data Explorer

• Time-based filtering
• Last hour/day/week view
• Custom date range selector
• Device-specific filtering
• Environmental metrics grouping:
• Temperature/Humidity together
• Gas readings (CO/LPG/Smoke) together
• Motion event timeline
• Proper pagination

4. Sensor-Specific Features

• Temperature & Humidity comfort zones
• Gas level safety thresholds
• Motion activity patterns
• Light level periods

Acceptance Criteria

1. New tabbed interface implemented
2. Overview dashboard shows key metrics
3. Time-based filtering works correctly
4. Device filtering implemented
5. Pagination allows viewing all records
6. Sensor readings have appropriate units displayed
7. UI updates smoothly on filter changes

Notes

• Focus on making sensor data easily interpretable (Most Important, remember our base)
• Consider color coding for different value ranges

Write UNIT TESTS