Consiglio Nazionale delle Ricerche

Tipo di prodottoArticolo in rivista
TitoloSchema Versioning for Multitemporal Relational Databases
Anno di pubblicazione1997
FormatoElettronico
Autore/iC. De Castro, F. Grandi, M. Scalas
Affiliazioni autoriC. De Castro: IEIIT - UOS di Bologna F. Grandi, M. Scalas: DEIS, Università di Bologna
Autori CNR e affiliazioni
  • CRISTINA DE CASTRO
Lingua/e
  • inglese
AbstractIn order to follow the evolution of application needs, a database management system is easily expected to undergo changes involving database structure after implementation. Schema evolution concerns the ability of maintaining extant data in response to changes in database structure. Schema versioning enables the use of extensional data through multiple schema interface as created by a history of schema changes. However, schema versioning has been considered only to a limited extent in current literature. Also in the field of temporal databases, whereas a great deal of work has been done concerning temporal versioning of extensional data, a thorough investigation of schema versioning potentialities has not yet been made. In this paper we consider schema versioning in a broader perspective and introduce new design options whose distinct semantic properties and functionalities will be discussed. First of all, we consider solutions for schema versioning along transaction time but also along valid time. Moreover, the support of schema versioning implies operations both at intensional and extensional level. Two distinct design solutions (namely single- and multi-pool) are presented for the management of extensional data in a system supporting schema versioning. Finally, a further distinction is introduced to define synchronous and asynchronous management of versioned data and schemata. The proposed solutions differ in their semantics and in the possible operations they support. The mechanisms for the selection of data through a schema version are in many cases strictly related to the particular schema versioning solution adopted, that also affects the data definition and manipulation language at user-interface level. In particular, we show how the temporal language TSQL2, originally designed to support basic functionalities of transaction-time schema versioning, can accordingly be extended.
Lingua abstractinglese
Altro abstract-
Lingua altro abstract-
Pagine da249
Pagine a290
Pagine totali41
RivistaInformation systems (Oxf.)
Attiva dal 1975
Editore: Pergamon, - Oxford
Paese di pubblicazione: Regno Unito
Lingua: multilingue
ISSN: 0306-4379
Titolo chiave: Information systems (Oxf.)
Titolo proprio: Information Systems. (Oxf.)
Titolo abbreviato: Inf. syst. (Oxf.)
Numero volume della rivista22
Fascicolo della rivista5
DOI-
Verificato da refereeSì: Internazionale
Stato della pubblicazione-
Indicizzazione (in banche dati controllate)-
Parole chiaveTransaction Time, Valid Time, Temporal Database, Multitemporal Database, Schema Versioning
Link (URL, URI)http://www.sciencedirect.com/science/article/pii/S0306437997000173
Titolo parallelo-
Data di accettazione-
Note/Altre informazioni-
Strutture CNR
  • IEIIT — IEIIT - Sede secondaria di Bologna
Moduli CNR-
Progetti Europei-
Allegati
articolo pubblicato
Tipo documento: application/pdf

Dati associati a vecchie tipologie
I dati associati a vecchie tipologie non sono modificabili, derivano dal cambiamento della tipologia di prodotto e hanno solo valore storico.
Editore
  • Pergamon Press, Oxford (Regno Unito)
Autore/i opera originaleC. De Castro, F. Grandi, M.R. Scalas
Lingua opera originaleeng
Titolo opera originaleSchema Versioning for Multitemporal Relational Databases