A New Optimized Model to Handle Temporal Data using Open Source Database
- Resource Type
- article
- Authors
- KUMAR, S.; RISHI, R.
- Source
- Advances in Electrical and Computer Engineering, Vol 17, Iss 2, Pp 55-60 (2017)
- Subject
- indexing
object oriented databases
open source software
query processing
runtime
Electrical engineering. Electronics. Nuclear engineering
TK1-9971
Computer engineering. Computer hardware
TK7885-7895
- Language
- English
- ISSN
- 1582-7445
1844-7600
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.