SQL/SE: a query language extension for databases supporting schema evolution

The incorporation of a knowledge of time within database systems allows for temporally related information to be modelled more naturally and consistently. Adding this support to the metadatabase further enhances its semantic capability and allows elaborate interrogation of data. This paper presents SQL/SE, an SQL extension capable of handling schema evolution in relational database systems.

[1]  C. J. Date.  A guide to the SQL standard (2nd ed.) , 1989 .

[2]  Richard T. Snodgrass,et al.  The temporal query language TQuel , 1987, TODS.

[3]  Jinho Kim,et al.  Design and implementation of temporal query language with abstract time , 1990, Inf. Syst..

[4]  Jacob Stein,et al.  Class modification in the GemStone object-oriented DBMS , 1987, OOPSLA 1987.

[5]  Abdullah Uz Tansel,et al.  HQUEL, a Query Language for Historical Relational Databases , 1986, SSDBM.

[6]  L. Edwin McKenzie,et al.  Bibliography: Temporal Databases , 1986, SIGMOD Rec..

[7]  Sylvia L. Osborn.  The Role of Polymorphism in Schema Evolution in an Object-Oriented Database , 1989, IEEE Trans. Knowl. Data Eng..

[8]  Jay Banerjee,et al.  Data model issues for object-oriented applications , 1987, TOIS.

[9]  A. Nico Habermann,et al.  Beyond schema evolution to database reorganization , 1990, OOPSLA/ECOOP '90.

[10]  Shamkant B. Navathe,et al.  A Temporal Relational Model and a Query Language , 1989, Inf. Sci..

[11]  John F. Roddick,et al.  Temporal semantics in information systems - a survey , 1992, Inf. Syst..

[12]  Carlo Zaniolo,et al.  Database relations with null values , 1982, J. Comput. Syst. Sci..

[13]  C. J. Date.  Null Values in Database Management , 1982, BNCOD.

[14]  Richard T. Snodgrass,et al.  Schema Evolution and the Relational Algebra , 1990, Inf. Syst..

[15]  David Scott Warren,et al.  Formal semantics for time in databases , 1982, TODS.

[16]  James Clifford.  A logical framework for the temporal semantics and natural-language querying of historical databases , 1982 .

[17]  David A. Bell,et al.  Taxonomy of time models in databases , 1990 .

[18]  Shashi K. Gadia,et al.  A query language for a homogeneous temporal database , 1985, PODS '85.

[19]  Nandlal L. Sarda.  Algebra and Query Language for A Historical Data Model , 1990, Comput. J..

[20]  John F. Roddick.  Dynamically Changing Schemas Within Database Models , 1991, Aust. Comput. J..

[21]  Richard T. Snodgrass,et al.  A Bibliography on Temporal Databases , 1988 .

[22]  Shashi K. Gadia,et al.  A homogeneous relational model and query languages for temporal databases , 1988, TODS.

[23]  Randy H. Katz,et al.  Toward a unified framework for version modeling in engineering databases , 1990, CSUR.

[24]  Won Kim,et al.  Versions of Schema for Object-Oriented Databases , 1988, VLDB.

[25]  C. J. Date.  A Guide to the SQL Standard , 1987 .

[26]  Jay Banerjee,et al.  Semantics and implementation of schema evolution in object-oriented databases , 1987, SIGMOD '87.

[27]  Eero Peltola,et al.  Grammatical data base model , 1979, Inf. Syst..

[28]  C. J. Date.  Relational Database - Selected Writings , 1986 .

[29]  Harry K. T. Wong,et al.  The role of time in information processing: a survey , 1982, SGMD.