ÇİFT ZAMANLI İLİŞKİSEL VERİTABANI YÖNETİMİ SİSTEMLERİ ÜZERİNE BİR UYGULAMA AN IMPLEMANTATION OF BITEMPORAL RELATIONAL DATABASE MANAGEMENT SYSTEMS

Bu makale birden fazla seviyede icice gecmisligi mumkun kilan cift zamanli iliskisel veri modelinin uygulanma arastirmasini icerir. Zamansal veriyi betimlemenin temel yapisi olan Cift Zamanli Atom bes bolumden olusur; olay zamani periyodu, bu verinin veri tabanina islenme zaman donemlerinin alt ve ust sinirlari ve yeni veri degeri. Cift zamanli veri ozniteliklerde bulunmaktadir ve soyut veri tipi olarak uygulanmistir. Icice gecmis cift zamanli veri modeli yonetimi icin ornekler, modelin ozelliklerini gostermek icin sorgulamalar sunulmustur. Ornek uygulama modelin yapilabilirligini gostermek icin nesnesel-iliskisel veri tabani sisteminde tamamlanmistir. This paper presents an implementation of a nested bitemporal relational data model that allows more than one level of nesting. The fundamental construct for representing temporal data is a Bitemporal Atom (BTA) that consists of five parts: valid time period, the time periods' lower and upper bounds this data is recorded in the database and a value. Bitemporal data is attached to attributes and applied as an abstract data type. A number of examples of the management of nested bitemporal data model and queries to demonstrate the features of the model are provided. A prototype implementation has been completed in an object-relational database system to demonstrate the feasibility of the model. Anahtar kelimeler: Zamansal veri tabani, Cift zamanli veri tabani, Sutun zaman etiketleme, Satir zaman etiketleme, Cift zamanli sorgulama.

[1]  Albert Croker,et al.  The historical relational data model (HRDM) and algebra based on lifespans , 1986, 1987 IEEE Third International Conference on Data Engineering.

[2]  Michael Stonebraker,et al.  Object-Relational DBMSs: Tracking the Next Great Wave , 1998 .

[3]  Shashi K. Gadia,et al.  Relational Database Systems with Zero Information Loss , 1993, IEEE Trans. Knowl. Data Eng..

[4]  Fusheng Wang,et al.  XBiT: An XML-Based Bitemporal Data Model , 2004, ER.

[5]  Shashi K. Gadia,et al.  A homogeneous relational model and query languages for temporal databases , 1988, TODS.

[6]  Canan Eren Atay,et al.  Nested Bitemporal Relational Algebra , 2006, ISCIS.

[7]  Jennifer Widom,et al.  TIP: a temporal extension to Informix , 2000, SIGMOD 2000.

[8]  James F. Allen.  Maintaining knowledge about temporal intervals , 1983, CACM.

[9]  Angelo Montanari,et al.  The t4sql temporal query language , 2007, CIKM '07.

[10]  S. Chittayasothorn,et al.  A temporal compatible object relational database system , 2007, Proceedings 2007 IEEE SoutheastCon.

[11]  Albert Croker,et al.  On completeness of historical relational query languages , 1991, TODS.

[12]  Richard T. Snodgrass,et al.  The Temporal Query Language TQuel , 1987, ACM Trans. Database Syst..

[13]  Gultekin Özsoyoglu,et al.  Extending relational algebra and relational calculus with set-valued attributes and aggregate functions , 1987, TODS.

[14]  Fusheng Wang,et al.  Using XML to Build Efficient Transaction-Time Temporal Database Systems on Relational Databases , 2006, 22nd International Conference on Data Engineering (ICDE'06).

[15]  Jaroslav Pokorný,et al.  A Comparison of XML-Based Temporal Models , 2009, SITIS.

[16]  Richard T. Snodgrass,et al.  Performance evaluation of a temporal database management system , 1986, SIGMOD '86.

[17]  Abdullah Uz Tansel,et al.  Temporal Relational Data Model , 1997, IEEE Trans. Knowl. Data Eng..

[18]  Canan Eren Atay,et al.  Bitemporal Databases: Modeling and Implementation , 2009 .

[19]  Abdullah Uz Tansel,et al.  Adding time dimension to relational model and extending relational algebra , 1986, Inf. Syst..

[20]  Jim Melton,et al.  Advanced SQL:1999: Understanding Object-Relational and Other Advanced Features , 2002 .

[21]  Shashi K. Gadia.  Ben-Zvi's Pioneering Work in Relational Temporal Databases , 1993, Temporal Databases.

[22]  Abdullah Uz Tansel.  Modelling temporal data , 1990 .