Lectures related to Database transaction

Transaction Management & Concurrency Control

Explores transaction management, concurrency control, ACID properties, anomalies, and conflict serializability in database systems.

Concurrency Control & Recovery in Databases

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

Transactions and Concurrency Control

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

Concurrency Control: Lock-Based Protocols

Covers lock-based concurrency control protocols and various transaction models.

Architecture of CockroachDB

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

Terminating Reliable Broadcast & NBAC

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

Transactions: Concepts and Implementations

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

Untitled

Decentralized Patterns and Distributed Workload Management

Explores decentralized patterns, distributed workload management, and Scalog's architecture in advanced blockchain systems.

Operational Analytics: Fresh Data Management Techniques

Covers operational analytics, focusing on the adaptive STEP system for efficient access to fresh data in analytical processing.

Transactional Memory: Hardware Concurrency Control

Explores transactional memory for hardware concurrency control, discussing locking mechanisms, performance trade-offs, and hardware changes.

Untitled

Data Intensive Applications and Systems: HTAP Overview

Provides an overview of HTAP systems, covering concurrency control, data layout, consolidation trade-offs, and workload-driven snapshot efficiency.

Multi-Version Concurrency Control: Optimistic Approaches

Explores Multi-Version Concurrency Control with optimistic approaches to enhance transaction processing systems.

Economics of Real Estate: Auctions

Delves into the economics of real estate auctions, analyzing auction formats and their impact on competition and transaction outcomes.

Multiversion Concurrency Control: MVCC and Snapshot Isolation

Explores Multiversion Concurrency Control and Snapshot Isolation in database systems, ensuring consistent snapshots and reducing conflicts.

ACID and Transaction Schedules

Explores transactions, ACID properties, schedules, and anomalies in database systems.

Transactional Memory: Hardware Simplification

Explores transactional memory and hardware simplification for concurrency control in software, emphasizing the benefits of hardware speculation and declarative concurrency.

Distributed Transactions: Replication Strategies

Explores replication strategies for fault tolerance, load balancing, and eventual consistency in distributed transactions.

Database Systems: Overview

Introduces database systems, covering DBMS ecosystem, relational model, course overview, prerequisites, course outline, grading scheme, projects, and teaching methods.