A temporal query language

version 2.2 TI = time interval (for example [0 – 2, 1 – 3, 1 – 5, 5 – 10]) CTI = computed time interval (for example [0 – 10]) TP = time point (internally a time interval with same time of start and end) CPT = examples: 12345 or 1234F ICD9 = examples: 022, 022.2, 022.22, E123, E123.1, E123.12, V01, V01.1, V01.01 NOTE_TP = TP with payload information [TP, NOTE_ID] ICD9_TI = TI with payload information [TI, ICD9_ID] MAX = Integer.MAXIMUM (maximum positive number) MIN = Integer.MINIMUM (minimum negative number)

[1]  John K. Tsotsos.  Temporal Event Recognition: An Application to Left Ventricular Performance , 1981, IJCAI.

[2]  Bharadwaj Jayaraman,et al.  Constructing a Parallel Implementation from High-Level Specifications: A Case Study Using Resource Expressions , 1983, ICPP.

[3]  Drew McDermott,et al.  A Temporal Logic for Reasoning About Processes and Plans , 1982, Cogn. Sci..

[4]  Dennis McLeod,et al.  Database description with SDM: a semantic database model , 1981, TODS.

[5]  Richard Montague,et al.  The Proper Treatment of Quantification in Ordinary English , 1973 .

[6]  Lawrence A. Bjork.  Generalized Audit Trail Requirements and Concepts for Data Base Applications , 1975, IBM Syst. J..

[7]  Robert M. Keller,et al.  Resource expressions for applicative languages , 1982, ICPP.

[8]  Edmund M. Clarke,et al.  Compiling path expressions into VLSI circuits , 1985, POPL '85.

[9]  David Maier,et al.  Making smalltalk a database system , 1984, SIGMOD '84.

[10]  S. Jones,et al.  Handling the Time Dimension in a Data Base , 1980, ICOD.

[11]  Gio Wiederhold,et al.  Structured organization of clinical data bases , 1899, AFIPS '75.

[12]  E. F. CODD,et al.  A relational model of data for large shared data banks , 1970, CACM.

[13]  Peter Dadam,et al.  Designing DBMS support for the temporal dimension , 1984, SIGMOD '84.

[14]  Gad Ariav,et al.  MDM: Handling the Time Dimension in Generalized DBMS. , 1981 .

[15]  E. F. Codd,et al.  Extending the database relational model to capture more meaning , 1979, ACM Trans. Database Syst..

[16]  Keith Allen Kimball.  The Data System. , 1978 .

[17]  Marc B. Vilain,et al.  A System for Reasoning About Time , 1982, AAAI.

[18]  Richard T. Snodgrass,et al.  The temporal query language TQuel , 1987, TODS.

[19]  David Scott Warren,et al.  Formal semantics for time in databases , 1982, TODS.

[20]  Peter C. Cheeseman,et al.  A representation of time for automatic planning , 1984, ICRA.

[21]  Stephen Todd,et al.  The Peterlee Relational Test Vehicle - A System Overview , 1976, IBM Syst. J..

[22]  Lawrence M. Fagan.  VM, representing time-dependent relations in a medical setting , 1980 .

[23]  Michael Stonebraker,et al.  The design and implementation of INGRES , 1976, TODS.

[24]  Carlo Zaniolo,et al.  The database language GEM , 1983, SIGMOD '83.

[25]  R L Blum,et al.  Discovery, confirmation, and incorporation of causal relationships from a large time-oriented clinical data base: the RX project. , 1982, Computers and biomedical research, an international journal.

[26]  E. F. Codd,et al.  Relational Completeness of Data Base Sublanguages , 1972, Research Report / RJ / IBM / San Jose, California.

[27]  Susan Jones,et al.  LEGOL 2.0: A relational specification language for complex rules , 1979, Inf. Syst..

[28]  James F. Allen.  An Interval-Based Representation of Temporal Knowledge , 1981, IJCAI.

[29]  Kenneth M. Kahn,et al.  Mechanizing Temporal Knowledge , 1977, Artif. Intell..

[30]  Sten Fredrik Andler,et al.  Predicate path expressions: a high-level synchronization mechanism , 1979 .

[31]  Anthony C. Klug.  Equivalence of Relational Algebra and Relational Calculus Query Languages Having Aggregate Functions , 1982, JACM.

[32]  T. Lougenia Anderson,et al.  Modeling Time at the Conceptual Level , 1982, JCDKB.

[33]  Won Kim,et al.  On optimizing an SQL-like nested query , 1982, TODS.

[34]  Shashi K. Gadia,et al.  A homogeneous relational model and query languages for temporal databases , 1988, TODS.

[35]  Janis A. Bubenko,et al.  Information Modeling in the Context of System Development , 1980, IFIP Congress.

[36]  Manfred R. Klopprogge,et al.  TERM: An Approach to Include Time Dimension in the Entity-Relationship Model , 1981, ER.

[37]  Tera Lougenia Anderson,et al.  The database semantics of time , 1981 .

[38]  G. J. Whitrow,et al.  The Natural Philosophy of Time , 1963 .

[39]  Lynette Hirschman,et al.  Representing Implicit And Explicit Time Relations In Narrative , 1981, IJCAI.

[40]  William J. Long,et al.  A Control Structure for Time Dependent Reasoning , 1983, IJCAI.