INTERACTIVE DEMOS

Healthcare

ICU Patient Deterioration Score Claims Auto-Adjudication

A 40-bed medical ICU monitors patients with continuous vitals (heart rate, SpO2, blood pressure, respiratory rate). The Modified Early Warning Score (MEWS) predicts deterioration 2-4 hours before a code event — but only if computed continuously from real-time vitals, not from nurse spot-checks every 4 hours.

⚠Patient in bed ICU-12B coded at 3:17 AM. Retrospective chart review showed SpO2 trending down from 96% to 89% over 90 minutes, but the 1 AM spot-check recorded 94% and the next check wasn't until 5 AM.

LIVEvitals_stream

bed_id	patient_id	heart_rate	spo2	systolic_bp	resp_rate	temp_c	ts
ICU-12B	PT-884210	82	96	128	16	37.1	2024-03-15T01:00:00.000Z
ICU-12B	PT-884210	89	94	132	18	37.2	2024-03-15T01:30:00.000Z
ICU-12B	PT-884210	98	93	138	20	37.4	2024-03-15T02:00:00.000Z
ICU-12B	PT-884210	108	91	145	24	37.6	2024-03-15T02:15:00.000Z
ICU-12B	PT-884210	118	89	152	28	37.8	2024-03-15T02:30:00.000Z
ICU-07A	PT-771038	72	98	118	14	36.8	2024-03-15T02:00:00.000Z

Streaming SQLRunning

▶Ingest continuous vitals from Kafka✓

CREATE SOURCE vitals_stream WITH (
  connector = 'kafka',
  topic = 'icu.vitals.monitor',
  properties.bootstrap.server = 'broker:9092'
) FORMAT PLAIN ENCODE JSON;

▶Compute MEWS and detect score acceleration✓

deterioration_alertsauto-updating

bed_id	patient_id	mews_score	trend	spo2_trend	predicted_event	alert_level
ICU-12B	PT-884210	7	RAPID_RISE	-2%	CODE_IMMINENT	CRITICAL
ICU-12B	PT-884210	5	RISING	-1%	DETERIORATING	HIGH
ICU-12B	PT-884210	3	RISING	-2%	NULL	MODERATE

✓RisingWave computes MEWS every 30 seconds from continuous monitor feeds. Bed ICU-12B's score rises from 2 to 7 as SpO2 drops below 91% and heart rate climbs above 115 — rapid response team called 47 minutes before the code would have occurred.

Talk to Sales