Temporal data warehouse logical modelling

Georgia Garani, George K. Adam and Dimitrios Ventzas

International Journal of Data Mining, Modelling and Management, 2016, vol. 8, issue 2, 144-159

Abstract: Temporal data warehouses (TDWs) have been developed for the management of time-varying data in dimensions. This paper presents a new approach for the logical modelling of TDWs. The novel design is based on the integration of two schemata, the star schema and the snowflake schema, to the temporal starnest schema. Time in the temporal starnest schema is not treated as another dimension but as time attributes in every temporal dimension, i.e., dimension tables dependent on time. Time manipulation functions for the treatment of time attributes are provided in the query language. The temporal starnest schema proposed in this paper expresses naturally hierarchy levels by the clustering of data in nested tables, with resulting description of aggregation levels for a dimension in a natural way. The proposed extension is applied to a TDW for accident monitoring in crossroads where the expressive power of the model is exemplified with several temporal queries expressed in a suitable extension of SQL standard.

Keywords: temporal data warehouses; TDW; temporal databases; valid time; logical modelling; starnest schema; nested relations; temporal nested dimension; hierarchy; transaction times; temporal queries; data management; time-varying data; accident monitoring; crossroads; road traffic accidents. (search for similar items in EconPapers)
Date: 2016
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.inderscience.com/link.php?id=77156 (text/html)
Access to full text is restricted to subscribers.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:ids:ijdmmm:v:8:y:2016:i:2:p:144-159

Access Statistics for this article

More articles in International Journal of Data Mining, Modelling and Management from Inderscience Enterprises Ltd
Bibliographic data for series maintained by Sarah Parker ().