Saved in:
| Main Authors: | , , , , , , , , , |
|---|---|
| Format: | Preprint |
| Published: |
2025
|
| Subjects: | |
| Online Access: | https://arxiv.org/abs/2510.16388 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1866917024405389312 |
|---|---|
| author | Armenise, Doriana Battello, Ginevra Brunello, Andrea Driul, Lorenza Montanari, Angelo Rizzante, Elisa Saccomanno, Nicola Salvador, Andrea Xodo, Serena Zermano, Silvia |
| author_facet | Armenise, Doriana Battello, Ginevra Brunello, Andrea Driul, Lorenza Montanari, Angelo Rizzante, Elisa Saccomanno, Nicola Salvador, Andrea Xodo, Serena Zermano, Silvia |
| contents | The fragmentation of obstetric information across electronic health record modules, device repositories, and laboratory systems, as it is common in hospitals, hinders both intrapartum care and reproducible research. In this work, we present a practical blueprint for transforming heterogeneous peripartum records into computable, queryable assets by designing and prototyping a unified peripartum relational database with natural-language-to-SQL (NL2SQL) capabilities at the Obstetrics Clinic of Udine University Hospital. Requirements were co-defined with clinicians and formalized as an Entity-Relationship diagram, from which the logical schema and SQL implementation of the database were then derived. The latter integrates heterogeneous sources to connect maternal anamnestic and longitudinal history, current-pregnancy findings, intrapartum course, and delivery and neonatal outcomes. The NL2SQL layer enables clinicians to pose natural-language queries to the system, lowering barriers to audit and exploratory analysis. |
| format | Preprint |
| id |
arxiv_https___arxiv_org_abs_2510_16388 |
| institution | arXiv |
| publishDate | 2025 |
| record_format | arxiv |
| spellingShingle | Unified Peripartum Database with Natural-Language-to-SQL Capabilities at Udine University Hospital: Design and Prototype Armenise, Doriana Battello, Ginevra Brunello, Andrea Driul, Lorenza Montanari, Angelo Rizzante, Elisa Saccomanno, Nicola Salvador, Andrea Xodo, Serena Zermano, Silvia Databases H.2; H.4.0 The fragmentation of obstetric information across electronic health record modules, device repositories, and laboratory systems, as it is common in hospitals, hinders both intrapartum care and reproducible research. In this work, we present a practical blueprint for transforming heterogeneous peripartum records into computable, queryable assets by designing and prototyping a unified peripartum relational database with natural-language-to-SQL (NL2SQL) capabilities at the Obstetrics Clinic of Udine University Hospital. Requirements were co-defined with clinicians and formalized as an Entity-Relationship diagram, from which the logical schema and SQL implementation of the database were then derived. The latter integrates heterogeneous sources to connect maternal anamnestic and longitudinal history, current-pregnancy findings, intrapartum course, and delivery and neonatal outcomes. The NL2SQL layer enables clinicians to pose natural-language queries to the system, lowering barriers to audit and exploratory analysis. |
| title | Unified Peripartum Database with Natural-Language-to-SQL Capabilities at Udine University Hospital: Design and Prototype |
| topic | Databases H.2; H.4.0 |
| url | https://arxiv.org/abs/2510.16388 |