Computer system and method for efficient index creation for a streaming database

Abstract

Index creation in a streaming database with medical state parameters allows near-real-time access to medical state parameters reflecting medical states of patients. A message broker receives messages that include records with current measured medical state parameter values of patients. A stream processor processes messages with a plurality of parameter augmentation algorithms to derive additional computed medical state parameter values for a respective patient. Records with the computed values are inserted via generated messages into any incoming data stream. A data handler can create persisted patient-signal specific stream data tables for unknown combinations of patient identifier and signal identifier in the streaming database, and can create a block range index for the time information of the persisted stream data table. Records contained in the received and generated messages are written into respective persisted patient-signal specific stream data tables of the streaming database, and respective block range indexes are updated accordingly.