Skip to main content
Article
A TSQL2 Tutorial
ACM SIGMOD (1994)
  • Richard T. Snodgrass
  • Ilsoo Ahn
  • Gad Ariav
  • Don Batory
  • James Clifford
  • Curtis E. Dyreson, Utah State University
  • Ramez Elmarsi
  • Fabio Grandi
  • Christian S. Jensen
  • Wolfgang Kaefer
  • Nick Kline
  • Krishna Kulkarni
  • T.Y. Cliff Leung
  • Nikos Lorentzos
  • John F. Roddick
  • Arie Sugev
  • Michael D. Soo
  • Suryanarayana M. Sripada
Abstract

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 objective. The media plan involves placing commercials, and is recorded in a temporal database. The media plan must then be evaluated; we show how TSQL2 can be used to derive information from the stored data. We then give examples that illustrate storing and querying indeterminate information, comparing multiple versions of the media plan, accommodating changes to the schema, and vacuuming a temporal database of old data.

Keywords
  • TSQL2,
  • tutorial
Disciplines
Publication Date
September, 1994
Citation Information
Richard T. Snodgrass, Ilsoo Ahn, Gad Ariav, Don Batory, et al.. "A TSQL2 Tutorial" ACM SIGMOD Vol. 23 Iss. 3 (1994)
Available at: http://works.bepress.com/curtis_dyreson/23/