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 J.
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 - TSQL2
KW - Temporal query language
KW - Temporal upward compatibility
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 - Wirtschaftsinformatik
JF - Wirtschaftsinformatik
SN - 0937-6429
IS - 1
ER -