View in EDS

Data Integrity and Consistency Challenges in Distributed Database Systems

Saved in:
Bibliographic Details
Title: Data Integrity and Consistency Challenges in Distributed Database Systems
Authors: Hajar, Maseeh Yasin, Hisham Ahmed, Mahmoud
Source: Engineering and Technology Journal. 10
Publisher Information: Everant Journals, 2025.
Publication Year: 2025
Subject Terms: Distributed Databases, Data Integrity, Consistency Models, Two-Phase Commit, Rule-Based Enforcement, Active Triggers, Intelligent Management Objects (IMOs), Multi-Version Concurrency Control (MVCC), Replication, Real-Time Systems
Description: With the advent of distributed computing, maintaining data consistency and integrity between geographically remote and logically divided systems has become one of the most significant challenges for system designers and database architects. Distributed databases, though they offer higher availability, scalability, and local autonomy, create problems in maintaining synchronized and consistent states of data. This work covers the Database Integrity (DDBI) project—a pioneering endeavor sponsored by Rome Laboratory and conducted at SRI International—where innovative methods such as rule-based enforcement, active trigger algorithms, and intelligent object versioning were presented to address integrity in distributed object-oriented databases. Apart from the results of the DDBI project, this paper addresses root consistency and transaction models like the Two-Phase Commit (2PC) protocol and examines current replication methods in large-scale data environments. A theoretical classification of consistency models is presented to aid in selecting the most appropriate frameworks for different system needs. Moreover, the study explores the implications of Intelligent Management Objects (IMOs) to integrity and discusses consistency-availability trade-offs. Drawn statistics from comparative studies and simulations confirm the effectiveness of the proposed methods. Finally, this paper provides an organized overview of the techniques reshaping the future of distributed database systems and the need for adaptive, robust, and intelligent design paradigms.
Document Type: Article
ISSN: 2456-3358
DOI: 10.47191/etj/v10i05.36
DOI: 10.5281/zenodo.15471862
DOI: 10.5281/zenodo.15471861
Rights: CC BY
Accession Number: edsair.doi.dedup.....3d1e89cffdb8f9bafd4b05f83a8df609
Database: OpenAIRE
Description
Abstract:With the advent of distributed computing, maintaining data consistency and integrity between geographically remote and logically divided systems has become one of the most significant challenges for system designers and database architects. Distributed databases, though they offer higher availability, scalability, and local autonomy, create problems in maintaining synchronized and consistent states of data. This work covers the Database Integrity (DDBI) project—a pioneering endeavor sponsored by Rome Laboratory and conducted at SRI International—where innovative methods such as rule-based enforcement, active trigger algorithms, and intelligent object versioning were presented to address integrity in distributed object-oriented databases. Apart from the results of the DDBI project, this paper addresses root consistency and transaction models like the Two-Phase Commit (2PC) protocol and examines current replication methods in large-scale data environments. A theoretical classification of consistency models is presented to aid in selecting the most appropriate frameworks for different system needs. Moreover, the study explores the implications of Intelligent Management Objects (IMOs) to integrity and discusses consistency-availability trade-offs. Drawn statistics from comparative studies and simulations confirm the effectiveness of the proposed methods. Finally, this paper provides an organized overview of the techniques reshaping the future of distributed database systems and the need for adaptive, robust, and intelligent design paradigms.
ISSN:24563358
DOI:10.47191/etj/v10i05.36