A 1NF temporal relational model and algebra coping with valid-time temporal indeterminacy

Loading...
Thumbnail Image
File version

Accepted Manuscript (AM)

Author(s)
Anselma, Luca
Piovesan, Luca
Terenziani, Paolo
Griffith University Author(s)
Primary Supervisor
Other Supervisors
Editor(s)
Date
2016
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

Collections