Paper Info
Title
Transformation of Relational Databases to Transaction-Time Temporal Databases
Abstract
In recent years, versioning has emerged as a very popular operating system feature for file systems. Some of these systems can provide user friendly â聙聹go back in timeâ聙聺 feature, where the user can see exactly how file system looked on the dates he specifies. The advantages of these techniques are however, not present or supported by most relational database systems used worldwide. Using versioning in relational databases we can decrease the complexity of information systems, provide new functionality, increase the security and usually decrease the administration costs. In this paper we present an approach to transformation of the snapshot relational database to temporal database with tuple time-stamping. The transformation is achieved by automatic database schema extension and modification. Information system which uses the transformed database schema remain intact, or requires minimal modifications. The automatic transformation can be applied on PostgreSQL relational databases, however similar or same transformations can be used in other relational databases.
Year
DOI
Venue
2011
10.1109/ECBS-EERC.2011.14
ECBS-EERC
Keywords
Field
DocType
popular operating system feature,transaction-time temporal databases,file system,relational database system,snapshot relational database,information system,relational databases,automatic database schema extension,temporal database,automatic transformation,postgresql relational databases,temporal databases,indexation,tv,sql,operating system,transaction time,operating systems,computational complexity,relational database,indexes
Relational database,Information retrieval,Database model,Computer science,Database schema,Database design,Relational database management system,Information schema,Database theory,Relational model,Database
Conference
Citations 
PageRank 
References 
0
0.34
0
Authors
2
Name
Order
Citations
PageRank
Ján Máté100.68
Jirí Safarík2236.29