Comprehensive insights into bitemporal databases: a PRISMA-guided systematic literature review

Neelamegam, Gokul and Bhogal, Jagdev and Samimi, Parnia and Ozturkoglu, Omer (2026) Comprehensive insights into bitemporal databases: a PRISMA-guided systematic literature review. Journal of Data, Information and Management, 8 (2). pp. 71-96. ISSN 2524-6356

Preview

Text s42488-026-00162-x.pdf - Published Version Available under License Creative Commons Attribution. Download (2MB)

Abstract

Conventional databases support either retroactive or proactive changes, but not both simultaneously, resulting in the loss of valuable historical data. Bitemporal databases resolve this problem by supporting two temporal dimensions simultaneously: valid time and transaction time. This approach enhances data integrity and traceability in real-world applications. Although numerous studies have examined bitemporal databases, a comprehensive review of the field is still lacking. Therefore, we conducted a hybrid systematic literature review following the PRISMA framework, supplemented by bibliometric and scientometric analyses, covering publications from January 1995 to January 2026. Four main databases were chosen: IEEE, Scopus, ProQuest, and Web of Science. Subsequently, 54 papers were analysed, providing unique insights into bitemporal data modelling, querying, and applications. Key gaps identified include the need for hybrid Data Base Management System (DBMS) infrastructures, limited empirical validation on industrial-scale datasets, insufficient cloud-native temporal optimisation strategies, and underdeveloped integration of bitemporal data structures with AI-driven predictive analytics. Finally, this study summarises current progress in bitemporal database research, highlights key implementation challenges, and emphasises its strong potential to improve data accuracy, traceability, and temporal consistency across diverse application areas.

Item Type:	Article
Identification Number:	10.1007/s42488-026-00162-x
Dates:	Date Event 11 May 2026 Published 25 April 2026 Accepted
Uncontrolled Keywords:	Bitemporal data, Systematic literature review, PRISMA, Bibliometric analysis, Data integrity
Subjects:	CAH11 - computing > CAH11-01 - computing > CAH11-01-01 - computer science
Divisions:	Architecture, Built Environment, Computing and Engineering > Computer Science
Depositing User:	Gemma Tonks
Date Deposited:	18 Aug 2026 13:41
Last Modified:	18 Aug 2026 13:41
URI:	https://www.open-access.bcu.ac.uk/id/eprint/17171

Actions (login required)

View Item