|2/2017 - 8|
A New Optimized Model to Handle Temporal Data using Open Source DatabaseKUMAR, S. , RISHI, R.
|View the paper record and citations in|
|Click to see author's profile in SCOPUS, IEEE Xplore, Web of Science|
|Download PDF (1,184 KB) | Citation | Downloads: 849 | Views: 2,484|
indexing, object oriented databases, open source software, query processing, runtime
temporal(17), data(15), relational(7), databases(7), systems(6), information(6), database(6), object(5), time(4), science(4)
Blue keywords are present in both the references section and the paper title.
About this article
Date of Publication: 2017-05-31
Volume 17, Issue 2, Year 2017, On page(s): 55 - 60
ISSN: 1582-7445, e-ISSN: 1844-7600
Digital Object Identifier: 10.4316/AECE.2017.02008
Web of Science Accession Number: 000405378100008
SCOPUS ID: 85020110475
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.
|References|||||Cited By «-- Click to see who has cited this paper|
| F. Kunzner, D. Petkovic, "A comparison of different forms of temporal data management," Beyond Databases, Architectures and Structures. Springer International Publishing, pp 92-106, 2015. |
[CrossRef] [Web of Science Times Cited 3] [SCOPUS Times Cited 9]
 S. M. Halawani, N. A. Al-Romema, "Retrieval optimization technique for tuple timestamp historical relation temporal data model," Journal of Computer Science 8.2, pp 243-250, 2012.
 R. D. M. Galante, C. S. D. Santos, N. Edelweiss, A. F. Moreira, "Temporal and versioning model for schema evolution in object-oriented databases," Data & Knowledge Engineering, pp 99-128, May, 2005.
[CrossRef] [Web of Science Times Cited 22] [SCOPUS Times Cited 36]
 C. Atay, "An attribute or tuple timestamping in bitemporal relational databases," Turkish Journal of Electrical Engineering & Computer Science, pp 4305-4321, 2016.
[CrossRef] [Web of Science Times Cited 4] [SCOPUS Times Cited 5]
 M. Kvet, K. Matiasko, M. Vajsova, "Sensor based transaction temporal database architecture," in IEEE World Conference on Factory Communication Systems (WFCS), 2015.
[CrossRef] [SCOPUS Times Cited 7]
 J. Mate, J. Safarik, "Transformation of relational databases to transaction-time temporal databases," 2nd Eastern European Regional Conference on the Engineering of Computer Based Systems (ECBS-EERC), 201.
[CrossRef] [Web of Science Times Cited 6] [SCOPUS Times Cited 17]
 I. A. Goralwalla, M. T. Ozsu, D. Szafron. "A framework for temporal data models: exploiting object-oriented technology," Proc. of IEEE TOOLS 23 on Technology of Object-Oriented Languages and Systems, 1997.
[CrossRef] [Web of Science Record]
 C. S. Jensen, R. T. Snodgrass, "Temporal data management," IEEE Transactions on Knowledge and Data Engineering, pp 36-44, 1999.
[CrossRef] [Web of Science Times Cited 134] [SCOPUS Times Cited 188]
 N. Edelweiss, P. N. Hubler, M. M. Moro, G. Demartine, "A temporal database management system implemented on top of a conventional database," Proc. XX IEEE International Conference of the Chilean Computer Science Society, 2000.
[CrossRef] [Web of Science Times Cited 7] [SCOPUS Times Cited 13]
 C. Yang et al., "Standardization on bitemporal information representation in BCDM," IEEE International Conference on Information and Automation, 2015, pp. 2052-2057.
[CrossRef] [SCOPUS Times Cited 3]
 A. U. Tansel, "On handling time-varying data in the relational data model," Information and Software Technology, pp 119-126, 2004.
[CrossRef] [Web of Science Times Cited 9] [SCOPUS Times Cited 11]
 V. T. N. Chau, S. Chittayasothorn, "A temporal compatible object relational database system," in Proc. of IEEE SoutheastCon, 2007.
[CrossRef] [SCOPUS Times Cited 10]
 L. Anselma, P. Terenziani, R. T. Snodgrass, "Valid-time indeterminacy in temporal relational databases: Semantics and representations," IEEE Transactions on Knowledge and Data Engineering, pp. 2880-2894, Dec. 2013.
[CrossRef] [Web of Science Times Cited 13] [SCOPUS Times Cited 21]
 C. S. Jensen, R. T. Snodgrass, "Semantics of time-varying information," Information Systems, pp 311-352, June, 1996.
[CrossRef] [Web of Science Times Cited 51] [SCOPUS Times Cited 70]
 S. M. Halawani, N. A. Al-Romema, "Memory storage issues of temporal database applications on relational database management systems," Journal of Computer Science, pp 296-304, 2010.
 M. H. Bohlen, R. Busatto, C. S. Jensen. "Point-versus interval-based temporal data models," in Proc. of 14th IEEE International Conference on Data Engineering, 1998.
[CrossRef] [Web of Science Times Cited 41]
 N. Edelweiss, J. P. M. Oliveira, B. Pernici, "An object-oriented temporal model," International Conference on Advanced Information Systems Engineering, Springer Berlin Heidelberg, 1993, pp. 397-415.
 M. Pomarlan, "Visibility-based planners for mobile robots capable to handle path existence queries in temporal logic," Advances In Electrical and Computer Engineering, pp 55-64, Feb. 2014.
[CrossRef] [Full Text] [Web of Science Times Cited 1] [SCOPUS Times Cited 1]
 M. Kaufmann et al., "Bi-temporal Timeline Index: A data structure for processing queries on bi-temporal data," 31st IEEE International Conference on Data Engineering, 2015.
[CrossRef] [SCOPUS Times Cited 23]
 P. Terenziani, "Irregular indeterminate repeated facts in temporal relational databases," IEEE Transactions on Knowledge and Data Engineering, pp 1075-1079, Apr. 2016.
[CrossRef] [Web of Science Times Cited 5] [SCOPUS Times Cited 9]
Web of Science® Citations for all references: 296 TCR
SCOPUS® Citations for all references: 423 TCR
Web of Science® Average Citations per reference: 14 ACR
SCOPUS® Average Citations per reference: 20 ACR
TCR = Total Citations for References / ACR = Average Citations per Reference
We introduced in 2010 - for the first time in scientific publishing, the term "References Weight", as a quantitative indication of the quality ... Read more
Citations for references updated on 2023-09-27 20:33 in 106 seconds.
Note1: Web of Science® is a registered trademark of Clarivate Analytics.
Note2: SCOPUS® is a registered trademark of Elsevier B.V.
Disclaimer: All queries to the respective databases were made by using the DOI record of every reference (where available). Due to technical problems beyond our control, the information is not always accurate. Please use the CrossRef link to visit the respective publisher site.
Faculty of Electrical Engineering and Computer Science
Stefan cel Mare University of Suceava, Romania
All rights reserved: Advances in Electrical and Computer Engineering is a registered trademark of the Stefan cel Mare University of Suceava. No part of this publication may be reproduced, stored in a retrieval system, photocopied, recorded or archived, without the written permission from the Editor. When authors submit their papers for publication, they agree that the copyright for their article be transferred to the Faculty of Electrical Engineering and Computer Science, Stefan cel Mare University of Suceava, Romania, if and only if the articles are accepted for publication. The copyright covers the exclusive rights to reproduce and distribute the article, including reprints and translations.
Permission for other use: The copyright owner's consent does not extend to copying for general distribution, for promotion, for creating new works, or for resale. Specific written permission must be obtained from the Editor for such copying. Direct linking to files hosted on this website is strictly prohibited.
Disclaimer: Whilst every effort is made by the publishers and editorial board to see that no inaccurate or misleading data, opinions or statements appear in this journal, they wish to make it clear that all information and opinions formulated in the articles, as well as linguistic accuracy, are the sole responsibility of the author.