A framework to model real-time databases

TL;DR

This paper presents a comprehensive framework for designing real-time databases, addressing their unique data and transaction timing constraints, supported by a case study demonstrating its practical application.

Contribution

It introduces a novel framework for modeling real-time databases, including fundamental operations and a structural model validated through a case study.

Findings

Framework effectively models real-time database requirements

SQL queries and Java code can be generated from the model

Case study confirms the framework's practical validity

Abstract

Real-time databases deal with time-constrained data and time-constrained transactions. The design of this kind of databases requires the introduction of new concepts to support both data structures and the dynamic behaviour of the database. In this paper, we give an overview about different aspects of real-time databases and we clarify requirements of their modelling. Then, we present a framework for real-time database design and describe its fundamental operations. A case study demonstrates the validity of the structural model and illustrates SQL queries and Java code generated from the classes of the model