A 1NF temporal relational model and algebra coping with valid-time temporal indeterminacy
File version
Accepted Manuscript (AM)
Author(s)
Piovesan, Luca
Terenziani, Paolo
Griffith University Author(s)
Primary Supervisor
Other Supervisors
Editor(s)
Date
Size
File type(s)
Location
License
Abstract
In the real world, many phenomena are time related and in the last three decades the database community has devoted much work in dealing with “time of facts” in databases. While many approaches incorporating time in the relational model have been already devised, most of them assume that the exact time of facts is known. However, this assumption does not hold in many practical domains, in which temporal indeterminacy of facts occurs. The treatment of valid-time indeterminacy requires in-depth extensions to the current relational approaches. In this paper, we propose a theoretically grounded approach to cope with this issue, overcoming the limitations of related approaches in the literature. In particular, we present a 1NF temporal relational model and propose a new temporal relational algebra to query it. We also formally study the properties of the new data model and algebra, thus granting that our approach is interoperable with pre-existent temporal and non-temporal relational approaches, and is implementable on top of them. Finally, we consider computational complexity, showing that only a limited overhead is added when moving from determinate to indeterminate time.
Journal Title
Journal of Intelligent Information Systems
Conference Title
Book Title
Edition
Volume
47
Issue
3
Thesis Type
Degree Program
School
Publisher link
Patent number
Funder(s)
Grant identifier(s)
Rights Statement
Rights Statement
© 2016 Springer Netherlands. This is an electronic version of an article published in Journal of Intelligent Information Systems, 2016, 47 (3), pp. 345-374. Journal of Intelligent Information Systems is available online at: http://link.springer.com// with the open URL of your article.
Item Access Status
Note
Access the data
Related item(s)
Subject
Artificial intelligence
Science & Technology
Computer Science, Information Systems
Persistent link to this record
Citation
Anselma, L; Piovesan, L; Terenziani, P, A 1NF temporal relational model and algebra coping with valid-time temporal indeterminacy, Journal of Intelligent Information Systems, 2016, 47 (3), pp. 345-374