Lecture

Distributed Transactions: Replication Strategies

Related lectures (32)

Distributed Transactions: 2PC Principles and Replication Strategies

Explores 2PC principles, failure scenarios, and replication strategies in distributed transactions and discusses the transition from ACID to BASE properties in NoSQL systems.

Eventual Consistency: NoSQL, CAP Theorem, and BASE

Explores NoSQL databases, CAP theorem, BASE principles, and eventual consistency in distributed systems.

Distributed Transactions: Architectures and Protocols

Explores parallel database architectures and distributed transaction protocols, focusing on coordination, concurrency control, and recovery challenges.

Concurrency Control & Eventual Consistency

Covers concurrency control techniques and eventual consistency in databases, including two-phase locking, strict 2PL, and Dynamo's algorithm.

Architecture of CockroachDB

Explores the architecture of CockroachDB, focusing on transaction management, concurrency control, and scalability.

Replicated Consistency: Levels and Tradeoffs

Explores replicated consistency levels, tradeoffs, and implications on system performance and availability.

Replication: Strategies and Techniques

Explores replication strategies in distributed systems, covering synchronous, asynchronous replication, and conflict resolution.

Concurrency Control & Recovery in Databases

Delves into transaction management, concurrency control, and recovery in databases to ensure data integrity and system resilience.

Relational Model: Basics

Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.

Querying a database: the SQL language

Covers the SQL language for interacting with databases through structured queries, including selecting, filtering, aggregating, and sorting data.

Distributed Transactions: Principles and Protocols

Explores distributed transactions, covering principles, protocols, concurrency control, commit, and replication.

Parallel & Distributed DBMS

Covers the architecture of parallel databases, benefits of parallelism, distributed databases, and replication methods.

Transactions: Concepts and Implementations

Explores the elegance and challenges of transactions, including ACID properties and transactional memory benefits in concurrent programming.

Terminating Reliable Broadcast & NBAC

Explores Terminating Reliable Broadcast and Non-Blocking Atomic Commit in distributed systems, covering agreement, consensus, and transaction commitment.

Transactions and Concurrency Control

Delves into lock-based concurrency control, deadlock handling, transaction models, and their limitations.

SQL Client-Server Architecture + IDE

Covers the architecture of a typical DBMS and SQL interfaces like SQL Developer and DataGrip.

Parallel Databases

Explores parallel and distributed databases, covering architectures, query optimization, data storage, and distributed transactions.

DDL, DML, Views

Covers SQL data definition, manipulation, and views in databases.

Data Wrangling with Hive: Managing Big Data Efficiently

Covers data wrangling techniques using Apache Hive for efficient big data management.

Eventual Consistency: Principles of Reactive Programming

Explores eventual consistency in distributed systems, emphasizing the importance of suitable data structures like CRDTs.