Real-Time Database Systems: Fundamentals, Architectures and Applications (SpringerBriefs in Computer Science)

✍ Scribed by Pedro Mejia Alvarez, Ricardo J. Zavaleta Vazquez, Susana Ortega Cisneros, Raul E. Gonzalez Torres

• Publisher: Springer
• Year: 2023
• Tongue: English
• Leaves: 126
• Edition: 1
• Category: Library

✦ Synopsis

This book provides an overview of both experimental and commercial real-time database systems (RTDBs) and a systematic approach to understanding, designing, and implementing them.

To this end, the book is composed of four chapters: Chapter 1 “An Overview of Real-Time Database Systems” delves into the realm of RTDBs and discusses the specific requirements, transaction models, and scheduling algorithms that set RTDBs apart from conventional DBMs. Chapter 2 on “Experimental Real-Time Databases” presents various experimental RTDBs developed in academia with their architectures, features, and implementations, while chapter 3 on “Commercial Real-Time Databases” does so for systems developed and offered by commercial vendors as products or services. Eventually, chapter 4 on “Applications of Real-Time Database Systems” showcases various applications of RTDBs across different domains.

This book will help researchers, graduate students and advanced professionals to get an overview of the area and to understand the main challenges and systems available.

✦ Table of Contents

Preface
Contents
Chapter 1 An Overview of Real-Time Database Systems
1.1 Challenges in Real-Time Database Systems
1.2 Soft vs. Hard Real-Time Database Systems
1.3 Contrast with Conventional Database Systems
1.4 Real-Time Database Model
1.4.1 Data and Consistency
1.4.2 Real-Time Database System Transactions
1.5 Real-Time Database System: Transaction and Query Processing
1.5.1 Scheduling Real-Time Transactions
1.6 Admission Control
1.7 Concurrency Control
1.7.1 Priority Inversion in Real-Time Transactions
1.7.2 Locking Concurrency Control Protocols
1.7.3 Optimistic Concurrency Control Protocols
1.7.4 Comparison of Concurrency Control Protocols
1.7.5 Deadlocks in Concurrency Control Protocols
1.8 Real-Time Distributed Databases and Commit Protocols
1.9 Recovery in Real-Time Database Management Systems
1.10 Input/Output Scheduling in Real-Time Database Systems
1.10.1 Feasible Deadline SCAN (FD-SCAN)
1.10.2 Highest Priority Group First (HPGF)
1.10.3 Adaptive Earliest Deadline First (A-EDF)
1.10.4 Adaptive Feasible Deadline SCAN (A-FDSCAN)
1.10.5 Dynamic I/O Scheduling for Real-Time Systems
1.10.6 Machine Learning-based Scheduling
1.10.6.1 Machine Learning-based I/O Scheduler for Real-time Database Systems
1.10.6.2 A Deep Reinforcement Learning-based I/O Scheduler for Real-time Database Systems
1.11 Buffer Management in Real-Time Database Management Systems
1.11.1 Deadline-Driven Page Replacement (DDPR) Algorithm
1.11.2 Priority-Driven Buffer Management (PDBM) Algorithm
1.11.3 Adaptive Real-Time Buffer Management (ARTBM) Algorithm
1.11.3.1 Prediction-Based Buffer Management (PBBM) Algorithm: Detailed Description
1.12 Related Developments
1.12.1 Main-Memory Databases
1.12.2 Real-Time Data Analytics
1.12.3 Time-Series Databases
1.12.4 NoSQL Databases
Chapter 2 Experimental Real-Time Databases
2.1 STRIP
2.1.1 STRIP Real-Time Scheduling
2.1.2 Data Sharing Architecture
2.1.3 Streams Support
2.1.4 View Definition
2.2 BeeHive Real-Time Database
2.2.1 Beehive Architecture
2.2.2 Beehive Real-Time Scheduling
2.2.3 General Beehive Design
2.2.4 Native BeeHive Design
2.3 RTSORAC: A Real-Time Object-Oriented Database Model
2.3.1 RTSORAC Model
2.3.2 Real-time Scheduling Characteristics in RTSORAC
2.3.3 Architecture of RTSORAC
2.4 The COMET approach
2.4.1 Components and Aspects
2.4.2 Aspect Packages
2.5 Feedback Control-Based QoS Management on Real-Time Databases
2.5.1 Feedback Control Loop
2.5.2 Controller Function
2.5.3 Applications in Real-Time Database Management Systems
2.5.4 Advantages and Challenges
2.5.5 Feedback Control Techniques
2.6 QeDB: A Quality-Aware Embedded Real-Time Database
2.6.1 System Model
2.6.2 Data and Transactions
2.6.3 Real-Time Transactions
2.6.4 Performance Metrics
2.6.5 I/O deadline and CPU deadline
2.6.6 QoS Management Architecture
2.7 RT-MongoDB: A NoSQL Database Solution
2.7.1 Fundamental Concepts
2.7.1.1 MongoDB Internals
2.7.2 RT-MONGODB
2.8 V4DB Real-Time Database Testbed
2.8.1 The V4DB System
2.8.2 V4DB Database
2.8.3 Database granularity
2.8.4 Description of the Transactions
2.8.5 System Test Options
2.8.5.1 Transaction Processing Type
2.8.5.2 Concurrency Control Mode
2.9 Chronos Testbed
2.9.1 Architecture of Chronos
2.9.2 Client-Server Application
2.9.3 Adaptive Update Policy
2.9.4 Experiments in Chronos
Chapter 3 Commercial Real-Time Database Systems
3.1 SQLite Database Management System
3.1.1 SQLite in RTOS Environments
3.2 ITTIA DB: Time Series Platform for Building Embedded Systems and IoT Devices
3.2.1 Overview of ITTIA DB SQL
3.2.2 Supported 3rd Party Platforms
3.2.3 Real-Time Features
3.3 Raima Database Manager (RDM)
3.3.1 Non-SQL and SQL Database Design and Manipulation
3.3.2 Product Features
3.3.3 Transactional File Server (TFS)
3.3.4 Snapshots
3.3.5 Circular Tables support
3.4 eXtremeDB-RT
3.4.1 Temporal Consistency
3.4.2 RT Transaction Scheduling
3.4.3 Methods to Enforce Deadlines
3.4.4 Supported platforms
Chapter 4 Applications of Real-Time Database Systems
4.1 Military Command and Control Systems (MCCS)
4.2 Energy and Utilities
4.3 Online Gaming
4.4 Environmental Monitoring
4.5 Sensor Network Applications
4.6 Web-based Real-Time Data Services
References