临床决策支持系统中用于时态数据管理的扩展SQL
An extended SQL for temporal data management in clinical decision-support systems.
作者信息
Das A K, Tu S W, Purcell G P, Musen M A
机构信息
Section on Medical Informatics, Stanford University School of Medicine, California 94305-5479.
出版信息
Proc Annu Symp Comput Appl Med Care. 1992:128-32.
We are developing a database implementation to support temporal data management for the T-HELPER physician workstation, an advice system for protocol-based care of patients who have HIV disease. To understand the requirements for the temporal database, we have analyzed the types of temporal predicates found in clinical-trial protocols. We extend the standard relational data model in three ways to support these querying requirements. First, we incorporate timestamps into the two-dimensional relational table to store the temporal dimension of both instant- and interval-based data. Second, we develop a set of operations on timepoints and intervals to manipulate timestamped data. Third, we modify the relational query language SQL so that its underlying algebra supports the specified operations on timestamps in relational tables. We show that our temporal extension to SQL meets the temporal data-management needs of protocol-directed decision support.
我们正在开发一个数据库实现，以支持T-HELPER医生工作站的时态数据管理，T-HELPER是一个针对感染HIV疾病患者的基于协议护理的建议系统。为了理解时态数据库的需求，我们分析了临床试验协议中发现的时态谓词类型。我们通过三种方式扩展标准关系数据模型以支持这些查询需求。首先，我们将时间戳合并到二维关系表中，以存储基于瞬间和基于间隔的数据的时态维度。其次，我们开发了一组关于时间点和时间间隔的操作，以处理带时间戳的数据。第三，我们修改关系查询语言SQL，以便其底层代数支持对关系表中的时间戳进行指定的操作。我们表明，我们对SQL的时态扩展满足了协议导向决策支持的时态数据管理需求。
Zotero 插件