A Comparison of attribute and tuple time stamped bitemporal relational data models

Atay C. E.

International Conference on Applied Computer Science, ACS, Malta, 15 - 17 Eylül 2010, ss.479-489 identifier

  • Yayın Türü: Bildiri / Tam Metin Bildiri
  • Cilt numarası:
  • Basıldığı Ülke: Malta
  • Sayfa Sayıları: ss.479-489
  • Anahtar Kelimeler: Attribute time stamping, Bitemporal database, Bitemporal query, Model comparison, Object relational database system
  • Dokuz Eylül Üniversitesi Adresli: Evet

Özet

This paper is indented to facilitate the implementation and evaluation of bitemporal database models by presenting queries with a time component. Time-varying data management has been much taken into consideration with either the attribute or tuple time stamping schema. While the first approach attaches bitemporal data to attributes, the second one splits the object's history into several tuples. Although there have been extensive research on bitemporal data models, it is hard to find model comparisons in ease of use and system performance. In this paper, we have compared interval-based attribute and tuple time stamped bitemporal data models, measured system performance in terms of disk block accesses and evaluated their usability using the same data and same queries for both approaches. Our tests indicate that attribute time stamping model is more appropriate to model bitemporal data.1.