Maintaining Dimension's History in Data Warehouses Effectively

Atay C. E., Garani G.

INTERNATIONAL JOURNAL OF DATA WAREHOUSING AND MINING, cilt.15, sa.3, ss.46-62, 2019 (SCI-Expanded) identifier identifier

  • Yayın Türü: Makale / Tam Makale
  • Cilt numarası: 15 Sayı: 3
  • Basım Tarihi: 2019
  • Doi Numarası: 10.4018/ijdwm.2019070103
  • Dergi Adı: INTERNATIONAL JOURNAL OF DATA WAREHOUSING AND MINING
  • Derginin Tarandığı İndeksler: Science Citation Index Expanded (SCI-EXPANDED), Scopus
  • Sayfa Sayıları: ss.46-62
  • Anahtar Kelimeler: Data Warehouse, Object-Relational, Slowly Changing Dimension, Temporal Data Warehouse, SLOWLY CHANGING DIMENSIONS
  • Dokuz Eylül Üniversitesi Adresli: Evet

Özet

A data warehouse is considered a key aspect of success for any decision support system. Research on temporal databases have produced important results in this field, and data warehouses, which store historical data, can clearly benefit from such studies. A slowly changing dimension is a dimension in which any of its attributes in a data warehouse can change infrequently over time. Although different solutions have been proposed, each has its own particular disadvantages. The authors propose the Object-Relational Temporal Data Warehouse (O-RTDW) model for the slowly changing dimensions in this research work. Using this approach, it is possible to keep track of the whole history of an object in a data warehouse efficiently. The proposed model has been implemented on a real data set and tested successfully. Several limitations implied in other solutions, such as redundancy, surrogate keys, incomplete historical data, and creation of additional tables are not present in our solution.