Case Study · Healthcare / Data Integration

One patient, one record: unifying data across 50+ hospitals

For a nationwide institution caring for an organization’s employees and their families, Khwarizm unified patient data from 50+ facilities into one platform — keeping each facility’s data local — giving clinicians a complete view at the point of care, and leaders organization-wide health, safety, and analytics to steer by.

In medicine, the record is the first instrument of care. Before a clinician can treat, they need to know what came before — the history, the tests, the medications. But across a national hospital network, that history had been scattered: every one of 50-plus facilities kept its own patient database, and none could see the others. Khwarizm was brought in to change that — to give any authorized clinician, at any facility, a single complete view of the patient in front of them, without moving a single hospital’s data out of its own hands.

A record in every hospital, and nowhere whole

The institution runs care at national scale — from large general hospitals to specialized centers, each delivering full medical care and serving up to 8,000 patients. Yet its data lived in isolation: every facility maintained a separate patient database, so a person’s medical history existed only in fragments, held wherever they happened to have been treated.

The institution exists to care for a large public organization’s employees and their families. A person’s medical record opens on their first day of employment and is kept for life — a complete, longitudinal history that follows the employee and their family across an entire career and is never discarded. That makes each record uniquely valuable — and made its fragmentation across 50-plus databases all the more costly.

The burden fell on patients. They were expected to carry their own medical reports — to every visit, and above all when they were transferred from one facility to another. A referral across the country could mean a patient arriving with a folder of paper, or arriving with nothing at all, leaving clinicians to make decisions with an incomplete picture.

The fragmentation reached beyond the bedside. The network’s central warehouse was not kept current with real balances from the facilities, so the supply chain suffered — stock visibility was poor, and planning was working from numbers that were always behind.

Unify the data — without centralizing it

The design principle was deliberate: unify the view, but keep each facility’s data local. Rather than rip out fifty databases and force everything into one, Khwarizm connected them into a synchronized whole while every hospital retained its own system of record.

Two flows of data made that possible. Facilities push patient data online to the central databases, so that a record created anywhere becomes visible to every authorized facility in the network. And in the other direction, Khwarizm pushes lookup and reference data down from the central databases to unify a single master data dictionary — one shared set of codes, terminologies, and definitions — so that a record written in one hospital means exactly the same thing when read in another.

We unified the data without centralizing control. Each facility still owns its own records — but now every facility can see the whole patient.

The technology behind the flow

Moving clinical data between 50-plus sites in near real time, reliably, is a demanding engineering problem. Khwarizm built the integration on Oracle’s data platform. Oracle GoldenGate handles the real-time replication — capturing changes at each facility and at the center and keeping them continuously in sync, in both directions, with low latency. The central master databases run on Oracle Exadata, the engineered platform built for exactly this kind of high-throughput, mission-critical workload. The load is heavy: with as many as 500 visits a day at each of 50-plus facilities — on the order of 25,000 patient visits a day — and every visit pulling a full history, resolving master-data lookups, and writing new records, the platform handles millions of transactions and queries daily, and the optimized Exadata machine absorbs that volume while keeping response times fast even at peak. And Oracle Enterprise Manager gives the team a single console to monitor and administer the whole estate.

Together, the three turn a daunting national footprint into a smooth, manageable operation. The databases are consolidated on Exadata; GoldenGate keeps every site in sync on its own; and Enterprise Manager surfaces the entire estate — every database and every replication flow across all 50-plus facilities — through one pane of glass. The whole platform is therefore run from a single point of IT operations: one team, in one operations centre, monitors health, tunes performance, applies patches, and resolves issues across the national network without ever touching each hospital by hand. What could have been fifty separate administration burdens became one clean, centrally run operation.

From paper folders to an instant view

The change clinicians feel is immediate. A patient’s complete record now appears on screen the moment they present — wherever they are in the country, and whether or not they remembered their paperwork. Transfers between facilities no longer depend on a folder of printouts making the journey with the patient. The record simply travels ahead of them.

Before, a patient arriving from another governorate meant waiting for files — or working blind. Now the full history is in front of us the moment they walk in.

Security in removing the paper

Eliminating paper did more than save effort — it closed a real security and privacy gap. A paper report has no access control and no audit trail: it can be lost, copied, misplaced, or read by anyone who happens to hold it, and sensitive medical histories were being physically carried through corridors and across the country. Moving those records into the unified platform means every view is authenticated, role-based, and logged. Patient data is no longer exposed on paper; it is protected in the system, accessible only to authorized clinicians, and traceable whenever it is opened.

Real-time supply chain management

The same live data flow transformed operations. With current balances streaming continuously from every facility to the center, the warehouse and each hospital now work from a real-time picture of stock rather than figures that were always behind. Replenishment and distribution can be driven by actual demand across the network, cutting both stock-outs and waste — so the right supplies are in the right place when clinicians need them, and planning is finally grounded in what is true today.

From records to organization-wide insight

Unification unlocked something the fragmented systems never could: analytics across the entire organization. Because every facility now shares one master data dictionary, records are finally comparable — so the institution can study the health of its whole population rather than fifty disconnected samples. The lifelong records, beginning on each employee’s first day and spanning their families, give that analysis real depth over time.

That reach matters most in occupational health and safety. Leaders can now track health-and-safety trends across sites, departments, and roles — surfacing emerging risks, injury and illness patterns, and the impact of interventions — and act before problems spread. And it all rolls up into clear dashboards and reporting, giving decision-makers across the organization an accurate, timely, evidence-based view to plan and steer by, rather than the guesswork that siloed data had forced on them.

The results

The institution moved from fifty isolated islands of data to a single, coherent view of every patient — with each facility still holding its own records locally. Clinicians gained an immediate, complete picture at the point of care. Patients were freed from carrying folders of 30-plus documents from door to door. Sensitive medical data became more secure, protected by authenticated, logged access instead of loose paper. And the supply chain gained the real-time visibility it had been missing, all resting on one national master data dictionary. And for the first time, decision-makers could see the whole organization — analyzing population health and occupational health and safety across every site, and steering by clear, evidence-based reporting.

The deeper win is one that only national-scale integration can deliver: continuity of care that follows the patient, not the paperwork. Wherever someone seeks treatment across the country, the record is already there — and the institution can keep building on a data foundation that is unified in view, yet sovereign in place.