Database Replication: A Survey of Open Source and Commercial Tools

Moiz, Salman Abdul; Sailaja, P.; Venkataswamy, G.; Pal, Supriya N.

doi:10.5120/1788-2469

Cited by 17 publications

(7 citation statements)

References 5 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Another straightforward option is reusing consensus mechanism [77,120] (e.g., state machine replication [147]). Consensus is essentially an abstraction of the shared log approach with clear, safe guarantees and a mature toolkit.…”

Section: Data Synchronization Approachmentioning

confidence: 99%

A survey on hybrid transactional and analytical processing

Song,

Zhou,

Cui

et al. 2024

The VLDB Journal

View full text Add to dashboard Cite

To provide applications with the ability to analyze fresh data and eliminate the time-consuming ETL workflow, hybrid transactional and analytical (HTAP) systems have been developed to serve online transaction processing and online analytical processing workloads in a single system. In recent years, HTAP systems have attracted considerable interest from both academia and industry. Several new architectures and technologies have been proposed. This paper provides a comprehensive overview of these HTAP systems. We review recently published papers and technical reports in this field and broadly classify existing HTAP systems into two categories based on their data formats: monolithic and hybrid HTAP. We further classify hybrid HTAP into four sub-categories based on their storage architecture: row-oriented, column-oriented, separated, and hybrid. Based on such a taxonomy, we outline each stream’s design challenges and performance issues (e.g., the contradictory format demand for monolithic HTAP). We then discuss potential solutions and their trade-offs by reviewing noteworthy research findings. Finally, we summarize emerging HTAP applications, benchmarks, future trends, and open problems.

show abstract

Section: Data Synchronization Approachmentioning

confidence: 99%

A survey on hybrid transactional and analytical processing

Song,

Zhou,

Cui

et al. 2024

The VLDB Journal

View full text Add to dashboard Cite

show abstract

“…This is often called the database integration problem [45]. The main challenges in Distributed Database systems [46][47][48] is the consistency problem where schema definitions and data should be consistent and equal across the different database instances.…”

Section: Distributed and Federated Database Systemsmentioning

confidence: 99%

“…Homogeneous DDBMS are systems where the schema definitions and data should be consistent and equal across the different database instances. A common approach to solving this consistency problem is to use database replication [47], where a master has write permissions on a subset of the data, and when changes occur, they are propagated to the slaves. Homogeneous DDBMS also solve the problem of load balancing between servers.…”

Section: Distributed and Federated Database Systemsmentioning

confidence: 99%

Hastily formed knowledge networks and distributed situation awareness for collaborative robotics

Berger

Doherty

Rudol

et al. 2021

Auton. Intell. Syst.

View full text Add to dashboard Cite

In the context of collaborative robotics, distributed situation awareness is essential for supporting collective intelligence in teams of robots and human agents where it can be used for both individual and collective decision support. This is particularly important in applications pertaining to emergency rescue and crisis management. During operational missions, data and knowledge are gathered incrementally and in different ways by heterogeneous robots and humans. We describe this as the creation of Hastily Formed Knowledge Networks (HFKNs). The focus of this paper is the specification and prototyping of a general distributed system architecture that supports the creation of HFKNs by teams of robots and humans. The information collected ranges from low-level sensor data to high-level semantic knowledge, the latter represented in part as RDF Graphs. The framework includes a synchronization protocol and associated algorithms that allow for the automatic distribution and sharing of data and knowledge between agents. This is done through the distributed synchronization of RDF Graphs shared between agents. High-level semantic queries specified in SPARQL can be used by robots and humans alike to acquire both knowledge and data content from team members. The system is empirically validated and complexity results of the proposed algorithms are provided. Additionally, a field robotics case study is described, where a 3D mapping mission has been executed using several UAVs in a collaborative emergency rescue scenario while using the full HFKN Framework.

show abstract

“…Data replication is a combination of database and distributed system. Database replication can be defined as the process of creation and maintenance of the duplicate copy of database objects in a distributed database system [13].…”

Section: Overview Of Database Replicationmentioning

confidence: 99%

Mathematical Framework for A Novel Database Replication Algorithm

Yadav¹,

Singh²,

Yadav³

2013

IJMECS

View full text Add to dashboard Cite

In this paper, the detailed overview of the database replication is presented. Thereafter, PDDRA (Pre-fetching based dynamic data replication algorithm) algorithm as recently published is detailed. In this algorithm, further, modifications are suggested to minimize the delay in data replication. Finally a mathematical framework is presented to evaluate mean waiting time before a data can be replicated on the requested site

show abstract

Database Replication: A Survey of Open Source and Commercial Tools

Cited by 17 publications

References 5 publications

A survey on hybrid transactional and analytical processing

A survey on hybrid transactional and analytical processing

Hastily formed knowledge networks and distributed situation awareness for collaborative robotics

Mathematical Framework for A Novel Database Replication Algorithm

Contact Info

Product

Resources

About