| Description |
1 online resource (xii, 141 pages : illustrations |
| Series |
Synthesis lectures on data management, 2153-5426 ; # 7 |
|
Synthesis digital library of engineering and computer science.
|
|
Synthesis lectures on data management ; # 7. 2153-5426
|
| Contents |
1. Overview -- Motivation -- Challenges -- Replica control -- Other issues |
|
2. 1-copy-equivalence and consistency -- Replication model -- 1-copy-isolation -- 1-copy-atomicity -- 1-copy-durability -- Relationship between isolation, atomicity and durability -- 1-copy-consistency -- Session consistency -- Eventual consistency |
|
3. Basic protocols -- Eager protocols -- Protocol description -- Example execution -- Eager properties -- Primary copy vs. update anywhere -- Lazy protocols -- Protocol description -- Example execution -- Lazy vs. eager properties -- Primary copy vs. update anywhere -- Summary |
|
4. Replication architecture -- Where to locate the replication logic -- Kernel based architecture -- Middleware based architecture -- Kernel vs. middleware based replication -- Black vs. grey box middleware -- Processing of write operations -- Partial replication -- Other issues -- Group communication as building block -- Group communication and reliable multicast -- Simplifying replication with group communication -- Related work |
|
5. The scalability of replication -- Model -- The analysis -- Related work |
|
6. Eager replication and 1-copy-serializability -- Centralized middleware -- Protocol -- Example execution -- Algorithm properties -- Discussion -- Decentralized middleware -- Protocol -- Example execution -- Algorithm properties -- Discussion -- Decentralized middleware with asymmetric processing -- Protocol -- Example execution -- Algorithm properties -- Related work |
|
7. 1-copy-snapshot isolation -- 1-copy-snapshot isolation -- Snapshot isolation in a non-replicated system -- Snapshot isolation in a replicated system -- Primary copy, centralized middleware -- Protocol -- Example execution -- Algorithm properties -- Update anywhere, centralized middleware -- Protocol -- Example execution -- Algorithm properties -- Update-anywhere, decentralized middleware -- Protocol description -- Example execution -- Algorithm properties -- Snapshot isolation vs.traditional optimistic concurrency control -- Related work |
|
8. Lazy replication -- Bounding the staleness in lazy primary copy -- Boundary types -- Basic implementation -- Push vs. pull based refresh -- Materialized views -- Transaction propagation -- Multiple primaries -- Lazy update anywhere -- Distributed vs. central conflict management -- Conflict detection -- Conflict resolution -- Related work -- Bounding staleness -- Replica placement -- Conflict detection and resolution |
|
9. Self-configuration and elasticity -- Self-healing -- Fault-tolerant measures during normal processing -- Failure types -- Failover: client side -- Failover: server side -- Recovery -- Self-optimization -- Load-balancing -- Other optimization techniques -- Elasticity: self-provisioning -- System reconfiguration -- Deciding on the right number of replicas -- Related work |
|
10. Other aspects of replication -- Multi-tier architectures -- Quorums -- Mobile and peer-to-peer environments |
|
A. Transactions and the ACID properties -- A.1. Atomicity -- A.2. Consistency -- A.3. Durability -- A.4. Isolation -- A.5. Distributed transactions and 2-phase commit -- Bibliography -- Authors' biographies |
| Summary |
Database replication is widely used for fault-tolerance, scalability and performance. The failure of one database replica does not stop the system from working as available replicas can take over the tasks of the failed replica. Scalability can be achieved by distributing the load across all replicas, and adding new replicas should the load increase. Finally, database replication can provide fast local access, even if clients are geographically distributed clients, if data copies are located close to clients |
| Analysis |
database replication |
|
transactions |
|
replica control |
|
1-copy-equivalence |
|
consistency |
|
scalability |
|
fault-tolerance |
|
performance |
|
elasticity |
| Notes |
Part of: Synthesis digital library of engineering and computer science |
|
Series from website |
| Bibliography |
Includes bibliographical references (pages 129-138) |
| Notes |
English |
| Subject |
Distributed databases.
|
|
COMPUTERS -- Programming Languages -- SQL.
|
|
Distributed databases
|
| Form |
Electronic book
|
| Author |
Jiménez-Peris, R. (Ricardo)
|
|
Patiño-Martínez, M. (Marta)
|
| ISBN |
9781608453825 |
|
1608453820 |
|
9783031018398 |
|
3031018397 |
