Semantics of time-varying attributes and their use for temporal database design

Christian S. Jensen, Richard Thomas Snodgrass

Research output: Chapter in Book/Report/Conference proceedingConference contribution

3 Citations (Scopus)

Abstract

Based on a systematic study of the semantics of temporal attributes of entities, this paper provides new guidelines for the design of temporal relational databases. The notions of observation and update patterns of an attribute capture when the attribute changes value and when the changes are recorded in the database. A lifespan describes when an attribute has a value. And derivation functions describe how the values of an attribute for all times within its lifespan axe computed from stored values. The implications for temporal database design of the semantics that may be captured using these concepts are formulated as schema decomposition rules.

Original languageEnglish (US)
Title of host publicationLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
PublisherSpringer Verlag
Pages366-377
Number of pages12
Volume1021
ISBN (Print)3540606726, 9783540606727
StatePublished - 1995
Event14th International Conference on Object-Oriented Entity-Relationship, OOER 1995 - Gold Coast, Australia
Duration: Dec 13 1995Dec 15 1995

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume1021
ISSN (Print)03029743
ISSN (Electronic)16113349

Other

Other14th International Conference on Object-Oriented Entity-Relationship, OOER 1995
CountryAustralia
CityGold Coast
Period12/13/9512/15/95

Fingerprint

Temporal Databases
Database Design
Time-varying
Semantics
Attribute
Life Span
Decomposition
Relational Database
Schema
Update
Decompose

ASJC Scopus subject areas

  • Computer Science(all)
  • Theoretical Computer Science

Cite this

Jensen, C. S., & Snodgrass, R. T. (1995). Semantics of time-varying attributes and their use for temporal database design. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) (Vol. 1021, pp. 366-377). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 1021). Springer Verlag.

Semantics of time-varying attributes and their use for temporal database design. / Jensen, Christian S.; Snodgrass, Richard Thomas.

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 1021 Springer Verlag, 1995. p. 366-377 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 1021).

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Jensen, CS & Snodgrass, RT 1995, Semantics of time-varying attributes and their use for temporal database design. in Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). vol. 1021, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 1021, Springer Verlag, pp. 366-377, 14th International Conference on Object-Oriented Entity-Relationship, OOER 1995, Gold Coast, Australia, 12/13/95.
Jensen CS, Snodgrass RT. Semantics of time-varying attributes and their use for temporal database design. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 1021. Springer Verlag. 1995. p. 366-377. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).
Jensen, Christian S. ; Snodgrass, Richard Thomas. / Semantics of time-varying attributes and their use for temporal database design. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 1021 Springer Verlag, 1995. pp. 366-377 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).
@inproceedings{d9ca618526294f8fb5bc757f0c9c35ae,
title = "Semantics of time-varying attributes and their use for temporal database design",
abstract = "Based on a systematic study of the semantics of temporal attributes of entities, this paper provides new guidelines for the design of temporal relational databases. The notions of observation and update patterns of an attribute capture when the attribute changes value and when the changes are recorded in the database. A lifespan describes when an attribute has a value. And derivation functions describe how the values of an attribute for all times within its lifespan axe computed from stored values. The implications for temporal database design of the semantics that may be captured using these concepts are formulated as schema decomposition rules.",
author = "Jensen, {Christian S.} and Snodgrass, {Richard Thomas}",
year = "1995",
language = "English (US)",
isbn = "3540606726",
volume = "1021",
series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",
publisher = "Springer Verlag",
pages = "366--377",
booktitle = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

}

TY - GEN

T1 - Semantics of time-varying attributes and their use for temporal database design

AU - Jensen, Christian S.

AU - Snodgrass, Richard Thomas

PY - 1995

Y1 - 1995

N2 - Based on a systematic study of the semantics of temporal attributes of entities, this paper provides new guidelines for the design of temporal relational databases. The notions of observation and update patterns of an attribute capture when the attribute changes value and when the changes are recorded in the database. A lifespan describes when an attribute has a value. And derivation functions describe how the values of an attribute for all times within its lifespan axe computed from stored values. The implications for temporal database design of the semantics that may be captured using these concepts are formulated as schema decomposition rules.

AB - Based on a systematic study of the semantics of temporal attributes of entities, this paper provides new guidelines for the design of temporal relational databases. The notions of observation and update patterns of an attribute capture when the attribute changes value and when the changes are recorded in the database. A lifespan describes when an attribute has a value. And derivation functions describe how the values of an attribute for all times within its lifespan axe computed from stored values. The implications for temporal database design of the semantics that may be captured using these concepts are formulated as schema decomposition rules.

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

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

M3 - Conference contribution

AN - SCOPUS:70349365656

SN - 3540606726

SN - 9783540606727

VL - 1021

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 366

EP - 377

BT - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

PB - Springer Verlag

ER -