Lecture

Operational Analytics: Fresh Data Management Techniques

Related lectures (32)

Concurrency Control & Recovery in Databases

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

Transaction Management & Concurrency Control

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

Introduction to Database Systems

Covers the basics of database systems, including data modeling, DBMS, data independence, and the course overview.

Concurrency Control & Eventual Consistency

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

Transactions and Concurrency Control

Explores transactions, concurrency control, conflict resolution, and snapshot isolation in databases, emphasizing consistency and performance.

Architecture of CockroachDB

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

Transactions and Concurrency Control

Delves into transactions, ACID properties, schedules, locking protocols, and concurrency control in database systems.

Distributed Transactions: Architectures and Protocols

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

Transactional Memory: Hardware Concurrency Control

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

Data Wrangling with Hive: Managing Big Data Efficiently

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

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.

Transactions: Concepts and Implementations

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

Transactions and Concurrency Control

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

Optimizing Recursive Queries

Explores optimizing recursive queries in database systems using Datalog and semirings, discussing the challenges and solutions in data analytics.

Concurrency Control: Lock-Based Protocols

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

Spark Data Frames

Covers Spark Data Frames, distributed collections of data organized into named columns, and the benefits of using them over RDDs.

Multiversion Concurrency Control: MVCC and Snapshot Isolation

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

Buffer Management in DBMS

Discusses buffer management in a DBMS, covering challenges, buffer pool, and replacement policies.

Micro-architectural Analysis of Database Workloads

Explores the micro-architectural analysis of modern DBMS, focusing on performance optimization and data cache stall mitigation.

Transactional Memory: Two-phase Locking and Invisible Reads

Explores historical perspectives and mechanisms of transactional memory, emphasizing the importance and challenges of its implementation in modern computing systems.