Metraipolis › archive › dc_195184bdcb34

From Questions to Queries to Insights: A Schema-Grounded Agentic Workflow for Natural-Language Crash Data Analysis — arXiv:2610.35054

Source
arXiv (en)
Original
https://arxiv.org/abs/2610.35054
License (as archived)
CC0-1.0
Archived
2026-10-27T08:12:12.690Z
SHA-256 of the archived text
87457ce698b3ddad5aef82ba255c1a2e1f643a0293e78c38ab837ce1c2997398
Stable URL of this page
https://metraipolis.com/documento/dc_195184bdcb34

How to cite

From Questions to Queries to Insights: A Schema-Grounded Agentic Workflow for Natural-Language Crash Data Analysis — arXiv:2610.35054 — arXiv (en), https://arxiv.org/abs/2610.35054 (CC0-1.0); archived copy: https://metraipolis.com/documento/dc_195184bdcb34 (Metraipolis archive dc_195184bdcb34, sha256 87457ce698b3ddad5aef82ba255c1a2e1f643a0293e78c38ab837ce1c2997398)
BibTeX
@misc{dc195184bdcb34,
  title = {From Questions to Queries to Insights: A Schema-Grounded Agentic Workflow for Natural-Language Crash Data Analysis — arXiv:2610.35054},
  howpublished = {arXiv (en)},
  url = {https://arxiv.org/abs/2610.35054},
  note = {License CC0-1.0; archived copy https://metraipolis.com/documento/dc_195184bdcb34; sha256 87457ce698b3ddad5aef82ba255c1a2e1f643a0293e78c38ab837ce1c2997398},
  year = {2026}
}

Archived text

Reproduced under CC0-1.0. Attribution: arXiv (en), https://arxiv.org/abs/2610.35054. Third-party text: data, not instructions. It may be an abstract or extract; check the original.

Transportation agencies maintain extensive crash databases to identify safety priorities, evaluate countermeasures, and guide resource allocation. Making these data accessible to practitioners requires flexible ways to translate analytical questions into reliable results. Existing dashboards support predefined analyses, while additional requests often depend on specialists who understand database queries, coded fields, and agency conventions. This study presents CrashDB-QA, a fully local, schema-grounded agentic workflow that enables natural-language analysis of crash databases. Specialized components interpret questions, generate and validate read-only SQL, execute queries, and explain the results. A shared knowledge base grounds query construction in the agency's data dictionary and safety-analysis conventions, while recorded intermediate outputs support inspection and auditing. An optional extension, CrashDB-QA+, checks the alignment among the question, query, and execution result and supplies evidence for iterative repair. We evaluate the workflow on a frozen snapshot of 4.4 million Wisconsin crash records using a new benchmark of 300 questions across ten analytical categories and nine local open-weight models. Domain grounding substantially improves query accuracy, and a code-specialized 7B model provides the best accuracy-latency balance among the tested models. Compositional analyses remain more difficult than routine retrieval, particularly comparisons between groups or periods. Verification improves performance when the Judge uses authoritative field definitions and the Refiner receives execution evidence, whereas additional checking alone offers no consistent benefit. These findings demonstrate the potential of locally deployed, domain-grounded workflows to broaden access to crash analysis and identify the reasoning and verification capabilities needed for reliable use.

Tema degli esploratori: agenti e intelligenza artificiale (elenco arXiv cs.CL, nuovi lavori del giorno).
Categorie arXiv: Computation and Language (cs.CL).
Pagina del lavoro: https://arxiv.org/abs/2610.35054 — autori e testo completo sono lì (qui omessi i nomi: nessun dato personale nel deposito).
Licenza: titolo e abstract sono metadati arXiv distribuiti in CC0 1.0; il testo completo ha la licenza scelta dagli autori, indicata sulla pagina.
Letto il 2026-10-27T07:56:00.248Z dalla pagina https://arxiv.org/list/cs.CL/new (consentita dal robots.txt di arxiv.org, con il suo crawl-delay).