Extending the relational algebra to support transaction time

Edwin McKenzie; Richard Snodgrass

doi:10.1145/38713.38761

Extending the relational algebra to support transaction time

Research output: Contribution to journal › Conference article › peer-review

Abstract

In this paper we discuss extensions to the conventional relational algebra to support transaction time. We show that these extensions are applicable to historical algebras that support valid time, yielding a temporal algebraic language. Since transaction time concerns the storage of information in the database, the notion of state is central. The extensions are formalized using denotational semantics. The additions preserve the useful properties of the conventional relational algebra.

Original language	English (US)
Pages (from-to)	467-478
Number of pages	12
Journal	Proceedings of the ACM SIGMOD International Conference on Management of Data
DOIs	https://doi.org/10.1145/38713.38761
State	Published - 1987
Externally published	Yes
Event	1987 ACM SIGMOD International Conference on Management of Data, SIGMOD 1987 - San Francisco, United States Duration: May 27 1987 → May 29 1987

ASJC Scopus subject areas

Software
Information Systems

Access to Document

10.1145/38713.38761

Cite this

@article{7bb63924e8594520bc0107d35d6f46b6,

title = "Extending the relational algebra to support transaction time",

abstract = "In this paper we discuss extensions to the conventional relational algebra to support transaction time. We show that these extensions are applicable to historical algebras that support valid time, yielding a temporal algebraic language. Since transaction time concerns the storage of information in the database, the notion of state is central. The extensions are formalized using denotational semantics. The additions preserve the useful properties of the conventional relational algebra.",

author = "Edwin McKenzie and Richard Snodgrass",

note = "Publisher Copyright: {\textcopyright} 1987 ACM.; 1987 ACM SIGMOD International Conference on Management of Data, SIGMOD 1987 ; Conference date: 27-05-1987 Through 29-05-1987",

year = "1987",

doi = "10.1145/38713.38761",

language = "English (US)",

pages = "467--478",

journal = "Proceedings of the ACM SIGMOD International Conference on Management of Data",

issn = "0730-8078",

publisher = "Association for Computing Machinery (ACM)",

}

TY - JOUR

T1 - Extending the relational algebra to support transaction time

AU - McKenzie, Edwin

AU - Snodgrass, Richard

PY - 1987

Y1 - 1987

N2 - In this paper we discuss extensions to the conventional relational algebra to support transaction time. We show that these extensions are applicable to historical algebras that support valid time, yielding a temporal algebraic language. Since transaction time concerns the storage of information in the database, the notion of state is central. The extensions are formalized using denotational semantics. The additions preserve the useful properties of the conventional relational algebra.

AB - In this paper we discuss extensions to the conventional relational algebra to support transaction time. We show that these extensions are applicable to historical algebras that support valid time, yielding a temporal algebraic language. Since transaction time concerns the storage of information in the database, the notion of state is central. The extensions are formalized using denotational semantics. The additions preserve the useful properties of the conventional relational algebra.

UR - http://www.scopus.com/inward/record.url?scp=85142657198&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85142657198&partnerID=8YFLogxK

U2 - 10.1145/38713.38761

DO - 10.1145/38713.38761

M3 - Conference article

AN - SCOPUS:85142657198

SN - 0730-8078

SP - 467

EP - 478

JO - Proceedings of the ACM SIGMOD International Conference on Management of Data

JF - Proceedings of the ACM SIGMOD International Conference on Management of Data

T2 - 1987 ACM SIGMOD International Conference on Management of Data, SIGMOD 1987

Y2 - 27 May 1987 through 29 May 1987

ER -

Extending the relational algebra to support transaction time

Abstract

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this