A New Optimized Model to Handle Temporal Data using Open Source Database
The majority of the database applications now a days deal with temporal data. Temporal records are known to change during the course of time and facilities to manage the multiple snapshots of these records are generally missing in conventional databases. Consequently, different temporal data model...
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Stefan cel Mare University of Suceava
2017-05-01
|
| Series: | Advances in Electrical and Computer Engineering |
| Subjects: | |
| Online Access: | http://dx.doi.org/10.4316/AECE.2017.02008 |
| Summary: | The majority of the database applications now a days deal with temporal data. Temporal records are known
to change during the course of time and facilities to manage the multiple snapshots of these records are
generally missing in conventional databases. Consequently, different temporal data models have been proposed
and implemented as an extension of the temporal less database systems. In the single relation model, the
present and past instances are stored in a single relation that makes its handling cumbersome and inefficient.
This paper emphasize upon storing the past instances of the records in the multiple historical relations.
The current relations will manage the recent snapshot of data. The tuple time stamping approach is used to
timestamp the temporal records. This paper proposes a temporal model for the management of time varying data
built on the top of conventional open source database. Indexing is used to enhance the performance of the
model. The proposed model is also compared with the single relation model. |
|---|---|
| ISSN: | 1582-7445 1844-7600 |