Notions of upward compatibility of temporal query languages

John Bair, Michael H. Böhlen, Christian S. Jensen, Richard Thomas Snodgrass

Research output: Contribution to journalArticle

20 Citations (Scopus)

Abstract

Migrating applications from conventional to temporal database management technology has received scant mention in the research literature. This paper formally defines three increasingly restrictive notions of upward compatibility which capture properties of a temporal SQL with respect to conventional SQL that, when satisfied, provide for a smooth migration of legacy applications to a temporal system. The notions of upward compatibility dictate the seman- tics of conventional SQL statements and constrain the semantics of extensions to these statements. The paper evaluates the seven extant temporal extensions to SQL, all of which are shown to complicate migration through design decisions that violate one or more of these notions. We then outline how SQL-92 can be systematically extended to become a temporal query language that satisfies all three notions.

Original languageEnglish (US)
Pages (from-to)25-34+105
JournalWirtschaftsinformatik
Volume39
Issue number1
StatePublished - 1997

Fingerprint

Query languages
Semantics

Keywords

  • SQL
  • Temporal query language
  • Temporal upward compatibility
  • TSQL2
  • Upward compatibility

ASJC Scopus subject areas

  • Information Systems

Cite this

Bair, J., Böhlen, M. H., Jensen, C. S., & Snodgrass, R. T. (1997). Notions of upward compatibility of temporal query languages. Wirtschaftsinformatik, 39(1), 25-34+105.

Notions of upward compatibility of temporal query languages. / Bair, John; Böhlen, Michael H.; Jensen, Christian S.; Snodgrass, Richard Thomas.

In: Wirtschaftsinformatik, Vol. 39, No. 1, 1997, p. 25-34+105.

Research output: Contribution to journalArticle

Bair, J, Böhlen, MH, Jensen, CS & Snodgrass, RT 1997, 'Notions of upward compatibility of temporal query languages', Wirtschaftsinformatik, vol. 39, no. 1, pp. 25-34+105.
Bair, John ; Böhlen, Michael H. ; Jensen, Christian S. ; Snodgrass, Richard Thomas. / Notions of upward compatibility of temporal query languages. In: Wirtschaftsinformatik. 1997 ; Vol. 39, No. 1. pp. 25-34+105.
@article{aaea6359bedc4f8da0dd94a2394e218c,
title = "Notions of upward compatibility of temporal query languages",
abstract = "Migrating applications from conventional to temporal database management technology has received scant mention in the research literature. This paper formally defines three increasingly restrictive notions of upward compatibility which capture properties of a temporal SQL with respect to conventional SQL that, when satisfied, provide for a smooth migration of legacy applications to a temporal system. The notions of upward compatibility dictate the seman- tics of conventional SQL statements and constrain the semantics of extensions to these statements. The paper evaluates the seven extant temporal extensions to SQL, all of which are shown to complicate migration through design decisions that violate one or more of these notions. We then outline how SQL-92 can be systematically extended to become a temporal query language that satisfies all three notions.",
keywords = "SQL, Temporal query language, Temporal upward compatibility, TSQL2, Upward compatibility",
author = "John Bair and B{\"o}hlen, {Michael H.} and Jensen, {Christian S.} and Snodgrass, {Richard Thomas}",
year = "1997",
language = "English (US)",
volume = "39",
pages = "25--34+105",
journal = "Business and Information Systems Engineering",
issn = "0937-6429",
publisher = "Springer Gabler",
number = "1",

}

TY - JOUR

T1 - Notions of upward compatibility of temporal query languages

AU - Bair, John

AU - Böhlen, Michael H.

AU - Jensen, Christian S.

AU - Snodgrass, Richard Thomas

PY - 1997

Y1 - 1997

N2 - Migrating applications from conventional to temporal database management technology has received scant mention in the research literature. This paper formally defines three increasingly restrictive notions of upward compatibility which capture properties of a temporal SQL with respect to conventional SQL that, when satisfied, provide for a smooth migration of legacy applications to a temporal system. The notions of upward compatibility dictate the seman- tics of conventional SQL statements and constrain the semantics of extensions to these statements. The paper evaluates the seven extant temporal extensions to SQL, all of which are shown to complicate migration through design decisions that violate one or more of these notions. We then outline how SQL-92 can be systematically extended to become a temporal query language that satisfies all three notions.

AB - Migrating applications from conventional to temporal database management technology has received scant mention in the research literature. This paper formally defines three increasingly restrictive notions of upward compatibility which capture properties of a temporal SQL with respect to conventional SQL that, when satisfied, provide for a smooth migration of legacy applications to a temporal system. The notions of upward compatibility dictate the seman- tics of conventional SQL statements and constrain the semantics of extensions to these statements. The paper evaluates the seven extant temporal extensions to SQL, all of which are shown to complicate migration through design decisions that violate one or more of these notions. We then outline how SQL-92 can be systematically extended to become a temporal query language that satisfies all three notions.

KW - SQL

KW - Temporal query language

KW - Temporal upward compatibility

KW - TSQL2

KW - Upward compatibility

UR - http://www.scopus.com/inward/record.url?scp=0001798935&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0001798935&partnerID=8YFLogxK

M3 - Article

AN - SCOPUS:0001798935

VL - 39

SP - 25-34+105

JO - Business and Information Systems Engineering

JF - Business and Information Systems Engineering

SN - 0937-6429

IS - 1

ER -