Queries to Temporal Databases Supporting Schema Versioning

The conceptual schema (intention) and raw data (extension) are evolving entities which require adequate support for past, present and even future versions. Temporal Databases supporting schema evolution were developed with the aim of satisfying this need. The support for schema versioning raises two complex subjects: the storage of the several schema versions and their associate data, and the processing of queries that involve more than one schema version. The main objective of this work is to analyse the second aspect in order to propose a strategy for answering those queries. In an environment supporting schema versioning the complete history of schema evolution is kept. In many occasions it can be necessary to query the database’s structure, so this work proposes an extension to the temporal query language TSQL2 in order to support queries to intentional data.

[1]  John F. Roddick,et al.  Schema evolution in database systems: an annotated bibliography , 1992, SGMD.

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

[3]  Gad Ariav Temporally oriented data definitons: Managing schema evolution in temporally oriented databases , 1991, Data Knowl. Eng..

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

[5]  Pericles Loucopoulos,et al.  A conceptual modelling formalism for temporal database applications , 1991, Inf. Syst..

[6]  李幼升,et al.  Ph , 1989 .

[7]  Albert Croker,et al.  The historical relational data model (HRDM) and algebra based on lifespans , 1986, 1987 IEEE Third International Conference on Data Engineering.

[8]  Richard T. Snodgrass,et al.  The TSQL2 Temporal Query Language , 1995 .

[9]  Shamkant B. Navathe,et al.  Dealing with Temporal Schema Anomalies in History Databases , 1987, VLDB.

[10]  Duane Szafron,et al.  Managing Schema Evolution Using a Temporal Object Model , 1997, ER.

[11]  Fabio Grandi,et al.  On Schema Versioning in Temporal Databases , 1995, Temporal Databases.

[12]  M.R. Scalas,et al.  A model for schema evolution in temporal relational databases , 1993, 1993 CompEuro Proceedings Computers in Design, Manufacturing, and Production.

[13]  Fabio Grandi,et al.  Schema Versioning for Multitemporal Relational Databases , 1997, Inf. Syst..

[14]  Sushil Jajodia,et al.  Temporal Databases: Theory, Design, and Implementation , 1993 .

[15]  John F. Roddick A model for temporal inductive inference and schema evolution in relational database systems , 1994 .