支持临床关系数据库上的时态查询：S-WATCH-QL语言。
Supporting temporal queries on clinical relational databases: the S-WATCH-QL language.
作者信息
Combi C, Missora L, Pinciroli F
机构信息
Dipartimento di Matematica e Informatica, Università degli Studi di Udine.
出版信息
Proc AMIA Annu Fall Symp. 1996:527-31.
Due to the ubiquitous and special nature of time, specially in clinical datábases there's the need of particular temporal data and operators. In this paper we describe S-WATCH-QL (Structured Watch Query Language), a temporal extension of SQL, the widespread query language based on the relational model. S-WATCH-QL extends the well-known SQL by the addition of: a) temporal data types that allow the storage of information with different levels of granularity; b) historical relations that can store together both instantaneous valid times and intervals; c) some temporal clauses, functions and predicates allowing to define complex temporal queries.
由于时间具有普遍性和特殊性，特别是在临床数据库中，需要特殊的时态数据和运算符。在本文中，我们描述了S-WATCH-QL（结构化观察查询语言），它是SQL的时态扩展，SQL是基于关系模型的广泛使用的查询语言。S-WATCH-QL通过增加以下内容对著名的SQL进行了扩展：a）时态数据类型，允许存储不同粒度级别的信息；b）历史关系，可同时存储瞬时有效时间和时间间隔；c）一些时态子句、函数和谓词，用于定义复杂的时态查询。
Zotero 插件