Lecture

Exam Instructions: Types of Questions and Code Grading

Related lectures (32)

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

Parallel & Distributed DBMS

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

Distributed Transactions: Architectures and Protocols

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

Distributed Transactions: Principles and Protocols

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

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.

Transactions and Concurrency Control

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

Data Warehouses and Decision Support Systems

Explores data warehouses, decision support systems, OLAP, data lakes, multidimensional data models, and query optimizations.

Spark Data Frames

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

Terminating Reliable Broadcast & NBAC

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

Data Wrangling with Hadoop

Covers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.

Database Systems: Overview

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

Data formats and data wrangling with Hadoop

Explores Apache Hive for data warehousing, data formats, and partitioning, with practical exercises in querying and connecting to Hive.

Transaction Management & Concurrency Control

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

Transactions: Concepts and Implementations

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

Eventual Consistency

Explores eventual consistency in distributed systems, discussing challenges, tradeoffs, and practical applications.

Data Warehousing: Overview and Challenges

Introduces data warehousing fundamentals, challenges, and the innovative concept of a 'lakehouse'.

Views: SQL Queries Simplification

Explores how views simplify query writing and are key in data warehouses.

Data Warehouses: Introduction and Challenges

Covers the introduction and challenges of data warehouses, including integrating data, managing metadata, and optimizing query performance.

Transactions and Concurrency Control

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