University of Hertfordshire

By the same authors

Temporal Support in Relational Databases

Research output: Chapter in Book/Report/Conference proceedingConference contribution


  • 906957

    Accepted author manuscript, 189 KB, PDF document

View graph of relations
Original languageEnglish
Title of host publication10th Int Workshop on the Teaching, Learning and Assessment of Databases
Subtitle of host publicationTLAD 2012
PublisherThe Higher Education Academy
ISBN (Print)978-1-907207-57-0
Publication statusPublished - Jul 2012
Event10th Int Workshop on the Teaching, Learning and Assessment of Databases (TLAD 2012) - University of Hertfordshire, Hatfield, United Kingdom
Duration: 9 Jul 2012 → …


Workshop10th Int Workshop on the Teaching, Learning and Assessment of Databases (TLAD 2012)
CountryUnited Kingdom
Period9/07/12 → …


This paper examines the current state of temporal support in relational databases and the type of situations where we need that support. There has been much research in this area and there were attempts in the American National Standards Institute (ANSI) and the International Organisation for Standardisation (ISO) standards committees in the late 1990s to add an extension called TSQL2 to the existing SQL standard. However no agreement could be reached as it was felt that some of the suggested extensions did not fit well with the relational model, as well as being difficult to implement. TSQL2 was abandoned and since then vendors have added their own data types, and if we are lucky, operators too in an attempt to provide support. However, to novice students and database designers it is often not apparent why some temporal concepts are difficult to deal with in a relational database. In teaching these concepts to students we use a Case Study (based on a real example) which illustrates the problems of providing temporal support by using examples of the data types which could be useful to solve temporal problems and the operators which are necessary to provide this.


Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. To copy otherwise, to republish, to post on servers or to redistribute to lists, requires prior specific permission. © 2012 Higher Education Academy

ID: 7778609