University of Hertfordshire

By the same authors

Temporal Support in Relational Databases

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

Standard

Temporal Support in Relational Databases. / Byrne, Bernadette; Triyambakaaradhya, Prajwal.

10th Int Workshop on the Teaching, Learning and Assessment of Databases: TLAD 2012. The Higher Education Academy, 2012. p. 13-26.

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

Harvard

Byrne, B & Triyambakaaradhya, P 2012, Temporal Support in Relational Databases. in 10th Int Workshop on the Teaching, Learning and Assessment of Databases: TLAD 2012. The Higher Education Academy, pp. 13-26, 10th Int Workshop on the Teaching, Learning and Assessment of Databases (TLAD 2012), Hatfield, United Kingdom, 9/07/12.

APA

Byrne, B., & Triyambakaaradhya, P. (2012). Temporal Support in Relational Databases. In 10th Int Workshop on the Teaching, Learning and Assessment of Databases: TLAD 2012 (pp. 13-26). The Higher Education Academy.

Vancouver

Byrne B, Triyambakaaradhya P. Temporal Support in Relational Databases. In 10th Int Workshop on the Teaching, Learning and Assessment of Databases: TLAD 2012. The Higher Education Academy. 2012. p. 13-26

Author

Byrne, Bernadette ; Triyambakaaradhya, Prajwal. / Temporal Support in Relational Databases. 10th Int Workshop on the Teaching, Learning and Assessment of Databases: TLAD 2012. The Higher Education Academy, 2012. pp. 13-26

Bibtex

@inproceedings{8215b19794804e7d90b120c65c893e85,
title = "Temporal Support in Relational Databases",
abstract = "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.",
author = "Bernadette Byrne and Prajwal Triyambakaaradhya",
note = "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. {\circledC} 2012 Higher Education Academy",
year = "2012",
month = "7",
language = "English",
isbn = "978-1-907207-57-0",
pages = "13--26",
booktitle = "10th Int Workshop on the Teaching, Learning and Assessment of Databases",
publisher = "The Higher Education Academy",

}

RIS

TY - GEN

T1 - Temporal Support in Relational Databases

AU - Byrne, Bernadette

AU - Triyambakaaradhya, Prajwal

N1 - 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

PY - 2012/7

Y1 - 2012/7

N2 - 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.

AB - 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.

M3 - Conference contribution

SN - 978-1-907207-57-0

SP - 13

EP - 26

BT - 10th Int Workshop on the Teaching, Learning and Assessment of Databases

PB - The Higher Education Academy

ER -