Granularity is an integral feature of bothanchored(e.g., 25 October 1995 , July 1996) andunanchored(e.g.,3 minutes, 6 hours 20 minutes , 5 days, 1 week) temporal data. In supporting temporal data that is specified in different gran ularities, numerous approaches have been proposed to deal with the issues of converting temporal data from one granularity to another. The emphasis, however, has only been on granularity conversions with respect to anchored temporal data. This is because a granularity in these approaches i s modeled as an anchoredpartitioning of the time axis, thereby making it difficult to deal with granularity conversions in u anchored temporal data. In this paper we provide a novel approach to the treatment of granularity in temporal data. A granularity is modeled as a special kind of unanchored temporal primitive that can be used as a unit of time. That is, a granularity is modeled as a unit unanchored temporal primitive. Granularities are accommodated within the context of calendarsand granularity conversions are presented and discussed in terms of unanchored durations of time. This allows us to consistently model and operate on unanchored temporal data that is comprised of different and mixed granularities. Specifically, we show how unanchored temporal data is represented, give procedures for converting the data to a given granularity, provide canonical forms for the data, an d describe how operations between the data are performed.
[1]
Nikos A. Lorentzos.
DBMS Support for Nonmetric Measurement Systems
,
1994,
IEEE Trans. Knowl. Data Eng..
[2]
Duane Szafron,et al.
Modeling temporal primitives: back to basics
,
1997,
CIKM '97.
[3]
Duane Szafron,et al.
Temporality in object database management systems
,
1998
.
[4]
Eric J. Topol,et al.
Diagnosing and Managing Unstable Angina, Quick Reference Guide for Clinicians
,
1994
.
[5]
Barbara Pernici,et al.
Automatic deduction of temporal information
,
1992,
TODS.
[6]
Angelo Montanari,et al.
Dealing with Time Granularity in the Event Calculus
,
1992,
FGCS.
[7]
Francesco Pinciroli,et al.
Applying object-oriented technologies in modeling and querying temporally oriented clinical databases dealing with temporal granularity and indeterminacy
,
1997,
IEEE Transactions on Information Technology in Biomedicine.
[8]
James Clifford,et al.
A Simple, General Structure for Temporal Domains
,
1986,
Temporal Aspects in Information Systems.
[9]
Richard T. Snodgrass,et al.
The TSQL2 Temporal Query Language
,
1995
.
[10]
Nikos A. Lorentzos.
DBMS Support for Nonmetric Systems
,
1994
.
[11]
C.E. Dyreson,et al.
Valid-time indeterminacy
,
1993,
Proceedings of IEEE 9th International Conference on Data Engineering.
[12]
Sushil Jajodia,et al.
Logical design for temporal databases with multiple granularities
,
1997,
TODS.