Michael D. Soo

Learn More
This docuinent specifies a temporal extension to the SQL-92 language standard. The language is designated TSQLZ. The document is organized as follows. The next section indicates the starting point of the design, the SQL92 language. Section 4 lists the desired features on which the TSQL2 Language Design Committee reached consensus. Section 5 presents the(More)
This document contains de nitions of a wide range of concepts speci c to and widely used within temporal databases. In addition to providing de nitions, the document also includes explanations of concepts as well as discussions of the adopted names. The consensus e ort that lead to this glossary was initiated in Early 1992. Earlier versions appeared in(More)
To add time support to the relational model, both rst normal form (1NF) and non-1NF approaches have been proposed. Each has associated diiculties. Remaining within 1NF when time support is added may introduce data redundancy. The non-1NF models may be incapable of directly using existing relational storage structures or query evaluation technologies. This(More)
Joins are arguably the most important relational operators. Poor implementations are tantamount to computing the Cartesian product of the input relations. In a temporal database, the problem is more acute for two reasons. First, conventional techniques are designed for the evaluation of joins with equality predicates rather than the inequality predicates(More)
Adding time to the relational model has been a daunting task [1, 2, 3, 4]. More than two dozen time-extended relational data models have been proposed over the last fifteen years [5]. Most of these are valid-time models. Each fact in a validtime relation has associated the time when it is true in the modeled reality. Other models support transaction-time(More)
Joins are arguably the most important relational operators. Poor implementations are tantamount to computing the Cartesian product of the input relations. In a temporal database, the problem is more acute for two reasons. First, conventional techniques are designed for the optimization of joins with equality predicates, rather than the inequality predicates(More)
This tutorial presents the primary constructs of the consensus temporal query language TSQL2 via a media planning scenario. Media planning is a series of decisions involved in the delivery of a promotional message via mass media. We will follow the planning of a particular advertising campaign. We introduce the scenario by identifying the marketing(More)
Normal forms play a central role in the design of relational databases. Several normal forms for temporal relational databases have been proposed. These definitions are particular to specific temporal data models, which are numerous and incompatible. This paper attempts to rectify this situation. We define a consistent framework of temporal equivalents of(More)
Despite intensive research, there are very few reagents with which to modulate and dissect the mRNA splicing pathway. Here, we describe a novel approach to identify such tools, based on detection of the exon junction complex (EJC), a unique molecular signature that splicing leaves on mRNAs. We developed a high-throughput, splicing-dependent EJC(More)