2001jiis I. Goralwalla, Y. Leontiev, M. T. Özsu, D. Szafron and C. Combi, Temporal Granularity: Completing the Puzzle, Journal of Intelligent Information Systems, 16 (1), January 2001, pp. 41-63. abstract or pdf.

Granularity is an integral feature of both anchored (e.g., 25 October 1995; July 1996) and unanchored (e.g., 3 minutes, 6hours 20 minutes, 5days) temporal data. In supporting temporal data that is specied in dierent granularities, 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. 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. We show how unanchored temporal data is represented, give procedures for converting the data to a given granularity, provide canonical forms for the data, and describe how operations between the data are performed. We alsoshow how anchored temporal data is represented at dierent granularities and give the semantics of operations on anchored temporal data.