The client is a healthcare organisation in the United States operating across multiple care settings. A
patient’s history was spread across every organisation that had ever treated them. The hospital holds the
admission, the laboratory holds the results, the imaging centre holds the study, the pharmacy holds what
was dispensed, the insurer holds the claim, and none of them holds all of it. The patient carries the record
between them, usually in a paper folder and usually incompletely.
The clinical cost is repeated tests, missed interactions and decisions taken without the history that would
have changed them. The system level cost is that the health authority is planning capacity, procurement
and disease response using data that is a reporting cycle behind reality
| Cost | Driver |
|---|---|
| Duplicate investigations | Tests repeated because a prior result cannot be found or trusted. |
| Avoidable admissions | Deterioration in chronic disease that was visible in the data before it became an emergency. |
| Length of stay | Decisions waiting on information that exists elsewhere in the system. |
| Clinician time | Documentation and reporting burden that takes clinicians away from patients. |
| Late diagnosis | Conditions found at a stage where treatment is longer, harder and more expensive. |
| Planning error | Capacity and procurement decided on data that describes last year. |
| Research friction | Months of approvals and extract preparation before a study can begin. |
Data arrives in the standards the sector already uses, is normalised against national terminologies, resolved to a single patient identity, and curated into a lakehouse where every access is filtered by consent
and by purpose. Models and copilots read only what the requesting purpose allows, and nothing leaves the platform in identified form.
Everything the platform produces for a clinician is advisory. It surfaces, ranks and explains. The clinical decision, and the accountability for it, stays with the clinician, and the architecture makes that structurally true rather than a line in a disclaimer.
| The platform does | The platform never does |
|---|---|
| Surface the complete history | Make a diagnosis of record |
| Flag a deterioration risk | Order a test or a treatment |
| Highlight an interaction or allergy | Change a prescription |
| Draft a summary for a code | Sign a clinical note |
| Rank a cohort for review | Alter a care pathway on its own |
| Show the evidence and the source | Replace clinical judgement |
| Source | Mechanism and shape |
|---|---|
| Hospital record systems | Clinical messaging for admissions, transfers, orders and results, plus resource APIs where the vendor supports them. |
| Laboratories | Structured result messages with units and reference ranges preserved, because a value without its range is not interpretable. |
| Imaging centres | Standard imaging transfer of studies and structured reports, with pixel data landed in governed storage and metadata indexed. |
| Pharmacy and dispensing | Dispense events and medication lists, which are usually a better record of what the patient actually took than the prescription. |
| Insurers and claims | Batch files carrying diagnosis and procedure coding, useful for coverage and for population denominators. |
| Genomics | Variant call files and interpretation reports, referenced rather than copied, with the raw sequence kept where it was produced. |
| Devices and wearables | Continuous streams landed at low resolution by default, with full resolution retained around clinical events. |
| Registries and public health | Notifications, immunisation and screening records. |
Every clinical code is mapped to a reference vocabulary at the point of curation, and both the original local code and the mapped concept are kept. Keeping both matters, because a clinician needs to see what was actually recorded and an analyst needs to compare across organisations.
| Domain | Reference vocabulary |
|---|---|
| Clinical findings and procedures | A clinical terminology with a concept hierarchy, so a query for a parent concept finds the children. |
| Laboratory tests | A test identification standard, with units normalised and reference ranges retained per laboratory. |
| Diagnoses for reporting | The statistical classification the country reports on. |
| Medicines | A drug vocabulary that resolves brand to ingredient, strength and form. |
| Imaging | Study and body part coding from the imaging standard plus the report terminology. |
Without a universally used national identifier, the same person appears as a different patient in every system, with names spelled differently, dates transposed and addresses out of date. Getting this wrong in either direction is harmful, so the design is deliberately conservative.
Consent written into a policy document is a promise. Consent implemented as a row filter on the table is a control. Every query carries the identity of the requester and the purpose of the request, and the platform resolves what is visible from the consent state at that moment.
| Control | Implementation |
|---|---|
| Purpose binding | Direct care, operations, public health and research are separate purposes with separate entitlements. The same person gets different results under different purposes. |
| Consent register | Held as versioned records with effective dates, so a query about the past uses the consent that applied then. |
| Row filters | Applied on the table itself, so the rule cannot be bypassed by using a different tool. |
| Column masks | Identifiers masked by default, released only to purposes that genuinely need them. |
| Sensitive categories | Certain record types carry additional restriction by law or by policy and are filtered independently of the rest. |
| Break glass | Emergency access permitted, logged separately, and reviewed by a named person afterwards rather than approved in advance. |
| Withdrawal | Consent withdrawal propagates to derived tables and to future model training, with deletion vectors making removal practical. |
| Stage | What lives there and why |
|---|---|
| Bronze | The message or file exactly as received, with sending organisation, transport metadata and receipt time. Nothing corrected. This is what an audit or a clinical incident review will need. |
| Silver | Parsed into clinical resources, terminology mapped, units normalised, patient resolved, duplicates collapsed, and every value carrying its provenance back to the sending system. |
| Gold | Patient 360, encounter, longitudinal medication and result series, cohort tables, population denominators and the operational marts each organisation needs. |
| Expectation class | Example |
|---|---|
| Structural | Mandatory elements present, codes resolve in the declared vocabulary version. |
| Clinical plausibility | Values inside physiologically possible ranges, with implausible entries quarantined rather than published. |
| Temporal | Discharge never precedes admission, results never precede the order. |
| Completeness | Expected message volume per organisation per day, so a hospital that quietly stops sending is detected the same day. |
Clinical prediction is unusually easy to get wrong in a way that looks excellent in testing. The two common failures are both about time.
| Model | Job and shape |
|---|---|
| Deterioration early warning | Continuous risk score on inpatients from vital signs, laboratory trend and treatment, tuned for lead time and for a manageable alert rate. |
| Chronic disease risk | Progression and complication risk in the community, used to prioritise outreach rather than to label patients. |
| Medical imaging | Detection and segmentation as a second reader, with the finding always presented alongside the image region it came from. |
| Clinical language | Extraction of problems, medications and findings from discharge summaries and reports, marked as derived. |
| Precision medicine | Variant interpretation and pharmacogenomic flags combined with the clinical record. |
| Population health | Incidence, prevalence and demand forecasting by geography for capacity and procurement planning. |
| Hospital operations | Admission, discharge and theatre demand forecasting, which is where operational value appears earliest. |
Many organisations will contribute to a model and refuse to contribute their data, and that position is usually correct. Training is therefore sent to the data, with only model updates returning.
| Copilot | Scope and limit |
|---|---|
| Clinician summary | Assembles the longitudinal picture for the patient in front of the clinician, with every statement linked to its source document. It never states a conclusion the record does not support. |
| Documentation support | Drafts the discharge summary and suggests coding from the encounter record. The clinician edits and signs. |
| Research cohort | Turns an eligibility description into a query against de-identified data and returns counts, not people. |
| Operations | Explains bed, theatre and staffing pressure and what is driving it. |
| Public health | Answers surveillance questions from population tables with denominators stated. |
| Guideline lookup | Retrieves the applicable guideline and cites the section, without adapting it to the patient. |
| Condition | Required behaviour |
|---|---|
| Supported by the record | State it and link to the document, the encounter and the date. |
| Supported by a guideline | Cite the guideline and the section. Never paraphrase a recommendation without pointing at it. |
| Record is incomplete | Say what is missing and from which organisation, rather than filling the gap. |
| Conflicting entries | Show both with their sources and dates, and let the clinician resolve them. |
| Consent restricts the answer | State that restricted data exists without revealing it, so the clinician knows to ask. |
| Outside scope | Refuse, and record the refusal. |
| Control | Implementation |
|---|---|
| Network | Private connectivity end to end, no public endpoints on the workspace or the storage account, egress restricted to an approved list. |
| Identity | Single corporate directory, short lived tokens, no shared service accounts, machine identities scoped per pipeline. |
| Encryption | Customer managed keys for storage and for managed services, with rotation and revocation held by the institution rather than the platform. |
| Secrets | Held in the enterprise vault and referenced, never present in notebooks, jobs or repositories. |
| Least privilege | Access granted to a group by role and purpose, reviewed on a recertification cycle, with standing access to production data treated as an exception. |
| Tokenisation | Card numbers and national identifiers replaced at ingest, with detokenisation available only to a small number of controlled paths. |
| Audit immutability | Access logs written once to a separate account under different administration. |
| Phase | Scope | What it produced |
|---|---|---|
| Phase 0 Foundation |
Legal basis, consent model, identity strategy, terminology ownership, security architecture, participant inventory. | Approved information governance design and a signed consent model. |
| Phase 1 First cohort |
Three to five organisations onboarded end to end, terminology mapped, identity resolution running with human review. | Match quality measured and reconciliation against source reports for a full month. |
| Phase 2 Clinical value |
Longitudinal record available at the point of care in those organisations. | Clinician adoption and measured reduction in repeat investigations. |
| Phase 3 Models |
Deterioration and operational forecasting in shadow mode, externally validated. | Performance and alert burden accepted by clinical governance. |
| Phase 4 Research |
Controlled workspaces and aggregate query interface opened to approved studies. | First studies completed without any data leaving the platform. |
| Phase 5 Scale |
Onboarding industrialised, population analytics available to the health authority. | Repeatable onboarding package and published transparency reporting. |
| Measure | What it tells you |
|---|---|
| Record completeness at point of care | Share of encounters where the full linked history was available. The measure the clinical case rests on. |
| Identity match rate and review queue | Linkage quality, and whether human review is keeping up. |
| False merge incidents | Tracked separately and reported to clinical governance, because the tolerance is near zero. |
| Duplicate investigation rate | The clearest financial return, measurable from existing order data. |
| Alert precision and burden | Confirmed alerts against total alerts, which decides whether staff keep responding. |
| Prediction lead time | How much warning was actually given before the event. |
| Unmapped code rate | How much clinical content is still not comparable across organisations. |
| Data freshness by organisation | Which participants are lagging, before anyone builds an analysis on stale data. |
| Metric | Enterprise scale |
|---|---|
| Hospitals connected | 200 to 1,000 |
| Patients | 20 to 100 million |
| Clinical records | 1 to 5 billion |
| Medical images | 300 to 800 million |
| Daily streaming events | 100 to 300 million |
| Healthcare professionals served | 50,000 to 250,000 |
| Research datasets | 5 to 30 PB |
| Measure | Target |
|---|---|
| Clinical data availability | 99.9 percent |
| Patient search response | Under 3 seconds |
| Diagnostic model inference | Under 5 seconds |
| Imaging model processing | Under 30 seconds per study |
| Data refresh | Near real time |
| Data quality compliance | Above 97 percent |
| Measure | Expected improvement |
|---|---|
| Deterioration detection | 20 to 30 percent earlier identification |
| Hospital readmissions | 10 to 18 percent reduction |
| Diagnostic turnaround time | 20 to 35 percent faster |
| Clinical documentation time | 30 to 45 percent reduction |
| Resource utilisation | 12 to 20 percent improvement |
| Research data preparation | 50 to 70 percent faster |
| Patient wait times | 10 to 20 percent reduction |
| Administrative cost | 12 to 18 percent reduction |
The three platforms are built on the same Databricks foundation and are operated to the same envelope. The figures below describe the capability of that foundation across the estate rather than the load of any single engagement, and they are the numbers we size and design against when a new platform is scoped.
| Platform metric | Typical target |
|---|---|
| Data ingestion | 20 to 150 TB per day |
| Structured streaming throughput | 20,000 to 500,000 events per second |
| Historical lakehouse | 2 to 30 PB |
| Delta tables | 5,000 to 25,000 |
| Models under management | 100 to 500 |
| Feature store features | 10,000 to 100,000 |
| Vector embeddings | 100 million to 2 billion |
| Platform metric | Typical target |
|---|---|
| Daily inference requests | 10 to 100 million |
| Enterprise users | 5,000 to 50,000 |
| Platform availability | 99.9 to 99.95 percent |
| Automated data quality checks | Above 95 percent of published tables |
| Governance coverage | 100 percent of production datasets |
| Mean time to detect a data issue | Under 15 minutes |
| Problem | What we did |
|---|---|
| Identity resolution errors | Conservative thresholds, human review of the uncertain band, reversible links, and false merges reported to clinical governance every month. |
| Terminology mapping backlog | A funded clinical terminology service from Phase 0, with unmapped rates published rather than absorbed. |
| Source conformance variation | Per organisation profiling and a conformance test suite before any feed is trusted, with reconciliation against the organisation's own reports. |
| Consent complexity | Model the consent rules with legal and clinical governance before building, because retrofitting purpose binding onto live data is close to a rebuild. |
| Model generalisation | External validation at a second organisation before deployment anywhere, and subgroup performance published. |
| Alert fatigue | Alert rate treated as a design constraint with clinical staff, and monitored after release as closely as accuracy. |
| Imaging storage cost | Tiered storage with metadata indexed hot and pixel data retrieved on demand. |
| Participation risk | Clinical value delivered to contributing organisations early, because voluntary participation is the real dependency. |