An Efficient and Robust Tuple Timestamp Hybrid Historical Relational Data Model

Main Article Content

Lalit Gandhi
Rahul Rishi
Sonia Sharma


This paper proposes a novel, efficient and robust tuple time stamped hybrid historical relational model for dealing with temporal data. The primary goal of developing this model is to make it easier to manage historical data robustly with minimal space requirements and retrieve it more quickly and efficiently. The model's efficiency and results were revealed when it was applied to an employee database. The proposed model's performance in terms of query execution time and space requirements is compared to a single relational data model. The obtained results show that the proposed model is approximately 20% faster than the conventional single relational data model. Memory consumption results also show that the proposed model's memory cost at different frequencies is significantly reduced, which is approximately 30% less than the single relational data model for a set of queries. Because net cost is strongly related to query execution time and memory cost, the suggested model's net cost is also significantly reduced. The proposed tuple timestamp hybrid historical model acts as generic, accurate and robust model. It provides the same functionality as previous versions, as well as hybrid functionality of previously proposed models, with a significant improvement in query execution speed and memory usage. This model is effective and reliable for the use in a wide range of temporal database fields, including insurance, geographic information systems, stocks and finance (e.g. Finacle in Banking), data warehousing, scientific databases, legal case histories, and medical records.

Article Details

How to Cite
Gandhi, L. ., Rishi, R. ., & Sharma, S. . (2023). An Efficient and Robust Tuple Timestamp Hybrid Historical Relational Data Model. International Journal on Recent and Innovation Trends in Computing and Communication, 11(3), 01–10.


Bohlen, Michael H., Renato Busatto, and Christian S. Jensen. "Point-versus interval-based temporal data models." In Proceedings 14th international conference on data engineering, pp. 192-200. IEEE, 1998. doi: 10.1109/ICDE.1998.655777.

Sevilla-Lara, L., Zha S., Yan Z., Goswami V., Feiszli M., Torresani L. “Only Time Can Tell: Discovering Temporal Data for Temporal Modeling” Proceedings of the IEEE/CVF Winter Conference on Applications of Computer Vision (WACV), 2021, pp. 535-544

Snodgrass, Richard T. "A Case Study of Temporal Data." Teradata Corporation, 2010.

Kumar, Shailender, Rahul Rishi, and Rupender Duggal. "Implementation of temporal functionality in objects with role model (TF-ORM)." In 2016 1st India International Conference on Information Processing (IICIP), pp. 1-5. IEEE, 2016. 10.1109/IICIP.2016.7975368

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. doi:10.1016/j.datak.2004.07.001

Burney, Aqil, Nadeem Mahmood, and Kamran Ahsan. "Tempr-pdm: a conceptual temporal relational model for managing patient data." In Proc. Int. WSEAS conference AIKED, pp. 237-243. 2010.

Yang, C., Wang, X., Zhang, M., Zheng, R., Wei, W., & Lou, Y., "Standardization on bitemporal information representation in BCDM," IEEE International Conference on Information and Automation, 2015, pp. 2052-2057. doi: 10.1109/ICInfA.2015.7279627

Gandhi, Lalit. "Literature survey of temporal data models." International Journal of Latest Trends in Engineering and Technology 8, no. 4-1 (2017): 294-300.

Kunzner, F., & Petkovic, D. “A Comparison of Different Forms of Temporal Data Management”. Springer International Publishing International Conference: Beyond Databases, Architectures and Structures, pp 92-106, 2015. doi:10.1007/978-3-319-18422-7­_8.

Zemke, Fred. "What’s new in SQL: 2011," ACM SIGMOD Record 41.1, pp. 67-73, 2012.

Jensen, Christian S., Michael D. Soo, and Richard T. Snodgrass. "Unifying temporal data models via a conceptual model." Information Systems 19, no. 7, pp. 513-547, 1994. doi: 10.1016/0306-4379(94)90013-2.

Gadia, Shashi K., and Chuen-Sing Yeung. "A generalized model for a relational temporal database." In ACM SIGMOD Record, vol. 17(3), pp. 251-259, ACM, 1988. doi: 10.1145/971701.50233.

Edelweiss, Nina, Patrícia Nogueira Hubler, Mirella Moura Moro, and Giovani Demartini. "A temporal database management system implemented on top of a conventional database." In Proceedings 20th International Conference of the Chilean Computer Science Society, pp. 58-67. IEEE, 2000. 10.1109/SCCC.2000.890392

Alromema, Nashwan. "Retrieval optimization technique for tuple timestamp historical relation temporal data model." Journal of Computer Science 8, no. 2 (2012): 243-250.

S.Kumar, R.Rishi “A New Optimized Model to Handle Temporal Data using Open Source Database”, Advances in Electrical and Computer Engineering, Volume 17, Number 2, 2017

C. S. Jensen, R. T. Snodgrass, “Temporal data management,” IEEE Transactions on Knowledge and Data Engineering,11(1):36-44, 1999. doi:10.1109/69.755613.

R. Elmasri and S.Navathe, "Fundamentals of Database Systems", Benjamin/Cummings 2012

Kvet, Michal, Karol Matiaško, and Monika Vajsová. "Sensor based transaction temporal database architecture." In 2015 IEEE World Conference on Factory Communication Systems (WFCS), pp. 1-8. IEEE, 2015. DOI: 10.1109/WFCS.2015.7160547

Ali, Noraida Haji, and Sumazly Sulaiman. "Managing News Archive Using Temporal Data Modeling." Journal of Applied Sciences 12, no. 3 (2012): 284-288.

Krause, Josua, Adam Perer, and Harry Stavropoulos. "Supporting iterative cohort construction with visual temporal queries." IEEE Transactions on visualization and computer graphics 22(1), pp. 91-100, 2016. doi: 10.1109/TVCG.2015.2467622.

Kumar, Shailender, and Rahul Rishi. "Retrieval of meteorological data using temporal data modeling." Indian Journal of Science and Technology 9, no. 37 (2016). DOI: 10.17485/ijst/2016/v9i37/99875.

Christy, A., and G. Meera Gandhi. "Combining bitemporal conceptual data model with multiway join relations for forecasting." Procedia Computer Science 57 (2015): 1104-1114.

Wang W., Peng X., Qiao Y., Cheng J. “An empirical study on temporal modeling for online action detection” Complex & Intelligent Systems (2022) 8:1803–1817

Petkovic, Dusan. "Temporal Data in Relational Database Systems: A Comparison." New Advances in Information Systems and Technologies. Springer International Publishing, pp. 13-23, 2016. doi: 10.1007/978-3-319-31232-3_2.

Atay, Canan. "A comparison of attribute and tuple time stamped bitemporal relational data models." (2010). Int Conf on Applied Computer Science. 2010: 479-89.

Anselma, L., Terenziani, P., & Snodgrass, R. T. “Valid-time indeterminacy in temporal relational databases: Semantics and representations”. IEEE Transactions on Knowledge and Data Engineering, 25(12), pp. 2880-2894, 2013. doi: 10.1109/TKDE.2012.199.

Terenziani, Paolo. "Irregular indeterminate repeated facts in temporal relational databases." IEEE Transactions on Knowledge and Data Engineering 28, no. 4 (2015): 1075-1079. doi: 10.1109/TKDE.2015.2509976.

AL-romema, Nashwan. "Memory storage issues of temporal database applications on relational database management systems." Journal of Computer Science 6, no. 3 (2010).

Murugan, K., and T. Ravichandran. "Intelligent query processing in temporal database using efficient context free grammar." Indian Journal of Science and Technology 5, no. 6 (2012): 1-6.

Congdon P., “A spatio-temporal autoregressive model for monitoring and predicting COVID infection rates” Journal of Geographical Systems (2022)

Gandhi, L., Rishi R., Sharma S., Wawale S.G., Chweya R. “Air quality data acquisition through temporal data modeling” Hindawi Mathematical Problems in Engineering.