SavedAdd your journal

Journals / Pamukkale Üniversitesi Mühendislik Bilimleri Dergisi / 2014 / Cilt: 20 - Sayı: 2

AN IMPLEMANTATION OF BITEMPORAL RELATIONAL DATABASE MANAGEMENT SYSTEMS

ÇİFT ZAMANLI İLİŞKİSEL VERİTABANI YÖNETİMİ SİSTEMLERİ ÜZERİNE BİR UYGULAMA

Canan Eren ATAY
Pages
54–62
Publication Date
2022-10-18
DOI
—
🏛️Bibliographic metadata and full text access for this article are provided via DergiPark.
DergiPark Record ↗
✨

AI Summary & Key Takeaways

AI Insight
⚡ TL;DR(Too Long; Didn't Read)

A prototype implementation has beencompleted in an object-relational database system to demonstrate thefeasibility of the model.

📌 3 Key Takeaways

🎯
Objective & Hypothesis:This paper presents an implementation of a nested bitemporalrelational data model that allows more than one level of nesting.
📊
Key Findings & Data:A number of examples of the management ofnested bitemporal data model and queries to demonstrate the featuresof the model are provided.
💡
Conclusion & Impact:A prototype implementation has beencompleted in an object-relational database system to demonstrate thefeasibility of the model.
🔬Design:Modeling & Simulation
📍Scope:Comprehensive Sample
⚙️Variables:Domain Parameters

Abstract

This paper presents an implementation of a nested bitemporalrelational data model that allows more than one level of nesting. Thefundamental construct for representing temporal data is a BitemporalAtom (BTA) that consists of five parts: valid time period, the timeperiods’ lower and upper bounds this data is recorded in the databaseand a value. Bitemporal data is attached to attributes and applied asan abstract data type. A number of examples of the management ofnested bitemporal data model and queries to demonstrate the featuresof the model are provided. A prototype implementation has beencompleted in an object-relational database system to demonstrate thefeasibility of the model.

Özet

Bu makale birden fazla seviyede içiçe geçmişliği mümkün kılan çift zamanlı ilişkisel veri modelinin uygulanma araştırmasını içerir. Zamansal veriyi betimlemenin temel yapısı olan Çift Zamanlı Atom beş bölümden oluşur; olay zamanı periyodu, bu verinin veri tabanına işlenme zaman dönemlerinin alt ve üst sınırları ve yeni veri değeri. Çift zamanlı veri özniteliklerde bulunmaktadır ve soyut veri tipi olarak uygulanmıştır. İçiçe geçmiş çift zamanlı veri modeli yönetimi için örnekler, modelin özelliklerini göstermek için sorgulamalar sunulmuştur. Örnek uygulama modelin yapılabilirliğini göstermek için nesnesel-ilişkisel veri tabanı sisteminde tamamlanmıştır.

🔖

Cite This Article

ATAY, C. E. (2022). AN IMPLEMANTATION OF BITEMPORAL RELATIONAL DATABASE MANAGEMENT SYSTEMS. Pamukkale Üniversitesi Mühendislik Bilimleri Dergisi, Cilt: 20 - Sayı: 2, 54–62. https://ajindex.com/articles/587455

📄 Full Text PDF Viewer

📄

PDF görüntüleyici hazırlanıyor...

References (17)

  1. Tansel, A. U., ‘Modeling Temporal Data’, Information and Software Technology, pp. 514-520, 1990
  2. Snodgrass, R., Ahn, I., ‘Performance Evaluation of a Temporal Database Management System’, ACM 1986
  3. Tansel, A. U., Atay, C. E., ‘Nested Bitemporal Relational Algebra’, International Symposium on Computer and Information Sciences, pp. 622-633, 2006
  4. Stonebraker, M., Moore, D., Object-relational DBMSs: Tracking the Next Great Wave, San Francisco, The Morgan Kaufmann Series in Data Management Systems, 1999
  5. Melton, J., Understanding Object-Relational and Other Advanced Features, Morgan Kaufmann Publishers, San Francisco, 2003
  6. Tansel, A. U., Clifford, J., Gadia, S., Jajodia, S., Segev, A., Snodgrass, R., eds., Temporal Databases: Theory, Design, and Implementation, Benjamin/Cummings, 1993
  7. Atay, C. E., Tansel, A. U., Bitemporal Databases: Modeling and Implementation, VDM Verlag, 2009
  8. Gadia, S. K., ‘Ben-Zvi’s Pioneering Work in Relational Temporal Databases’. Chapter 8, pp. 202 – 207. In A. Tansel et al., editors, Temporal Databases, Benjamin/ Cummings, 1993
  9. Snodgrass, R., ‘The Temporal Query Language TQUEL’, ACM Transactions on Database Systems, June 1987
  10. Ozsoyoglu, G., Ozsoyoglu, M.Z., Matos, V., ‘Extending Relational Algebra and Relational Calculus with SetValued Attributes and Aggregate Functions’, ACM Trans. Database Systems, vol. 12, no. 4, pp. 566-592, 1987
  11. Gadia, S. K., ‘A Homogeneous Relational Model and Query Languages for Temporal Databases’, ACM Transactions on Database Systems, December 1988
  12. Clifford, J., Croker, A., ‘The Historical Relational Data Model (HRDM) and Algebra Based on Lifespans’, in Proceedings of the International Conference on Data Engineering. (Los Angeles, Calif.). IEEE Computer Society Press, 1987
  13. Bhargava, G., Gadia, S., ‘Relational Database Systems with Zero Information Loss’, IEEE Transactions on Knowledge and Data engineering, 1993
  14. Tansel, A. U., ‘Temporal Relational Data Model’, IEEE Transactions on Knowledge and Data Engineering, Vol. 9, No. 3, June 1997
  15. Chau, V. T., Chittayasothorn, S., ‘A Temporal Compatible Object Relational Database System’, The IEEE Southeastcon, 2007
  16. Dumas, M., Fauvet, M. C., Scholl, P. C., TEMPOS: A Platform for Developing Temporal Applications on Top of Object DBMS, TKDE, IEEE, 2004
  17. Shasha, D., Zhu, Y., “SpyTime-a Performance Benchmark for Bitemporal Database”, www.cs.nyu.edu/shasha/ spytime/spytime.html, Retrieved D