Team project · Java · JSP · Oracle · MyBatis · Vanilla JavaScript
2024.07 – 2025.06
KMA Road Weather Information System — build
Built road-weather aggregation batches and statistics screens full stack, improving SQL, service-layer responsibilities, and shared JSP structure.
Requirements · backend and frontend implementation · testing · release support
- Key outcomes
- Reduced an Oracle statistics query from 15–20 seconds to about one second
- Minute-level source data → 10-minute, hourly, and daily statistics
- Shared JSP table, chart, search, and date handling
- Vanilla JavaScript screen-state helper
- Upfront design
- Time-series aggregation — separate collection and reference times; explicit windows
- Service layer — centralized processing and separated layer responsibilities
- Screen state — one flow for search, reset, refetch, and chart updates
- Troubleshooting
- 15–20s query → execution-plan analysis and SQL restructuring → about 1s
- Method overloading and mixed responsibilities → service-layer restructuring
- Repeated screen handling → shared JSP structure and state helper



