Comparison of different temporal data warehouses approaches

Data warehouses are mainly used for business data analysis by querying and reporting huge collections of data. For the management of historical data, temporal data warehouses have been developed. Two current approaches for dealing with temporal data in data warehouses are compared in this paper, Obj...

Full description

Saved in:
Bibliographic Details
Published inThe online journal of science and technology Vol. 7; no. 2; pp. 17 - 27
Main Authors Atay,Canan Eren, Garani,Georgia
Format Journal Article
LanguageEnglish
Published Sakarya Üniversitesi Yayınları 01.04.2017
Subjects
Bilim-Teknoloji
İstanbul
Türkiye
Starnest Schema
Data Warehouse
Object-Relational Model
Temporal Data Warehouse
Online AccessGet full text

Cover

More Information
Summary:Data warehouses are mainly used for business data analysis by querying and reporting huge collections of data. For the management of historical data, temporal data warehouses have been developed. Two current approaches for dealing with temporal data in data warehouses are compared in this paper, Object-Relational Temporal Data Warehouse (ORTDW) model and Starnest Temporal Data Warehouse (S-TDW) model. The O-RTDW model enables data values to be associated with facts, and specifies when facts are valid, thereby providing a complete history of the data values and their changes. To accurately and completely store all data changes, the valid time should be kept at the attribute level. On the other hand, the S-TDW model uses the starnest schema for the modeling of time-varying data in dimensions. The temporal starnest schema expresses naturally hierarchy levels by the clustering of data in nested tables, with result the description of aggregation levels for a dimension in a natural way. By comparing these two temporal data warehouses models, object-oriented and nesting approaches are also compared and evaluated.
ISSN:2146-7390
2146-7390