Nested Bitemporal Relational Algebra

Tansel, Abdullah Uz; Atay, Canan Eren

doi:10.1007/11902140_66

Cited by 14 publications

(10 citation statements)

References 14 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…The standard query language SQL3 includes object-relational features that can serve as built-in temporal semantics, and which, therefore, provide a robust platform for implementing temporal databases. Commercial object-relational database systems implement some features of SQL3 and provide readily available platforms to test the concepts developed in [1].…”

Section: Resultsmentioning

confidence: 99%

See 1 more Smart Citation

BtSQL: nested bitemporal relational database query language

Atay¹,

Tansel²

2014

Turk J Elec Eng & Comp Sci

Self Cite

View full text Add to dashboard Cite

Abstract:A nested bitemporal relational data model and its query language are implemented. The bitemporal atom (BTA) is the fundamental construct to represent temporal data and it contains 5 components: a value, the lower and upper bounds of valid time, and the lower and upper bounds of the recoding time. We consider 2 types of data structures for storing BTAs: 1) string representation and 2) abstract data-type representation. We also develop a preprocessor for translating a bitemporal structured query language (BtSQL) statement into standard SQL statements. The BtSQL includes the select, insert, delete, and update statements of the SQL, extended for bitemporal relational databases. It supports bitemporal, historical, and current context. Bitemporal context is for auditing purposes, historical context is for querying past states of a bitemporal database, and current context is for querying the snapshot state of a bitemporal database. We also evaluate the performance of the 2 alternative implementation methods by considering retrieval, insertion, and update queries.

show abstract

Section: Resultsmentioning

confidence: 99%

“…The order of a nested bitemporal relation scheme is one more than the order of its tuple scheme. The inductive definition of bitemporal tuple and nested bitemporal relation schemes are given in [1].…”

Section: Nested Bitemporal Relation Schemesmentioning

confidence: 99%

BtSQL: nested bitemporal relational database query language

Atay¹,

Tansel²

2014

Turk J Elec Eng & Comp Sci

Self Cite

View full text Add to dashboard Cite

show abstract

“…A Calculus and Algebra are also defined. The approach in [12] is extended in [13], in order to support nested bitemporal relations, in which valid and transaction time are incorporated at the attribute level.…”

Section: Period-stamped Temporalmentioning

confidence: 99%

Period-Stamped Temporal Models

Lorentzos¹

2016

Encyclopedia of Database Systems

View full text Add to dashboard Cite

show abstract

“…Bitemporal algebra operations are more complicated than temporal algebras that support one time dimension only [1,8,15]. A bitemporal algebra includes both forms of the slice operation in addition to other algebraic operations.…”

Section: Bitemporal Relational Algebrasmentioning

confidence: 99%