Prototype (revised) — slide “The problem” · outputs rail from the datamarts Option C only: connector from Marts · no status badges · uniform intensity · capitalized box texts.
AritmoLab · Policlinico San Donato
The problem04 · The problem
From free text to a research platform

The clinical truth lives in unstructured columns

“Il paziente riferisce sincope ricorrente; ECG basale con sopraslivellamento ST in V1–V3; test provocativo con flecainide positivo per pattern Brugada.”

EN“The patient reports recurrent syncope; baseline ECG with ST-segment elevation in V1–V3; flecainide provocation test positive for a Brugada pattern.”

SourcesCardioref · Genetic data
Omics Portal · ECG
→
Stagingraw replica
→
Integration3NF · text mining
→
Data Warehousestar schema
→
Martsdbt · Superset
four challenges to face · the answers come next
01
Volume without structuretwenty years of records locked in free-text columns
02
Ambiguous languagenegation · family history · bilingual shorthand
03
No shared ontologyevery system names conditions its own way
04
Proving reliabilityextraction must be demonstrably correct
outputs of the datamarts
Dashboardsclinical review on Superset
Machine Learningcohort tables for model training
Predictive Statisticsoutcomes & risk analysis
ThothII — natural-language → SQL over the DWH, builds the final datamarts
Role of AI in the Analysis of Unstructured Clinical DatabasesDr. Marco Pancotti - MultiPhysixLabDr. Sara Paratico - Gruppo San DonatoSan Donato Milanese, Milan, Italy · 2–3 October 202604 / 14

Option C, revised. The rail drops straight from the Marts stage; the three outputs have equal visual weight and no status labels; texts inside the diagram boxes are capitalized; the EN translation is now the same size as the Italian.