A TSQL2 tutorial

Publisher Website
Google Scholar
Abstract
This tutorial presents the primary constructs of the consensus temporal query lan- guage TSQL2 via a media planning scenario. Media planning is a series of deci- sions involved in the delivery of a promotional message via mass media. We will follow the planning of a particular advertising campaign. We intro- duce 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 indetermi- nate information, comparing multiple versions of the media plan, accommodating changes to the schema, and vacuuming a temporal database of old data.

This publication has 0 references indexed in Scilit: