Temporal data warehouse logical modelling. (2016)

• Record Type: Journal Article
• Authors: Garani, Georgia; Adam, George K.; Ventzas, Dimitrios
• Is Part Of: International journal of data mining, modelling and management. Volume 8:Number 2(2016)
• Page Start: 144
• Page End: 159
• Publication Date: 2016
• Subjects: 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; Data mining -- Periodicals; Information science -- Periodicals; Databases -- Periodicals; 005.7
• Languages: English
• ISSNs: 1759-1163

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.