16 October 2026 in bioRxiv
Passive acoustic monitoring often summarizes long recordings as fixed-window presence predictions, but many ecological questions require records of individual vocal events: how many occurred, when they occurred, whether they overlapped, how long they lasted, what frequency band they occupied, and whether each event was complete enough for structural measurement. We address this event-level measurement problem with SpectroBird, a spectrogram-based method for localizing and curating avian vocalizations in noisy field recordings. SpectroBird first applies a detection-localization model to identify candidate vocalizations as time-frequency boxes. An event-consolidation step merges repeated detections from overlapping windows while preserving overlapping vocalizations as separate events. A completeness-curation model then classifies each consolidated event as complete or incomplete before downstream event-level analysis. We demonstrate SpectroBird on breeding-season Hume’s Leaf Warbler buzz vocalizations recorded in the Himalaya across a 3,200–3,800 m elevational gradient. Under shared window-level scoring, the detection-localization model remained competitive with AST and YOLOv11-cls baselines while retaining event timing and frequency bounds; event-level evaluation achieved AP > 0.999 for complete buzzes. Applied to two field seasons, the resulting event records showed that duration of complete buzzes declined with elevation, complete-buzz occurrence showed no simple elevation trend, and relative day-of-year occurrence patterns were strongly correlated between years. These results show how event-level detection and curation can support ecological analyses that depend on individual vocalizations rather than fixed-window presence alone.
2 April 2026 in Proceedings of the ACM on Management of Data
Large language models (LLMs) have achieved strong performance on natural language to SQL (NL2SQL) tasks, but their practical effectiveness depends on tuning a complex pipeline of interacting components. Real-world deployments must navigate a critical trade-off between execution accuracy and monetary cost, a factor that has been largely overlooked by prior work focused primarily on maximizing accuracy. Navigating this trade-off is non-trivial: the ideal configuration of components (e.g., LLM, prompting strategy, schema linking) is not only interdependent but also highly sensitive to the target database schema. This creates a challenging, schema-aware configuration tuning problem that lacks a systematic solution. We present PRISM, a framework that systematically identifies high-accuracy, cost-efficient NL2SQL configurations tailored to each schema. Adopting an optimize-then-deploy strategy, PRISM first uses cost-aware Bayesian Optimization in an offline phase to efficiently explore the configuration space and curate a pool of high-performing pipelines. In an online phase, it deploys these configurations either as a single, cost-effective candidate or as an ensemble to maximize accuracy. Experiments on the BIRD benchmark demonstrate that PRISM achieves 69.48% execution accuracy in the single-candidate setting, improving accuracy by 2.34% over the strongest baseline while reducing cost by 92%. In the ensemble setting, PRISM boosts accuracy further to 74.9%.